Скачать или смотреть php and mysql, database connectivity, connection file in php, mysql database, mysqli_connect()

Mysql Introduction :
MySQL is an open-source relational database management system (RDBMS). It is the most popular database system used with PHP. MySQL is developed, distributed, and supported by Oracle Corporation.

Commands -- Insert, Update, Drop, Delete etc.

Used to manage all records in database and create a dynamic website / app.

MySQLi extension is used for php 5 or later versions.
How to integrate/connect php with mysql
Step 1 : Create a connection file. (Conn.php)

Step 2 : Make a connection with DB (MySql) & PHP in conn.php file.

Step 3 : If connection OK then perform other operation. Else Provide connection Error.
Example :
PHP contains many built-in function for MySql connections.


For PHP 1.0 to 4.0 version,
$conn = mysql_connect('Host Name', 'DB User Name', 'DB password');
$db = mysql_select_db($conn, 'DB Name');


For PHP 5 and later vesion,
$conn = mysqli_connect('Host Name', 'DB User Name', 'DB password', 'DB Name');

Check Connection is OK or NOT
if( !$conn )
{
echo “Connection Error...”;
}
else
{echo “Connection Established Successfuly”;
}