PHP - Displaying Posted Variables Help!

Hi, I only want to display some included PHP code only if a value is displayed from  form input. The value is a zip code which is used to display weather information, but the app produces an error when you first enter the page, because their is no value for the zip variable. I know I need an if/else statement, but not sure what to put in it.

The form code is this

<h3>Enter your zip code to receive weather info.</h3>
             <form method="post" action="<?php echo $PHP_SELF;?>">
Enter Zip Code:<input type="text" size="12" maxlength="12" name="zip"><br /> 
<input id="submit" type="submit" name="Submit" value="Enter Zip"/>

</form>

<?php


// this is how we bring in the weather file

include 'weather_report.php' 

?>


the zip variable is set-up in the weather_report.php file as follows

$zip = $_POST["zip"];


but like I said until that value is set, an error is thrown by the weather app code.

Hi everyone,   I've been running a self-written php shopping cart for the last 8 years, with lots of success.  Recently however, the credit card processor (Linkpoint) I use upgraded their gateway, and now I have a problem.   Basically, the last page of my checkout does a _POST to a specific url for their gateway.  I send through a bunch of <input> variables, some of them hidden, but all of them check out okay.  I have combed over their specs, made sure I'm not sending any bad characters, made sure I've got the right format for the fields they want, etc...    Right now the transaction is successful, the customer's card is charged, but Linkpoint's system is returning an error message: We are unable to process your request due to invalid data.   Long story short, their support staff has asked me to "send them the xml string" via email.  I have no idea how to do this (even after spending a few hours online trying to figure it out).   Is there a simple way to generate the xml string that's being passed during the _POST?  Some kind of php code I can incorporate into my final checkout page, run a test transaction, and maybe write the string out somewhere so I can get it to them?   Any help you guys could give me would be greatly appreciated.  Thanks in advance!
Danny  

How can I echo the $id?  Every time I post approved it refreshes my page and I can see the echoed out ID.  I need to know what the ID value is.
Code: [Select]
if (isset($_POST['approve']))
{
if(is_array($_POST['approve'])) {
$keys = array_keys($_POST['approve']);
$id = $keys[0];

echo $id;
die();
//$sql = "UPDATE `blog_comments` SET `approved` = 1 WHERE `post_id` = '$id'";
//header("Location: " . $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'] );
}
}

How can I prioritize the data posted.  Right now this if statements are being posted at different times.  If I hit submit and all the if statements post to mysql it is saying that they all receive the same time stamp, but the data is never posted in the same order.  Can I order the posting process in php?

Code: [Select]
if ((isset($_POST['companywebsiteas'])) && ($_POST['companywebsiteas'] != $r['companywebsite']))
{
$details = $_POST['companywebsiteas'];
update_company_actions($info['companyid'], 18, $details);
}

if ((isset($_POST['companyindustryas'])) && ($_POST['companyindustryas'] != $info['industry']))
{
$details = $_POST['companyindustryas'];
update_company_actions($info['companyid'], 17, $details);
}

if ((isset($_POST['companystageas'])) && ($_POST['companystageas'] != $info['stage']))
{
$details = $_POST['companystageas'];
update_company_actions($info['companyid'], 10, $details);
}

if ((!isset($_POST['companystateas'])) && (($_POST['companycountryas'] != $info['country']) || ($_POST['companycityas'] != $info['city'])))
{
$details = $_POST['companycityas'].', '.$_POST['companycountryas'];
update_company_actions($info['companyid'], 11, $details);
}
else if ((isset($_POST['companystateas'], $_POST['companycityas'])) && (($_POST['companystateas'] != $info['state']) || ($_POST['companycityas'] != $info['city'])))
{
$details = $_POST['companycityas'].', '.$_POST['companystateas'];
update_company_actions($info['companyid'], 11, $details);
}

 am coming across the problem. When I use copied text in my input form it gives some characters this � character. I am not sure how to post text so this doesn't happen. Example: This line copied: The 976cc, 101-hp Rotax® 1000R V-Twin engine is known for its reliable power. Produces: The 976cc, 101-hp Rotax� 1000R V-Twin engine is Can-Am's most powerful side-by-side engine. My code:

if (get_magic_quotes_gpc()) {
                    $description_clean_magic = stripslashes($description);
                } else {
                    $description_clean_magic = $description;
                }

Here there,   This is a post for all of you ajax/php pimps who don't mind helping a beginner.  I have been working on a little ajax script to filter a table called "recipes2" in a database called "recipes" using a dropdown menu. Once I get this script to work, I can run queries without having to refresh the page.     The problem, something is not right, the php script does not seem to be getting the posted data. even though the ajax script returns success when i check for it.  What am I doing wrong?     Also please note that, if possible, I'd like all the code to stay on one page.    This is the SQL script if you want to create the database and table:     [attachment=3349:recipesDB.txt]   Here is the code, the file should be named 'filterRecipes.php'.  [attachment=3350:filterRecipes.txt]

To anyone,

Apache 2.2.21/PHP5.3.5/MySQL 5.2.36.  The following code returns the below errors.  I am trying to get the POSTed values into MySQL.  There are no other errors.  It's like the code stopped at the ?> closing statement.  Why would the code not return the 'echo' statements? 

Any ideas?????  Much appreciated....Buchberg

Notice: Use of undefined constant id - assumed 'id' in C:\website\do_addrecord_auth_users.php on line 2

Notice: Undefined index: id in C:\website\do_addrecord_auth_users.php on line 2

<?
if ((!$_POST[id]) || (!$_POST[f_name]) || (!$_POST[l_name]) ||
(!$_POST[username]) || (!$_POST[password]) || (!$_POST[firm]) || (!$_POST[email])) {
("Location: /show_addrecord_auth_users.html");
exit;
}
$db_name="booster";
$table_name="auth_users";
$connection=mysql_connect("localhost", "username", "password") or die (mysql_error());
$db=mysql_select_db($db_name, $connection) or die (mysql_error());
$sql="INSERT INTO $table_name
(id, f_name, l_name, username, password, firm, email) VALUES
('$_POST[id]', '$_POST[f_name]', '$_POST[l_name]', '$_POST[username]',
'$_POST[password]', '$_POST[firm]', '$_POST[email]')";
$result=mysql_query($sql, $connection) or die (mysql_error());
?>
<HTML>
<HEAD>
<TITLE>Add a record to Auth Users</TITLE>
</HEAD>
<BODY>
<H1>Adding a record to <? echo "$table_name"; ?></H1>
<TABLE CELLSPACING=3 CELLPADDING=3>
<TR>
<TD VALIGN=TOP>
<P>id<BR>
<? echo "$_POST[id]"; ?></P>
</TD>
<TD VALIGN=TOP>
<P>First Name<BR>
<? echo "$_POST[f_name]"; ?></P>
</TD>
<TD VALIGN=TOP>
<P>Last Name<BR>
<? echo "$_POST[l_name]"; ?></P>
</TD>
<TD VALIGN=TOP>
<P>Username<BR>
<? echo "$_POST[username]"; ?></P>
</TD>
<TD VALIGN=TOP>
<P>Password<BR>
<? echo "$_POST[password]"; ?></P>
</TD>
<TD VALIGN=TOP>
<P>Firm<BR>
<? echo "$_POST[firm]"; ?></P>
</TD>
<TD VALIGN=TOP>
<P>email<BR>
<? echo "$_POST[email]"; ?></P>
</TD>
<P><a href="show_addrecord_auth_users.html">Add Another</a></P>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

<?php 

include("add_p2.php");




//basic pdo connection (with added option for error handling)

if (isset($_POST['submit'])) {
    try {




$stmt = $dbh->prepare("INSERT INTO passwords (description, username, password ) VALUES (:description, :username, :AES_ENCRYPT)");
$stmt->bindParam(':description', $description);
$stmt->bindParam(':username', $username);
$stmt->bindParam(':password', $password); 


	try {
    $statement->execute(array(
       "description" => "description",
       "username" => "username",
       "password" => "password"
    ));
} catch(PDOException $e) {
    echo "Exception caught: $e";
}	


//insert one row
$name = 'one';
$value = 1;
$stmt->execute();


header( 'Location: localhost/password_added.php' ); exit();


?>

<?php

$dsn = "mysql:host=127.0.0.1;dbname=pword_db;charset=utf8";
$opt = array(
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
);
$pdo = new PDO($dsn,'root','', $opt);


?>

<form action="add_p.php" method="post">
	<span class="cursive">Description:	</span><br>
	<textarea name="description" rows="20" cols="50"></textarea>
	<br>
	<span class="cursive">Username:	</span><br>
	<input type="text" name="username" />
	<br>
	<span class="cursive">Password:	</span><br>
	<input type="text" name="password" />
	<br>
	<input type="submit"/>
	</form>

    Hi,   above is the 3 components that should add form data into MySQL database using PDO.   all it's doing is entering empty values, I'm really not sure why this is?   please could someone help me with pointing me in the right direction, offer hint's making this work         Thanks                     Attached Files  PHPmyadmin.JPG   64.83KB   0 downloads

this code is to create a new user based on posted variables. it works fine for creating the necessary tables and granting privileges. but then when i log out as root and try to log back in as the user it's failing. why is it failing? Thanks, G.

Code: [Select]
<?php
extract( $_POST );
include( '../php/userobject.php' );

@ $db = mysqli_connect('localhost', 'root', 'xxxxxx', 'mealchamp');
if ( mysqli_connect_errno() ) {
echo 'Error: could not connect to database as root.<br />';
exit;
}
else
echo 'Connected to database as root.<br />';

$query = "SELECT username FROM userlist WHERE username = $uname";
$result = mysqli_query($db, $query);

if ($result) 
echo 'That user name is already taken.<br/>Please hit back on your browser, and try a different user name.<br/>';
else {
echo 'That username is available.<br/>';
echo "$fname<br/>";
echo "$lname<br/>";
echo "$add1<br/>";
echo "$add2<br/>";
echo "$city<br/>";
echo "$prov<br/>";
echo "$ctry<br/>";
echo "$post<br/>";
echo "$email<br/>";
echo "$uname<br/>";
echo "$pass1<br/>";
echo "$sex<br/>";
echo "$birth<br/>";
echo "$height<br/>";
echo "$weight<br/>";

$query = "INSERT INTO userlist 
(firstname, lastname, address1, address2, city,  province, country, postal, email,  username, password, sex,  birth,  height,  weight) VALUES
('$fname', '$lname', '$add1', '$add2', '$city','$prov', '$ctry', '$post','$email','$uname', '$pass1', '$sex', '$birth', '$height',  '$weight')";
$result = mysqli_query($db, $query);
if ($result)
echo "Userlist was updated successfully<br />";
else
echo "Could not update userlist";

$query = "CREATE TABLE ".$uname."_persfood  
(persfoodid  INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 food   VARCHAR(30) NOT NULL)";
$result = mysqli_query($db, $query);
if ($result)
echo "Personal food table was created successfully<br />";
else
echo "Could not create personal food table<br />";

$query = "GRANT select ON mealchamp.userlist TO ".$uname." IDENTIFIED BY '$pass1'";
$result = mysqli_query($db, $query);
if ($result)
echo "User priveleges were granted successfully<br />";
else
echo "Could not grant user priveleges<br />";
$query = "GRANT select, insert, update, delete, index ON mealchamp.".$uname."_persfood TO ".$uname." IDENTIFIED BY '$pass1'";
$result = mysqli_query($db, $query);
if ($result)
echo "User priveleges were granted successfully<br />";
else
echo "Could not grant user priveleges<br />";

mysqli_close($db);

@ $db = mysqli_connect('localhost', $uname, $pass1, 'mealchamp');
if ( mysqli_connect_errno() ) {
echo 'Error: could not connect to database as user.<br />';
exit;
}
else {
echo 'Connected to database as user.<br />';
?>

hi there,

basically in my database i have  DATETIME for when an article was posted, using this, I'd like to make it possible for viewers of the article to see when it was posted in a "Posted Today", "Posted Yesterday" or Posted 23 hours ago" format. If it was posted longer ago than yesterday, then I would like it to just be the normal date.

I know how to work out if it was posted today, just through:

$date = date('j F', strtotime($rows['date']));
$today=date('j F');

but not sure how to do the hours.

thanks!

I have a basicc form that takes users info and when they submit it it show on a new web page in the proper order. I need to know how do I skip a blank field. This form takes a users First, Middle, and Last name but many times they leave the middle name blank so I would want to skip this field from showing up when the form is posted. Here is what I have for the basic php script ..Would like to know how to skip a field if it is left blank on the form.
 
echo $_POST["First"], print "."; ?><?php echo $_POST["Middle"], print "."; ?><?php echo $_POST["Last"], print "."; ?><?php echo $_POST["Persona1"], print ".";<br />

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=320461.0

My issue

in my php page where i need to show all the news that have the status only active.

in my mysql table i have 3 fiels news,posted date and expiry date.
on page load i check the status of the news and displays only the active news.For that i am doing the following code,which gives me error.

that is  on page load,
first i select all the news ,update the status inactive for the news which has crossed expiry time

i check the status of the news and displays only the active news.For that i am doing the following code,which gives me error.

$query1="select time(date_posted),time(expiry_time) from muh_title where status='Active'";
      $res=mysql_query($query1);
      $row=mysql_fetch_row($res);
      $expiry_time=$row[0];$dateposted=$row[1];
      $query11="select addtime(time(date_posted),time(expiry_time)) from muh_title";
      $res11=mysql_query($query11);
      $row11=mysql_fetch_row($res11);
      $newtime=$row11[0];
      
      $query2="SELECT TIMEDIFF(time(date_posted) ,time(NOW())) FROM muh_title";
       $res2=mysql_query($query2);
      $row2=mysql_fetch_row($res2);
      $diff=$row2[0];
      
      //while($newtime){
      $query5="select *from muh_main_title where date_posted> date_sub(now(),interval (expiry_time) hour-minute )";
      //$query3="update muh_title set status='Inactive' ";
      $res3=mysql_query($query5);
      
      
      }
      $q="select * from muh_title where status='Active' ";
      $r= mysql_query($q);
      $row= mysql_fetch_row($r);
      echo "<font size='6' color='white'><b><marquee direction='left' loop='-1' align='absmiddle' behaviour='scroll' scrolldelay='90'>$row[1]</marquee></b></font>";
       ?>

i am sure some where i have lost the flow of code.

Hello there,

I have a problem with this project I'm working on, everything is working fine except for one last thing.
it goes as you go to the website, search for a city, choose a hotel from a list in that city, then book a room in that hotel, go to confirmation page then to paypal.
everything is fine except after the booking when you go to the confirmation page, it shows correctly the number of nights you booked and everything, all except the rooms, it shows 0 rooms selected, and it doesn't give any price at all.

here is the code

Code: [Select]
<?php

include("db.class.php");




class hotelManager
{


public function getHotel($where)
{
$where = isset($_POST['where']) ? $_POST['where'] : "";
$dbObj = new DB();
$where = $_POST['where'];
$sql = "select * from hotels where city_id IN (select id from cities where name = '$where') or country_id IN (select id from countries where name = '$where')";
$result = mysql_query($sql);
$arr = array();
echo "<table>";
while($row = mysql_fetch_array($result)
or die(mysql_error()))
{
echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
$imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='$rowid'");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
echo "</td>";
echo "<td valign=\"top\">";

echo "<table>
<tr>
<td valign=\"top\">
<a href=\"hotels.php?id=".$row['id']."\" class=\"titleslink\">".$row['name']."</a>
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['location']."
</td>
</tr>
</table>";

echo "</td>";
echo "</tr>";
}
echo "</table>";

  //return $arr; // array of arrays

}
/*************************** GET ONE HOTEL *****************************/
public function getHotelbyID($hotelID)
{
$dbObj = new DB();
$result = mysql_query("select * from hotels where id = '$hotelID'");
return $result;
}

public function HotelDatatabel($result)
{
$row = @mysql_fetch_array($result);
echo "<table width=98%>";       
        echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
$imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='$rowid' LIMIT 1");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
echo "</td>";
echo "<td valign=\"top\">";
echo "<table>
<tr>
<td valign=\"top\" class=\"searchtitle\">
".$row['name']."
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['location']."
</td>
</tr>
<tr>
<td>
".$row['details']."
</td>
</tr>
<tr>
<td>
<a href=\"http://".$row['website']."\" class=\"link\">".$row['website']."</a>
</td>
</tr>
</table>";
echo "</td>";
echo "</tr>";
echo "</table>";

}

/************************************ GET ROOMS **************************************/

public function getHotelRooms($hotelID)
{
$result = mysql_query("select * from rooms where hotel_id = '$hotelID'");
echo "<form name='bookingform' id='bookingform' method='post' action='book.php'>";
echo "<input name=\"roomid\" id=\"roomid\" type=\"hidden\" />";
echo "<input name=\"roomnum\" id=\"roomnum\" type=\"hidden\" />";

echo "<input name=\"hotelid\" id=\"hotelid\" type=\"hidden\" value=\"$hotelID\"/>";
echo "<table width=80% >";
echo"<tr>";
echo "<td>Check-in date</td>";
echo "<td>";
echo "<input type=\"text\" name=\"datein\" class=\"date_input\" />";
echo "</td>";
echo "<td>Check-out date</td>";
echo "<td>";
echo "<input type=\"text\" name=\"dateout\" class=\"date_input\" />";
echo "</td>";
echo"</tr>";
echo "<table>";
echo "<table class=\"rooms\" width=100% cellspacing=\"1\" >";
echo "<tr>
<th class=\"rooms\">Room Type</th>
<th class=\"rooms\">Rate for night</th>
<th class=\"rooms\">MAX</th>
<th class=\"rooms\">Nr.rooms</th>
<th class=\"rooms\">Book</th>
</tr>";
while($row = @mysql_fetch_array($result))
{
echo "<tr>";
echo "<td class=\"text\" align=center>".$row['room_type']."</td>";
echo "<td class=\"text\" align=center>".$row['price_per_day']."</td>";
echo "<td class=\"text\" align=center>".$row['people']." People</td>";
echo "<td class=\"text\" align=center>";

?>

                        <select name="nrooms" id="nrooms" onchange="
                        //alert('<?php echo $row['id'] ; ?>');
                        //alert(this.value);
                        var exist = 0;
                        if(roomids.length > 0)
                        {
for(var hh = 0;hh < roomids.length; hh++)
{

if(roomids[hh] == <?php echo $row['id'] ; ?>)
{
exist = 1;
//alert(hh);
roomnumar[hh] = this.value;


}
}
if(exist == 0)
{
roomids.push(<?php echo $row['id'] ; ?>);
roomnumar.push(this.value);
}
                        }
                        else
                        {
                        roomids.push(<?php echo $row['id'] ; ?>);
                        roomnumar.push(this.value);
                        }
                       
                        document.bookingform.roomid.value = roomids;
                        document.bookingform.roomnum.value = roomnumar;
                       
                       
                       
                        ">
                        <option value=0>  0  </option>
                        <?php
                        for($i = 0; $i < $row['available_rooms']; $i++)
                         {
                         $nr = $i+1;
                         $pr=$nr * $row['price_per_day'];
                         echo "<option value=$nr>$nr ($pr\$)</option>";
                         }
                        echo "</select>
                        </td>";
                        echo "<td align=center>
                        &nbsp;
                        </td>";
echo "</tr>";
echo "<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>";

}
echo "<tr class=\"rooms\">
<td colspan=\"4\">&nbsp;</td>

<td align=center><input type=\"submit\" value=\"book\" id=\"bookroom\" name=\"bookroom\"/></td>
</tr>";
echo "</table>";
echo "</form>";
print_r($_SESSION['order']);

$_SESSION['order']=0;
unset($_SESSION['order']);

}

}


?>
BookinManager.php

Code: [Select]
<?php include("hotelsManager.php"); ?>
<?php include("config.php"); ?>
<?php include("textManager.php"); ?>
<?php
 function echoPostedData()
 {
   
   $dbo = new DB();
   $hotelObj = new hotelManager();
   $hotelID = $_POST['hotelid'];
   $datein = $_POST['datein'];
   $dateout = $_POST['dateout'];
   $roomid = $_POST['roomid'];
   $pr = $_POST['pr'];
   
   $_SESSION['hotelID'] = isset($_POST['hotelid']) ? $_POST['hotelid'] : $_SESSION['hotelID'];
   $_SESSION['datein'] = isset($_POST['datein']) ? $_POST['datein'] : $_SESSION['datein'];
   $_SESSION['dateout'] = isset($_POST['dateout']) ? $_POST['dateout'] : $_SESSION['dateout'];
         $_SESSION['roomid'] = isset($_POST['roomid']) ? $_POST['roomid'] : $_SESSION['roomid'];   
   
   
   $roomsarray = explode(",",$_POST['roomid']);
   $_SESSION['roomsarray'] = isset($_POST['roomid']) ? explode(",",$_POST['roomid']) : $_SESSION['roomsarray'];
   $roonsNo = $_POST['nrooms'];
   $_SESSION['nrooms'] = isset($_POST['roomnum']) ? explode(",",$_POST['roomnum']) : $_SESSION['nrooms'];
   
   
   
   /********************** hotels ************************/
   
   /******************************************************/
   
   echo "<table width=95% border=0 align=\"center\" cellpadding=\"0\" cellspacing=\"0\">
         <tr><td valign=\"top\">";
                  echo "<table>";
                  echo "<tr>";
                  echo "<td valign=top>";
                   $imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='".$_SESSION['hotelID']."' LIMIT 1");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
  echo "</td>";
  echo "<td>";
  $result=$hotelObj->getHotelbyID($_SESSION['hotelID']);
  $row = mysql_fetch_array($result);
  echo "<table>";
  echo "<tr><td valign=top><strong class=subtitle3>".$row['name']."</strong></td></tr>";
  echo "<tr><td class=text valign=top>".$row['location']."</td></tr>";
  echo "<tr><td class=text valign=top>check-in Date: ".$_SESSION['datein']."</td></tr>";
  echo "<tr><td class=text valign=top>check-out Date: ".$_SESSION['dateout']."</td></tr>";
  echo "<tr><td class=text valign=top>";
  $newdate = $_SESSION['dateout'] - $_SESSION['datein'];
  $totalprice = array_sum($_SESSION['totalprice'])
  echo "</td></tr>";
  echo "<tr><td class=text valign=top>Total Price: ".$totalprice."</td></tr>";
  echo "</table>";
  
  echo "</td>";
  echo "</tr>";
  echo "</table>";
        echo "</td></tr></table>";
 }
 
 function echoForm2()
 {
?>
  <form id="userDetails" name="userDetails" action="" method="post">
                  <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr>
                      <td valign="top" class="subtitle3"><strong>Your Name</strong><br />
                      <input type="text" name="name" size="50" /></td>
                     
                    </tr>
                    <tr>
                      <td valign="top" class="subtitle3"><strong>Email address</strong><br />
                        <input type="text" name="email" size="50" />
                      </td>
                    </tr>
                    <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    </tr>
                    <tr>
                      <td valign="top" class="subtitle3">
                     
                      <?php
$roomsarray = explode(",",$_POST['roomid']);
$roonsNo =  explode(",",$_POST['roomnum']);

for($i = 0;$i<count($roomsarray);$i++)
{
if($roonsNo[$i] > 1)
{

for($j = 0;$j<$roonsNo[$i];$j++)
{
echo "<div>";
$result = mysql_query("select * from rooms where id = '$roomsarray[$i]'");
$row = mysql_fetch_array($result);
echo "<span class=subtitle3><strong>Room: </strong>".$row['room_type']." #".($j+1)."</span>";
echo "</div>";
echo "<table>";
echo "<tr>";
echo "<td>";
echo "<span class=subtitle3><strong> Full guest name </strong></span>";
echo "<br />";
echo "<input type=text name=\"guest_name[]\" size=30/>";
echo "</td>";
echo "<td align=center>
<span class=subtitle3><strong> Max people</strong></span>
<br />
<span class=subtitle3>".$row['people']."guests</span>
</td>";
echo "<td align=center>
<span class=subtitle3><strong>Smoking</strong></span><br />
<select name='smoking'>
<option value=\"\">...</option>
<option value=\"yes\">Yes</option>
<option value=\"no\">No</option>
</select>
</td>";
echo "</tr>";
echo "</table>";
echo "<br />";
}
}
else
{
if($roonsNo[$i] != 0)
{
echo "<div>";
$result = mysql_query("select * from rooms where id = '$roomsarray[$i]'");
$row = mysql_fetch_array($result);
echo "<span class=subtitle3><strong>Room: </strong>".$row['room_type']."</span>";
echo "</div>";

echo "<table>";
echo "<tr>";
echo "<td>";
echo "<span class=subtitle3><strong> Full guest name</strong></span>";
echo "<br />";
echo "<input type=text name=\"guest_name[]\" size=30/>";
echo "</td>";
echo "<td align=center>
<span class=subtitle3><strong> Max people</strong></span>
<br />
<span class=subtitle3>".$row['people']."guests</span>
</td>";
echo "<td align=center>
<span class=subtitle3><strong>Smoking</strong></span><br />
<select name='smoking'>
<option value=\"\">...</option>
<option value=\"yes\">Yes</option>
<option value=\"no\">No</option>
</select>
</td>";
echo "</tr>";
echo "</table>";

echo "<br />";
}
}

}

?>
<hr>
                      </td>
                     
                    </tr>
                    <tr>
                    <td align="right">
                      <input type="submit" name="submit" id="submit" value="Make the reservation" />
                      </td>
                    </tr>
                  </table>
  </form>
<?php
 }
 
?>
Code: [Select]
<?php include("includes/bookinManager.php"); ?>
                 
              <table width="100%" border="0" cellpadding="0" cellspacing="0" class="formtable">
                <tr>
                  <th align="left" valign="top" class="formtable"> Booking Data </th>
                </tr>
                <tr>
                  <td valign="top">&nbsp;</td>
                </tr>
                <tr>
                  <td valign="top">
  <?php
   echoPostedData();
  ?>
                  </td>
                </tr>
                <tr>
                  <td valign="top">&nbsp;</td>
                </tr>
              </table>
             
             
              </td>
            </tr>
            <tr>
              <td valign="top"><img src="images/spacer.gif" width="28" height="10" /></td>
            </tr>
            <tr>
              <td valign="top">
              <?php
if(isset($_POST['bookroom']))
  {?>
              <table width="100%" border="0" cellpadding="0" cellspacing="0" class="formtable">
                <tr>
                  <th align="left" valign="top" class="formtable"> Your Details </th>
                </tr>
                <tr>
                  <td valign="top" >
                  <form action="book.php" method="post" id="payPalForm">  
<table width="60%" border="0" cellpadding="0" cellspacing="0" class="formtable">
<tr>
<td>First name :</td>
<td><input type="text" name="first_name" /></td>
</tr>
<tr>
<td>Last name :</td>
<td><input type="text" name="last_name" /></td>
</tr>
<tr>
<td>Email address :</td>
<td><input type="text" name="email" /></td>
</tr>
<tr>
<td>Full guest name :</td>
<td><input type="text" name="full" /></td>
</tr>
<tr>
<td>Address :</td>
<td><INPUT type="text" NAME="address1" VALUE=""/></td>
</tr>
<tr>
<td>Special Requests :</td>
<td><input type="text" name="special" /></td>
</tr>

</table>
  </td>
                </tr>
                <tr>
                  <td valign="top">
                  <?php //echoForm2();
                  ?>
                 
                 


                  <input type="hidden" name="item_number" value="<?php echo $row['id']; ?>">
<input type="hidden" name="cmd" value="_ext-enter">
<input type="hidden" name="redirect_cmd" value="_xclick">
<input type="hidden" name="business" value="tarek_1305896294_biz@gotharious.com">
<input type="hidden" name="item_name" value="Standard Room: Dar El Masyaf Hotel : 2 nights : 9th, july, 2011">
<input type="hidden" name="currency_code" value="USD">
<INPUT TYPE="hidden" NAME="first_name" VALUE="Tarek">
<INPUT TYPE="hidden" NAME="last_name" VALUE="Sabrouty">
<INPUT TYPE="hidden" NAME="address1" VALUE="9th Popastes St.">
<INPUT TYPE="hidden" NAME="address2" VALUE="Cleopatra Hamamat">
<INPUT TYPE="hidden" NAME="city" VALUE="Alexandria">
<INPUT TYPE="hidden" NAME="Country" VALUE="Egypt">
<INPUT TYPE="hidden" NAME="lc" VALUE="US">
<INPUT TYPE="hidden" NAME="email" VALUE="tarek@gotharious.com">
<INPUT TYPE="hidden" NAME="night_phone_a" VALUE="+20166005733">
<INPUT TYPE="hidden" NAME="amount" VALUE="100.00">

                     
                      <?php
$roomsarray = explode(",",$_POST['roomid']);
$roonsNo =  explode(",",$_POST['roomnum']);

for($i = 0;$i<count($roomsarray);$i++)
{
if($roonsNo[$i] > 1)
{

for($j = 0;$j<$roonsNo[$i];$j++)
{
echo "<div>";
$result = mysql_query("select * from rooms where id = '$roomsarray[$i]'");
$row = mysql_fetch_array($result);
echo "<span class=subtitle3><strong>Room: </strong>".$row['room_type']." #".($j+1)."</span>";
echo "</div>";
echo "<table>";
echo "<tr>";
echo "<td>";
echo "<span class=subtitle3><strong> Full guest name </strong></span>";
echo "<br />";
echo "<input type=text name=\"guest_name[]\" size=30/>";
echo "</td>";
echo "<td align=center>
<span class=subtitle3><strong> Max people</strong></span>
<br />
<span class=subtitle3>".$row['people']."guests</span>
</td>";
echo "<td align=center>
<span class=subtitle3><strong>Smoking</strong></span><br />
<select name='smoking'>
<option value=\"\">...</option>
<option value=\"yes\">Yes</option>
<option value=\"no\">No</option>
</select>
</td>";
echo "</tr>";
echo "</table>";
echo "<br />";
}
}
else
{
if($roonsNo[$i] != 0)
{
echo "<div>";
$result = mysql_query("select * from rooms where id = '$roomsarray[$i]'");
$row = mysql_fetch_array($result);
echo "<span class=subtitle3><strong>Room: </strong>".$row['room_type']."</span>";
echo "</div>";

echo "<table>";
echo "<tr>";
echo "<td>";
echo "<span class=subtitle3><strong> Full guest name</strong></span>";
echo "<br />";
echo "<input type=text name=\"guest_name[]\" size=30/>";
echo "</td>";
echo "<td align=center>
<span class=subtitle3><strong> Max people</strong></span>
<br />
<span class=subtitle3>".$row['people']."guests</span>
</td>";
echo "<td align=center>
<span class=subtitle3><strong>Smoking</strong></span><br />
<select name='smoking'>
<option value=\"\">...</option>
<option value=\"yes\">Yes</option>
<option value=\"no\">No</option>
</select>
</td>";
echo "</tr>";
echo "</table>";

echo "<br />";
}
}

}

?>

                     
                    <input type="submit" name="Submit" value="Submit">

</form>
                 
                <tr>
                  <td valign="top">&nbsp;</td>
                </tr>
              </table>
              <?php } ?>