MySQL guide for beginner. - HTML Forums

FWDrew · 03-28-2008, 01:55 AM

Hi everyone,

Well....I am having a slightly difficult time getting my head around MySQL. I have really gotten to like PHP and gotten used to it and now I discover MySQL and I am just a little confused.

My question is...after searching google I wasn't able to find any "dumbed down" explanations or guides for someone just starting off with MySQL.

Anyway you guys could point me in the right direction with some links or what not would be so helpful

Drew

rangana · 03-28-2008, 02:14 AM

W3Schools and Tizag could keep you going

You might also find this link useful

FWDrew · 03-28-2008, 01:08 PM

Quote:

Originally Posted by rangana

W3Schools and Tizag could keep you going

You might also find this link useful

Hi Rangana,

As always, thanks for your help

I'll be looking at those links, I cant believe I forgot to go to W3C first...DOH!

I have 2 stupid questions, and I feel so dumb, but I am just gonna put it out there.

1.Ok, so I use godaddy for my host. Now I get 10 MySQL databases with my hosting. I am able to create a new database and a name and password for that database. I am able to log in to "MySQL" (which uses phpMyAdmin). So, do I still need to download MySQL or do I already have it (as I am thinking I do)?

2. Say I have done things correctly and inserted one table into a database....to connect to that database do I just write the command (to connect) on whatever page I am working on?

Regards,

Drew

putts · 03-28-2008, 01:31 PM

1. If you plan on doing development directly on your local machine, you may have to install a local version of mySQL if your code cannot connect to your GoDaddy database. You do not have mySQL locally at this point. GoDaddy serves the database just like they do your PHP code. So the database you have is just an instance of mySQL stored on the GoDaddy servers.

2. PHP is very closely integrated with mySQL and can usually connect to an instance of a mySQL database that is on the same server fairly fluidly. You should really check the PHP documentation and what they might have W3C on it first and see if you can work your way through it yourself that way. Then, if you have more specific questions, I'm sure one of the PHP guys would be able to help you.

FWDrew · 03-30-2008, 03:55 AM

Quote:

Originally Posted by putts

1. If you plan on doing development directly on your local machine, you may have to install a local version of mySQL if your code cannot connect to your GoDaddy database. You do not have mySQL locally at this point. GoDaddy serves the database just like they do your PHP code. So the database you have is just an instance of mySQL stored on the GoDaddy servers.

2. PHP is very closely integrated with mySQL and can usually connect to an instance of a mySQL database that is on the same server fairly fluidly. You should really check the PHP documentation and what they might have W3C on it first and see if you can work your way through it yourself that way. Then, if you have more specific questions, I'm sure one of the PHP guys would be able to help you.

Thank you putts and sorry for the delayed response. I am going to try and install it and I'll let you guys know how it goes. I am sure I will have more detailed questions to come.

Thanks again,

Drew

FWDrew · 04-03-2008, 12:42 AM

Ok, I believe I am ready for my next question

I have installed MySQL on my computer and have created a database and table on my GD account using phpmyadmin. Now I am attempting to simply connect to the mysql using php.

So far he is what I have gathered:

PHP Code:


			


<?php

$dbhost = 'localhost';

$dbuser = 'root';

$dbpass = 'password';



$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');



$dbname = 'links';

mysql_select_db($dbname);

?>

My question is what should I be entering for $dbhost? Should it be the server ip for myPHP admin account or should it be my server ip for the website I would like to use? Or maybe even a local directory? As you can see I am obviously confused.

Thanks for any help as always.

Drew

Vege · 04-03-2008, 05:37 AM

if GD stands for godaddy you can find the right hostname in their manuals/instructions.