';
define('DB_NAME', 'feature_films');
define('DB_USER', 'root');
define('DB_PASSWORD', '123');
define('DB_HOST', 'localhost');
// Connect to database server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die ('Could not connect: ' . mysql_error ());
}
// Select database
$db_selected = mysql_select_db(DB_NAME, $link);
if(!$db_selected) {
die ('Can\'t use ' . DB_NAME . ': ' . mysql_error());
}
//store the post variable as $term and build our query.
if (isset($_GET['term']))
{
$term = $_GET['term'];
if ($term=="")
$term="__++**";
$sql = mysql_query("select * from films where Film like '%$term%' or Director like '%$term%'");
echo("