Hiro Posted June 15, 2009 Share Posted June 15, 2009 First off, I'd like to apologize if this is in the wrong section. I'm trying to get into MySQL and have recently registered with Awardspace, and began looking for tutorials as soon as I got my account. I was confused to find that all of the tutorials I've found on the net use a different format than the one provided with my host. Awardspace uses MySQL Manager with phpMyAdmin, and apparently does not support remote MySQL management. I was wondering if this is a feature solely offered to paid web hosts, or if there are tutorials on using MySQL Manager. I've tried to figure it out on my own but can't seem to find the material. Thank you in advance. Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/ Share on other sites More sharing options...
Ken2k7 Posted June 15, 2009 Share Posted June 15, 2009 MySQL Manager? Never heard of that. Isn't phpMyAdmin a MySQL manager? Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/#findComment-855942 Share on other sites More sharing options...
Hiro Posted June 15, 2009 Author Share Posted June 15, 2009 Actually yeah, I meant phpMyAdmin. MySQL Manager is just a quick link to an overview of your databases, but it actually makes you log into phpMyAdmin to edit. I guess I should just look up phpMyAdmin tutorials. I would like to know, however, if free hosting sites offer remote mySQL management. And if so, would it be easier for a beginner to use a program like HeidiSQL over phpMyAdmin? Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/#findComment-855962 Share on other sites More sharing options...
haku Posted June 15, 2009 Share Posted June 15, 2009 phpmyadmin is pretty easy to use - it adds a GUI to the mysql interface. But for learning it may be better to use the command line to get a feel for it. If you install Wamp (for windows), it comes with a command line interface built in that you can use. Left click on the icon in your system tray, go to mysql, and choose mysql console. Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/#findComment-855988 Share on other sites More sharing options...
Hiro Posted June 16, 2009 Author Share Posted June 16, 2009 I'd like to become familiar with using command lines, but like I mentioned my host only allows me to use phpMyAdmin. I also looked up tutorials and learned how to make tables for my db, but where can I learn how to extract information from my databases? I'd like to show my tables on my website, but don't know how. Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/#findComment-856727 Share on other sites More sharing options...
haku Posted June 16, 2009 Share Posted June 16, 2009 Install Wamp (like I already suggested). It's a local server installation on your own computer. It's better to have that for testing anyways - then you don't have to keep uploading the files to your server everytime you make a change. Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/#findComment-856732 Share on other sites More sharing options...
Hiro Posted June 17, 2009 Author Share Posted June 17, 2009 Ok thanks haku. I've been messing around with MySQL and PHP, and installed a login system (http://www.evolt.org/article/PHP_Login_System_with_Admin_Features/17/60384/) for my site. I will need to tweak this code later for my own uses, but for now I'm having problems. I use iframes on my site, and need the login system links to display in my frames. However once I log in, the logout buttons give a 404, and the PHP script won't work with iframes. <? /** * User has already logged in, so display relavent links, including * a link to the admin center if the user is an administrator. */ if($session->logged_in){ echo "<h1>Logged In</h1>"; echo "Welcome <b>$session->username</b>, you are logged in. <br><br>" ."[<a href=\"php\userinfo.php?user=$session->username\">My Account</a>] " ."[<a href=\"php\useredit.php\">Edit Account</a>] "; if($session->isAdmin()){ echo "[<a href=\"php\admin/admin.php\">Admin Center</a>] "; } echo "[<a href=\"php\process.php\">Logout</a>]"; } else{ ?> That's the code for the user CP once you're logged in. I need the links to points to the frame "content", so I tried to add target="content in the logout link like this: echo "[<a href=\"php\process.php\" target="content">Logout</a>]"; but it gave me this error "Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /home/www/site/index.html on line 96" How can I use iframes with PHP? Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/#findComment-858420 Share on other sites More sharing options...
Hiro Posted June 17, 2009 Author Share Posted June 17, 2009 Also, I found out another weird thing... I logged in with Google Chrome (I usually use firefox), and hovered over the logout link, and the link was "http://musevox.awardspace.biz/php/process.php". In firefox, it reads "http://musevox.awardspace.biz/php\process.php". It will function correctly in Chrome, but will 404 on Firefox. Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/#findComment-858438 Share on other sites More sharing options...
haku Posted June 18, 2009 Share Posted June 18, 2009 You should start a new topic for new problems, especially considering this isn't even remotely related to mysql anymore. Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/#findComment-858681 Share on other sites More sharing options...
Hiro Posted June 18, 2009 Author Share Posted June 18, 2009 You're right, I'll head over to PHP help. Quote Link to comment https://forums.phpfreaks.com/topic/162193-completely-new-to-mysql/#findComment-858706 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.