PHP - Retaining Checkbox Values

I have  a form that has a list of checboxes, each checkbox has multiple values. IE. Checkbox1 has Date 1 and Cost1. Checkbox2 has Date2 and cost2 and so on.

This is what I have in form.

echo "<input type=checkbox name=service_id[] value=".$id."><label>".$description."</label> Date:<input type=date name=date[] value=".date('Y-m-d').">Date:<input type=number name=cost[] value=".$cost."><br>";

When i run the for loop to insert the values into a table i have this.

foreach($_POST['service_id'] as $key => $value){
$cat1=$_POST['service_id'][$key];
$cat2=$_POST['date'][$key];
$cat3=$_POST['cost'][$key];}

The problem is that when I select certain boxes (ie, checkbox #2), it inserts Date1 and Cost1 but does use the correct service id (ie checkbox)
I am clearly not storing the values into the array correctly. Any thoughts?

Is is possible to give multiple values in a single checkbox?
i need to have a checkbox that holds multiple values.

Help Anyone..

 

Basically i made a form with checkbox using post.. here's the form

Code: [Select]
<?php echo '<form name="formupload" method="post" action="val3.php">';
echo '<input type="image" src="images/reject.png" name="test" width="170" height="35" border="0" value="reject">';
echo "<table border=\"5\" >";
echo "<tr><th>List of Instructor</th>";
    if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
echo "<tr><td>";
    echo "<input type='checkbox' name='list[]' value='".$row['fullname']."'>" .$row['fullname']."<br/></td>"; 
    echo "</tr>";
   } 

}
    else {
    echo "<tr><td>No one to Approve</td></tr>";  
    } 
echo '</form>'; ?>

Then my val3.php will output the values of the checked checkbox.

here's the code.
Code: [Select]
<?php

foreach ($_REQUEST['list'] as $checkbox)
{
echo $checkbox;
echo "<br/>";
}


?>




Now i don't know how to insert those values to my database.. help pls.

Trying to get a form to display checked and unchecked values based on what is in the database.

Hard coded form works fine. I implode the array and it goes into the database as a comma delimited string.

But I need to let users edit the checkbox values, so I need to create the form by exploding the string, iterating through the array, and outputting the checkbox form elements.

Here's what I have...

Code: [Select]
<p>Specialization:
<p>
<?php

//echo $session->userinfo['specialization']; THIS DISPLAYS THE STRING CORRECTLY
 
$aSpecialization = array('Automotive', 'Aerospace', 'Biotech/Life Sciences', 'Chemicals', 'Damages Analysis', 'Electronics', 'Litigation', 'Manufacturing ', 'Materials', 'Medical Devices', 'Mobile Applications', 'Patent Prosecution', 'Physics', 'Renewable Energy', 'Semiconductors', 'Software', 'Telecommunications', 'Utilities');
 
//converting comma separated into array using explode function

  $dbspecialization= explode(',',$session->userinfo['specialization']);
  
  // echo $dbspecialization; THIS IS CONFIRMED AS AN array
 
  foreach ($aSpecialization as $specialization) {
 
     if(in_array($specialization,$dbspecialization)) {
      echo '<input name="specialization[]" type="checkbox" value="$specialization" CHECKED> $aSpecialization[] <br />';
          } else {
      echo '<input name="specialization[]" type="checkbox" value="$specialization"> $aSpecialization[] <br />';
          }
    }
?>

But the output I get is...

Code: [Select]
<input name="specialization[]" type="checkbox" value="$specialization" CHECKED> $aSpecialization[] <br />

<input name="specialization[]" type="checkbox" value="$specialization"> $aSpecialization[] <br />

<input name="specialization[]" type="checkbox" value="$specialization"> $aSpecialization[] <br />

etc...


What am I missing?

What I have is a page with a list of cars, each with a checkbox next to them.

Code: [Select]
<?php
$sth = null; $count = 0;
$sth = $dbh->prepare("SELECT * FROM garage WHERE warehouse_id = ? ORDER BY car_name ASC");
$sth->execute(array($_POST['ware_id']));
echo "<table>";
echo "<tr>";
echo '<td>Choose Vehicles:</td>';
echo "</tr>";
echo "<tr>";
echo "<td>";

echo "<form action='warehouse_ship_3.php' method='POST'>";
while($row = $sth->fetch()){
echo "<input type='checkbox' name='cars' value='".$row['uci']."' /> ID: ".$row['uci'].", ".$row['car_year']." ".$row['car_name']."<br />";  
}
echo "<input type='hidden' name='ware_id' value='".$_POST['ware_id']."' />";
echo "<hr />";
echo '<div class="center"><input class="myButton" type="submit" name="submit" value="Next" /></div></form>';
echo "</td>";
echo "</tr>";
echo "</table>";

?>
That works fine. What I'm trying to do with this second page, is select all the car's info from a table called "garage" which stores data for all the cars (car name, year, etc) and display it. UCI stands for Unique car id, every car has a different id. It works when the user only selects one car on the previous page, but if they select two or more cars, only the car with the highest UCI number shows up. How would I work it to display info on every car that they selected?

Code: [Select]
<?php
  if(empty($_POST['cars']))
  {
    echo("You didn't select any cars.");
  }
  else
  {
$sth = $dbh->prepare("SELECT * FROM `garage` WHERE `uci` = ?");
$sth->execute(array($_POST['cars']));
while($cars = $sth->fetch()){

echo"
".$cars['uci'].", ".$cars['car_year']." ".$cars['car_name']."
";
}
  }
?>

So, i need this.

So first of all, I have a confession, I used Dreamweaver to take care of all my database work. Pheww. Now that I got that of my chest, I am having problems, not only with my lack of experience working with databases, but with my script also. I need to insert multiple checkbox values into my database into the same cell. So I have searched around and I thought I had found a fairly good approach, but with Dw's hodgepodge of overcomplicated mess, I am finding problems integrating it. The error I am getting post submission is "Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\gov\ballot.php on line 10
Column 'involvement' cannot be null" So if you would, could you debug my script and give me some instruction along to way so that I can learn a little something too? Here is my script:

<?php require_once('Connections/ballot.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}


$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "Ballot")) {
  $insertSQL = sprintf("INSERT INTO votes (`first`, `last`, gender, grade, involvement, schedule, party, `time`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['first'], "text"),
                       GetSQLValueString($_POST['last'], "text"),
                       GetSQLValueString($_POST['gender'], "text"),
                       GetSQLValueString($_POST['grade'], "text"),
                       GetSQLValueString($_POST['involvement'], "text"),
                       GetSQLValueString($_POST['schedule'], "text"),
                       GetSQLValueString($_POST['party'], "text"),
                       GetSQLValueString($_POST['time'], "text"));

  mysql_select_db($database_ballot, $ballot);
  $Result1 = mysql_query($insertSQL, $ballot) or die(mysql_error());

  $insertGoTo = "thanks.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_ballot, $ballot);
$query_Recordset1 = "SELECT * FROM votes";
$Recordset1 = mysql_query($query_Recordset1, $ballot) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Please Place your Vote Below</title>
</head>

<body style="background-image:url(images/bg.jpg); background-repeat:repeat-x; background-color:#000000;">
<table align="center" bgcolor="#FFFFFF" cellpadding="0" cellspacing="0" border="0">
<tr><td>
<div style="border:thin; border-color:000000; border-style:groove; width:700px; background-color:ffffff;">
<div align="center"><a href="index.php"><img src="images/header.jpg" alt="Mock Elections 2010" /></a></div>
<div style="margin:10px; margin-top:30px;">
Before continuing to vote, in order to count your vote, we ask that you please ensure you are adhereing to the following guidelines:
</div>
<div style="margin:30px">
  <p>- When putting your name, remember to put your full legal name. NO nicknames.<br />
    - Be sure that all your information is valid otherwise your vote will not be counted.
    <br />
  </p>
</div>
<div style="margin-left:150px; margin-right:150px; margin-top:50px;">
<form action="<?php echo $editFormAction; ?>" method="POST" name="Ballot">
First Name:&nbsp; <input type="text" name="first" /><br />
Last Name:&nbsp; <input type="text" name="last" /><br />
<div>Gender:&nbsp;
<label>
Male <input type="radio" value="Male" name="gender" /></label>
<label>Female <input type="radio" value="Female" name="gender" /></label>
</div>
Grade:&nbsp;
<select name="grade">
  <option selected="selected">&nbsp;</option>
  <option value="7">7</option>
  <option value="8">8</option>
  <option value="9">9</option>
  <option value="10">10</option>
  <option value="11">11</option>
  <option value="12">12</option>
  <option value="Teacher">Teacher</option>
  <option value="Staff">Staff</option>
</select><br />
<div>Involvement:&nbsp;
  <label>
    <input type="checkbox" name="involvement[]" value="Athletics" id="involvement_0" />
    Athletics</label>
  <label>
    <input type="checkbox" name="involvement[]" value="Co-Curricular" id="involvement_1" />
    Co-Curricular</label>
  <label>
    <input type="checkbox" name="involvement[]" value="Clubs" id="involvement_2" />
    Clubs</label>
</div>
<div>Schedule:&nbsp;
<label><input type="radio" value="C4" name="schedule" />C4</label>
<label><input type="radio" value="All Day" name="schedule" />All Day Hauser Student</label>
</div>
<div>Party:&nbsp;
<label><input type="radio" value="PokePartay" name="party" />PokePartay</label>
<label><input type="radio" value="Equilibrium" name="party" />Equilibrium Party</label>
</div>
<br />
<input type="Submit" value="Submit" />
<input type="hidden" value="<?php 
$tz =  new DateTimeZone('America/Indianapolis');
$date = new DateTime('now', $tz);
echo $date->format('m-d-Y h:i:s') . "\n";
?>" name="time" />
<?php
if (isset($_POST['submit'])) { 
   $involvements = $_POST['involvement'];

   foreach($involvements as $involvement) {
      $query2 = "INSERT INTO votes (involvement) VALUES ('$involvement')";
      $result2 = mysql_query($ballot, $query2) or die(mysql_error());
   }
}
?>
<input type="hidden" name="MM_insert" value="Ballot" />
</form>
</div>
<br />
<br />
<br />
<br />
</div>

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

</body>
</html>
<?php
mysql_free_result($Recordset1);
?>


Thanks,
Philip Ulrich

First,
I will select checkbox then click generate report then it displays the items with download link

Then i click download link to download the selected checkbox values in pdf


I want to download the selected checkbox items by clicking download link

Now i am getting all check box items in the pdf download

How to download only the selected check box items

Code: [Select]
<?php
session_start();
$_SESSION['pidd'] = 2;
$sessvar = $_SESSION['pidd'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<style type="text/css" media="print">
DIV#noprint{visibility:hidden;}
INPUT#printbutt{visibility:hidden;}
#downloadlink{visibility:hidden;}
</style>
<script type="text/javascript">
function gen() {

var st1=document.getElementById("ckbox1").checked;

var st2=document.getElementById("ckbox2").checked;

var st3=document.getElementById("ckbox3").checked;

var st4=document.getElementById("ckbox4").checked;

if(st1 == true) {
document.getElementById('g1').style.display = 'block';

}

if(st2 == true) {

document.getElementById('g2').style.display = 'block';

}

if(st3 == true) {

document.getElementById('g3').style.display = 'block';

}

if(st4 == true) {
document.getElementById('g4').style.display = 'block';

}



document.getElementById('p_info').style.display = 'none';

document.getElementById('histree').style.display = 'none';

document.getElementById('insurence').style.display = 'none';
document.getElementById('billin').style.display = 'none';
}

function showuser() {

document.getElementById('g1').style.display = 'none';

document.getElementById('g2').style.display = 'none';

document.getElementById('g3').style.display = 'none';

document.getElementById('g4').style.display = 'none';


var str1=document.getElementById("ckbox1").checked;

var str2=document.getElementById("ckbox2").checked;

var str3=document.getElementById("ckbox3").checked;

var str4=document.getElementById("ckbox4").checked;


if(str1 == true) {

document.getElementById('p_info').style.display = 'block';

}

else

document.getElementById('p_info').style.display = 'none';

if(str2 == true) {

document.getElementById('histree').style.display = 'block';

}

else

document.getElementById('histree').style.display = 'none';

if(str3 == true) {

document.getElementById('insurence').style.display = 'block';

}

else

document.getElementById('insurence').style.display = 'none';

if(str4 == true) {

document.getElementById('billin').style.display = 'block';

}

else

document.getElementById('billin').style.display = 'none';

}

function checkByParent(aId, aChecked) {
    var collection = document.getElementById(aId).getElementsByTagName('INPUT');
    for (var x=0; x<collection.length; x++) {
        if (collection[x].type.toUpperCase()=='CHECKBOX')
            collection[x].checked = aChecked;
    }
}
</script>
</head>
<body>
<div id="main_content">
  <div id="left">
    <div id="noprint">
      <h4>Patient Report</h4>
      <a id="check_all" href="#" style="text-decoration:none" onClick="checkByParent('checkboxes', true); return false;">check all</a>&nbsp;&nbsp;&nbsp;&nbsp; <a id="uncheckall" href="#" style="text-decoration:none" onClick="checkByParent('checkboxes', false); return false;">uncheck all</a> <br>
      <br>
      <form method="post" name="myform" action="">
        <div id="checkboxes">
          <div id="cb_id1">
            <input id="ckbox1" name="cbox1" type="checkbox" <? if(isset($_REQUEST['cbox1'])) echo 'checked="checked"' ; ?> value="p_info" />
            Patient Info </div>
          <div id="cb_id2">
            <input id="ckbox2" name="cbox2" type="checkbox" <?php if(isset($_REQUEST['cbox2'])) echo 'checked="checked"' ; ?> value="histree" />
            History </div>
          <div id="cb_id3">
            <input id="ckbox3" name="cbox3" type="checkbox" <?php if(isset($_REQUEST['cbox3'])) echo 'checked="checked"' ; ?> value="insurance" />
            Insurence </div>
          <div id="cb_id4">
            <input id="ckbox4" name="cbox4" type="checkbox" <?php if(isset($_REQUEST['cbox4'])) echo 'checked="checked"' ; ?> value="billin" />
            Billing </div>
        </div>
        <!--checkboxes div -->
        <br>
        <input id="vuprint" name="view" type="button" value="View" onClick="showuser();">
        <hr/>
        <label for="docs"> Documents:<br>
        <br>
        </label>
        <input name="sub" type="button" value="Generate report" onclick="gen();">
        <hr/>
      </form>
      <input id="printbutt" name="prt" type="button" value="Print" onClick="javascript:window.print();">
    </div>
    <!--No print -->
  </div>
  <!--Left div -->
  <div id="side">
    <div id="p_info">
      <?php require("db_conn.php");
$pinfo = mysqli_query($mysqli,"SELECT * FROM patient_datas WHERE P_Id='".$sessvar."' ");
while($fet = mysqli_fetch_array($pinfo)) {
echo "<h4>Patient Info</h4>";
echo "<b>Name: </b>" . $fet["P_Fname"] . " " . $fet["P_Lname"]. "<br>";
echo "<b>Dob:</b> " . date("d-m-Y",strtotime($fet["P_Dob"]))."<br>";
echo "<b>Age:</b> " . $fet["P_Age"]."<br>";
echo "<b>Gender:</b> " . $fet["P_Gender"]."<br>";
echo "<b>Marital Status:</b> " . $fet["P_Mstatus"]."<br>";
echo "<b>Blood: </b>" . $fet["P_Blood"]."<br>";
echo "<b>Height: </b>" . $fet["P_Height"] . $fet["P_Hval"]."<br>";
echo "<b>Weight: </b>" . $fet["P_Weight"] . $fet["P_Wval"];
}
?>
    </div>
    <div id="histree">
      <?php 
$his = mysqli_query($mysqli,"SELECT * FROM patient_datas WHERE P_Id='".$sessvar."' ");
while($hisrow = mysqli_fetch_array($his,MYSQLI_ASSOC)) {
echo "<h4>Patient Histroy</h4>";
echo "<b>P_Idate: </b>" . date("d-m-Y",strtotime($hisrow["P_Idate"]))."<br>";
echo "<b>P_Edate: </b>" . date("d-m-Y",strtotime($hisrow["P_Edate"]))."<br>";
echo "<b>D_Ddate: </b>" . date("d-m-Y",strtotime($hisrow["D_Ddate"]));
} ?>
    </div>
    <!-- Insurence -->
    <div id="insurence">
      <?php
$insu = mysqli_query($mysqli,"SELECT * FROM patient_datas WHERE P_Id='".$sessvar."' ");
while($insrow = mysqli_fetch_array($insu,MYSQLI_ASSOC)) { ?>
      <?php
echo "<h4>Insurence</h4>";
echo "<b>P_Isname: </b>" . $insrow["P_Isname"]."<br>";
// echo $insow[""];
} ?>
    </div>
    <div id="billin">
      <?php
$bilrow = mysqli_query($mysqli,"SELECT * FROM patient_datas WHERE P_Id='1' ");
while($bill = mysqli_fetch_array($bilrow,MYSQLI_ASSOC)) { ?>
      <?php
echo "<h4>Billing</h4>";
echo "<b>P_Fbill: </b>" . $bill["P_Fbill"]."<br>";
echo "<b>Fees: </b>" . $bill["fees"];
} ?>
    </div>
  </div>
  <!--/side div -->
  <div id="generatereport">
    <div id="g1" style="display:none; clear:both;">
      <label for="Gen_reports">Generaterd reports</label>
      <br />
      <br />
      <?php
$pinfo = mysqli_query($mysqli,"SELECT * FROM patient_datas WHERE P_Id='1' ");
while($fet = mysqli_fetch_array($pinfo,MYSQLI_ASSOC)) { 

$new_dob = date("d-m-Y",strtotime($fet["P_Dob"])); ?>
      <?php echo "<h4>Patient Info</h4>";

echo "<b>Patient Id:</b> ". $fet["P_Id"]."<br>";

echo "<b>Name:</b> " . $fet["P_Fname"] . " " . $fet["P_Lname"]."<br>";

echo "<b>Dob:</b> " . $new_dob ."<br>";

echo "<b>Age:</b> " .$fet["P_Age"]."<br>"; 

echo "<b>Gender:</b> " . $fet["P_Gender"]."<br>";

echo "<b>Marital Status:</b> " . $fet["P_Mstatus"]. "<br>";

echo "<b>Blood:</b> " . $fet["P_Blood"] . "<br>";

echo "<b>Height:</b> " . $fet["P_Height"] . $fet["P_Hval"]. "<br>";

echo "<b>Weight:</b> " . $fet["P_Weight"] . $fet["P_Wval"]. "<br>";

}
echo "*************************************************************************************************************************";

?> </div>
    <div id="g2" style="display:none">
      <?php

$his = mysqli_query($mysqli,"SELECT * FROM patient_datas WHERE P_Id='1' ");

while($secrow = mysqli_fetch_array($his,MYSQLI_ASSOC)) {

echo "<h4>Patient Histroy</h4>";

echo "<b>P_Idate:</b> " . date("d-m-Y",strtotime($secrow["P_Idate"])) ."<br>";

echo "<b>P_Edate:</b> " . date("d-m-Y",strtotime($secrow["P_Edate"])) ."<br>";

echo "<b>D_Ddate:</b> " . date("d-m-Y",strtotime($secrow["D_Ddate"])) ."<br>";

}
echo "*************************************************************************************************************************";
?>
    </div>
    <div id="g3" style="display:none">
      <?php



$insu = mysqli_query($mysqli,"SELECT * FROM patient_datas WHERE P_Id='1' ");

while($insrow = mysqli_fetch_array($insu,MYSQLI_ASSOC)) {

echo "<h4>Insurence</h4>";

echo "<b>P_Isname:</b>" . $insrow["P_Isname"]."<br>";

}
echo "*************************************************************************************************************************";
?>
    </div>
    <div id="g4" style="display:none">
      <?php


$bilrow = mysqli_query($mysqli,"SELECT * FROM patient_datas WHERE P_Id='1' ");

while($bill = mysqli_fetch_array($bilrow,MYSQLI_ASSOC)) {

echo "<h4>Billing</h4>";

echo "<b>P_Fbill:</b> " . $bill["P_Fbill"]."<br>";

echo "<b>Fees:</b> " . $bill["fees"];
}

?>
    </div>
    <?php 
$infochk = 'p_info';
$hischk = 'histree';
$insuchk = 'insurance';
$billchk = 'billin';
?>
    <a id="downloadlink" href="download_pdf2.php?info=<?php if(isset($infochk)) echo $infochk; ?>&hist=<?php if(isset($hischk)) echo $hischk; ?>&insu=<?php if(isset($insuchk)) echo $insuchk; ?>&billin=<?php if(isset($billchk)) echo $billchk; ?>">Download</a> </div>
  <!--generate report -->
</div>
<!--/main_coontent -->
</body>
</html>

Hi,

I have this form which will create a checkbox list using data from my database and also determin if a checkbox had been checked before and check if it had.

<form style="text-align:center" name="PrefRestaurant" id="PrefRestaurant" action="preferances_check.php" method="post"><table align="center"> <?php checkbox(id, name, restaurants, id); ?></table>
<input type="submit" name="Prefer" id="Prefer" value="Επιλογή"/></form>
   
function checkbox($intIdField, $strNameField, $strTableName, $strOrderField, $strMethod="asc") {
$strQuery = "select $intIdField, $strNameField
               from $strTableName
               order by $strOrderField $strMethod";
    $rsrcResult = mysql_query($strQuery);


while ($arrayRow = mysql_fetch_assoc($rsrcResult)) {
$testqry = "SELECT * FROM user_restaurant WHERE user_id = $_SESSION[UserId] AND restaurant_id = $arrayRow[id]";
$rsltestqry = mysql_query($testqry);
$numrows = mysql_num_rows($rsltestqry);
if ($numrows == 1) {
echo "<tr align=\"left\"><td><input type=\"checkbox\" name=\"restaurant[]\" value=\"$arrayRow[id]\" checked/>$arrayRow[name]</td></tr>";
}
else{
echo "<tr align=\"left\"><td><input type=\"checkbox\" name=\"restaurant[]\" value=\"$arrayRow[id]\" />$arrayRow[name]</td></tr>";
}
}

}      


Now the part which I can't get to work is when I'm trying to store the new values in my database. When I click the submit button I clear my database of any row that is related to the currently loggedin user and I want to store his new preferences (checked cheboxes). I've read that only the cheked checkboxes' values are POSTed so I did this (preferances_check.php)

foreach($_POST['restaurant']  as  $value)  {
 
 $query="INSERT INTO user_restaurant VALUES ('$_SESSION[UserId]','$value')";
 
} 

But it is not working, nothing gets written in my table Could someone please enlighten me on this? Thnks!

I have an audio mix submitting form on my website. The first part of the form takes the details from the user and inserts a new row in the first table 'mix', auto incrementing to generate a mix_id primary key.

The second part then uses a series of check boxes  to select which genres the mix contains and a foreach for the resulting array to insert, into the 2nd table 'genres_for_mix', a new row for each genre id (foreign key for the genres table) that is selected and the mix_id that it concerns.

Now I'm starting to think this is a bad way to do this because:

1. I don't know how to echo this out when a user edit's the mix to make all the relevant checkboxes selected.
2. When a user deselects a choice, it would be quite long winded to delete the nessesary row.


So instead I'm thinking that it would be much wiser to user the serialise functions to put the array into the database


However, I still don't know how to make the right checkboxes selected when I echo out the edit form. Do I use something like inarray()? If so how?

Also, it's really important that I can query the database for mixes that are associated with a specific genre. Without unserialising the array and therefore echo'ing out all the results, I don't know how to query this. Would I just use a 'WHERE genre_field LIKE 'genre_id'?

Can anyone help me with this please?

So, I have a checkbox, like so:

(uci is an ID number)
<input type='checkbox' name='cars[]' value='".$row['uci']."' />

That is passed to the next page via the form. However I need to pass the id numbers again, through to a third and final page. Currently I'm trying to do it through hidden inputs, but all I get returned to me is the word, "Array".

This is the second page, displaying the data it recieves from the checkbox on the first page and attempting to send it through to the third page via a hidden input.

$ids = $_POST['cars'];

...
Displays data here...
...

<form action='step_3.php' method='POST'>
<input type='hidden' name='cars' value='$ids' />
<input type='submit' name='submit' value='Final Step' />
</form>


I also tried <input type='hidden' name='cars' value='".$_POST['cars']."' /> but that didn't work either.

This is what I'm using to display the data on the final page, as a check to make sure it's working (this is where I'm just getting the word, "Array"):

echo"Car Id's: ".$_POST['cars']."<br />";

So, I guess my question is how do I pass the multiple options checked on the first page through more than one page? It works fine displaying the data on the second page, however when I try to display it again on the third page via the hidden input, it doesn't work.

I posted a topic earlier and there was confusion as to what I could not work out.   I am able to display the checkbox, either checked or unchecked depending of the value or 1 or 0 in the obcDisplay field.

<input type="checkbox" name="obcDisplay" value="<?=$r['obcDisplay'] ?>" <?=($r['obcDisplay']) ? 'checked="checked"' : ''; ?>/>

I am trying to update the DB table by the checkbox.  If the checkbox is checked (obcDisplay = 1) and I uncheck the box and submit, I want the table updated so that obcDisplay now equals 0.  When the form is displayed, the checkbox is now uncheck (obcDisplay = 0).  Now I check the box and submit and the update changes the field from 0 to 1.   I can display the checkbox as checked or unchecked by the DB field obcDisplay being either 0 or 1.  It is changing the value where I am having the problem.

I am trying to give role based access here. I want to display the pages which user has access in checkbox format. Here is my code

$sql = "SELECT p.page_id AS pid, 
                            p.page, 
                            p.href, 
                            ra.pages AS rpage 
             FROM pages p 
             INNER JOIN role_access ra 
             WHERE p.page_id IN (ra.page) 
             AND ra.role=1";

$query = mysqli_query($con, $sql) or die(mysqli_error($con));

$checked_arr = array();

while($row = mysqli_fetch_array($query)) { 
$checked_arr = explode(",",$row['rpage']);

foreach ($checked_arr as $page) {

    echo "<br/><input type='checkbox' name=\"pages[]\" value='$page' />$page<br>";
}

My tables are like this

ROLE

CREATE TABLE `role` (
  `rid` int(5) NOT NULL,
  `role_name` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `role` (`rid`, `role_name`) VALUES
(1, 'Admin'),
(2, 'Others');

ALTER TABLE `role`
  ADD PRIMARY KEY (`rid`);


ROLE-ACCESS

CREATE TABLE `role_access` (
  `id` int(10) NOT NULL,
  `page` varchar(160) NOT NULL,
  `role` int(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `role_access` (`id`, `page`, `role`) VALUES
(1, '1,2,3,4,5', 1),
(2, '2,4,5', 2);

ALTER TABLE `role_access`
  ADD PRIMARY KEY (`id`);



PAGES

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL,
  `code` varchar(10) NOT NULL,
  `page` varchar(100) NOT NULL,
  `href` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `pages` (`page_id`, `code`, `page`, `href`) VALUES
(1, 'Patient', 'Registration', '/patient_registration.php'),
(2, 'Patient', 'List', '/patient_list.php'),
(3, 'Patient', 'Edit', '/edit_patient.php'),
(4, 'Patient', 'Export', '/export_patient.php'),
(5, 'Patient', 'MRD', '/patient_MRD.php');

ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`);

 

 

In above query i get result like this

But required result is

if i change checkbox display like

while($row = mysqli_fetch_array($query)) { 
$checked_arr = explode(",",$row['rpage']);
$pname = $row['page'];
foreach ($checked_arr as $page) {

    echo "<br/><input type='checkbox' name=\"pages[]\" value='$page' />$pname<br>";
}
}

i get result

 

How to get the names for that file.

 

 

 

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=309239.0

Hello, 

I am trying to update my database with multiple array values like this.

if (isset($_POST['submit_multiple']))
{

$id=$_POST['selector'];
$class=$_POST['class'];
$section=$_POST['section'];

$N = count($id);

for($i=0;$i<$N;$i++)
{

echo "update table1 set transfer_status='yes',transfer_date='".date('Y-m-d')."',class='".$class[$i]."',section='".$section[$i]."' where enroll_no='".$id[$i]."'";
}

and in the form 

<form action="transfer_mul_student.php" method="post"><select name="class[]">
<option value="">--SELECT CLASS--</option>
<option value="Nursery">Nursery</option>
<option value="LKG">LKG</option>
<option value="UKG">UKG</option>
<option value="I">I</option>
<option value="II">II</option>
<option value="III">III</option>
<option value="IV">IV</option>


</select>
<select name="section[]"><option value="">--SELECT SECTION--</option>
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
</select><input name="selector[]" id="selector" type="checkbox" value="<?php echo $row['enroll_no']; ?>" />


<input type="submit" class="delete_multiple" value="Transer" name="submit_multiple" />

Here 

$row['enroll_no']

is from table student.

I have attached the screenshot for the page display with form    err1.PNG   12.04KB   0 downloads,    In that If i select checkbox1, checkbox2 checkbox3.. it takes the value for class and section properly, but if i select checkbox1, checkbox3, it takes value for 1st record properly and for 2nd one it takes blank value for class and section. How to overcome this? Please suggest