PHP - Problem With Number Of $_post Items (not Size!)

I'm new at PHP and have a problem.
I have a MySql database with lists of students grouped into classrooms. A typical group is shown in the attached screenshot screenshot.docx. I want to be able to select one or more of the names by using the associated checkbox, and upgrade a student or students into a different group as defined in the radio button list also in the screenshot.
I have the rudiments of the file attached, but I have absolutely no idea how I can post the array so that the records are updated.
Each student has an individual record with a field name userGroup which holds a string nominated by their classroom teacher, such as "year7", "year 8" and so on while they are in one of the several classrooms, but when they leave school this is recorded in a field named noGroup with a value of 0 or 1.
I can post further details as required, but it would be great if someone could help me.

This topic has been moved to MySQL Help.

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

Hi, I am using POST to send the id of a row in a MySQL database, this id should then be used to delete the row from MySQL, this all works fine when I use GET, but as soon as i try and use POST (for security reasons) it deletes another row.
Here is the code ($_POST):
Code: [Select]
<?php

$member = $logged['username'];
//IFMESSAGES THEN SAY OTHERWISE SAY NO 

$seemessages = mysql_query("SELECT * FROM `rmail` WHERE `to` = '$member' && `status` = 'unread'");
$howmanymessages = mysql_num_rows($seemessages);

$seereadmessages = mysql_query("SELECT * FROM `rmail` WHERE `status` = 'read' && `to` = '$member'");
$howmanyreadmessages = mysql_num_rows($seereadmessages);  
$totalmessages = $howmanyreadmessages + $howmanymessages;
//MENU FOR USING EMAIL VIEWED ON ALL SECTIONS OF R-MAIL
echo'<div id="emailmenu"><a href="rmail.php">Home</a>|<a href="rmail.php?inbox">Inbox('.$howmanymessages.'/'.$totalmessages.')</a>|<a href="rmail.php?compose">Compose</a>| </div><br/>';

if(isset($_POST['delete'])){
//DELETE MESSAGE
$id = $_POST['delete'];
echo $id;
$newvalue = mysql_query("SELECT * FROM data");
$newvalue = mysql_fetch_array($newvalue);
$newvalue = $newvalue['rmailsent'];
$newvalue = $newvalue-1;
mysql_query("UPDATE data SET rmailsent = '$newvalue'");
mysql_query("DELETE FROM rmail WHERE `id` = '$id'");
echo "Message has been deleted!";
}
else if(isset($_GET['inbox'])){
$username = $logged['username'];
//DISPLAY EMAILS FOR USER
//WHEN DISPLAYING DISPLAY LINK WITH THE ID TO VIEW THE SPECIFIC MESSAGE
$getemail = mysql_query("SELECT * from rmail WHERE `to` = '$username' ORDER BY `id` DESC");

echo'
<table border="1">
<tr>
<td> <font size="5">Check</font> </td>
<td> <font size="5">Status</font></td>
<td><font size="5">From</font></td>
<td width="500"><font size="5">Subject</font></td>
<td><font size="5">Date Sent</font></td>
<td><font size="5">Time Sent</font></td>
<td><font size="5">Action</font></td>
</tr>
';
while($email = mysql_fetch_array($getemail)){
$id = $email['id'];
if($email['status'] == "unread"){
echo "<tr bgcolor='#666666'>";
}else{
echo "<tr>";
}
echo '<td><input type="checkbox" name="'.$email['id'].'checked" class="check"></td>';
echo '<td>';
if($email['status'] == "unread"){
echo '<center><img src="/webimages/unread.gif" alt="Message Unread" width="30" height="25"></center>';
}else if($email['status'] == "read"){
echo '<center><img src="/webimages/read.gif" alt="Message Read" width="30" height="25"><center>';
}
echo '</td>';
echo '<td>'.$email['from'].'</td>';
echo '<td><a href="rmail.php?viewmail&id='.$email['id'].'">'.$email['subject'].'</a></td>';
echo '<td>'.$email['date'].'</td>';
echo '<td>'.$email['time'].'</td>';
echo '<td><form action="rmail.php" method="post">
<input type="hidden" value="'.$email['id'].'" name="delete"><input type="image" src="/webimages/delete.png" onclick="return confirm(\'Are you sure you want to Delete?Click Ok to proceed and Delete or Cancel if you do not want to delete!\');"><a href="viewmembers.php?user='.$email['from'].'"><img src="/webimages/eye3.gif" border="0" height="25" width="30"></a></td>';

echo "</font></tr>";
}
echo "</table>";
}

</html>
Here is the code with $_GET (this works but $_POST doesnt):
Code: [Select]
<?php

$member = $logged['username'];
//IFMESSAGES THEN SAY OTHERWISE SAY NO 

$seemessages = mysql_query("SELECT * FROM `rmail` WHERE `to` = '$member' && `status` = 'unread'");
$howmanymessages = mysql_num_rows($seemessages);

$seereadmessages = mysql_query("SELECT * FROM `rmail` WHERE `status` = 'read' && `to` = '$member'");
$howmanyreadmessages = mysql_num_rows($seereadmessages);  
$totalmessages = $howmanyreadmessages + $howmanymessages;
//MENU FOR USING EMAIL VIEWED ON ALL SECTIONS OF R-MAIL
echo'<div id="emailmenu"><a href="rmail.php">Home</a>|<a href="rmail.php?inbox">Inbox('.$howmanymessages.'/'.$totalmessages.')</a>|<a href="rmail.php?compose">Compose</a>| </div><br/>';

if(isset($_GET['delete'])){
//DELETE MESSAGE
$id = $_GET['delete'];
echo $id;
$newvalue = mysql_query("SELECT * FROM data");
$newvalue = mysql_fetch_array($newvalue);
$newvalue = $newvalue['rmailsent'];
$newvalue = $newvalue-1;
mysql_query("UPDATE data SET rmailsent = '$newvalue'");
mysql_query("DELETE FROM rmail WHERE `id` = '$id'");
echo "Message has been deleted!";
}
else if(isset($_GET['inbox'])){
$username = $logged['username'];
//DISPLAY EMAILS FOR USER
//WHEN DISPLAYING DISPLAY LINK WITH THE ID TO VIEW THE SPECIFIC MESSAGE
$getemail = mysql_query("SELECT * from rmail WHERE `to` = '$username' ORDER BY `id` DESC");

echo'
<table border="1">
<tr>
<td> <font size="5">Check</font> </td>
<td> <font size="5">Status</font></td>
<td><font size="5">From</font></td>
<td width="500"><font size="5">Subject</font></td>
<td><font size="5">Date Sent</font></td>
<td><font size="5">Time Sent</font></td>
<td><font size="5">Action</font></td>
</tr>
';
while($email = mysql_fetch_array($getemail)){
$id = $email['id'];
if($email['status'] == "unread"){
echo "<tr bgcolor='#666666'>";
}else{
echo "<tr>";
}
echo '<td><input type="checkbox" name="'.$email['id'].'checked" class="check"></td>';
echo '<td>';
if($email['status'] == "unread"){
echo '<center><img src="/webimages/unread.gif" alt="Message Unread" width="30" height="25"></center>';
}else if($email['status'] == "read"){
echo '<center><img src="/webimages/read.gif" alt="Message Read" width="30" height="25"><center>';
}
echo '</td>';
echo '<td>'.$email['from'].'</td>';
echo '<td><a href="rmail.php?viewmail&id='.$email['id'].'">'.$email['subject'].'</a></td>';
echo '<td>'.$email['date'].'</td>';
echo '<td>'.$email['time'].'</td>';
echo '<td><a href="rmail.php?delete='.$email['id'].'">DELETE</a><a href="viewmembers.php?user='.$email['from'].'"><img src="/webimages/eye3.gif" border="0" height="25" width="30"></a></td>';

echo "</font></tr>";
}
echo "</table>";
}

</html>

Any Ideas?
Thanks
Rhys

hello i have a script and i keep getting an error
on php4 i dont get that error
only on php5

<?php
session_start();
error_reporting(E_ALL);
ini_set('display_errors',1);
function query_str($params) {
        $str = '';
                foreach ($params as $key => $value) {
                        $str .= (strlen($str) < 1) ? '' : '&';
                        $str .= $key . '=' . rawurlencode($value);
                }
                 return ($str);
}

if($_GET['id']=='1'){
                $query=parse_str($_POST);
                query_str($query);
                $username=rtrim($username);
                $password=rtrim($password);
                // .... continue
echo $username.':'.$password.chr(10);
}


Code: [Select]
Warning: parse_str() expects parameter 1 to be string, array given in /var/www/poo/do.php on line 15
Warning: Invalid argument supplied for foreach() in /var/www/poo/do.php on line 7
Notice: Undefined variable: username in /var/www/poo/do.php on line 17
Notice: Undefined variable: password in /var/www/poo/do.php on line 18

the html code is this
Code: [Select]
<form  name="Form_Auth" action="do.php?id=1" method="post" target="_top">
<input name="username" id="txt" value="Nome utente" class="nomeutente">
<input name="password" type="password" maxlength="32" id="pass" value="password" class="password lf">
<input name="bottone" type="submit" class="bottone rf" value="Invia" alt="accedi">
</form>

Hi there I'm trying to make this form submit...but alas, is to no avail .... i have two forms on top of each other one of them is:

Code: [Select]
<form name="entries_form" method="post" action="index.php">
        <table>
    <tr>
<th><label>Date</label></th>
<th><label>From</label></th>
<th><label>To</label></th>
<th><label>Break</label></th>
<th><label>Hours</label></th>
<th><label>Required Hours</label></th>
<th><label>Notes</label></th>
    </tr>
    <tr>
<td>
   
    <input name="Date" type="text" id="Date" />
</td>
<td>
   
<input name="From" type="text" id="From" />
</td>
<td>
    <input name="To" type="text" id="To" />
</td>
<td>
   
    <input name="Break" type="text" id="Break" />
</td>
<td>
   
    <input name="Hours" type="text" id="Hours" />
</td>
<td>
   
    <input name="Rqrd_hrs" type="text" id="Rqrd_hrs" />
</td>
<td>
   
    <input name="Notes" type="text" id="Notes" />
</td>
<td>
    <input type="submit" name="Save" value="Save" id="Save" style="background-color:#7A70A4;" />
</td>
    </tr>
</table>
    </form>
to post i'm using this code (to much over the top maybe):
Code: [Select]
<?php

$session = new Session();
$u_id = $session->get('id'); //to get the user id from session

 if(isset($_POST['submit']) == 'Save'){//form's button  name is Save
$entry->user_id = $user_id = $u_id;
        $entry->date = $date = trim(strtolower($_POST['Date']));
        $entry->start_time = $start_time = trim(strtolower($_POST['From']));
        $entry->end_time   = $end_time   = trim(strtolower($_POST['To']));
$entry->breaks      = $break   = trim(strtolower($_POST['Break']));
$entry->total_hours   = $total_hours   = trim(strtolower($_POST['Hours']));
$entry->reqd_hours   = $required_hours   = trim(strtolower($_POST['Rqrd_hrs']));
$entry->notes   = $notes   = trim(strtolower($_POST['Notes'])); 
   
        $entry->add_entry();
    }else die("Not Posted");
    ?>
the add entry() function does the following:
Code: [Select]
public function add_entry(){
    global $database;
$sql = "INSERT INTO sheetentries (";
$sql .= "user_id, date, start_time, end_time, break, required_hours, total_hours, notes";
$sql .= ") VALUES ('";
$sql .= $this->user_id ."', '";
$sql .= $this->date ."', '";
$sql .= $this->start_time ."', '";
$sql .= $this->end_time ."', '";
$sql .= $this->breaks ."', '";
$sql .= $this->reqd_hours ."', '";
$sql .= $this->total_hours ."', '";
$sql .= $this->notes ."')";
    $database->query($sql);
    }
the user_id or $u_id brought from the session when the user loggs in:
Code: [Select]
$u_id = $session->get('id');
anyway, whenever i try submitting the form nothing happens, what am i missing,,, thanks in advance

I'm making a script for editing lines in a text file.

PHP code form form script:

$n = 0;
$bestand = "../test.txt"; 
$gegevens = file($bestand);

//count lines titel.txt
$lines = count(file($bestand));

while($n < $lines) {
$items = explode("|", $gegevens[$n]);
$titel = $items[0]; 
$beschrijving = $items[1];
$n=$n+1;

echo "<tr>
<td><input type=\"text\" class=\"edit\" name=\"titel[".$n."]\" value=\" ".$titel." \" /></td>
<td><textarea name=\"beschrijving[".$n."]\">".$beschrijving."</textarea></td>
  </tr>";
}


Code of processing script

<?php
$n = 1;

$bestand = "../test.txt";
$lines = count(file($bestand));

while($n < $lines){

//Set variables
$titel = $_POST['titel[$n]'];

//Replace 'Enter' for '<br />'
$_POST['beschrijving[$n]'] = preg_replace ("#\r?\n#", '<br />', $_POST['beschrijving[$n]']);
$beschrijving = $_POST['beschrijving[$n]'];

//Write $titel
$handle = fopen($bestand, "a");
fwrite($handle, "".$titel."|");
fclose($handle);

//Write $beschrijving
$handle = fopen($bestand, "a+");
fwrite($handle, "".$beschrijving." ");
fclose($handle);

$n=$n+1;
}
?>


De form scripts works fine, no problems. But the processing script give me the next notices:

Code: [Select]
Notice: Undefined index: titel[$n] in /var/www/NellekeTekent/cms/edit.php on line 10 Notice: Undefined index: beschrijving[$n] in /var/www/NellekeTekent/cms/edit.php on line 13 Notice: Undefined index: titel[$n] in /var/www/NellekeTekent/cms/edit.php on line 10 Notice: Undefined index: titel[$n] in /var/www/NellekeTekent/cms/edit.php on line 10 Notice: Undefined index: titel[$n] in /var/www/NellekeTekent/cms/edit.php on line 10
I gues the problem is '$n' when setting $titel and $beschrijving.
But I don't know how to solve it.
Can you help me?

Hi all,

I have been working on this script for over 5 hours, the script used to work but I have recreated some html code in the html form and I think it may have something to do with why the script does not work but I can not see it.

Hopefully an extra pair of eyes can help.

The I have tested what the $_POST['title'] below echos in the php script and it does carry the value to the php page, but the IF statement does not work.

Here it is:

html form in a php page:
Code: [Select]
<form action="testform.php" method="post">
<fieldset style="border:none">
    <ul class="controls">
             <li>
          <label for="label">Title</label>
          <input name="title" id="title" type="text" class="text" maxlength="" value="grumman aa4"  />
          </li>
             <li>
            <label for="label">Aircraft Registration</label>
    <input name="reg" id="label" type="text" class="text" maxlength="6" value="G-qwea" style="text-transform:uppercase;"  />
    </li>    
             <li>
         <input name="Button" type="submit" class="button centered" />
            </li> </ul>
            </fieldset></form>
The part of the PHP page that does not work is below. If the php below just says if ($_POST['reg'] == "")... it works but as soon as I put || $_POST['title'] it does not work. I have also tried if ($_POST['reg'] && $_POST['title'] == "")... which DOES work?


testform.php

<?php

if ($_POST['reg'] || $_POST['title'] == "") {
$fillinform = "Please fill in all the form to add a listing.";
include("saleform.php");
exit();
}
?>

I'm trying firstly to output hidden fields based on the values of the $_POST variable.

Then after that I want to output the values again in a unordered list.

I'm using the following code:
while (list($key, $val) = each($_POST)) {
if ($key != 'Submit') {
echo '<input type="hidden" name="' . $key . '" value="' . $val . '" />';
}
}

echo '<ul>';
while (list($key, $val) = each($_POST)) {
if ($key != 'Submit') {
echo '<li><strong>' . $key . '</strong>: <span class="highlight-219ddb">' . $val . '</span></li>';
}
}
echo '</ul>';

However the <ul> appears to be blank? Can I only use the list() function once on a particular variable?

Why doesn't this code work...

Code: [Select]
// Initialize variables.
$form_value = '';
$form_value = $_POST['form_value'];


I get this error...

Quote

Notice: Undefined index: form_value


Thanks,


Debbie

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?

I have a webpage where all the database items are displyes in a table format.The table also has a check box.Upon clicking the delete button i need to delete all the items whish has the checkbox checked.
How will i do that

Hi Guys, I am trying to get the while function to list four of my items on a row however I have no idea how and every time I try, I fail. Please give me a hand? Here is the code I have so far

Code: [Select]



if($row['photo'] == "#no_photo")
$photo = ('<img src="images/item_pictures/default_item.png" width="150" height="150" alt="Default Item">');
else
$photo = $row['photo'];


echo "<br /> <br />" ;


echo "<br />
<font face='Comic Sans MS, cursive'>Click on an item to view it in full.</font>
<br />
<br />";


if($row['photo'] == "#no_photo")
$photo = ('<img src="images/item_pictures/default_item.png" width="100" height="100" alt="Default Item">');
else
$photo = $row['photo'];


echo "<br /> <br />" ;


$i = 0;
while ($i < $num) {




$f1 = "<tr><td><font size='6'><a href='item.php?id=" . mysql_result($result,$i,"item_id") . "'>" . mysql_result($result,$i,"item_name") . "</a></font></td><td> "    . $photo . "</td></tr>";




echo "" .  $f1 ."" ;
$i++;




Thanks, Jacbey

Hi all I am having troubles integrating a shopping cart.
$action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] : 'view';
switch ($action) {
    case 'add' :
        addToCart();
        break;
    case 'update' :
        updateCart();
        break;
    case 'delete' :
        deleteFromCart();
        break;
    case 'view' :
}

Allows me to Delete and Update but not Add an item.

[php]$action = (isset($_POST['action']) && $_POST['action'] != '') ? $_POST['action'] : 'view';
Allows me to ADD an item to the cart(add action passed from previous page via form)  but not Delete or UPDATE

Im not sure if I should have attached the pages or just pasted them but heres the code

cart.php

<?php
require_once 'config.php';
require_once 'cart-functions2.php';
require_once 'functions.php';
require_once 'database.php';
$ID = $_POST["ID"];
$pSize = $_POST["size"];
$pcolour = $_POST["colour"];
?>
<?php
$action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] : 'view';
switch ($action) {
    case 'add' :
        addToCart();
        break;
    case 'update' :
        updateCart();
        break;
    case 'delete' :
        deleteFromCart();
        break;
    case 'view' :
}
$ID = $_POST["ID"];
$cartContent = getCartContent();
$numItem = count($cartContent);

$pageTitle = 'Shopping Cart';


// show the error message ( if we have any )
displayError();

if ($numItem > 0 ) {
?>
<form action="<?php echo $_SERVER['PHP_SELF'] . "?action=update"; ?>" method="post" name="frmCart" id="frmCart">
<table width="780" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
  <tr class="entryTableHeader">
   <td colspan="2" align="center">Item</td>
   <td align="center">Unit Price</td>
   <td width="75" align="center">Quantity</td>
   <td align="center">Total</td>
  <td width="75" align="center">&nbsp;</td>
</tr>
<?php
$subTotal = 0;
for ($i = 0; $i < $numItem; $i++) {
    extract($cartContent[$i]);
    $productUrl = "index.php";
    $subTotal += $price * $ct_qty;
?>
<tr class="content">
  <td width="80" align="center"></td>
  <td><?php echo $pDesc; ?></td>
   <td align="right"><?php echo displayAmount($price); ?></td>
  <td width="75"><input name="txtQty[]" type="text" id="txtQty[]" size="5" value="<?php echo $ct_qty; ?>" class="box" onKeyUp="checkNumber(this);">
  <input name="hidCartId[]" type="hidden" value="<?php echo $ct_id; ?>">
  <input name="hidProductId[]" type="hidden" value="<?php echo $ID; ?>">
  </td>
  <td align="right"><?php echo displayAmount($price * $ct_qty); ?></td>
  <td width="75" align="center"> <input name="btnDelete" type="button" id="btnDelete" value="Delete" onClick="window.location.href='<?php echo $_SERVER['PHP_SELF'] . "?action=delete&cid=$ct_id"; ?>';" class="box">
  </td>
</tr>
<?php
}
?>


cart-functions

<?php
require_once 'config.php';

/*********************************************************
*                 SHOPPING CART FUNCTIONS
*********************************************************/

function addToCart()
{
$sid = session_id();
$ID = $_GET["ID"];
$pSize = $_GET["size"];
$pcolour = $_GET["colour"];   
    
    // current session id
    
    
    // check if the product is already
    // in cart table for this session
    $sql = "SELECT ID
            FROM cart
            WHERE ID = '$ID' AND ct_session_id = '$sid'";
    $result = dbQuery($sql);
    
    if (dbNumRows($result) == 0) {
        // put the product in cart table
        $sql = "INSERT INTO cart (ID, ct_qty, ct_session_id, ct_date)
                VALUES ('$ID', 1, '$sid', NOW())";
        $result = dbQuery($sql);
    } else {
        // update product quantity in cart table
        $sql = "UPDATE cart
                SET ct_qty = ct_qty + 1
                WHERE ct_session_id = '$sid' AND ID = '$ID'";        
                
        $result = dbQuery($sql);        
    }    
   
    header('Location: cart2.php'); 
                 
}

/*
    Get all item in current session
    from shopping cart table
*/
function getCartContent()
{
    $cartContent = array();

    $sid = session_id();
    $sql = "SELECT ct.ct_id, ct.ID, ct.ct_size, ct.ct_colour, ct.ct_qty, pd.pDesc, pd.price, pd.ID
            FROM cart ct, products pd
            WHERE ct_session_id = '$sid' AND ct.ID = pd.ID"; 
    
    $result = dbQuery($sql);
   
    while ($row = dbFetchAssoc($result)) {
    
        $cartContent[] = $row;
    }

    return $cartContent;
}

/*
    Remove an item from the cart
*/
function deleteFromCart($cartId = 0)
{
    if (!$cartId && isset($_GET['cid']) && (int)$_GET['cid'] > 0) {
        $cartId = (int)$_GET['cid'];
    }

    if ($cartId) {    
        $sql  = "DELETE FROM cart
                 WHERE ct_id = $cartId";

        $result = dbQuery($sql);
    }
    
    header('Location: cart2.php');    
}

/*
    Update item quantity in shopping cart
*/
function updateCart()
{
    $cartId     = $_POST['hidCartId'];
    $productId  = $_POST['hidProductId'];
    $itemQty    = $_POST['txtQty'];
    $numItem    = count($itemQty);
    $numDeleted = 0;
    $notice     = '';
    
    for ($i = 0; $i < $numItem; $i++) {
        $newQty = (int)$itemQty[$i];
        if ($newQty < 1) {
            // remove this item from shopping cart
            deleteFromCart($cartId[$i]);    
            $numDeleted += 1;
        }
                            
            // update product quantity
            $sql = "UPDATE cart
                    SET ct_qty = $newQty
                    WHERE ct_id = {$cartId[$i]}";
                
            dbQuery($sql);
       
    }

    exit;
}

function isCartEmpty()
{
    $isEmpty = false;
    
    $sid = session_id();
    $sql = "SELECT ct_id
            FROM cart ct
            WHERE ct_session_id = '$sid'";
    
    $result = dbQuery($sql);
    
    if (dbNumRows($result) == 0) {
        $isEmpty = true;
    }    
    
    return $isEmpty;
}

/*
    Delete all cart entries older than one day
*/
function deleteAbandonedCart()
{
    $yesterday = date('Y-m-d H:i:s', mktime(0,0,0, date('m'), date('d') - 1, date('Y')));
    $sql = "DELETE FROM cart
            WHERE ct_date < '$yesterday'";
    dbQuery($sql);        
}

?> 


Thanks in advance

Hi all,

Using a form with check boxes divided into different categories, I collect data selected by the user.

I now want to combine each choice in each category with each choice in the other categories and list the combinations to the user.

If the user chooses one or more options in each category, it is relatively easy to nest foreach loops, since the number of categories will always be the same. For example, if the form contains three categories of options, the code will be:

Code: [Select]
foreach ($form['cat_1'] as $k1 => $val1)
{
foreach ($form['cat_2'] as $k2 => $val2)
{
foreach ($form['cat_3'] as $k3 => $val3)
{
echo  $val1.' _ '.$val2.' _ '.$val3.'<br/>';
}
}
}

Things get complicated if the user does not select options within a given category. More generally, I want to be able to generate the list regardless of the number of categories in which the user selects options.

Thank you in advance for your advice.

hi, I have a function that calculates sales tax and it should put 2 numbers  after the decimal point but it 's putting 5 numbers after the decimal point.  Can someone help me figure out why? 

Code: [Select]
function TotalSalesTax($price)
{
$salesTax = .07;
$TotalSalesTax = $price * $salesTax;
    number_format($TotalSalesTax, 2);
return $TotalSalesTax;
}