need help to complete my assignment (how to calculate total costs)

raynl

Hi,

I'm working on my assignment and its almost finished, the assignment is about a hotel reservation system where i enter the guests details and it calculates the final cost to produce the bill. I need to some help about how to calculate the final costs e.g. checkin-date = checkout-date, lets say guest 1 checks in on 01-05-2010 upto 10-05-2010 so that makes it 10 days. How can I calculate from checkindate to checkoutdate? any one knows? would be a big help if you can help me. Here is the site:

http://www.eyegraphic.co.uk/08227747/reservation.php

here is the coding for the reservation page:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<!The text above represents the validation of the website>
<html>
<head>
<title>HOTEL MANAGEMENT SYSTEM</title>

<link rel="stylesheet" href="style1.css" type="text/css">

</head>


<table width="100%" border="0" cellspacing="7" cellpadding="0" align="center">

<tr> 
    <td colspan="2" bgcolor="#000033"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td bgcolor="#000033"> 
            <P class="compname"><img src="wel.gif"align= "left" width="150" height="50">
          <img src="lg.gif"align= "right" width="70" height="70"> Hotel Management System<br /></P>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td width="140" valign="top" class="leftside">
      <table width="100%" border="2" cellspacing="20" cellpadding="5">
        <tr> 
<td class="button"><a href="index.html">Home</a></td>
        </tr>
        <tr> 
         <td class="button"><a href="add.php">Booking</a></td>
        </tr>
        <tr> 
          <td class="button"><a href="delete.php">Delete Booking</a></td>
        </tr>
          <td class="button"><a href="update.php">Update Details</a></td>
        </tr>
       <td class="button"><a href="list.php">List Bookings</a></td>
        </tr>
           <td class="button"><a href="logout.php">Logout</a></td>
        </tr>
       </table><p><center> <img src="payment.jpg" width="100" height="200"></center></p> 



</td>
 <td width="100%" valign="top"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">

      <tr>
      <td bgcolor="">
        <table width="100%" border="0" cellspacing="1" cellpadding="0">
          <td> 
            <td width="100%" valign="top" class="main">


 <!--THIS IS WHERE THE PHP CODES FOR THE Hotel Management System BEGINS FROM-->               

 <?php

// THIS AIDS THE WEB TO BE CONNECTED TO THE DATABASE
      $link = mysql_connect ("host", "user", "pass");
      mysql_select_db ("eyegraphic2");

// THIS BASICALLY GETS NEW RECORD ENTRY THAT IS NEW MOVIES BEEN ENTERED
      $guestid = $_GET['guestid'];
      $roomno= $_GET['roomno'];
      $reservedate= $_GET['reservedate'];
      $numnights= $_GET['numnights'];
      $numguests= $_GET['numguests'];
      $checkindate= $_GET['checkindate'];
      $checkoutdate= $_GET['checkoutdate'];
      $totalcost= $_GET['totalcost'];





// THIS SIMPLY GETS CHECKBOX THAT IS IT ALLOWS THE CHECKBOX TICKS 
      $add = $_GET['add'];


// THIS AIDS THE WEB TO BE CONNECTED TO THE DATABASE
//      $link = mysql_connect ("localhost", "root", "forest");
 //     mysql_select_db ("hotel");

// THIS SIMPLY ADD NEW RECORD TO THE DATABASE IF IT EXISTS
      if ($add == "on")
      {
        $query = "insert into roomreservation (guestid, roomno, reservedate, numnights, numguests, checkindate, checkoutdate, totalcost) values ('$guestid', '$roomno', '$reservedate', '$numnights', '$numguests', '$checkindate', '$checkoutdate', '$totalcost')";
        $result = mysql_query ($query);
      }

// THIS HELPS TO RELOAD UPDATED DATABASE AFTER ANY NEW RECORDS HAS BEEN INSERTED 
      $query = "select * from roomreservation";
      $result = mysql_query ($query);



//THE CODE BELOW UPDATES THE TABLE TO BE DISPLAYED ON THE PAGE
      print ("<form action=\"http://www.eyegraphic.co.uk/08227747/reservation.php\" method=\"get\">");
      print ("<table border='9'align=center>");
      print ("<tr><th>GuestID</th><th>RoomNo</th><th>ReserveDate</th><th>NumNights</th><th>NumGuests</th><th>CheckinDate</th>><th>CheckoutDate</th>><th>TotalCost</th>><th colspan='2'>&nbsp</th></tr>");
      print ("<tr><td><input type=\"text\" name=\"guestid\" size=3></td>");
      print ("<td><input type=\"text\" name=\"roomno\" size=30></td>");
      print ("<td><input type=\"text\" name=\"reservedate\" size=8 value='YYYY-MM-DD'></td>");
      print ("<td><select name='numnights'><option>1</option><option>2</option><option>3</option><option>4</option><option>5</option><option>6</option><option>7</option><option>8</option><option>9</option><option>10</option></select></td>");
      print ("<td><select name='numguests'><option>1</option><option>2</option><option>3</option><option>4</option><option>5</option><option>6</option><option>7</option><option>8</option><option>9</option><option>10</option></select></td>");
      print ("<td><input type=\"text\" name=\"checkindate\" size=8 value='YYYY-MM-DD'></td>");
      print ("<td><input type=\"text\" name=\"checkoutdate\" size=8 value='YYYY-MM-DD'></td>");
      print ("<td><input type=\"text\" name=\"totalcost\" size=30></td>");


  print ("<td colspan='2' align='center'>Add<input type=\"checkbox\" name=\"add\" value=\"on\"></td></tr>");
  print "</tr>";
  for ($i = 0; $i < mysql_num_rows ($result);$i ++)
  {        
   $row = mysql_fetch_object ($result);
    print "<tr>";
    print "<td>$row->guestid</td>";
    print "<td>$row->roomno</td>";
    print "<td>$row->reservedate</td>";
print "<td>$row->numnights</td>";
    print "<td>$row->numguests</td>";
print "<td>$row->checkindate</td>";
print "<td>$row->checkoutdate</td>";
print "<td>$row->totalcost</td>";

    print "</tr>";

  }

  print ("<table border='9'align=center>");

  print ("<tr><td colspan='6' align='center'><input type=\"submit\" value=\"Update Database\"></td></tr></table></form>");
  mysql_close ($link);

  print ("<form action=\"http://www.eyegraphic.co.uk/08227747/payment.php\" method=\"get\">");
  print ("<table border='9'align=center>");
  print ("<tr><td colspan='6' align='center'><input type=\"submit\" value=\"Continue\"></td></tr></table></form>");




   ?>


<!--THIS WHERE THE PHP CODES END 


<!--THIS CODE BELOW IS THE CONTUINATION OF THE HTML CODE AND IT IS RESPONSIBLE FOR THE FOOTER OF THE WEB PAGE            

             <P></P></tr>
            </tr>
        </table>
      </td>
    </tr>
  </table>
        </td>
     </tr>
   <tr> 

    <td></td>
<td bgcolor="white"> 
  <table width="100%" border="0" cellspacing="1" cellpadding="0">
    <tr> 
      <td bgcolor="#000033" width="100%"> 
<p class="foot">Contact us at 024 76272554 or 07833087894. Email- 08227747@northampton.ac.uk or r.a.y@hotmail.co.uk </p>

<P class="foot"> &copy; 2010 Hotel Management System <br />
              <br />


            <?php
//THIS PHP CODE IS RESPONSIBLE FOR THE DATE AND TIME DISPLAYED ON THE FOOTER OF THE WEB PAGE              

        echo(date("l dS \of F Y h:i:s A") . "<br />");
            ?>

    </tr>
  </table>
</td>
  </tr>
</table>
</body>
</html>

bradgrafelman

Since I see MySQL is involved, there's a simple MySQL function you can use to get that info: DATEDIFF().

Also, when posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags (not the CODE tags) as they make your code much easier to read and analyze.

EDIT: You might also want to remove your DB credentials before posting code in the future. 🙂

EDIT2: Also note that user-supplied data should never be placed directly into a SQL query, else you're vulnerable to SQL injection attacks (or just plain SQL errors). Instead, you must first sanitize it with a function such as [man]mysql_real_escape_string/man.

raynl

bradgrafelman;10949028 wrote:
Since I see MySQL is involved, there's a simple MySQL function you can use to get that info: DATEDIFF().

Also, when posting PHP code, please use the board's [noparse]
..
[/noparse] bbcode tags (not the CODE tags) as they make your code much easier to read and analyze.

EDIT: You might also want to remove your DB credentials before posting code in the future. 🙂

EDIT2: Also note that user-supplied data should never be placed directly into a SQL query, else you're vulnerable to SQL injection attacks (or just plain SQL errors). Instead, you must first sanitize it with a function such as [man]mysql_real_escape_string/man.

thanks for removing the user, pass! lol i never saw that hope no ones gonna hack into my server! btw im kinda new to php so will you be kind enough to show me what codes to produce the totalcost? thanks!

scrupul0us

use datediff to return the number of days between the dates...

num of days * daily rate + tax = total cost

raynl

scrupul0us;10949039 wrote:
use datediff to return the number of days between the dates...

num of days * daily rate + tax = total cost

I cant find anything in phpmyadmin thats says datediff. Im kinda new to php, do you how to write the code? would appreciate if u show me. thanks

bradgrafelman

DATEDIFF() is a MySQL function... you just use it in a SQL query, e.g.:

SELECT DATEDIFF(date1, date2) AS numDays, col1, col2, ... FROM myTable

The "AS numDays" is a column alias and allows you to use something like $row['numDays'] when using a function such as [man]mysql_fetch_assoc/man to retrieve the result set.