PHP - Vurtual Fitting Room

i am new with web socket and in same time I try to make server and client communication for soccer manager application, and for this purpose, i need to create closed "chat rooms" or "games" where two users can watch (read game event) and menage (create) game event (make substitution, formation ... or if you want, to send message to server, that they make changes in formation) this game (room) mast bi secret, and only this two player can use this game for "read" and "write" events in game for example: Game no: 200001 between user A and user B in 14.05. when User A, and User B click on game no. 200001 they can read and write game event. PS: for now, i create basic chat aplication with PHP, jQuery and webSocket and in this app, all user see wath all other user do (public chat) and i want to make secret chat for specific user (already automate subscribed from server) All work with no problem (i work on this example http://www.sanwebe.c...ket-php-socket) How i can create chat room(s) and subscribe user to specific chat room? Thanks
Edited by laponac84, 30 November 2014 - 09:09 AM.

I'm using FPDF to generate dynamic reports. How can I make sure MySQL queried results don't overflow into adjacent cells if the text length is longer then the cells designated width? I once accomplished this by using CSS with white-space:nowrap and overflow:hidden. But I can't think of how to do this with FPDF.

Any ideas??

I've been trying to think of the best way to build a PHP based chat room. Obviously a push method would work the greatest but I have been unable to find any such techniques using PHP so this is the only alternative I can think of.

When a user logs in to the chat, a file is created in a secure directory on the server for the user. This file will store messages to be sent to the user. Each time someone sends a message to the chat, the message is inserted into every user's file. Then, using AJAX, the user in chat will "reload" the chat every few seconds, which will simply access a PHP script that reads the file, sends it to the user, then truncates the file contents to zero.

My concern is obviously the high frequency of server loads to access the chat file, but this is why I would try to minimize the server's effort for retrieving chat content and focus the efforts more on sending messages since this action is done less often.

I'm looking for suggestions on what would be best to keep the system efficient... maybe some ideas of headers to send which may help with optimization. Thank you for your time.

If I query my database: www.mydomain.com/index.php?room=M210   I get both room M201 and M210B in my results.   I know enough to know that is a result of:

   and (allstate_schedule.room LIKE '$room%')

So I change it to this:

   and (allstate_schedule.room LIKE '$room')

Now the query works correctly: www.mydomain.com/index.php?room=M210   But if I pull up an unfiltered list: www.mydomain.com/index.php   ... I get my "No records found matching:"   here is my code:

 $query =
        "SELECT allstate_schedule.sponsor,allstate_schedule.school,allstate_schedule.student,allstate_schedule.instrument,allstate_schedule.school,allstate_schedule.room,allstate_schedule.time
        from allstate_schedule
        WHERE ((allstate_schedule.sponsor LIKE '$sponsor%')
      and (allstate_schedule.student LIKE '%$student%')
   and (allstate_schedule.instrument LIKE '$instrument%')
   and (allstate_schedule.school LIKE '$school%')
   and (allstate_schedule.room LIKE '$room%')
   and (allstate_schedule.time LIKE '$time%'))
        ORDER BY allstate_schedule.$sort LIMIT $eu, $limit ";
$resultt = mysql_query($query);

// Determine the number of employees
$number = mysql_num_rows($resultt);

if ($number == 0) {
   print "<b>No records found matching</b>:";

$sponsor = $sponsor;
$school = $school;
$room = $room;
$student = $student;

Edited by wkilc, 08 November 2014 - 12:07 PM.

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 } ?>