session_start();
include('dblib/db_connect.php');
if ($_SESSION['custid']) {
header('Location: confirm.html');
}
$name1=$_REQUEST['name1'];
$name2=$_REQUEST['name2'];
$email_var=$_REQUEST['email_var'];
$address=$_REQUEST['address'];
$city=$_REQUEST['city'];
$state=$_REQUEST['state'];
$zip=$_REQUEST['zip'];
$phone=$_REQUEST['phone'];
$comments=$_REQUEST['comments'];
$Submit=$_REQUEST['Submit'];
if($Submit){
if(!$name1){$required .="Name Required
";$no='1';}
if(!$address){$required .="Address Required
";$no='1';}
if(!$email_var){$required .="Email Required
";$no='1';}
if (!$no) {
$addq="insert into customers (
cust_Name1,
cust_Name2,
cust_Address1,
cust_City,
cust_State,
cust_Zip,
cust_Phone,
cust_Email,
cust_RegDate
) VALUES (
'$name1',
'$name2',
'$address',
'$city',
'$state',
'$zip',
'$phone',
'$email_var',
now())";
mysqli_query($sConn, $addq);
echo mysqli_error($sConn);
$current_cust=mysqli_insert_id($sConn);
$_SESSION['custid']=$current_cust;
$udq="update orders set
order_Cust='$current_cust',order_Comments='$comments' where order_Id='".$_SESSION['active_order']."'";
mysqli_query($sConn, $udq);
echo mysqli_error($sConn);
header('Location: confirm.html');
}
}
$queryst="select * from states";
$resultst=mysqli_query($sConn, $queryst);
echo mysqli_error($sConn);
while($rowst = mysqli_fetch_array($resultst))
{
extract($rowst);
$statelist .="";
}
include('storehead.inc'); ?>
Tell Us Where to Send It!
=$required?>
|
|
include('storefoot.inc'); ?>