Inserting data through a HTML Forms
Posted: Sat Jun 10, 2006 1:05 pm
Ok, I am trying to insert data through a HTML forms but it is no grabing the select text, i am also getting an double entry message
this is the message that i am getting
1 .Business Owner information Inserted.1.Business Information Inserted.Duplicate entry '' for key 11.Towns Information Inserted.1.Categories Information Inserted.
the State_search and the Towns_search are the one i need to intruduce into the database because the others are going through fine
Code: Select all
<?
$host = "localhost";
$username = "localhost";
$password = "abc123";
$database = "contacts";
$db = mysql_connect($host, $username, $password);
mysql_select_db($database);
// Business Owner
$First_Name = addslashes($First_Name);
$Last_Name= addslashes($Last_Name);
$Owner_Address = addslashes($Owner_Address);
$State= addslashes($State);
$City= addslashes($City);
$Zip= addslashes($Zip);
$Tel= addslashes($Tel);
$Email= addslashes($Email);
$Position=addslashes($Position);
$Comments=addslashes($Comments);
// Business Info
$BusinessName = Addslashes ($BusinessName);
$Slogan = Addslashes($Slogan);
$Business_Address = Addslashes($Business_Address);
$Tel = Addslashes($Tel);
$Email = Addslashes($Email);
$Member_Status =Addslashes($Member_Status);
$Fax =Addslashes($Fax);
//State
$State_search =Addslashes ($State_search);
// Towns
$Towns_search = Addslashes ($Towns_search);
// Categories
$Categories =Addslashes($Categories);
if(!$db)
{
echo " Error: could not connect to database.";
exit;
}
//business owner
$sql="INSERT INTO `FirstName`(`First_Name`,`Last_Name`,`Owner_Address`,`State`,`City`, `Zip`,`Tel`, `Email`,`Comments`,`Bus_Position`,`Status`)
VALUES ('".$First_Name."','".$Last_Name."','".$Owner_Address."','".$State."','".$City."','".$Zip."','".$Tel."','".$Email."','".$Comments."','".$Bus_Position."','".$Status."')";
$result = mysql_query($sql);
echo mysql_error();
if($result)
{
echo mysql_affected_rows()." .Business Owner information Inserted.";
}
//Business Info
$sql="INSERT INTO `Business_Info`(`BusinessName`,`Slogan`,`Business_Address`,`Tel`,`Website`,`Email`,`Member_Status`,`Fax`)
Values('".$BusinessName."','".$Slogan."','".$Business_Address."','".$Tel."','".$Website."','".$Email."','".$Member_Status."','".$Fax."')";
$result = mysql_query($sql);
echo mysql_error();
if($result)
{
echo mysql_affected_rows(). ".Business Information Inserted.";
}
//State
$sql = " INSERT INTO `State_search`(`State_search`)
VALUES('".$State_search."')";
$result = mysql_query($sql);
echo mysql_error();
if($result)
{
echo mysql_affected_rows(). ".State Information Inserted.";
}
// Towns
$sql = " INSERT INTO `Towns_search`(`Towns_search`)
VALUES('".$Towns_search."')";
$result = mysql_query($sql);
echo mysql_error();
if($result)
{
echo mysql_affected_rows(). ".Towns Information Inserted.";
}
// Category
$sql = " INSERT INTO `Categories`(`Categories`)
VALUES('".$Categories."')";
$result = mysql_query($sql);
echo mysql_error();
if($result)
{
echo mysql_affected_rows(). ".Categories Information Inserted.";
}
?>1 .Business Owner information Inserted.1.Business Information Inserted.Duplicate entry '' for key 11.Towns Information Inserted.1.Categories Information Inserted.
the State_search and the Towns_search are the one i need to intruduce into the database because the others are going through fine