[PHP-DB] inserting datas through table

2003-02-04 Thread kumar 
Dear Sir/Madam,
 I have create table for reservation system in that table i need to save
all the values
but it couldn`t save all the values it saves only the last value.
  Please help me!
   html
?php
if($submit)
{
$db = mysql_connect("localhost", "kumar","");
mysql_select_db("Golf",$db);
$sql = "INSERT INTO personalmst (setdate,name, uid, password, bumon,email)
VALUES ('$setdate','$name', '$uid', '$password','$bumon','$email')";
$result = mysql_query($sql);
 if(!($_POST['password'] == $_POST['confirmpassword'])) //Does their
passwords match?
{
 echo " Your password do not match!";
}
 echo "Thank you! Information entered.\n";
}
else
{
?
form method="post" action="Master.php" 
Setdate:input type="text" name="setdate"br
First name:input type="Text" name="name"br
UserID:input type="Text" name="uid"br
Password:input type="password" name="password"br
 Confirm Password:input type="text" name="confirmpassword"br
Department:SELECT NAME="bumon"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT bumon FROM personalmst",$db);
 echo("option value=\"\"/option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["bumon"],$myrow["bumon"]);
 }
?/SELECTbr
E-mail:input type="Text" name="email"br
input type="Submit"name="submit" value="Register"
input type="reset" name="cancel" value="cancel"
input type="button" name=update value=update
onclick="window.location='http://192.168.1.22/test/Master1.php'"
td align="right"a href="Bumon.php" align="right"MasterCheck/a
/td
/form
?
}
?
/HTML

[PHP-DB] inserting datas through table

2003-02-04 Thread kumar 
Dear Sir/Madam,
I have created  reservation table i need to store all the values in
database when i click the submit button
but it couldn`t working.
/*
Master3.php
*/
HTML
?php
if($submit)
{
$db = mysql_connect("localhost", "kumar","");
mysql_select_db("Golf",$db);
$sql = "INSERT INTO reservationmst(udate,timezone,starttime) VALUES
('$udate','$timezone','$starttime')";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
}
else
{
?
form method="get" action="Master3.php"
table border="2"
tr
tr
 thMonth /th
 thDay/th
 thTime Zone/th
  thStart Time/th
thDepartment/th
/tr
tr
  td input type="text" size="10" name="udate" /td
td
SELECT NAME="youbi"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT youbi FROM reservationmst",$db);
 echo("option value=\"\"select /option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["youbi"],$myrow["youbi"]);
 }
?/SELECT/td
  tdinput type="text" size="10" name="timezone"/td
  tdinput type="text" size="10" name="starttime"/td
td
SELECT NAME="bumon"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT bumon FROM personalmst",$db);
 echo("option value=\"\"select /option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["bumon"],$myrow["bumon"]);
 }
?/SELECT
SELECT NAME="bumon"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT bumon FROM personalmst",$db);
 echo("option value=\"\"select /option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["bumon"],$myrow["bumon"]);
 }
?/SELECT
SELECT NAME="bumon"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT bumon FROM personalmst",$db);
 echo("option value=\"\"select /option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["bumon"],$myrow["bumon"]);
 }
?/SELECT
SELECT NAME="bumon"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT bumon FROM personalmst",$db);
 echo("option value=\"\"select /option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["bumon"],$myrow["bumon"]);
 }
?/SELECT
/td
/tr
tr
  td input type="text" size="10" name="udate" /td
td
SELECT NAME="youbi"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT youbi FROM reservationmst",$db);
 echo("option value=\"\"select /option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["youbi"],$myrow["youbi"]);
 }
?/SELECT/td
  tdinput type="text" size="10" name="timezone"/td
  tdinput type="text" size="10" name="starttime"/td
td
SELECT NAME="bumon"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT bumon FROM personalmst",$db);
 echo("option value=\"\"select /option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["bumon"],$myrow["bumon"]);
 }
?/SELECT
SELECT NAME="bumon"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT bumon FROM personalmst",$db);
 echo("option value=\"\"select /option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["bumon"],$myrow["bumon"]);
 }
?/SELECT
SELECT NAME="bumon"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT bumon FROM personalmst",$db);
 echo("option value=\"\"select /option");
while($myrow = mysql_fetch_array($result))
 {
printf("option value=\"%s\"%s/option\n",
$myrow["bumon"],$myrow["bumon"]);
 }
?/SELECT
SELECT NAME="bumon"
?php $db = mysql_connect("localhost", "kumar")
OR DIE("Unable to connect to database");
mysql_select_db("Golf",$db);
$result = mysql_query("SELECT bumon FROM personalmst",$db);

Re: [PHP-DB] inserting datas through table

2003-02-04 Thread Jason Wong 
On Wednesday 05 February 2003 15:03, kumar wrote:

 I have created  reservation table i need to store all the values in
 database when i click the submit button
 but it couldn`t working.

Could you give a detailed description of HOW it isn't working?

What did you expect the code to do?

What is the code actually doing?

Did you print out the key variables to see whether they contain what you 
expect them to contain?


[snip]

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
QOTD:
"Oh, no, no...  I'm not beautiful.  Just very, very pretty."
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php