Establishing connection with MySQL with PHP

[al-zabir]

Establishing connection with MySQL with PHP:
==================================
To use MySQL database with your PHP scripting, you must need to establish a connection with database. There are several ways to do it. But, I am explaining here the most simpliest way of connecting with db. Let's assume the filename connect.php

connect.php

<?
$dbhost = "localhost";
$dbname = "your_db_name_here";
$dbuser = "db_user_name_here";
$dbpass = "db_password_here";

$con=mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
$db=mysql_select_db($dbname) or die("Could not select db: ".mysql_error());
?>

• first of all, declare all the variables dbhost,dbname and dbpass. Basically, in local pc, dbhost is always localhost
• Here mysql_connect() function will create a connection with db
• and mysql_select_db() function will select the db for connection

Note: For further dealing with db in PHP ( insert, update, delete ), you just have to include the file "connect.php".

[iGuides]

Thanks for the detailed guide, it will really help gaining more knowledge in programming field.

[al-zabir]

Thank you for your feedback admin. I will try to carry on

[deluxdon]

Thanks for sharing this info though i am still learing about php thingy

[Zafar Ahmed]

I am always willing to learn about databases, thank you for the information. However, you have not mentioned anything about Apache.

[al-zabir]

Originally Posted by Zafar Ahmed

I am always willing to learn about databases, thank you for the information. However, you have not mentioned anything about Apache.

Apache is a web server which is designed to run server-side language like PHP, ASP ( Apache2 is needed ), ASP.NET ( Apache2 is needed ) with mySQL, pgSQL databases. To run Apache with PHP and mySQL. You have to install Apache, PHP and MySQL individually and then configure it. But, I will not go for that way. Because, now there are so many software bundle that installs all the three things ( Apache, PHP and MySQL ) at the same time and there is no need to configure it anymore. Following are some such bundles that you can download for free. Just Download and install it.

Apache2Triad
Apache2Triad Net

XAMPP
apache friends - xampp

PHP Triad
SourceForge.net: PHP Triad for Windows


Thanks to all

[Zafar Ahmed]

Originally Posted by al-zabir

Apache is a web server which is designed to run server-side language like PHP, ASP ( Apache2 is needed ), ASP.NET ( Apache2 is needed ) with mySQL, pgSQL databases. To run Apache with PHP and mySQL. You have to install Apache, PHP and MySQL individually and then configure it. But, I will not go for that way. Because, now there are so many software bundle that installs all the three things ( Apache, PHP and MySQL ) at the same time and there is no need to configure it anymore. Following are some such bundles that you can download for free. Just Download and install it.

Apache2Triad
Apache2Triad Net

XAMPP
apache friends - xampp

PHP Triad
SourceForge.net: PHP Triad for Windows


Thanks to all

Do you have these softwares which installs Apache, PHP and MySQL at the same time and I don't have to configure them out. The download links you gave me seems like its a link to each Individuals.

[al-zabir]

No, Those are not links to each individuals. All of the above three softwares will install Apache, PHP and MySQL at the same time and you don't have to configure them out. Just choose any one of them and feel free to download and install. i will recommend the first one.

Thanks