page 1 : user chose room --> save to database number_room, so indatabase now there are id_reservation and number_room
page 2 : complete userself informatoin --> I have problem here, information will be saved into databse in new row, and have new id_reservation.But I want save it into id_reservation when user chose room.
my code here
page1 : for chose room
Code: Select all
$id_numberRoom = $_POST['id_numberRoom'];
if(!get_magic_quotes_gpc())
{
$id_numberRoom = addslashes($id_numberRoom);
}
@ $db = mysql_connect("localhost", "root","") or die("Error");
mysql_select_db("",$db) or die("Can't choose database");
//user book room
$query = "insert into reservation " . "(id_numberRoom) values"
. "('$id_numberRoom')";
mysql_query($query) or die(mysql_error());
//volny pokoj -> obsazeno in database
$query_edit_stateRoom = "UPDATE pokoj p,reservation r SET p.state_room = 'obsazeno'
WHERE p.id_numberRoom = r.id_numberRoom";
mysql_query($query_edit_stateRoom) or die(mysql_error());
?>Code: Select all
$day_moveInto = $_POST['day_moveInto'];
$day_move = $_POST['day_move'];
if(!$day_moveInto||!$day_move){
echo 'Třeba vyplnit upnle informace !!!';
exit;
}
if(!get_magic_quotes_gpc())
{
$day_moveInto = addslashes($day_moveInto);
$day_move = addslashes($day_move);
}
@ $db = mysql_connect("localhost", "root","") or die("No way");
mysql_select_db("",$db) or die("Nelze database");
$query = "insert into reservation " . "(day_moveInto,day_move) values"
. "('$day_moveInto','$day_move')";
mysql_query($query) or die(mysql_error());
?>