Here is my php code: <? php //create short varible name Itemno=$_Post['Itemno']; Firstname=$_POST['Firstname']; State=$_POST['State']; Streetnumber=$_POST['Streetnumber']; Zipcode=$_POST['Zipcode']; if (!Null||!Firstname ||!State ||!Streetnumber||!Zipcode){ echo "You have not entered all the required details.<br/>" ."Please go back and try again."; exit; } if (!get_magicquotes_gpc()) { Itemno=addslashes(Itemno); Firstname=addslashes(Firstname); State=addslashes(State); Streetnumber=addslashes(Streetnumber); Zipcode=addslashes(Zipcode); if (mysqli_connect_errno()){ echo "Error: Could not connect to database. Please try again later."; exit; } @$db= new mysqli("http://www.http://customers.freehosting.com", "teeshome_freeestimates", "xxxxxxx"); (Itemno,Firstname,State,Steetnumber,Zipcode); insert into customers values (Null,'Firstname','State.','.Streetnumber','Zipcode'); echo $db->affected_rows; $result= $db->query ($query); if ($result){ } else { echo "An error has occured. The item was not added."; } $db->close(); ?> Thank you
Lol sorry but you ar egoing to have to give more information on that. I ain't gonna be looking through all that line by line. Please give the full error that you get including line numbers.
I don't know where you learned PHP, but the code is totally wrong from the first line: //create short varible name $Itemno=$_Post['Itemno']; $Firstname=$_POST['Firstname']; $State=$_POST['State']; $Streetnumber=$_POST['Streetnumber']; $Zipcode=$_POST['Zipcode']; if (!$Itemno||!$Firstname ||!$State ||!$Streetnumber||!$Zipcode){ echo "You have not entered all the required details.<br/>" ."Please go back and try again."; exit; } if (!get_magicquotes_gpc()) { $Itemno=addslashes($Itemno); $Firstname=addslashes($Firstname); $State=addslashes($State); $Streetnumber=addslashes($Streetnumber); $Zipcode=addslashes($Zipcode); PHP: Itemno isn't a variable, it's a T_STRING. The variable is $Itemno. Etc.