PHP. Database connection

php_database_connection.md

Database connection

To store data, you would need a database. In this case we would be using MySQL database.

 <?php
    $DBNAME = 'dbname';
    $HOST   = 'localhost';
    $DBUSER = 'dbuser';
    $DBPASS = 'dbpass';
    
    $CONNECT = mysql_connect($HOST,$DBUSER,$DBPASS);
    if(!$CONNECT) {
    	echo 'MySQL Error: '.mysql_error();
    }
    
    $SELECT = mysql_select_db($DBNAME);
    if(!$SELECT) {
    	echo 'MySQL Error: '.mysql_error();
    }
  ?>

In the highlighted lines above, you would have to specify your own server database details.

You can save the above file as config.php and you would have to include that file in all pages where you need database connectivity.