how to connect php content to my sql database

Hi jayk jayk ,

To connect PHP to mysql database you should use mysql_connect() function.

Example :

<?php

mysql_connect('localhost','root','') or die(mysql_error());
echo "found server<br>";

mysql_select_db('mydb') or die(mysql_error());
echo "found database pos <br>";

?>

In the above code, the function mysql_connect( ) is used to make a connection to the mysql server. And the function mysql_select_db( ) is used to select the database. Here 'localhost' is my server, 'root' is my user and the third field ' ' is password field which I have left blank. In mysql_select_db( ) function, 'mydb' is the name of my database. You should keep these fields according to your servername, user, password and database name.

The echo lines I have used above is just to test / show a message after the code executes. There are also other methods to do this and it is one of the way I know. Hope this helps. Happy Learning. :)

thanks rijal