SQL PHP HTML ASP JavaScript articles and free scripts to download
SQL PHP MySQL Functions

PHP MySQL Connecting string

Connection to Mysql database can be established by using mysql_connect function. We can check the success of the function by checking the result. We will get a true result in case connection is established. Based on this we can even print a message saying the details. This function takes three parameters, first one is hostname then user-id and them password. We can give the port number along with the hostname also.

Here is the function to connect to mysql database

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

The above function will return true or false depending on the success of the connection. So we will add message to the above function like this.

$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}

Mysql_connect once establish the connection the link will be present till the script execution is over. It will close it self once the script execution is over or the function mysql_close() is called.

Connecting string with database selection. mysql_select_db() function
We can create a connection string and database connections at one go. This is required where all over the script we are using one database so better to select the database just after the connection is established. Here is the code.

$servername='localhost';

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

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


////////////////////////////////////////
////// DONOT EDIT BELOW /////////
///////////////////////////////////////


connecttodb($servername,$dbname,$dbuser,$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());
}



Google+

More on PHP MySQL functions
milind01-04-2009
nice working
Craig Misak05-08-2009
I think you have a typo.... you define $dbusername='userid' but than further down in your mysql_connect its only $dbuser..

I'm a newbe so maybe there is something else going on
Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List
Email:  
For Email Newsletters you can trust

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer