Forums
This topic is locked
using check box too delete records ( PHPAKT)
13 Sep 2001 12:53:46 dyna c posted:
is there a way to have a detail page where more than one record can be deleted at once. for example if I create a page that list 10 records. I want to use a check box to select records to be deleted and delete the selected records.
Hopes this makes sense
Can you point me in the right direction
detail page
Edited by - on 09/13/2001 17:58:03
Replies
Replied 14 Sep 2001 11:55:11
14 Sep 2001 11:55:11 Tim Green replied:
I have written the following code to illustrate how to do this. You will have to amend all the recordset details, and the SQL used etc.
This code works perfectly for me, and hopefully it will serve as a starting point for you.
Just copy and paste it into a new blank document.
I hope this is of help.
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Edited by - rawveg on 09/14/2001 11:56:52
This code works perfectly for me, and hopefully it will serve as a starting point for you.
Just copy and paste it into a new blank document.
I hope this is of help.
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Edited by - rawveg on 09/14/2001 11:56:52
Replied 14 Sep 2001 11:58:20
14 Sep 2001 11:58:20 Tim Green replied:
<pre id=code><font face=courier size=2 id=code>
<?php
// Copyright (c) Interakt Online 2001
// www.interakt.ro/
require("./../adodb/adodb.inc.php"
;
require("./../Connections/connTest.php";
?><?php
// If variable $formSeen has been set then process form parameters
if (isset($HTTP_POST_VARS["formSeen"])) {
$theDeletes = explode(",",$HTTP_POST_VARS["theValues"]);
$theSQL = "DELETE FROM Products WHERE ";
for ($k=0; $k < count($theDeletes); $k++) {
if ($k > 0) {
$theSQL.=" OR ";
}
$theSQL.="ID = '".$theDeletes[$k]."'";
}
echo $theSQL;
$theDelRS = $connTest->Execute($theSQL) or DIE($connTest->ErrorMsg());
}
?><?php
$Recordset1=$connTest->Execute("SELECT * FROM Products" or DIE($connTest->ErrorMsg());
$Recordset1_numRows=0;
$Recordset1__totalRows=$Recordset1->RecordCount();
?><?php
$Repeat1__numRows = 10;
$Repeat1__index= 0;
$Recordset1_numRows = $Recordset1_numRows + $Repeat1__numRows;
?>
<html>
<head>
<title>Multiple Delete Example</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="Javascript">
function MM_findObj(n, d) { //v4.0
var p,i,x; if(!d) d=document; if((p=n.indexOf("?")>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && document.getElementById) x=document.getElementById(n); return x;
}
function checkChange(theField) {
var currValue = MM_findObj(theField).value;
var blankCurr = false;
var theCurValues = MM_findObj("theValues".value;
if (theCurValues == "" {
blankCurr=true;
}
var theValueArray = theCurValues.split(",";
theValueArray.push(currValue);
var theValueString=theValueArray.join(",";
if (blankCurr) {
theValueString=theValueString.substr(1);
}
MM_findObj("theValues".value=theValueString;
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="<?php echo $PHP_SELF; ?>">
<table width="50%" border="0" cellspacing="0" cellpadding="2" align="center">
<tr>
<td width="2%"> </td>
<td width="98%">Part Number</td>
</tr>
<?php while (($Repeat1__numRows-- != 0) && (!$Recordset1->EOF))
{
?>
<tr>
<td height="20" width="2%">
<input type="checkbox" name="checkbox<?php echo $Recordset1->Fields("ID"?>" value="<?php echo $Recordset1->Fields("ID"?>" onClick="checkChange('checkbox<?php echo $Recordset1->Fields("ID"?>')">
</td>
<td height="20" width="98%">
<?php echo $Recordset1->Fields("PARTNO"?>
</td>
</tr>
<?php
$Repeat1__index++;
$Recordset1->MoveNext();
}
?>
</table>
<p align="center">
<input type="hidden" name="formSeen" value="true">
<input type="hidden" name="theValues">
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
<?php
$Recordset1->Close();
?>
</font id=code></pre id=code>
Edited by - rawveg on 09/14/2001 12:01:09
<?php
// Copyright (c) Interakt Online 2001
// www.interakt.ro/
require("./../adodb/adodb.inc.php"
;require("./../Connections/connTest.php"
;?><?php
// If variable $formSeen has been set then process form parameters
if (isset($HTTP_POST_VARS["formSeen"])) {
$theDeletes = explode(",",$HTTP_POST_VARS["theValues"]);
$theSQL = "DELETE FROM Products WHERE ";
for ($k=0; $k < count($theDeletes); $k++) {
if ($k > 0) {
$theSQL.=" OR ";
}
$theSQL.="ID = '".$theDeletes[$k]."'";
}
echo $theSQL;
$theDelRS = $connTest->Execute($theSQL) or DIE($connTest->ErrorMsg());
}
?><?php
$Recordset1=$connTest->Execute("SELECT * FROM Products"
or DIE($connTest->ErrorMsg());$Recordset1_numRows=0;
$Recordset1__totalRows=$Recordset1->RecordCount();
?><?php
$Repeat1__numRows = 10;
$Repeat1__index= 0;
$Recordset1_numRows = $Recordset1_numRows + $Repeat1__numRows;
?>
<html>
<head>
<title>Multiple Delete Example</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="Javascript">
function MM_findObj(n, d) { //v4.0
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"
)>0&&parent.frames.length) {d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && document.getElementById) x=document.getElementById(n); return x;
}
function checkChange(theField) {
var currValue = MM_findObj(theField).value;
var blankCurr = false;
var theCurValues = MM_findObj("theValues"
.value;if (theCurValues == ""
{blankCurr=true;
}
var theValueArray = theCurValues.split(","
;theValueArray.push(currValue);
var theValueString=theValueArray.join(","
;if (blankCurr) {
theValueString=theValueString.substr(1);
}
MM_findObj("theValues"
.value=theValueString;}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="<?php echo $PHP_SELF; ?>">
<table width="50%" border="0" cellspacing="0" cellpadding="2" align="center">
<tr>
<td width="2%"> </td>
<td width="98%">Part Number</td>
</tr>
<?php while (($Repeat1__numRows-- != 0) && (!$Recordset1->EOF))
{
?>
<tr>
<td height="20" width="2%">
<input type="checkbox" name="checkbox<?php echo $Recordset1->Fields("ID"
?>" value="<?php echo $Recordset1->Fields("ID"?>" onClick="checkChange('checkbox<?php echo $Recordset1->Fields("ID"?>')"></td>
<td height="20" width="98%">
<?php echo $Recordset1->Fields("PARTNO"
?></td>
</tr>
<?php
$Repeat1__index++;
$Recordset1->MoveNext();
}
?>
</table>
<p align="center">
<input type="hidden" name="formSeen" value="true">
<input type="hidden" name="theValues">
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
<?php
$Recordset1->Close();
?>
</font id=code></pre id=code>
Edited by - rawveg on 09/14/2001 12:01:09
Replied 14 Sep 2001 14:38:26
14 Sep 2001 14:38:26 dyna c replied:
code works a treat - thanks
It works well with the PHP insert record behaviour.
again thanks
It works well with the PHP insert record behaviour.
again thanks
Replied 14 Sep 2001 20:19:09
14 Sep 2001 20:19:09 Tim Green replied:
It's a pleasure. I tried to keep in mind that you might want to use other behaviours with the page (Insert/Update/Delete records etc).
If I get chance I will turn this into a behaviour (or Live Object) so that it can be easily implemented in the future.
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
If I get chance I will turn this into a behaviour (or Live Object) so that it can be easily implemented in the future.
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>