Before getting any further into database coding, it will be good practice to call upon the PHP command of include.

The first part of server connection, database selection, and table selection is a repeated snippit, so to save time and effort, we'll put that part into a seperate file and just call it into play when we need it.

**db_connect.inc**

<Code
  language="php"
  text={`<?php

// set your infomation.
$dbhost='localhost';
$dbusername='david';
$dbuserpass='mypassword';
$dbname='test';

// connect to the mysql database server.
$link_id = mysql_connect ($dbhost, $dbusername, $dbuserpass);

// select the specific database name we want to access.
$dbname=$dbusername."_".$dbname;
if (!mysql_select_db($dbname)) die(mysql_error());

?>`}
/>

The PHP command to call that section of code into action:

<Code
  language="php"
  text={`include ("db_connect.inc");`}
/>

Learn about the php command "include" and how it's used to connect to a MySQL database.

Include

Author

Table of Contents