i have 2 forms here.
1) DisplayDetails. php
2) RegistrationFor m.php
when user click to the link 'Next' at the DisplayDetails. php page it will bring
all the session value to the RegistrationFor m.php page. But, there's also value which is not session which is
i) $room_type
so, at the RegistrationFor m, i wanted to passed all the values from the DisplayDetails. php into mysql query
to insert into database.After i test it, all the data work fine including the session values from DisplayDetails. php.
The only problem is, value which is i) $room_type
that i got from the query in the DisplayDetails. php as the only that
unsuccessfully inserted into the database.
So, the question is, is it possible for me to get value from the DisplayDetails. php page into
RegistrationFor m.php page query so that i can insert the value into database.
below is the code for DisplayDetails. php -
-
<?php
-
session_start();
-
//echo "<pre>";
-
//var_dump($_SESSION);
-
//echo "</pre>";
-
-
$id_no=$_GET['id_no'];
-
-
-
$query="SELECT * from room1 WHERE id_no=$id_no";
-
-
$result=mysql_query($query);
-
-
//Get the number of rows in array for loop
-
$num=mysql_numrows($result);
-
-
mysql_close();
-
-
$i=0;
-
while ($i < $num) {
-
$id_no=mysql_result($result,$i,"id_no");
-
$room_no=mysql_result($result,$i,"room_no");
-
$room_type=mysql_result($result,$i,"room_type");
-
$qty=mysql_result($result,$i,"qty");
-
$room_price=mysql_result($result,$i,"room_price");
-
-
//echo "$id_no - $room_no - $room_type - $qty - $rom_price";
-
-
$i++;
-
}
-
-
?>
-
-
<body>
-
<h3><center>
-
Room's Reservation
-
</center></h3>
-
<form action="DisplayDetails.php" method="post">
-
-
<table width="373" border="1">
-
<tr>
-
<td colspan="2"><strong>Reservation Summary</strong></td>
-
</tr>
-
<tr>
-
<td>Check In :</td>
-
<td><label> <?php echo $_SESSION['checkin']; ?> </label></td>
-
</tr>
-
<tr>
-
<td>Check Out :</td>
-
<td><label><?php echo $_SESSION['checkout']; ?></label></td>
-
</tr>
-
<tr>
-
<td>Rooms :</td>
-
<td><label><?php echo $_SESSION['rooms']; ?></label></td>
-
</tr>
-
<tr>
-
<td>Adults Per Room :</td>
-
<td><label><?php echo $_SESSION['adults']; ?></label></td>
-
</tr>
-
<tr>
-
<td>Children Per Room :</td>
-
<td><label><?php echo $_SESSION['children']; ?></label></td>
-
</tr>
-
<tr>
-
<td>Days :</td>
-
<td><?php echo $_SESSION['days']; ?></td>
-
</tr>
-
<tr>
-
<td>Room Type</td>
-
<td><?php echo $room_type; ?></td>
-
</tr>
-
<tr>
-
<td>Room Price</td>
-
<td><?php echo $room_price; ?></td>
-
</tr>
-
<tr>
-
<td>TOTAL PRICE :</td>
-
<td><?php $total =$_SESSION['days'] * $room_price;
-
echo $total;?> </td>
-
</tr>
-
</table>
-
<label>
-
<input type="submit" name="submit" id="submit" value="submit" />
-
</label>
-
<a href="RegistrationForm.php"><strong>
-
Next >> </strong></a>
-
</form>
-
</body>
-
</html>
-
-
below is the code for RegistrationFor m.php -
<?php
-
session_start();
-
?>
-
<html>
-
<body>
-
-
<form action="RegistrationForm.php" method="post">
-
-
<p><strong>REGISTRATION FORM</strong></p>
-
-
<table width="285" border="1">
-
<tr>
-
<th width="120" scope="row">Name :</th>
-
<td width="149"><label>
-
<input type="text" name="name" id="name" value="<?php $name; ?>"/>
-
</label></td>
-
</tr>
-
<tr>
-
<th scope="row">Ic No :</th>
-
<td><label>
-
<input type="text" name="ic_no" id="ic_no" value="<?php $ic_no; ?>">
-
</label></td>
-
</tr>
-
<tr>
-
<th scope="row">Contact No :</th>
-
<td><label>
-
<input type="text" name="contact_no" id="contact_no" value="<?php $contact_no; ?>">
-
</label></td>
-
</tr>
-
<tr>
-
<th scope="row">Email :</th>
-
<td><label>
-
<input type="text" name="email" id="email" value="<?php $email; ?>">
-
</label></td>
-
</tr>
-
<tr>
-
<th scope="row">Gender :</th>
-
<td><label>
-
<select name="gender" id="gender" value="<?php $gender; ?>">
-
<option>female</option>
-
<option>male</option>
-
</select>
-
</label></td>
-
</tr>
-
<tr>
-
<th scope="row">Username :</th>
-
<td><label>
-
<input type="text" name="username" id="username" value="<?php $username; ?>">
-
</label></td>
-
</tr>
-
<tr>
-
<th scope="row">Password :</th>
-
<td><label>
-
<input type="text" name="password" id="password" value="<?php $password; ?>">
-
</label></td>
-
</tr>
-
</table>
-
<p>
-
</p>
-
<p>
-
<label>
-
<input type="submit" name="submit" id="submit" value="Submit">
-
</label>
-
-
<?php
-
-
-
$room_type=$_POST['room_type'];
-
-
$sql="INSERT INTO reservation1
-
(name,ic_no, gender,checkin,checkout,
-
room_type)
-
VALUES
-
('$_POST[name]','$_POST[ic_no]','$_POST[gender]','$_SESSION[checkin]','$_SESSION[checkout]',
-
'$_POST[room_type]')";
-
?>
-
-
</p>
-
</form>
-
-
</body>
-
</html>
-
-
2 3185
Hello,
I had look over your code and think that you have make mistake in DisplayDetails. php line number 18. mysql_close(); which should be end of the page. Also there is no database connection in RegistrationFor m.php. Also you have not assign room_type to session or retrieve it from session make sure for that.
Regards,
Mayur Bhayani
Thanks Mayur2007. your comment did really help me. I already solved the problems..thank z for spending time to check my code..:)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: lawrence |
last post by:
A very strange bug. www.monkeyclaus.org is run by a cms I'm
developing. One of types of users we allow is "justTestingTheSite", a
type of user I developed to give demo's to prospective clients. The
purpose of this level of security is to let someone log in and see
everything as if they were root, and yet not be able to update or
delete...
|
by: jason |
last post by:
How does one loop through the contents of a form complicated by dynamic
construction of checkboxes which are assigned a 'model' and 'listingID' to
the NAME field on the fly in this syntax: Hunter_69. Here is what the form
looks like. I have the difficulty of inserting the multiple items selected
by the user the first time he visits and uses...
|
by: shank |
last post by:
I have a recordset that contains multiple records of product a user is
purchasing. For clarity, I converted the recordset fields to variables. I
need to take that entire recordset and insert it into another table on a
remote server. The below code only inserts 1 record. How do I change the
code to get all records inserted?
thanks!
<%
Dim...
|
by: PT |
last post by:
I got a problem. And thats.....
First of all, I got these three tables.
------------------- ------------------ ----------------------
tblPerson tblPersonSoftware tblSoftware
------------------- ------------------ ----------------------
PID PName PID* SID* SID SWName
--- ...
|
by: Geoffrey KRETZ |
last post by:
Hello,
I'm wondering if the following behaviour is the correct one for
PostGreSQL (7.4 on UNIX).
I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching
the following request :
INSERT INTO temp_tab VALUES (1,2,3)
| |
by: robecflo |
last post by:
Hi Forum, i have a problem, hope somebody can give me ideas. I'm
developing with windows forms and vb.net, and oracle as a database. At
this moment i have a table called amortizaciones, this table has a
field called id_pasivo, which is foreign key to another table called
pasivo, a consecutive field called no_cupon and a third field called...
|
by: underground |
last post by:
I wonder if possible on page load to query the value of a specific colmn and insert the result into another table. My query looks like so
<?
include("include/session.php");
?>
<?
$usr = "xxxx";
$pwd = "xxxxx";
$db = "xxxxx";
|
by: rn5a |
last post by:
During registration, users are supposed to enter the following
details: First Name, Last Name, EMail, UserName, Password, Confirm
Password, Address, City, State, Country, Zip & Phone Number. I am
using MS-Access 2000 database table for this app. Note that the
datatype of all the fields mentioned above are Text. Apart from the
above columns,...
|
by: Bob |
last post by:
Hi all,
I'm trying to import data, modify the data then insert it into a new
table. The code below works fine for it but it takes a really long
time for 15,000 odd records. Is there a way I can speed up the
processing substantially? as it currently takes about 10 minutes and
thats just way too long because there is many of these imports...
|
by: rn5a |
last post by:
In a ASP applicatiuon, the FOrm has a textbox & a select list where
the admin can select multiple options. Basically the admin has to
enter the name of a new coach in the textbox & select the soccer clubs
which he will be coaching; thus he can select only one soccer club for
a new coach or multiple soccer clubs.
This is how I am trying it:...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |