deleting records with checkboxes

**nick0161** · Oct 11, 2004, 18:57

i changed </form> to echo "</form>"; and got
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in c:\program files\apache group\apache\htdocs\delrecord.php on line 77

which is just a commented line...

by the way i do really appreciate all the help you've given... many thx

**devscripts** · Oct 11, 2004, 18:58

hmmmm i think if i taught u how to do this so u forget that tutorial it wud have been better for you all this time lol.

i dunno wot to do now. i feel really bad. if u still want to go on paste ur code again :P i dont give up that easily BUT if u r too tired then i will leave u with a small tutorial here of my own so u understand how the values r passed through. its upto you.

does the parse error say enexpected soemthing?

**devscripts** · Oct 11, 2004, 18:59

paste me ur code now :P

**nick0161** · Oct 11, 2004, 19:01

hehehe yeh...
don't feel bad mate.. you've helped me heaps....i've kept your code.. heheh i'm not too tired... i'm at work... hehehe... i'm doing work experience... what's the small tutorial of,this is the error msg

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in c:\program files\apache group\apache\htdocs\delrecord.php on line 77

and the submit form gives the same result... so i'm presuming one error for two things is better than one each for each thing...

**nick0161** · Oct 11, 2004, 19:02

<table>
<tr>
<td>

<?php
global $delete;
global $submit;
global $eventid;
global $del;
global $record;

if (isset($_POST['action'])){
$enventid = "2004-10-20";}
else{
//$enventid = $_GET['eventid'];
$enventid = "2004-10-20";
}

echo "<html><body bgcolor=#FFFFFF>";
//echo "<form method=\"POST\" action=\"testresults.php\">";
$db = mysql_connect("localhost","root");//,"password");
//mysql_select_db("database",$db);
mysql_select_db("t1",$db);

$sql = "SELECT * from timetable where Date='$enventid'";
$result = mysql_query($sql, $db) or die ("Invalid query");

?>
<br><hr noshade>
<table cellpadding=0 cellspacing=0 width=200>
<tr><td>
<table border=1>
<tr><td>RoomID</td>
<td>Date</td>
<td>Time_Start</td>
<td>Time_Finish</td>
<td>Persons_Inc</td>
<td>Guests</td>
<td>Delete?</td>
</tr>

<?php /*
while ($row = mysql_fetch_array($result)){
echo "<tr><td>$row[RoomID]</td><td>";
echo "$row[Date]</td><td>";
echo "$row[Time_Start]</td><td>";
echo "$row[Time_Finish]</td><td>";
echo "$row[Persons_inc]</td><td>";
echo "$row[Guests]</td><td>";
echo "<input type=\"radio\" value=\"$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";
*/
while ($row = mysql_fetch_array($result)){
echo "<tr><td>$row[RoomID]</td><td>";
echo "$row[Date]</td><td>";
echo "$row[Time_Start]</td><td>";
echo "$row[Time_Finish]</td><td>";
echo "$row[Persons_inc]</td><td>";
echo "$row[Guests]</td><td>";
echo "<input type=\"radio\" value=\"$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";

// here echo the form like this....
echo "<form method =\"POST\" action=\"".$_SERVER['PHP_SELF']."\">";
echo "<input type=\"hidden\" name=\"action\" value=\"submitted\">";
echo "<input type=\"submit\" name=\"submit\" value=\"Submit Booking\">";
echo "<input type=\"hidden\" name=\"roomid\" value=\"".$row[RoomID]."\">";
echo "<input type=\"hidden\" name=\"date\" value=\"".$row[Date]."\">";
echo "<input type=\"hidden\" name=\"timestart\" value=\"".$row[Time_Start]."\">";
echo "<input type=\"hidden\" name=\"action2\" value=\"submitted2\">";
echo "<input type=\"submit\" name=\"submit2\" value=\"Delete\">";
echo "</form>";

}

//--------------------------------------
/*
</table></td><td>          </td><td>

<form action="<?php echo $_SERVER['PHP_SELF']; " method="post">
RoomID: <br />

<select name="book[roomid]">
<option value="1">BoardRoom
<option value="2">SmallRoom
</select><br>

Date: yyyy/mm/dd <input type="text" name="book[date]" /><br />
Start Time : <input type="text" name="book[start_time]" /><br />
Finish Time: <input type="text" name="book[finish_time]" /><br />
Persons Included: <input type="text" name="book[persons_inc]" /><br />
Guests: <input type="text" name="book[guests]" /><br />

<br />
<form method = "POST" action="delrecord.php">
<input type="hidden" name="action" value="submitted" />
<input type="submit" name="submit" value="Submit Booking" />
</form>

<form method = "POST" action="delrecord.php">
<input type="hidden" name="action2" value="submitted2" />
<input type="submit" name="submit2" value="Delete" />
</form>

*/
?>
<?php
if (isset($_POST['action']) == 'submitted'){

$RmID = $_POST['book']['roomid'];
if ($RmID == '2'){
$RoomID = "SmallRoom";}
else { $RoomID = "BoardRoom";}
$Date = $_POST['book']['date'];
$Time_Start = $_POST['book']['start_time'];
$Time_Finish = $_POST['book']['finish_time'];
$Persons_inc = $_POST['book']['persons_inc'];
$Guests = $_POST['book']['guests'];

$sql = "INSERT INTO timetable (RoomID,Date,Time_Start,Time_Finish,Persons_inc,Guests) VALUES('$RoomID','$Date','$Time_Start','$Time_Finish','$Persons_inc','$Guests')";
$result = mysql_query($sql, $db) or die ("Invalid query");
echo "<b>Submission Added</b><br><br>";
}

if (isset($_POST['action2']) == 'submitted'){

$sql = "DELETE FROM timetable WHERE RoomID='$_POST["roomid"]' AND Date='$_POST["date"]' AND Time_Start='$_POST["timestart"]'";

echo "you would like to delete";
//$array = explode(",",$delete);
//print_r($array);

//$sql = "DELETE FROM timetable WHERE RoomID='$array[0]' AND Date='$array[1]' AND Time_Start='$array[2]'";
//$sql = "DELETE FROM timetable WHERE RoomID='$row[RoomID]' AND Date='$row[Date]' AND Time_Start='$row[Time_Start]'";
//$sql = "DELETE FROM timetable WHERE RoomID=$RoomID' AND Date='$Date' AND Time_Start='$Time_Start'";
$result = mysql_query($sql, $db) or die ("Invalid query");
}
?>
</tr></table>

**nick0161** · Oct 11, 2004, 19:06

i'm confused whether i am meant to delete some or all of the html section after
//---------------------------------

**devscripts** · Oct 11, 2004, 19:09

ok few error first here
this form line forgot to close php with ?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
RoomID: <br />

<select name="book[roomid]">
<option value="1">BoardRoom
<option value="2">SmallRoom
</select><br>

**devscripts** · Oct 11, 2004, 19:11

now tell me where the error is.

**nick0161** · Oct 11, 2004, 19:12

it's hard to see but i commented that whole html section that was y i deleted ?>
what i meant to keep it... if i keep that html section i get a parse error on an empty line....

i get a parse error on line 41
which is a blank line before the commented while loop....

**devscripts** · Oct 11, 2004, 19:13

also get rid of

<form method = "POST" action="delrecord.php">
<input type="hidden" name="action2" value="submitted2" />
<input type="submit" name="submit2" value="Delete" />
</form>

this form since we have it in the loop.

**nick0161** · Oct 11, 2004, 19:17

still same error

**devscripts** · Oct 11, 2004, 19:20

try this code in a new file plz? i have removed some things errors. and let me know if u get errors and line numbers.

<table>
<tr>
<td>

<?php
global $delete;
global $submit;
global $eventid;
global $del;
global $record;

if (isset($_POST['action'])){
$enventid = "2004-10-20";}
else{
//$enventid = $_GET['eventid'];
$enventid = "2004-10-20";
}

echo "<html><body bgcolor=#FFFFFF>";
//echo "<form method=\"POST\" action=\"testresults.php\">";
$db = mysql_connect("localhost","root");//,"password");
//mysql_select_db("database",$db);
mysql_select_db("t1",$db);

$sql = "SELECT * from timetable where Date='$enventid'";
$result = mysql_query($sql, $db) or die ("Invalid query");

?>
<br><hr noshade>
<table cellpadding=0 cellspacing=0 width=200>
<tr><td>
<table border=1>
<tr><td>RoomID</td>
<td>Date</td>
<td>Time_Start</td>
<td>Time_Finish</td>
<td>Persons_Inc</td>
<td>Guests</td>
<td>Delete?</td>
</tr>

<?php
while ($row = mysql_fetch_array($result)){
echo "<tr><td>$row[RoomID]</td><td>";
echo "$row[Date]</td><td>";
echo "$row[Time_Start]</td><td>";
echo "$row[Time_Finish]</td><td>";
echo "$row[Persons_inc]</td><td>";
echo "$row[Guests]</td><td>";
echo "<input type=\"radio\" value=\"$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";

while ($row = mysql_fetch_array($result)){
echo "<tr><td>$row[RoomID]</td><td>";
echo "$row[Date]</td><td>";
echo "$row[Time_Start]</td><td>";
echo "$row[Time_Finish]</td><td>";
echo "$row[Persons_inc]</td><td>";
echo "$row[Guests]</td><td>";
echo "<input type=\"radio\" value=\"$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";

echo "<form method =\"POST\" action=\"".$_SERVER['PHP_SELF']."\">";
echo "<input type=\"hidden\" name=\"action\" value=\"submitted\">";
echo "<input type=\"submit\" name=\"submit\" value=\"Submit Booking\">";
echo "<input type=\"hidden\" name=\"roomid\" value=\"".$row[RoomID]."\">";
echo "<input type=\"hidden\" name=\"date\" value=\"".$row[Date]."\">";
echo "<input type=\"hidden\" name=\"timestart\" value=\"".$row[Time_Start]."\">";
echo "<input type=\"hidden\" name=\"action2\" value=\"submitted2\">";
echo "<input type=\"submit\" name=\"submit2\" value=\"Delete\">";
echo "</form>";

}

</table></td><td>          </td><td>

<form action="<?php echo $_SERVER['PHP_SELF']; ?> " method="post">
RoomID: <br />

<select name="book[roomid]">
<option value="1">BoardRoom
<option value="2">SmallRoom
</select><br>

Date: yyyy/mm/dd <input type="text" name="book[date]" /><br />
Start Time : <input type="text" name="book[start_time]" /><br />
Finish Time: <input type="text" name="book[finish_time]" /><br />
Persons Included: <input type="text" name="book[persons_inc]" /><br />
Guests: <input type="text" name="book[guests]" /><br />

<br />
<form method = "POST" action="delrecord.php">
<input type="hidden" name="action" value="submitted" />
<input type="submit" name="submit" value="Submit Booking" />
</form>

<?php
if (isset($_POST['action']) == 'submitted'){

$RmID = $_POST['book']['roomid'];
if ($RmID == '2'){
$RoomID = "SmallRoom";}
else { $RoomID = "BoardRoom";}
$Date = $_POST['book']['date'];
$Time_Start = $_POST['book']['start_time'];
$Time_Finish = $_POST['book']['finish_time'];
$Persons_inc = $_POST['book']['persons_inc'];
$Guests = $_POST['book']['guests'];

$sql = "INSERT INTO timetable (RoomID,Date,Time_Start,Time_Finish,Persons_inc,Guests) VALUES('$RoomID','$Date','$Time_Start','$Time_Finish','$Persons_inc','$Guests' )";
$result = mysql_query($sql, $db) or die ("Invalid query");
echo "<b>Submission Added</b><br><br>";
}

if (isset($_POST['action2']) == 'submitted'){
$roomid=$_POST['roomid'];
$date=$_POST["date"];
$timestart=$_POST["timestart"];
$sql = "DELETE FROM timetable WHERE RoomID='$roomid' AND Date='$date' AND Time_Start='$timestart'";
echo "you would like to delete";
$result = mysql_query($sql, $db) or die ("Invalid query");
}
?>
</tr></table>

**nick0161** · Oct 11, 2004, 19:23

i got a parse error on this line

</table></td><td>          </td><td>

**nick0161** · Oct 11, 2004, 19:27

a ?> was missing after the while loop... now starting to at least get a picture...

this is the error now

Notice: Use of undefined constant RoomID - assumed 'RoomID' in c:\program files\apache group\apache\htdocs\zealot.php on line 57

Notice: Use of undefined constant Date - assumed 'Date' in c:\program files\apache group\apache\htdocs\zealot.php on line 58

Notice: Use of undefined constant Time_Start - assumed 'Time_Start' in c:\program files\apache group\apache\htdocs\test.php on line 59

**devscripts** · Oct 11, 2004, 19:27

yup. i had forgot ?>

heres the full code again now we will fix it dont change anything until i say so :P

<table>
<tr>
<td>

<?php
global $delete;
global $submit;
global $eventid;
global $del;
global $record;

if (isset($_POST['action'])){
$enventid = "2004-10-20";}
else{
//$enventid = $_GET['eventid'];
$enventid = "2004-10-20";
}

echo "<html><body bgcolor=#FFFFFF>";
//echo "<form method=\"POST\" action=\"testresults.php\">";
$db = mysql_connect("localhost","root");//,"password");
//mysql_select_db("database",$db);
mysql_select_db("t1",$db);

$sql = "SELECT * from timetable where Date='$enventid'";
$result = mysql_query($sql, $db) or die ("Invalid query");

?>
<br><hr noshade>
<table cellpadding=0 cellspacing=0 width=200>
<tr><td>
<table border=1>
<tr><td>RoomID</td>
<td>Date</td>
<td>Time_Start</td>
<td>Time_Finish</td>
<td>Persons_Inc</td>
<td>Guests</td>
<td>Delete?</td>
</tr>

<?php
while ($row = mysql_fetch_array($result)){
echo "<tr><td>$row[RoomID]</td><td>";
echo "$row[Date]</td><td>";
echo "$row[Time_Start]</td><td>";
echo "$row[Time_Finish]</td><td>";
echo "$row[Persons_inc]</td><td>";
echo "$row[Guests]</td><td>";
echo "<input type=\"radio\" value=\"$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";

while ($row = mysql_fetch_array($result)){
echo "<tr><td>$row[RoomID]</td><td>";
echo "$row[Date]</td><td>";
echo "$row[Time_Start]</td><td>";
echo "$row[Time_Finish]</td><td>";
echo "$row[Persons_inc]</td><td>";
echo "$row[Guests]</td><td>";
echo "<input type=\"radio\" value=\"$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";

echo "<form method =\"POST\" action=\"".$_SERVER['PHP_SELF']."\">";
echo "<input type=\"hidden\" name=\"action\" value=\"submitted\">";
echo "<input type=\"submit\" name=\"submit\" value=\"Submit Booking\">";
echo "<input type=\"hidden\" name=\"roomid\" value=\"".$row[RoomID]."\">";
echo "<input type=\"hidden\" name=\"date\" value=\"".$row[Date]."\">";
echo "<input type=\"hidden\" name=\"timestart\" value=\"".$row[Time_Start]."\">";
echo "<input type=\"hidden\" name=\"action2\" value=\"submitted2\">";
echo "<input type=\"submit\" name=\"submit2\" value=\"Delete\">";
echo "</form>";

}
?>
</table></td><td>          </td><td>

<form action="<?php echo $_SERVER['PHP_SELF']; ?> " method="post">
RoomID: <br />

<select name="book[roomid]">
<option value="1">BoardRoom
<option value="2">SmallRoom
</select><br>

Date: yyyy/mm/dd <input type="text" name="book[date]" /><br />
Start Time : <input type="text" name="book[start_time]" /><br />
Finish Time: <input type="text" name="book[finish_time]" /><br />
Persons Included: <input type="text" name="book[persons_inc]" /><br />
Guests: <input type="text" name="book[guests]" /><br />

<br />
<form method = "POST" action="delrecord.php">
<input type="hidden" name="action" value="submitted" />
<input type="submit" name="submit" value="Submit Booking" />
</form>

<?php
if (isset($_POST['action']) == 'submitted'){

$RmID = $_POST['book']['roomid'];
if ($RmID == '2'){
$RoomID = "SmallRoom";}
else { $RoomID = "BoardRoom";}
$Date = $_POST['book']['date'];
$Time_Start = $_POST['book']['start_time'];
$Time_Finish = $_POST['book']['finish_time'];
$Persons_inc = $_POST['book']['persons_inc'];
$Guests = $_POST['book']['guests'];

$sql = "INSERT INTO timetable (RoomID,Date,Time_Start,Time_Finish,Persons_inc,Guests) VALUES('$RoomID','$Date','$Time_Start','$Time_Finish','$Persons_inc','$Guests' )";
$result = mysql_query($sql, $db) or die ("Invalid query");
echo "<b>Submission Added</b><br><br>";
}

if (isset($_POST['action2']) == 'submitted'){
$roomid=$_POST['roomid'];
$date=$_POST["date"];
$timestart=$_POST["timestart"];
$sql = "DELETE FROM timetable WHERE RoomID='$roomid' AND Date='$date' AND Time_Start='$timestart'";
echo "you would like to delete";
$result = mysql_query($sql, $db) or die ("Invalid query");
}
?>
</tr></table>

**nick0161** · Oct 11, 2004, 19:28

which are these lines

echo "<input type=\"hidden\" name=\"roomid\" value=\"".$row[RoomID]."\">";
echo "<input type=\"hidden\" name=\"date\" value=\"".$row[Date]."\">";
echo "<input type=\"hidden\" name=\"timestart\" value=\"".$row[Time_Start]."\">";

**nick0161** · Oct 11, 2004, 19:30

parse error 128 on the last line of the script

**nick0161** · Oct 11, 2004, 19:32

caused by two while statements... (they were repeated now back to same error as before)
errors here with the $row[RoomID]." etc... says undefined constants..

echo "<input type=\"hidden\" name=\"roomid\" value=\"".$row[RoomID]."\">";
echo "<input type=\"hidden\" name=\"date\" value=\"".$row[Date]."\">";
echo "<input type=\"hidden\" name=\"timestart\" value=\"".$row[Time_Start]."\">";

**devscripts** · Oct 11, 2004, 19:33

tell me the error msg. missing soemthing?

**nick0161** · Oct 11, 2004, 19:34

Notice: Use of undefined constant RoomID - assumed 'RoomID' in c:\program files\apache group\apache\htdocs\testii.php on line 57

Notice: Use of undefined constant Date - assumed 'Date' in c:\program files\apache group\apache\htdocs\testii.php on line 58

Notice: Use of undefined constant Time_Start - assumed 'Time_Start' in c:\program files\apache group\apache\htdocs\testii.php on line 59

**devscripts** · Oct 11, 2004, 19:36

<table>
<tr>
<td>

<?php
global $delete;
global $submit;
global $eventid;
global $del;
global $record;

if (isset($_POST['action'])){
$enventid = "2004-10-20";}
else{
//$enventid = $_GET['eventid'];
$enventid = "2004-10-20";
}

echo "<html><body bgcolor=#FFFFFF>";
//echo "<form method=\"POST\" action=\"testresults.php\">";
$db = mysql_connect("localhost","root");//,"password");
//mysql_select_db("database",$db);
mysql_select_db("t1",$db);

$sql = "SELECT * from timetable where Date='$enventid'";
$result = mysql_query($sql, $db) or die ("Invalid query");

?>
<br><hr noshade>
<table cellpadding=0 cellspacing=0 width=200>
<tr><td>
<table border=1>
<tr><td>RoomID</td>
<td>Date</td>
<td>Time_Start</td>
<td>Time_Finish</td>
<td>Persons_Inc</td>
<td>Guests</td>
<td>Delete?</td>
</tr>

<?php
while ($row = mysql_fetch_array($result)){
echo "<tr><td>$row[RoomID]</td><td>";
echo "$row[Date]</td><td>";
echo "$row[Time_Start]</td><td>";
echo "$row[Time_Finish]</td><td>";
echo "$row[Persons_inc]</td><td>";
echo "$row[Guests]</td><td>";
echo "<input type=\"radio\" value=\"$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";

while ($row = mysql_fetch_array($result)){
echo "<tr><td>$row[RoomID]</td><td>";
echo "$row[Date]</td><td>";
echo "$row[Time_Start]</td><td>";
echo "$row[Time_Finish]</td><td>";
echo "$row[Persons_inc]</td><td>";
echo "$row[Guests]</td><td>";
echo "<input type=\"radio\" value=\"$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";

echo "<form method =\"POST\" action=\"".$_SERVER['PHP_SELF']."\">";
echo "<input type=\"hidden\" name=\"action\" value=\"submitted\">";
echo "<input type=\"submit\" name=\"submit\" value=\"Submit Booking\">";
echo "<input type=\"hidden\" name=\"roomid\" value=\"".$row[RoomID]."\">";
echo "<input type=\"hidden\" name=\"date\" value=\"".$row[Date]."\">";
echo "<input type=\"hidden\" name=\"timestart\" value=\"".$row[Time_Start]."\">";
echo "<input type=\"hidden\" name=\"action2\" value=\"submitted2\">";
echo "<input type=\"submit\" name=\"submit2\" value=\"Delete\">";
echo "</form>";

}
?>
</table></td><td>          </td><td>

<form action="<?php echo $_SERVER['PHP_SELF']; ?> " method="post">
RoomID: <br />

<select name="book[roomid]">
<option value="1">BoardRoom
<option value="2">SmallRoom
</select><br>

Date: yyyy/mm/dd <input type="text" name="book[date]" /><br />
Start Time : <input type="text" name="book[start_time]" /><br />
Finish Time: <input type="text" name="book[finish_time]" /><br />
Persons Included: <input type="text" name="book[persons_inc]" /><br />
Guests: <input type="text" name="book[guests]" /><br />

</form>
<br />
<form method = "POST" action="delrecord.php">
<input type="hidden" name="action" value="submitted" />
<input type="submit" name="submit" value="Submit Booking" />
</form>

<?php
if (isset($_POST['action']) == 'submitted'){

$RmID = $_POST['book']['roomid'];
if ($RmID == '2'){
$RoomID = "SmallRoom";}
else { $RoomID = "BoardRoom";}
$Date = $_POST['book']['date'];
$Time_Start = $_POST['book']['start_time'];
$Time_Finish = $_POST['book']['finish_time'];
$Persons_inc = $_POST['book']['persons_inc'];
$Guests = $_POST['book']['guests'];

$sql = "INSERT INTO timetable (RoomID,Date,Time_Start,Time_Finish,Persons_inc,Guests) VALUES('$RoomID','$Date','$Time_Start','$Time_Finish','$Persons_inc','$Guests' )";
$result = mysql_query($sql, $db) or die ("Invalid query");
echo "<b>Submission Added</b><br><br>";
}

if (isset($_POST['action2']) == 'submitted'){
$roomid=$_POST['roomid'];
$date=$_POST["date"];
$timestart=$_POST["timestart"];
$sql = "DELETE FROM timetable WHERE RoomID='$roomid' AND Date='$date' AND Time_Start='$timestart'";
echo "you would like to delete";
$result = mysql_query($sql, $db) or die ("Invalid query");
}
?>
</tr></table>

**devscripts** · Oct 11, 2004, 19:39

gettting there

<table>
<tr>
<td>

<?php
global $delete;
global $submit;
global $eventid;
global $del;
global $record;

if (isset($_POST['action'])){
$enventid = "2004-10-20";}
else{
//$enventid = $_GET['eventid'];
$enventid = "2004-10-20";
}

echo "<html><body bgcolor=#FFFFFF>";
//echo "<form method=\"POST\" action=\"testresults.php\">";
$db = mysql_connect("localhost","root");//,"password");
//mysql_select_db("database",$db);
mysql_select_db("t1",$db);

$sql = "SELECT * from timetable where Date='$enventid'";
$result = mysql_query($sql, $db) or die ("Invalid query");

?>
<br><hr noshade>
<table cellpadding=0 cellspacing=0 width=200>
<tr><td>
<table border=1>
<tr><td>RoomID</td>
<td>Date</td>
<td>Time_Start</td>
<td>Time_Finish</td>
<td>Persons_Inc</td>
<td>Guests</td>
<td>Delete?</td>
</tr>

<?php
while ($row = mysql_fetch_array($result)){
echo "<tr><td>$row[RoomID]</td><td>";
echo "$row[Date]</td><td>";
echo "$row[Time_Start]</td><td>";
echo "$row[Time_Finish]</td><td>";
echo "$row[Persons_inc]</td><td>";
echo "$row[Guests]</td><td>";
echo "<input type=\"radio\" value=\"$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";

while ($row = mysql_fetch_array($result)){
echo "<tr><td>".$row[RoomID]."</td><td>";
echo "".$row[Date]."</td><td>";
echo "".$row[Time_Start]."</td><td>";
echo "".$row[Time_Finish]."</td><td>";
echo "".$row[Persons_inc]."</td><td>";
echo "".$row[Guests]."</td><td>";
echo "<input type=\"radio\" value=\".$row[RoomID],$row[Date],$row[Time_Start]\" name=\"delete\"></td></tr>";
echo "<form method =\"POST\" action=\"".$_SERVER['PHP_SELF']."\">";
echo "<input type=\"hidden\" name=\"action\" value=\"submitted\">";
echo "<input type=\"submit\" name=\"submit\" value=\"Submit Booking\">";
echo "<input type=\"hidden\" name=\"roomid\" value=\"".$row[RoomID]."\">";
echo "<input type=\"hidden\" name=\"date\" value=\"".$row[Date]."\">";
echo "<input type=\"hidden\" name=\"timestart\" value=\"".$row[Time_Start]."\">";
echo "<input type=\"hidden\" name=\"action2\" value=\"submitted2\">";
echo "<input type=\"submit\" name=\"submit2\" value=\"Delete\">";
echo "</form>";

}
?>
</table></td><td>          </td><td>

<form action="<?php echo $_SERVER['PHP_SELF']; ?> " method="post">
RoomID: <br />

<select name="book[roomid]">
<option value="1">BoardRoom
<option value="2">SmallRoom
</select><br>

Date: yyyy/mm/dd <input type="text" name="book[date]" /><br />
Start Time : <input type="text" name="book[start_time]" /><br />
Finish Time: <input type="text" name="book[finish_time]" /><br />
Persons Included: <input type="text" name="book[persons_inc]" /><br />
Guests: <input type="text" name="book[guests]" /><br />

</form>
<br />
<form method = "POST" action="delrecord.php">
<input type="hidden" name="action" value="submitted" />
<input type="submit" name="submit" value="Submit Booking" />
</form>

<?php
if (isset($_POST['action']) == 'submitted'){

$RmID = $_POST['book']['roomid'];
if ($RmID == '2'){
$RoomID = "SmallRoom";}
else { $RoomID = "BoardRoom";}
$Date = $_POST['book']['date'];
$Time_Start = $_POST['book']['start_time'];
$Time_Finish = $_POST['book']['finish_time'];
$Persons_inc = $_POST['book']['persons_inc'];
$Guests = $_POST['book']['guests'];

$sql = "INSERT INTO timetable (RoomID,Date,Time_Start,Time_Finish,Persons_inc,Guests) VALUES('$RoomID','$Date','$Time_Start','$Time_Finish','$Persons_inc','$Guests' )";
$result = mysql_query($sql, $db) or die ("Invalid query");
echo "<b>Submission Added</b><br><br>";
}

if (isset($_POST['action2']) == 'submitted'){
$roomid=$_POST['roomid'];
$date=$_POST["date"];
$timestart=$_POST["timestart"];
$sql = "DELETE FROM timetable WHERE RoomID='$roomid' AND Date='$date' AND Time_Start='$timestart'";
echo "you would like to delete";
$result = mysql_query($sql, $db) or die ("Invalid query");
}
?>
</tr></table>

**nick0161** · Oct 11, 2004, 19:40

was anything changed then? comes up with the same error... by the way i can actually see the forms too, and table.. and two delete and two submit bookings buttons

**nick0161** · Oct 11, 2004, 19:43

and in the table it has

notice: Use of undefined constant Date - assumed 'Date' in c:\program files\apache group\apache\htdocs\testii.php on line 47

but still shows correct data... this happens for all variables... (ie time-start)

**devscripts** · Oct 11, 2004, 19:43

the latst one i gave u has changes. please save that one. and retry.. before that one i had only small change... the latest had big changes.

User Tag List

Thread: deleting records with checkboxes

Thread Tools

Display

Bookmarks

Bookmarks

Posting Permissions