Need help with tutorial PHP script

[budbiss]

This is an example script that interacts with a MySQL database:

<?php
/ Connecting, selecting database /
$link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
or die("Could not connect : " . mysql_error());
echo "Connected successfully";
mysql_select_db("my_database") or die("Could not select database");

/ Performing SQL query /
$query = "SELECT * FROM my_table";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

/ Printing results in HTML /
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";

/ Free resultset /
mysql_free_result($result);

/ Closing connection /
mysql_close($link);
?>

I have MySQL running locally on my workstation...how do I configure this script so that it will work with my local machine when run locally?

[Yamakazi]

Of course you have to be sure MySQL is running.

Install MySQL as a service. Run mysqld-nt from a command prompt. If he doesn't find the command fire it from mysql/bin folder.

Now go to configuration panel -> adminstrative tools -> service
Make sure MySQL is started and it start everytime your systems boots (if that is what you want).

Ok now you need to make a DB. You can do this from a command prompt or use MYSQL CC. In my example my DB is called exampleDB

After that you should be able to connect to the DB. You are also adviced to create a special web account with restricted privleges and let PHP connect to it.

For instance create a user called PHP and give him a password MYPASSWORD then grant him only insert update select and delete functions.

$link = mysql_connect("localhost", "PHP", "MYPASSWORD") 
or die("Could not connect : " . mysql_error()); 
echo "Connected successfully"; 
mysql_select_db("exampleDB") or die("Could not select database"); 

If this isn't specific enough be more specific your self 🙂
Tell us what OS you are running. If you have created a DB, if your sure it's running etc...

[budbiss]

OK, maybe I wasn't spefic enough, let me expand on what I origionally wrote:

I am running MySQL on XP. I have gone through the MySQL to the point where it explains how to create and maintain dbs and tables and on the content in the tables. So, yes I already have a db created.

My question is how do I configure that PHP script so that it accesses the db I created? Keep in mind that I will be running the PHP script locally and have MySQL running locally...atleast for now while I learn how to do things in it.

Hope this gives you a better idea now. Thanks.

[budbiss]

OK, I finally got this to run, except now it returns an error. Here is the error message (I omitted certain info for security reasons):

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: '(omitted)@(omitted).net' (Using password: YES) in /home/(omitted)/www/(omitted)/(omitted)/(omitted)/test1-2.php on line 3
Could not connect : Access denied for user: '(omitted)@(omitted).net' (Using password: YES)

[lazzy]

you know somethen weird which you might want to try out. While setting up my mysql server on my comp, even after putting a username and password in the my.ini file the server doesnt need a username and pass. So, just try mysql_connect("localhost", "", "") with no username and pass and see what happens...

[budbiss]

OK, now everything works 🙂 I have another question though... what does this part do:

/ Free resultset /
mysql_free_result($result);

[lazzy]

http://www.php.net/mysql_free_result

[budbiss]

Thanks!