Kinsbane wrote:Could you post up your foreach loop at least? It's hard to follow your code when I don't know when your loop blocks start & end.
The original code is abit long
I can post the whole thing
<?php
session_start();
include("info.inc");
switch (@$_GET['do'])
{
case "new":
foreach($_POST as $field => $value)
{
if( $field == "nnights")
{
if($value == "")
{
unset($_GET['do']);
$message_new = "Please enter number of nights";
include("reservations.inc");
exit();
}
else if(!ereg("^[0-9]{1,2}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid number";
include("reservations.inc");
exit();
}
}else if( $field == "nrooms")
{
if($value == "")
{
unset($_GET['do']);
$message_new = "Please enter number of rooms";
include("reservations.inc");
exit();
}
else if(!ereg("^[0-9]{1,2}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid number";
include("reservations.inc");
exit();
}
}else if( $field == "nadults")
{
if($value == "")
{
unset($_GET['do']);
$message_new = "Please enter number of adults";
include("reservations.inc");
exit();
}
else if(!ereg("^[0-9]{1,2}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid number";
include("reservations.inc");
exit();
}
}else if( $field == "nchilds")
{
if($value == "")
{
unset($_GET['do']);
$message_new = "Please enter number of children";
include("reservations.inc");
exit();
}
else if(!ereg("^[0-9]{1,2}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid number";
include("reservations.inc");
exit();
}
}else if( $field == "nfirstn")
{
if($value == "")
{
unset($_GET['do']);
$message_new = "Please enter your first name";
include("reservations.inc");
exit();
}
else if(!ereg("^[A-Za-z' -]{1,20}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid name";
include("reservations.inc");
exit();
}
}else if( $field == "nlastn")
{
if($value == "")
{
unset($_GET['do']);
$message_new = "Please enter your last name";
include("reservations.inc");
exit();
}
else if(!ereg("^[A-Za-z' -]{1,50}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid name";
include("reservations.inc");
exit();
}
}else if( $field == "nemail")
{
if($value == "")
{
unset($_GET['do']);
$message_new = "Please enter your email address";
include("reservations.inc");
exit();
}
else if(!ereg("^.+@.+\.+[A-Za-z]{2,3}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid email address";
include("reservations.inc");
exit();
}
}else if( $field == "ndyear" or $field == "ndmonth" or $field == "ndday")
{
if($value == "")
{
unset($_GET['do']);
$message_new ="Please fill up the yyyy/mm/dd fields";
include("reservations.inc");
exti();
}
if( $field =="ndyear")
{
if(!ereg("^[0-9]{4}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid year";
include("reservations.inc");
exit();
}
}else if( $field =="ndmonth")
{
if(!ereg("^[0-9]{2}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid month";
include("reservations.inc");
exit();
}
}else if( $field =="ndday")
{
if(!ereg("^[0-9]{2}$",$value))
{
unset($_GET['do']);
$message_new = "Please enter valid day";
include("reservations.inc");
exit();
}
}
}
}
/* checking to see if a reservation has already been made */
$connection = mysql_connect($host,$user,$password) or die("couldnt connect to the server");
$db = mysql_select_db($database, $connection) or die("couldnt connect to the database");
$sql = "SELECT firstName FROM reservations WHERE firstName =$nfirstn";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
if ( $num > 0)
{
unset($_GET['do']);
$message_new = "There has been a reservation made under this name already";
include("reservations.inc");
exit();
}
else
{
$yearstring = '$ndyear';
$monthstring = '$ndmonth';
$daystring ='$ndday';
$newdate = $yearstring.$monthstring.$daystring;
$sql = "INSERT INTO reservations (arrivalDate, numNites, numRooms, numAdults, numChilds, firstName, lastName, title, email, address, zip, city, state, country, tel, fax, comments)
VALUES ('$newdate', '$nnights', '$nrooms', '$nadults', '$nchilds', '$nfirstn', '$nlastn', '$ntitle', '$nemail', '$naddress', '$zip, '$ncity', '$nstate', '$ncountry', '$ntel', '$nfax', '$ncomments')";
mysql_query($sql);
/*email the new info */
$emess = "A new reservation has been made ";
$emess.= "First name and Last name are under: ";
$emess.= "\n\n\t$nfirstn\n\t$nlastn\n\n";
$emess.= "ArrivalDate : ";
$emess.= "$yearstring/$monthstring/$daystring";
$ehead="From: reza.zaeim@gmail.com\r\n";
$subj = "New Reservation:";
$mailsend=mail("$email","$subj","$emess","$ehead");
header("Location: yahoo.com");
}
break;
default:
include("reservations.inc");
}
?>
