Log in

View Full Version : record (unknown num) checked checkboxes values in php/mysql, how ?



leonidassavvides
08-28-2008, 11:01 AM
<?php
// ------------------------------------------------------
include("../dbinfo.php");
$linkid = mysql_connect($hostname,$username,$password);
@mysql_select_db($database) or die( "Unable to select database"); // @
// Base query
$query ='';
$query = "SELECT * FROM $BookingsTable WHERE email='$email'";
$result = @mysql_query($query,$linkid);

$count = @mysql_num_rows($result);
echo " ( Your query returned " . $count . " items. )";
?>
.....
<? $i=0;
if ($count > 0) {
while ($i < $count) {
$bookingid = mysql_result($result,$i,"bookingid");
$dateplaced = mysql_result($result,$i,"dateplaced");
$status = mysql_result($result,$i,"status");
$datep = mysql_result($result,$i,"datep");
$dated = mysql_result($result,$i,"dated");
$Locationp = mysql_result($result,$i,"Locationp");
$Locationd = mysql_result($result,$i,"Locationd");
$days = mysql_result($result,$i,"days");
$mostdaysrate = mysql_result($result,$i,"mostdaysrate");
$vat = mysql_result($result,$i,"vat");
$off = mysql_result($result,$i,"off");
$total = mysql_result($result,$i,"total");
$cat = mysql_result($result,$i,"cat");
$bookingidarray=array();
//$cb=0;
?>
<input name="<?= $bookingidarray[$i]; ?>" type="checkbox" id="<?= $bookingidarray[$i]; ?>" value="<?=$bookingid; ?>" />
<?
++$i;
} # end while
} else { ?>


processor:record (unknown number) checked checkboxes values in php/mysql, how ?
how take value of a checkbox(checked) in php ? this is error: ?
$ck[++$ckd]=$_POST['$bookingidarray[$k]'].value;


<?php
$email=$_SESSION['username'];
$ck=array();
$ckd=0;
if ((isset($_POST['cancel']) {
for($k=0;$k<$_SESSION['bs'];++$k) { // $_SESSION['bs']=$count
if ($_POST['$bookingidarray[$k]']="checked") {
$ck[++$ckd]=$_POST['$bookingidarray[$k]'].value;
}
}
include("../dbinfo.php");
$linkid = mysql_connect($hostname,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
for($g=0;$g==$ckd;++$g) {
$query[$g] = "DELETE * FROM $BookingsTable WHERE email='$email' AND bookingid='".$ck[++$g];
$result[$g] = @mysql_query($query[$g],$linkid) or die("Unable to execute query. Please try again later.");
}
}
?>