PHP - Multiple Values In A Checkbox

Hello all,

   I am trying to learn OOP in PHP so please forgive my ignorance. I seem to be having difficulty inserting data into my database from checkbox items. My database has a column for each each fruit. I would like for each column to be populated with either a one(1) for checked or a zero(0)  for not checked. Currently, my attempts have failed. I can either get all checkboxes to insert all zeros or I can get the first column to insert a one(1) while the others as zeros. Is there anybody here that can help me figure out what I am doing wrong and help me to re-work my code so I can get this to work? If anybody can help me using OOP methods that would be fantastic. Thank you all in advance.

 

$preffruit->create_preffruit(array(

  'fruit_apple' => escape(Input::get(['fruit_selection'][0]) ? 1 : 0),
  'fruit_orange' => escape(Input::get(['fruit_selection'][1]) ? 1 : 0),
  'fruit_banana' => escape(Input::get(['fruit_selection'][2]) ? 1 : 0),
  'fruit_pear' => escape(Input::get(['fruit_selection'][3]) ? 1 : 0),
  'fruit_kiwi' => escape(Input::get(['fruit_selection'][4]) ? 1 : 0)

  ));

<input type="checkbox" name="fruit_selection[]" value="fruit_apple">
<input type="checkbox" name="fruit_selection[]" value="fruit_orange">
<input type="checkbox" name="fruit_selection[]" value="fruit_banana">
<input type="checkbox" name="fruit_selection[]" value="fruit_pear">
<input type="checkbox" name="fruit_selection[]" value="fruit_kiwi">



public function insert_preffruit($table, $fields = array()) {
			
			$keys = array_keys($fields);
			$values = '';
			$x = 1;			
			
			foreach($fields as $field) {
				$values .= '?';
				if($x < count($fields)) {
					$values .= ', ';
				}
				$x++;
			}		
				
				$sql = "INSERT INTO preffruit (`user_id`, `" . implode('`, `', $keys) . "`) VALUES (LAST_INSERT_ID(), {$values})";		
			
			if(!$this->query($sql, $fields)->error()) {
				return true;
			}			
			
			return false;
		}

 

Edited September 23, 2020 by ke-jo

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites.  When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell.  It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in.  Both cases mess up the table and formatting.  I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<table id="datatables-column-search-select-inputs" class="table table-striped" style="width:100%">

                                        <thead>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                                <th>Actions</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php

                                            //QUERY TO SELECT ALL USERS FROM DATABASE

                                            $query = "SELECT * FROM users";

                                            $select_users = mysqli_query($connection,$query);

                                            

                                            // SET VARIABLE TO ARRAY FROM QUERY

                                            while($row = mysqli_fetch_assoc($select_users)) {

                                                $user_id = $row['user_id'];

                                                $user_firstname = $row['user_firstname'];

                                                $user_lastname = $row['user_lastname'];

                                                $username = $row['username'];

                                                $user_phone = $row['user_phone'];

                                                $user_image = $row['user_image'];

                                                $user_title_id = $row['user_title_id'];

                                                $user_role_id = $row['user_role_id'];

                                            

                                                // POPULATES DATA INTO THE TABLE

                                                echo "<tr>";

                                                echo "<td>{$user_id}</td>";

                                                echo "<td>{$user_firstname}</td>";

                                                echo "<td>{$user_lastname}</td>";

                                                echo "<td>{$username}</td>";

                                                echo "<td>{$user_phone}</td>";

                                            

                                                //PULL SITE STATUS BASED ON SITE STATUS ID

                                                $query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

                                                $select_site = mysqli_query($connection, $query);

                                                while($row = mysqli_fetch_assoc($select_site)) {

                                                    $site_name = $row['site_name'];

                                                    echo "<td>{$site_name}</td>";

                                                }

                                                echo "<td>{$user_title_id}</td>";

                                                echo "<td>{$user_role_id}</td>";

                                                echo "<td class='table-action'>

                                                    <a href='#'><i class='align-middle' data-feather='edit-2'></i></a>

                                                    <a href='#'><i class='align-middle' data-feather='trash'></i></a>

                                                    </td>";

                                                //echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

                                                echo "</tr>";

                                            }   

                                            ?>

 

                                            <tr>

                                                <td>ID</td>

                                                <td>FirstName</td>

                                                <td>LastName</td>

                                                <td>Username</td>

                                                <td>Phone #</td>

                                                <td>Location</td>

                                                <td>Title</td>

                                                <td>Role</td>

                                                <td class="table-action">

                                                <a href="#"><i class="align-middle" data-feather="edit-2"></i></a>

                                                <a href="#"><i class="align-middle" data-feather="trash"></i></a>

                                                </td>

                                            </tr>

                                        </tbody>

                                        <tfoot>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                            </tr>

                                        </tfoot>

                                    </table>

 

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?

I have a form and on each input I set the value as the post variable of it's self.  I do this so that if the user submit the form and it has errors they haven't lost the data they have inputted.  For example

<input name="input1" type="text" value="<?php echo($_POST['input1']); ?>" />

This works fine for text field and textarea's but how do I retain the value of radio boxes and checkboxes?

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!

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 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 need this.

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.

 

 

 

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.

Hi I just barely made it through sending form to email using php. now I have another problem with checkboxes. please help! whenever I select multiple checkbox options. the form only sends me the last check box option checked. not all checked options.

here's my php code :

Code: [Select]
<?php

/*Subject and Email Variables*/

   $emailSubject = 'Inquiry';
    $emailAddress = 'inquiry@topazbranch.com';
    
/*Gathering Data Variables*/

   $firstname = $_POST['firstname'];
    $lastname = $_POST['lastname'];
    $contact = $_POST['contact'];
    $email = $_POST['email'];
    $newsletter = $_POST['newsletter'];
    $projects = $_POST['ch'];
    $trippingSchedule = $_POST['tripping'];
    $source = $_POST['source'];
    $agent = $_POST['agent'];
    $comments = $_POST['comments'];
   
   
   if($_POST['submit']) {
      
   $projects = $_POST['projects'];
   
   foreach($projects as $ch)
   
   }
   
    
    $body = <<<EOD
<br/><hr/><br/>
Firstname : $firstname<br/>
Lastname : $lastname<br/>
Contact: $contact<br/>
Email : $email<br/>
Newsletter : $newsletter<br/>
Projects : $ch<br/>
Tripping Schedule : $trippingSchedule<br/>
Source : $source<br/>
Agent name : $agent<br/>
Additional Comments : $comments<br/>
EOD;

   $headers = "From: $email\r\n";
    $headers .= "content-type: text/html\r\n";
    $success = mail($emailAddress, $emailSubject, $body, $headers);
    
/* Results render as HTML*/

   $theResults = <<<EOD
(some html here)
EOD;

echo "$theResults";

?>

MOD EDIT: code tags added.

Hi. I have a form with a selection of checkboxes. I am trying to use an array to store the results in a single column of a mysql database. The problem is, instead of the values, it just stores 'array'.

Each checkbox is like so:

<input name="previous_diseases[]" value="Tuberculosis"/>

Here is my code:

Code: [Select]
<?php
try{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$database = new PDO('mysql:host=localhost;dbname=db', 'username', 'password', $pdo_options);
 
$execution=$database->prepare('INSERT INTO form(title, forename, surname, address_1, address_2, address_city, address_county, address_country, address_postcode, email, previous_diseases, hear) VALUES(:title, :forename, :surname, :address_1, :address_2, :address_city, :address_county, :address_country, :address_postcode, :email, :previous_diseases, :hear)'); 
$execution->execute(array('title' => $_POST['title'],
         'forename' => $_POST['forename'],
 'surname' => $_POST['surname'],
         'address_1' => $_POST['address_1'],
 'address_2' => $_POST['address_2'],
 'address_city' => $_POST['address_city'],
 'address_county' => $_POST['address_county'],
 'address_country' => $_POST['address_country'],
 'address_postcode' => $_POST['address_postcode'],
 'email' => $_POST['email'],
 'previous_diseases' => $_POST['previous_diseases'],
     'hear' => $_POST['hear']));
Can anyone please show me what I need to change to get the values inserted into the database.

Thank you

Hi all:

I start an application in PHP and SQL Server for a company car and I need some recommendations.

The application tracked him to the maintenance of the cars. On one side are the car brands (Ford, Chevrolet, etc.) with the relevant goods and associated services. A relationship many-to-many.

On the other hand, the executives (stage 1) enter the customer associated with their cars and the corresponding products and services. The customer goes to the mechanic who performs the action (step 2) and finally counter that the collection (step 3).

My main problem is how to link Client - Automobile - Services in the first form. Enter the name and telephone number after a multi-select will select the brand and asynchronously checkbox must be loaded in all services and check the corresponding to that mark.


I find it difficult to incorporate all the links on the form. Appreciate design recommendations database (customer table) and how to assemble the form. Maybe some of you made any similar application or know a reference.

Finally thank you in advance for the time can provide for review this post.