processor:record (unknown number) checked checkboxes values in php/mysql, how ?Code:<?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 { ?>
how take value of a checkbox(checked) in php ? this is error: ?
$ck[++$ckd]=$_POST['$bookingidarray[$k]'].value;
Code:<?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."); } } ?>


Reply With Quote
Bookmarks