PHP - Moved: Retrieving Multiple Checkbox Values From A Database

 

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 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

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?

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        

Hi,

I am new to php and need help.
I am building a library system for an assignment.
I want to provide a functionality that registers (adds) all transactions to defferent databases.
I am stuck on how to add a selected row (selected by a checkbox) to the database and make sure that 2 users cannot update the same record at the same time.

Thanks for your help.

bellow is my code:

Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
  <meta name="generator" content="PSPad editor, www.pspad.com">
  <title>Web Works DD - Web Development & Software Solutions</title>
         <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>
      <link rel="stylesheet" type="text/css" href="css/style.css" />
 
  </head>
  <body>
  <!--<div class="utilities">
         <!-- UTILITIES MENU --
      <a href="index.php" style=text-decoration:none;><img src="images/home.png" border="0" alt="Home Page"/> Home Page</a>    <a href="sitemap.php" style=text-decoration:none;><img src="images/sitemap.png" border="0" alt="Sitemap"/> Sitemap</a>
        </div><!-- END UTILITIES -->
 
  <div id="right_bar">   <!-- right bar starts here -->
  </div> <!-- end of right bar -->
 
  <div id="top_bar">   <!-- top bar starts here -->
  <a href="index.php" style=text-ecoration:none; title="Web Works DD - Web Development & Software Solutions"><img src="images/mainLib.jpg" border=0 style=height:180;/> </a>
  <img src="images/topText.jpg" border=0 style=height:180;/>
  </div> <!-- end of top bar -->
       
 <div id="container">
 <div id="top-logo">
  <!--<a href="index.php" style=text-ecoration:none; title="Web Works DD - Web Development & Software Solutions"><img src="images/Main_logo.jpg" border=0 /> </a> -->
  </div>   
         
     <ul class="dropdown dav">
     <li><a href="index1.php">HOME</a></li>
     <li><a href="#" class="dir">VIEW RWSOURCES</a>
      <ul>
         <li><a href="books.php">BOOKS</a></li>
         <li><a href="dvds.php">DVDS</a></li>
         <li><a href="journals.php">JOURNALS</a></li>
    </ul>
   </li>
   <li><a href="staffLogin.php">STAFF ZONE</a></li>
    <li><a href="studentsLogin.php">STUDENT ZONE</a></li>
   
</ul>

<table>
<!--This defines a new form -->
<form action="" method="post">
<!--This creates the dropdown in html-->
<select name="fields">
<option value="1">Please select...</option>
<option value="isbnno">isbnno</option>
<option value="title">title</option>
<option value="description">description</option>
<option value="author">author</option>   
</select>
</td>
</tr>
<tr>
<td>
<input type="text" name="value" size="40">
</td>
</tr>
<tr>
<td>
<!-- Create a button -->
<input type="submit" value="Select" name="select">
</td>
</tr>
</form>
</table>
 
<?php
 session_start();
 include("secure/db_open.php");
       /* $myusername=$_SESSION['myusername']; 
        echo $myusername;
        $insert = $checkbox[$i];
        $cops = $_POST['copies'];
        $userid ="SELECT id FROM students WHERE username = '$myusername'";  
        $uido = mysql_query($userid); 
        $row = mysql_fetch_array($uido);
        echo $row['id'];    */
        
        
  
// get variable after selecting something from the dropdown with name 'fields'

$select = $_POST['select']; 
$valu = $_POST['value'];
// if something has been chosen
if (!empty($select)) 
{ 

$fields = $_POST['fields'];  //get the chosen value
$allbooks="SELECT * FROM books WHERE {$fields} = '$valu'";
//select books that are available - driven by the user's input
$copas="SELECT * FROM books WHERE {$fields} = '$valu' AND available_copies > 0";
$copy = mysql_query($copas); 
//count the number of rows resulting from the query
$count=mysql_num_rows($copy);
//$copse = mysql_fetch_array($copy);

//select books that are not available
$notavailable="SELECT * FROM books WHERE {$fields} = '$valu' AND available_copies = 0";
$shownotavailable=mysql_query($notavailable);
$count1=mysql_num_rows($shownotavailable);

//display a form 
echo "<table width='1100' border='0' cellspacing='1' cellpadding='0'>";
echo "<tr>";
echo "<td>" ;
echo "<form name='form1' method='post' action=''>";
echo "<table width='1100' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>";
echo "<tr>";
echo "<td align='center' colspan='9' bgcolor='#FFFFFF'>";
echo "<strong>Available to Loan </strong>" ;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center' bgcolor='#FFFFFF'>Loan</td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>ISBN No.</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Title</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Description</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Author</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Loan Type</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Location</strong></td>"; 
echo "<td align='center' bgcolor='#FFFFFF'><strong>Available Copies</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Desired Num of Copies</strong></td>";
echo "</tr>"; 
while(($row = mysql_fetch_assoc($copy)))
  {  
  echo "<tr>";
  echo "<td align='center' bgcolor='#FFFFFF'><input name='checkbox[]' type='checkbox' id='checkbox[]' value=".$row['bookid']."></td>";
  echo "<td>" .$row['isbnno']. "</td>";
  echo "<td>" .$row['title']. "</td>";
  echo "<td>" .$row['description']. "</td>";
  echo "<td>" .$row['author']. "</td>";
  echo "<td>" .$row['loan_type']. "</td>";
  echo "<td>" .$row['location']. "</td>";
  echo "<td>" .$row['available_copies']. "</td>"; 
  echo "<td align='center' bgcolor='#FFFFFF'><input name='copies' type='text' id='copies' size='2'></td>";  
  echo "</tr>";
  }        
echo "<tr>";
echo "<td colspan='9' align='center' bgcolor='#FFFFFF'><input name='loan' type='submit' id='loan' value='Loan Book'></td>";
echo "</tr>";
echo "</table>"; 

if (isset($_POST))
{
      session_start();
        $myusername=$_SESSION['myusername'];     
        $cops = $_POST['copies'];
        $userid ="SELECT id FROM students WHERE username = $myusername";  
        $uido = mysql_query($userid); 
        $row1 = mysql_fetch_array($uido);
        $sid = $row1['id']; 
        
    for ($i=0;$i<$count;$i++)
    {   
        $insert = $checkbox[$i];
       //echo "Welcome, ".$row['id'];
        $insertloaned="INSERT INTO studentloanedbooks(studentid, bookid, noofcopies) VALUES ($sid, $insert, $cops)";
        $loaned = mysql_query($insertloaned);
            
    }   
     
}  
    
if($count1>0)
{
    //display the books details
    //display a form 
echo "<br>";
echo "<br>";  
echo "<table width='1100' border='0' cellspacing='1' cellpadding='0'>";
echo "<tr>";
echo "<td>" ;
echo "<form name='form1' method='post' action=''>";
echo "<table width='1100' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>";
echo "<tr>";
echo "<td align='center' colspan='9' bgcolor='#FFFFFF'>";
echo "<strong>Available to Loan </strong>" ;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center' bgcolor='#FFFFFF'>Loan</td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>ISBN No.</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Title</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Description</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Author</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Loan Type</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Location</strong></td>"; 
echo "<td align='center' bgcolor='#FFFFFF'><strong>Available Copies</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Desired Num of Copies</strong></td>";
echo "</tr>"; 
while(($row = mysql_fetch_assoc($shownotavailable)))
  {  
  echo "<tr>";
  echo "<td align='center' bgcolor='#FFFFFF'><input name='checkbox[]' type='checkbox' id='checkbox[]' value='.$row[bookid]'></td>";
  echo "<td>" .$row['isbnno']. "</td>";
  echo "<td>" .$row['title']. "</td>";
  echo "<td>" .$row['description']. "</td>";
  echo "<td>" .$row['author']. "</td>";
  echo "<td>" .$row['loan_type']. "</td>";
  echo "<td>" .$row['location']. "</td>";
  echo "<td>" .$row['available_copies']. "</td>"; 
  echo "<td align='center' bgcolor='#FFFFFF'><input name='copies' type='text' id='copies' size='2'></td>";  
  echo "</tr>";
  }        
echo "<tr>";
echo "<td colspan='9' align='center' bgcolor='#FFFFFF'><input name='reserve' type='submit' id='reserve' value='Reserve Book'></td>";
echo "</tr>";
echo "</table>"; 

    
}



}
// include("secure/db_close.php");   


 //include("secure/db_close.php");  
?>
   


<!--if($cop>0){  -->



<!-- this is my footer div -->
<div id="footer">
Copyright &copy; 2010 | <a href="privacy.php">Privacy Policy</a> | <a href="terms.php">Terms of Service</a>
<img src="images/mini_logo1.png" align="right" style="margin-right:5" />
</div>   <!-- End footer div -->

    </div>
    </div>
  </body>
</html>

MOD EDIT: [code] . . . [/code] BBCode tags added.

This topic has been moved to JavaScript Help.

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

Hello I need a great help for my problem, I tried to insert multiple checkboxs for "$_POST active" in my CRUD and the values must be saved in the database but will be saved as "Array" everytime.
I used this code but where exactly I need to put it?

foreach($_POST['active'] as $act){//query? }

Here the PHP code

<?php
require_once "../lakota/config.php";

if ($_SERVER["REQUEST_METHOD"] == "POST") {

    if (isset($_POST['faction'], $_POST['stations'], $_POST["active"], $_POST['pending'], $_POST['influence'], $_POST['id_fact'])) {
    
    if(isset($_POST["submit"])){
	$activearr=$_POST["active"];
	$newvalues=  implode(",", $activearr);
	include_once "../lakota/checkboxClass.php";
	$checkBoxClass=new checkboxClass();
	echo $checkBoxClass->addtoDatabase($newvalues);
}
    
        $sql = "INSERT INTO lakotabgs (faction, stations, active, pending, influence, id_fact) VALUES (?,?,?,?,?,?)";
        
        if ($stmt = $link->prepare($sql)) {
            $stmt->bind_param("ssssss", $_POST['faction'], $_POST['stations'], $_POST["active"], $_POST['pending'], $_POST['influence'], $_POST['id_fact']);
            
            if ($stmt->execute()) {
                header("location: ../lakota/index.php");
                exit();
            } else {
                echo "Error! Try again later.";
            }
            $stmt->close();
        }
    }

    $link->close();
}
?>

HTML code

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Add new info</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"
          integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
</head>
<body>
                    
  			<form action="<?php echo $_SERVER["PHP_SELF"] ?>" method="post">                   
                        <label><b>Active States</b></label>
                        <input name="active[]" class="form-control" id="example1" type="checkbox" value="None"  />
                        <label for="example1">None</label>
                        <input name="active[]" class="form-control" id="example2" type="checkbox" value="Everybody"  />
                        <label for="example2">Everybody</label>
                        <input name="active[]" class="form-control" id="example3" type="checkbox" value="Unknown"  />
                        <label for="example3">Unknown</label>
                    <input type="submit" id="submit" name="submit" class="btn btn-primary" value="Add new info">
                    <a href="../lakota/index.php" class="btn btn-default">Back</a>
                </form>
</body>
</html>

 

Edited November 14, 2020 by AccuCORE

Hi,

so i have a problem. I'm using a script to enable and disable checkboxes, and i'm id-ing them fetching values from a database:

while($data = mysqli_fetch_array($sql))
{
  if ($count % 5 == 0) {
    echo '</tr><tr>';
    $count = 0;
  }
  echo '<td><input name="subject_level[]" class="subject_a" disabled="disabled" type="checkbox" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
  echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
  $count++; //Increment the count
}

The names of the checkboxes come out fine, just that, is there any way to retrieve the values of the checkboxes into an array of some sort so that i could build a search query later?

if($_POST(subject_level)) or if($_POST(subject_level[]))  doesn't return true. does it make sense? im new to php so please forgive my ignorance. Help appreciated. Thanks!

This topic has been moved to MySQL Help.

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

This topic has been moved to JavaScript Help.

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

This topic has been moved to JavaScript Help.

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