PHP MySQL connecting script and function

  Now let us start with PHP  commands to connect to MySQL server.

$link=mysql_connect("$servername","$dbuser","$dbpassword");

Here the variables $servername is equal to the name of the MySQL server, $dbuser stores the user id  and $dbpassword is the password assign to the user id to access the mysql_server.  If successful then it will return TRUE and we can check the variable $link to check the status of the command.

if(!$link){die("Could not connect to MySQL");}

The above command will display the error message if connection is not established.  Now once the MySQL connection established then we can select the database by using the command mysql_select_db. Here is the command.

mysql_select_db("$dbname",$link) or die ("could not open
db".mysql_error());

The above command will connect to database name stored in the variable $dbname. In case of any error the above line will print out it. Here is the total script below to connect from PHP to MySQL database using a function. At the top of the code we are assigning all values requried to connect to MySQL server.

<?Php
// hostname or ip of server
$servername='localhost';

// username and password to log onto db server
$dbusername='';
$dbpassword='';

// name of database
$dbname='mydb_name';

////////////// Do not  edit below/////////

connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect
("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open
db".mysql_error());
}?>

PHP MySQL Connection using PDO

how to check mysql support in php by using phpinfo



ASP MsSQL connection string
Your Rating





Post Comment This is for short comments only. Use the forum for more discussions.




HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2019 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer