SQL PHP HTML ASP JavaScript articles and free scripts to download
PHP PHP & Database Query

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

Be the first to post comment on this article :


Google+
Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy



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

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