deleting records with checkboxes

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

roomid wrong?

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

where?

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

does it echo u this line
echo "you would like to delete";
wen u hit delete?

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

forget about roomid i deleted my post coz i misread.

**nick0161** · Oct 11, 2004, 21:37

this is the html code before delete is pressed

<table>
<tr>
<td>

<html><body bgcolor=#FFFFFF><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>

<tr><td>BoardRoom</td><td>2004-10-20</td><td>04:00:00</td><td>05:00:00</td><td>amir mark</td><td>ELMO</td><td><input type="radio" value=".BoardRoom,2004-10-20,04:00:00" name="delete"></td></tr><form method ="POST" action="/zealotII.php"><input type="hidden" name="roomid" value="'.BoardRoom.'"><input type="hidden" name="date" value="'.2004-10-20.'"><input type="hidden" name="timestart" value="'.04:00:00.'"><input type="hidden" name="action2" value="submitted"><input type="submit" name="submit2" value="Delete"></form><tr><td>BoardRoom</td><td>2004-10-20</td><td>05:00:00</td><td>01:00:00</td><td>amir</td><td>ELMO</td><td><input type="radio" value=".BoardRoom,2004-10-20,05:00:00" name="delete"></td></tr><form method ="POST" action="/zealotII.php"><input type="hidden" name="roomid" value="'.BoardRoom.'"><input type="hidden" name="date" value="'.2004-10-20.'"><input type="hidden" name="timestart" value="'.05:00:00.'"><input type="hidden" name="action2" value="submitted"><input type="submit" name="submit2" value="Delete"></form></table></td><td>          </td><td>

<form action="/zealotII.php " 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 />
<input type="hidden" name="action" value="submitted" />
<input type="submit" name="submit" value="Submit Booking" />
</form>

Invalid query

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

yeh both delete buttons show the test writing "you would like to delete"

**devscripts** · Oct 11, 2004, 21:46

the second delete button shud delete the row try it

**devscripts** · Oct 11, 2004, 21:48

found an error

ur html code says
<input type="hidden" name="roomid" value="'.BoardRoom.'">
<input type="hidden" name="date" value="'.2004-10-20.'">
<input type="hidden" name="timestart" value="'.05:00:00.'">

its got extra quotes.

**nick0161** · Oct 11, 2004, 21:49

good news submit is working now... don't know y.. just decided to work...
bad new delete still doesn't work, and for how many entries are in the table determines how many delete buttons there are...

**devscripts** · Oct 11, 2004, 21:52

try this code
<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>";
echo "<form method =\"POST\" action=\"".$_SERVER['PHP_SELF']."\">";
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=\"submitted\">";
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 />
<input type="hidden" name="action" value="submitted" />
<input type="submit" name="submit" value="Submit Booking" />
</form>

<?php
if (isset($_POST['action']) && $_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']) && $_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, 21:55

Winner!!!!

**nick0161** · Oct 11, 2004, 21:56

well sort of it doesn't delete what you select just the bottom row...

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

all works now? except ur insert also has many errors.

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

i want u to giove me the output html again before u hit delete.

**nick0161** · Oct 11, 2004, 21:59

my insert?
submission works fine
delete only delete's whatever the bottom row is...

**nick0161** · Oct 11, 2004, 22:00

sorry i was wrong.. it depends which layer of buttons you get... but that's cool... if i put them in the table... then it'll be fine

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

and you have to press delete twice...

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

and you have to press delete twice...but that's sweet.. hmm sounds like an error checking method... hehehe

thanks so much mate... been really helpful

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

here's the html

<table>
<tr>
<td>

<html><body bgcolor=#FFFFFF><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>

<tr><td>BoardRoom</td><td>2004-10-20</td><td>04:00:00</td><td>05:00:00</td><td>amir mark</td><td>ELMO</td><td><input type="radio" value=".BoardRoom,2004-10-20,04:00:00" name="delete"></td></tr><form method ="POST" action="/zealotII.php"><input type="hidden" name="roomid" value="'.BoardRoom.'"><input type="hidden" name="date" value="'.2004-10-20.'"><input type="hidden" name="timestart" value="'.04:00:00.'"><input type="hidden" name="action2" value="submitted"><input type="submit" name="submit2" value="Delete"></form><tr><td>SmallRoom</td><td>2004-10-20</td><td>04:00:00</td><td>05:00:00</td><td>ernie</td><td>bert</td><td><input type="radio" value=".SmallRoom,2004-10-20,04:00:00" name="delete"></td></tr><form method ="POST" action="/zealotII.php"><input type="hidden" name="roomid" value="'.SmallRoom.'"><input type="hidden" name="date" value="'.2004-10-20.'"><input type="hidden" name="timestart" value="'.04:00:00.'"><input type="hidden" name="action2" value="submitted"><input type="submit" name="submit2" value="Delete"></form><tr><td>BoardRoom</td><td>2004-10-20</td><td>05:00:00</td><td>01:00:00</td><td>amir</td><td>ELMO</td><td><input type="radio" value=".BoardRoom,2004-10-20,05:00:00" name="delete"></td></tr><form method ="POST" action="/zealotII.php"><input type="hidden" name="roomid" value="'.BoardRoom.'"><input type="hidden" name="date" value="'.2004-10-20.'"><input type="hidden" name="timestart" value="'.05:00:00.'"><input type="hidden" name="action2" value="submitted"><input type="submit" name="submit2" value="Delete"></form><tr><td>BoardRoom</td><td>2004-10-20</td><td>06:00:00</td><td>00:00:00</td><td></td><td></td><td><input type="radio" value=".BoardRoom,2004-10-20,06:00:00" name="delete"></td></tr><form method ="POST" action="/zealotII.php"><input type="hidden" name="roomid" value="'.BoardRoom.'"><input type="hidden" name="date" value="'.2004-10-20.'"><input type="hidden" name="timestart" value="'.06:00:00.'"><input type="hidden" name="action2" value="submitted"><input type="submit" name="submit2" value="Delete"></form></table></td><td>          </td><td>

<form action="/zealotII.php " 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 />
<input type="hidden" name="action" value="submitted" />
<input type="submit" name="submit" value="Submit Booking" />
</form>

</tr></table>

**devscripts** · Oct 11, 2004, 22:04

ok lol im off to bed.... before i go ill leave u with this link... its a small tutorial but u will learn fast from it.

http://www.phpfreaks.com/tutorials/33/0.php

also i noticed ur from australia... can u tell me wot time is it in NSW part of australia if u know?

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

it would be 2:35 here so it would be 3:05pm there... thanks so much mate...
yeh i'll check out ya link after i eat.... so hungry hehehe...

thanks mate

where are you from?

**devscripts** · Oct 11, 2004, 22:08

uk. gonna go sleep now. c u later

check out www.islamway.com

)

ill help u more tommorow or something. good luck with ur work experience and thanks for telling me the time for NSW.

salaamz.

**nick0161** · Oct 11, 2004, 22:10

no worries mate...
thanks again for all you help..

.

The SitePoint Forums have moved.

User Tag List

Thread: deleting records with checkboxes

Thread Tools

Display

Bookmarks

Bookmarks

Posting Permissions