How to connect from a PHP file to a MySQL database

I Love Programming

One of the best features of PHP is how easily it interacts with MySQL. This allows you to store information in a database for your website to access and then create dynamic content. In order to do this you need to be able to read and write to the MySQL database from your PHP based website.

You can connect to your database from a PHP file with the following code:

<?php 
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error()) ;
mysql_select_db("Database_Name") or die(mysql_error()) ;
?>

Obviously you need to change the highlighted items to represent the actual values for your database.

Once you are connected to your database you can read data or write to your database.

 

View original post

Advertisements

One Comment

Tell us what you think

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s