Learn VBA & Macros in 1 Week!

PHP - Linking Checkbox Value To A Table Record In Php And Changing Values

Full Excel VBA Course - Beginner to Expert

Linking Checkbox Value To A Table Record In Php And Changing Values	View Content

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.

Full Excel VBA Course - Beginner to Expert

Table With Changing Values Everyday

Similar Tutorials

View Content

I'm not completely sure how to implement this so I'd like to ask you to give me an idea if you can
For a tennis booking system.. it will look something similar to (should be a table but this is for the sake of the idea)

Date: Oct 25th, 2010 (go to oct 26)
Court 1 Court 2 Court 3 Court 4

8:00 Open(bookit) Tally Open Hellio
9:00 Andy Roger Barney Training
...etc

Now everyday, this table should be empty, so new bookings can be made
how would I make it so a new table is empty /or has dif bookings every day (based on date) efficiently?

Im guessing I will have dif values in the sql table for dif dates but what I'm not sure of is how to display it in page

for ex, if someone presses the button oct 26, the new table is for that date, wif diff values

Php/mysql Usage = Display Full List, Checkbox Each Record Where User Is 'yes'

Similar Tutorials

View Content

Hey guys, I can't wrap my head around how to make this work right...

I have three tables:
Code: [Select]
CREATE TABLE `games` (
`g_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(150) DEFAULT NULL,
PRIMARY KEY (`g_id`));

CREATE TABLE IF NOT EXISTS `game_player` (
`r_id` int(11) NOT NULL AUTO_INCREMENT,
`p_id` int(11) DEFAULT NULL,
`g_id` int(11) DEFAULT NULL,
`bool` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`r_id`));

CREATE TABLE IF NOT EXISTS `players` (
`p_id` int(11) NOT NULL AUTO_INCREMENT,
`playerid` varchar(150) NOT NULL,
PRIMARY KEY (`p_id`),
UNIQUE KEY `playerid` (`playerid`));

The players table is my list of users, and they're tied to the list of games via the game_player table.

So here's my issue... I'm trying to show the full list of games, and then check mark each record where the player does play it.
This is what I have so far - it shows all the games, but it's not checking the boxes.

Code: [Select]
$result = mysql_query("SELECT * FROM games") or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$newquery = "SELECT * FROM game_player, players
WHERE game_player.p_id = players.p_id
AND game_player.g_id = ".$row['g_id']. "
AND players.playerid = {$userid}";
$query = mysql_query($newquery) or die(mysql_error());
if($query['bool'] == 1) { $set_checked = " CHECKED";
}
else{ $set_checked = "";
}
echo "<input type=\"checkbox\" name=\"box1\" value=\"".$query['g_id']."\"" . $set_checked . "/>".$row['name']."<br />\n";
}

Checkbox Values From Database

Similar Tutorials

View Content

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?

Checkbox Values To Database.

Similar Tutorials

View Content

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.

Multiple Values In A Checkbox?

Similar Tutorials

View Content

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

Help Anyone..

Retaining Checkbox Values

Similar Tutorials

View Content

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?

Multiple Values In A Checkbox

Similar Tutorials

View Content

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?

Displaying Multiple Checkbox Values

Similar Tutorials

View Content

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']."
";
}
  }
?>

Using $row And Changing Values

Similar Tutorials

View Content

Hi,

I'm using the following code:

<td>$row[color]</td>

and the possible values for this field are 1, 2 and 3. But I want the return to be red for 1, blue for 2, and green for 3.

How do I write it so that instead of getting a row of 1's, 2's and 3's, I change those numbers to their corresponding colors?

Thanks!

Table Issue - Multiple Location Values For User Pushes Values Out Of Row Instead Of Wrapping In Cell

Similar Tutorials

View Content

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:

<thead>

<tr>

<th>FirstName</th>

<th>LastName</th>

<th>Username</th>

<th>Phone #</th>

<th>Location</th>

<th>Title</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'>

</td>";

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

echo "</tr>";

}

<tr>

<td>FirstName</td>

<td>LastName</td>

<td>Username</td>

<td>Phone #</td>

<td>Location</td>

<td>Title</td>

</td>

</tr>

</tbody>

<tfoot>

<tr>

<th>FirstName</th>

<th>LastName</th>

<th>Username</th>

<th>Phone #</th>

<th>Location</th>

<th>Title</th>

</tr>

</tfoot>

</table>

Php,mysql Store Checkbox Values In Database

Similar Tutorials

View Content

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!

Pass Checkbox Values In Url To Download Page

Similar Tutorials

View Content

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

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

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

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

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

</div>

</body>
</html>

Form: $_post 2 Values From Each Checkbox And Button

Similar Tutorials

View Content

So, i need this.

Checkbox Selected From Database Values (theory)

Similar Tutorials

View Content

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?

Passing Checkbox Values Through Hidden Inputs?

Similar Tutorials

View Content

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.

Inserting Multiple Checkbox Values Into Mysql

Similar Tutorials

View Content

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:  <input type="text" name="first" /><br />
Last Name:  <input type="text" name="last" /><br />
<div>Gender: 
<label>
Male <input type="radio" value="Male" name="gender" /></label>
<label>Female <input type="radio" value="Female" name="gender" /></label>
</div>
Grade: 
<select name="grade">
  <option selected="selected"> </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: 
  <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: 
<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: 
<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

Changing Array Values

Similar Tutorials

View Content

Hi

Just learning PHP and I'm struggling with a very simple problem.

I'm playing around with arrays as i figure they're one of the most important things to know inside out but I can't work out how to change the value of an array element via a loop. I can obviously do it if I just directly write $cars[2] = "test" but not having any luck with the loop.

I've tried using "foreach" and passing a new value to the $value variable but when i do a print_r the values in the array are unchanged.

Code: [Select]

$cars[0]="Saab";
$cars[1]="Volvo";
$cars[2]="BMW";
$cars[3]="Toyota";

foreach ($cars as $key => $value)
{

$value = "TEST";
echo $key . " " . $value . "<br />";

}

print_r($cars)

I then tried using a for loop

Code: [Select]
for ($i=0; $i <= count($cars); $i++)

{

echo $cars[$i];

$cars[$i] = "2";

}

But this code just threw up a fatal error as follows:

"Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 16 bytes) in /home/zzzzzzzz/public_html/php_testing/arrays.php on line 27"

So would someone be kind enough to explain where i'm going wrong and why i get the fatal error on the second for loop.

Thanks

Drongo

Changing Form Values

Similar Tutorials

View Content

I have a form for a sign in page that I want the label for the form field to actually be displayed in the text box and clear when the box is selected to enter text. I've accomplished this using the code below and it works fine. The problem that I'm having is in IE the password field does not change to display dots or asterisk in place of each character. It works fine in Fire Fox but not in IE. Is there way to accomplish this using php or so that it is compatible with most browsers?

Here's the code that I'm using:
Code: [Select]
<?php

echo "<input type=\"text\" name=\"pword\" size=\"17\" value=\"Password...\" style=\"color: #999999\" onfocus=\"if (this.value == 'Password...') {this.value=''; this.style.color='#000000'; this.type='password';}\"> ";

?>

Changing Input Values ?

Similar Tutorials

View Content

Can be those <input ...> types with values changed from a script ?. Imagine it like we have an admin and we want to change some input values with a generated form on that page instead of going source and changing 1 by 1 ?

How To Update A Record In My Table

Similar Tutorials

View Content

Not sure how to update a record in my table here. I got my insert and delete statement working. Just can't get the update to work correctly. I'm not really sure how to do it.

Here is my code for my page, and my update and delete page

Code: [Select]
<?php

ini_set ("display_errors", "1");
error_reporting(E_ALL);

require_once('database.php');
session_start();

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

$query = "INSERT INTO grades (grade_id, student_id, grade_type, grade_name, grade_points) ";
$query .= "VALUES (:grade_id, :student_id, :grade_type, :grade_name, :grade_points) ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $_SESSION['student_id']);
$statement->bindValue (':grade_id', $_SESSION['grade_id']);
$statement->bindValue (':grade_type', $_POST['grade_type']);
$statement->bindValue (':grade_name', $_POST['grade_name']);
$statement->bindValue (':grade_points', $_POST['grade_point']);

$statement->execute();

$statement->closeCursor();

$grade_type = $_POST['grade_type'];

if ($grade_type == 'Lab') {

$final *= .60;
}

echo $final;

$grade_type = $_POST['grade_type'];

if ($grade_type == 'Mid-Term') {

$final *= .20;
}

echo $final;

$grade_type = $_POST['grade_type'];

if ($grade_type == 'Final') {

$final *= .20;
}

echo $final;

}

?>
<!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>View Course Grades</title>

<link rel="stylesheet" type="text/css" href="main.css" />
</head>

<body>

<?php

$student_name = $_SESSION['student_name'];
$student_id = $_SESSION['student_id'];
$query = "SELECT * FROM grades WHERE student_id = :student_id ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $student_id);
$statement->execute();
$grades = $statement->fetchAll();
$statement->closeCursor();

echo "<h1>Show Grades for $student_name </h1>";

foreach ($grades as $grade)
{

echo $grade['grade_type'] . " " . $grade['grade_name']. " " . $grade['grade_points'] . "<br />";
}

?>

<div id="content">


<table>
<tr>
<th>Grade Type</th>
<th>Grade Name</th>
<th>Grade Points</th>
<th>Remove</th>
</tr>
<?php foreach ($grades as $grade) : ?>
<tr>
<td><?php echo $grade['grade_type'];   ?></td>
<td><?php echo $grade['grade_name'];   ?></td>
<td><?php echo $grade['grade_points']; ?></td>
<td><form action="delete_grade.php" method="post">

<input type="submit" name="remove" value="Delete" />

</form></td>
</tr>
<?php endforeach; ?>
</table>

</div>
</div>

<div id="footer">

</div>

<form name="grades" method="post" action="grades.php">

<p>Grade Type<SELECT NAME="grade_type">
<OPTION VALUE="Mid-Term">Mid-Term
<OPTION VALUE="Final">Final
<OPTION VALUE="Lab">Lab
</SELECT>
<br>

Grade Name:<input type="text" name="grade_name" value=""><br />
Grade Points:<input type="text" name="grade_point" value="">

<input type="submit" name="add_grade" value="Add Grade">

</form>

</table>

</body>

</html>

My delete and update page

Code: [Select]
<html>
<head>
<title>Delete Grade</title>
</head>
<body>
<form method="post" action="delete_grade.php">

<?php

ini_set ("display_errors", "1");
error_reporting(E_ALL);

$dbc = mysqli_connect('localhost', 'se266_user', 'pwd', 'se266')
or die(mysql_error());

//delete grades

if (isset($_POST['remove']))
{
foreach($_POST['delete'] as $delete_id)
{
$query = "DELETE FROM grades WHERE grade_id = $delete_id";
mysqli_query($dbc, $query) or die ('can\'t delete user');
}
echo 'user has been deleted.<br />';
}

if (isset($_POST['update']))
{
foreach($_POST['update'] as $update_id)
{
$query = "UPDATE grades SET grade_id = $grade_id";
mysqli_query($dbc, $query) or die ('can\'t update user');

}
}

//Display grade info with checkbox to delete
$query = "SELECT * FROM grades";
$result = mysqli_query($dbc, $query);
while($row = mysqli_fetch_array($result))
{
echo '<input type="checkbox" value="' .$row['grade_id'] . '" name="delete[]" />';
echo ' ' .$row['grade_type'] .' '. $row['grade_name'];
echo '<br />';
}
mysqli_close($dbc);

?>

<input type="submit" name="remove" value="Remove" />
<input type="submit" name="update" value="Update" />

</form>
</body>
</html>