Jump to content

Else echo doesnt work

princeofpersia

By princeofpersia
in PHP Coding Help

 Share

Recommended Posts

princeofpersia Regular Member

princeofpersia

Posted
Posted

Hi guys, in code below I have a section where users can check seat avillability, however it shows the seats taken but it doest say the seats available, can u help me find out whats wrong? thanks in advance guys

this is the line below

 

$checkavailability=mysql_query("SELECT * FROM booking WHERE date='$mybookingdate' AND time='$mytime' AND ride_id='$ride_id'");
while($row=mysql_fetch_array($checkavailability))
{
$takenseats=$row['seat_no'];


  if (mysql_num_rows($checkavailability)>=1)
	   {
		 echo "<table>";

echo "

        <td>Seat No ".$takenseats." is taken</td>
        
";
}
else{


echo "

        <td>Seat No ".$takenseats." is Available</td>
        
";
}
	   }
	   

echo "</table>";	
}

?>

 

full code below:

 

 

<?php

session_start();
include ("includes/db.php");
include ("includes/function.php");
//authentication
if (loggedin()==FALSE)
{
Header("Location: login.php");
exit();
}
//username session
$_SESSION['username']=='$username';
$username=$_SESSION['username'];
echo "Welcome, " .$_SESSION['username']."!<p>";
//get details from user table to be passed to page(text fields)

$getdetails=mysql_query("SELECT * FROM users WHERE username='$username'");
while($row = mysql_fetch_array($getdetails))
{
$users_id=$row['id'];
$first_name=$row['first_name'];
$last_name=$row['last_name'];
$email=$row['email'];

}

///////////////////////////////////////
//****************************//


//post starts here
if (isset($_POST['next']) && $_POST['next'])
    {


$myfirstname = addslashes(strip_tags($_POST['firstname']));
$mylastname = addslashes(strip_tags($_POST['lastname']));
$myemail = addslashes(strip_tags($_POST['email']));
$mybookingdate = addslashes(strip_tags($_POST['datetime']));
$mytime = addslashes(strip_tags($_POST['time']));
$myseatnumber = addslashes(strip_tags($_POST['seatnumber']));
$ride_id=1;

//check if booking exists

$checkbooking=mysql_query("SELECT * FROM booking WHERE date='$mybookingdate' AND time='$mytime' AND seat_no='$myseatnumber'");
	   if (mysql_num_rows($checkbooking)>=1)
	   {
           echo "Seat No $myseatnumber For $mybookingdate at $mytime has been already taken, Please try a different seat, time or date";
	   
	   
	   }
else
{

$checktotoal=mysql_query("SELECT * FROM booking WHERE date='$mybookingdate' AND time='$mytime'");
	   if (mysql_num_rows($checkbooking)>=48)
	   {
           echo "We are fully book for this time and date, please choose different time/date to continue your booking";
	   
	   
	   }
	   
	   //pass the variables here
	}
	}

if (isset($_POST['availability']) && $_POST['availability'])
    {

$mybookingdate = addslashes(strip_tags($_POST['datecheck']));
$mytime = addslashes(strip_tags($_POST['timecheck']));
$myseatnumber = addslashes(strip_tags($_POST['seatnumbercheck']));
$ride_id=1;

$checkavailability=mysql_query("SELECT * FROM booking WHERE date='$mybookingdate' AND time='$mytime' AND ride_id='$ride_id'");
while($row=mysql_fetch_array($checkavailability))
{
$takenseats=$row['seat_no'];


  if (mysql_num_rows($checkavailability)>=1)
	   {
		 echo "<table>";

echo "

        <td>Seat No ".$takenseats." is taken</td>
        
";
}
else{


echo "

        <td>Seat No ".$takenseats." is Available</td>
        
";
}
	   }
	   

echo "</table>";	
}

?>
<html>
<head>

<link type="text/css" href="css/smoothness/jquery-ui-1.8.6.custom.css" rel="stylesheet" />	
<script type="text/javascript" src="includes/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="includes/jquery-ui-1.8.6.custom.min.js"></script>


<script type="text/javascript">  


$(function() {  
    $('#datetime').datepicker({  
dateFormat: 'dd.mm.yy'
});  
});  


$(function() {  
    $('#datecheck').datepicker({  
dateFormat: 'dd.mm.yy'
});  
});  
</script>

</head>

<body>
<table width="665" border="0">
  <tr>
    <td width="372"><form name="booking" method="post" action="">
      <p>BOOK NOW      
      <p>      First Name:<br />
        <input type="text" name='firstname' value="<? echo "$first_name";?>">
      <p>Last Name:<br />
        <input type="text" name='lastname' value="<? echo "$last_name";?>">
      <p>Email:<br />
        <input type="text" name='email' value="<? echo "$email";?>">
      <p>Choose a Date:<br />
        <input type="text" name='datetime' id="datetime">
      </p>
      <p> Select a Time:<br/>
        <select name='time'>
          <option value="9:00">9:00
            <option value="9:07">9:07
            <option value="9:14">9:14
            <option value="9:21">9:21
            <option value="9:28">9:28
            <option value="9:35">9:35
            <option value="9:42">9:42
            <option value="9:49">9:49
            <option value="9:56">9:56
            <option value="10:03">10:03
            <option value="10:10">10:10
            <option value="10:17">10:17
            <option value="10:24">10:24
            <option value="10:31">10:31
            <option value="10:38">10:38
            <option value="10:45">10:45
            <option value="10:52">10:52
            <option value="10:59">10:59
            <option value="11:02">11:02
            <option value="11:09">11:09
            <option value="11:16">11:16
            <option value="11:23">11:23
            <option value="11:30">11:30
            <option value="11:37">11:37
            <option value="11:44">11:44
            <option value="11:51">11:51
            <option value="11:58">11:58         
          </select>
      </p>
      <p> Select Seat Number:<br/>
        <select name='seatnumber'>
          <option value="1">Seat 1
            <option value="2">Seat 2
            <option value="3">Seat 3
            <option value="4">Seat 4
            <option value="5">Seat 5
            <option value="6">Seat 6
            <option value="7">Seat 7
            <option value="8">Seat 8
            <option value="9">Seat 9
            <option value="10">Seat 10
            <option value="11">Seat 11
            <option value="12">Seat 12
            <option value="13">Seat 13
            <option value="14">Seat 14
            <option value="15">Seat 15
            <option value="16">Seat 16
            <option value="17">Seat 17
            <option value="18">Seat 18
            <option value="19">Seat 19
            <option value="21">Seat 20
            <option value="22">Seat 22
            <option value="23">Seat 23
            <option value="24">Seat 24
            <option value="25">Seat 25
            <option value="26">Seat 26
            <option value="27">Seat 27
            <option value="28">Seat 28
            <option value="20">Seat 29
            <option value="30">Seat 30
            <option value="31">Seat 31
            <option value="32">Seat 32
            <option value="33">Seat 33
            <option value="34">Seat 34
            <option value="35">Seat 35
            <option value="36">Seat 36
            <option value="37">Seat 37
            <option value="38">Seat 38
            <option value="39">Seat 39
            <option value="40">Seat 40
            <option value="41">Seat 41
            <option value="42">Seat 42
            <option value="43">Seat 43
            <option value="44">Seat 44
            <option value="45">Seat 45
            <option value="46">Seat 46
            <option value="47">Seat 47
            <option value="48">Seat 48                                                                                              
          </select>
      <p>
        <input type='submit' name='next' value='Next Step'>
    </form></td>
    <td width="283">
    <form name="booking" method="post" action="">
      <p>Check Seat Availability<br />
      <p><br />
      <p>Choose a Date:<br />
        <input type="text" name='datecheck' id="datecheck">
              <p> Select Seat Number:<br/>
        <select name='seatnumbercheck'>
          <option value="1">Seat 1
            <option value="2">Seat 2
            <option value="3">Seat 3
            <option value="4">Seat 4
            <option value="5">Seat 5
            <option value="6">Seat 6
            <option value="7">Seat 7
            <option value="8">Seat 8
            <option value="9">Seat 9
            <option value="10">Seat 10
            <option value="11">Seat 11
            <option value="12">Seat 12
            <option value="13">Seat 13
            <option value="14">Seat 14
            <option value="15">Seat 15
            <option value="16">Seat 16
            <option value="17">Seat 17
            <option value="18">Seat 18
            <option value="19">Seat 19
            <option value="21">Seat 20
            <option value="22">Seat 22
            <option value="23">Seat 23
            <option value="24">Seat 24
            <option value="25">Seat 25
            <option value="26">Seat 26
            <option value="27">Seat 27
            <option value="28">Seat 28
            <option value="20">Seat 29
            <option value="30">Seat 30
            <option value="31">Seat 31
            <option value="32">Seat 32
            <option value="33">Seat 33
            <option value="34">Seat 34
            <option value="35">Seat 35
            <option value="36">Seat 36
            <option value="37">Seat 37
            <option value="38">Seat 38
            <option value="39">Seat 39
            <option value="40">Seat 40
            <option value="41">Seat 41
            <option value="42">Seat 42
            <option value="43">Seat 43
            <option value="44">Seat 44
            <option value="45">Seat 45
            <option value="46">Seat 46
            <option value="47">Seat 47
            <option value="48">Seat 48                                                                                              
          </select>
      <p>
      </p>
      <p> Select a Time:<br/>
        <select name='timecheck'>
          <option value="9:00">9:00
            <option value="9:07">9:07
            <option value="9:14">9:14
            <option value="9:21">9:21
            <option value="9:28">9:28
            <option value="9:35">9:35
            <option value="9:42">9:42
            <option value="9:49">9:49
            <option value="9:56">9:56
            <option value="10:03">10:03
            <option value="10:10">10:10
            <option value="10:17">10:17
            <option value="10:24">10:24
            <option value="10:31">10:31
            <option value="10:38">10:38
            <option value="10:45">10:45
            <option value="10:52">10:52
            <option value="10:59">10:59
            <option value="11:02">11:02
            <option value="11:09">11:09
            <option value="11:16">11:16
            <option value="11:23">11:23
            <option value="11:30">11:30
            <option value="11:37">11:37
            <option value="11:44">11:44
            <option value="11:51">11:51
            <option value="11:58">11:58         
          </select>
      <p>
        <input type='submit' name='availability' value='Check Availability'>
      </form>  
    </td>
  </tr>
</table>
<p>
</body>
    
</html>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.