Hollywood forums

Code: Select all

// addphone.php

if (isset ($_GET['fullname'])) { $fullname = htmlentities($_GET['fullname']); }
if (isset ($_GET['phone'])) { $phone = htmlentities($_GET['phone']); }

// mysql settings
$database="database_name";
$username="root";
$password="root";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$sql = "SELECT *  FROM `table_name` WHERE `Fullname` = '$fullname'";
$result=mysql_query($sql) or die(mysql_error);		
$num=mysql_numrows($result);

if ($num == 0) // this person not found, add to database
{
        $sql = "INSERT INTO `$database`.`table_name` (`Fullname`, `Telephone`) VALUES ( '" . $fullname . "','" . $phone . "' );";
	$result=mysql_query($sql) or die(mysql_error);
	mysql_close();
		
	echo "OK";
}
else
{ echo "FAIL"; }