Newbie: How to link php to MySQL

[maxonon]

How do I set up a link between a php-document and a MySQL database?? The database is already running.. Is there a simple php-command that fetches data from a MySQL-field and simply turns it into a variable?? There must be..
Thanks all!

[[deleted]]

Yes of course, you need to know the server (most likely "localhost") and your username and password for the db. Then you connect using the command "mysql_connect"

mysql_connect (string [server], string [username], string [password])

Lets say your username = "maxonon" and password was "themax"

$db = mysql_connect ("localhost", "maxonon","themax");

Of course this only returns the pointer $db. To get any info from the pointer you have to send a query to it.

$result = mysql_query("Select * from users", $db);

If successful, all the data is not in the $results 'variable' but you need to use yet another function to get the data out. There are many to do this but one is mysql_fetch_array

$aResults = mysql_fetch_array($result);

Do a print_r on a results and you will see the first row of your results.

print_r($aResults);

If you need all the results use mysql_fetch_array in a loop.

go to http://www.php.net/manual/en/ref.mysql.php for complete info

[maxonon]

Thanks for all help.. just one thing, is there a default password/username to the database?? 'cause i haven't configured one.. ow ca u do that??

[garethdown]

phpmyadmin and webmin are good for editing databases. - You can add / edit passwords and permissions etc.

Also you can set the default password for accessing databases from php in 'php.ini'.