A connection can be done in differant ways in PHP.
I normally use the following modell:
This holds the connection open, but you can also save the connection in a variable and use it with the queries, like this:
It depends on what you want to do. Both these ways work, just don't forget, when you're done:
It's good mannors to close the connection
I normally use the following modell:
function ConnectDB()
{
$host="localhost"; // Host name
$username="MyUsername"; // Mysql username
$password="MyPassword"; // Mysql password
$db_name="MyDB"; // Database name
$tbl_name="MyTable"; // Table name
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
}
This holds the connection open, but you can also save the connection in a variable and use it with the queries, like this:
$link = mysql_connect("localhost", "MyUsername", "MyPassword");
if(mysql_query("DO SOMETHING", $link))
{
echo "Something has been done!";
}
else
{
echo "Something was not done =(";
}
It depends on what you want to do. Both these ways work, just don't forget, when you're done:
mysql_close();
It's good mannors to close the connection
There are no comments on this article.
Leave a message!
If you have any question or just want to leave a message, just fill out the form below!
Your e-mail will not be visible in your post, it is for validation reasons only