PHP - Foreach $_post Help

This topic has been moved to Application Frameworks.

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

I'm not sure if the title explains it very well, but here is an image of it. I am trying to figure out how to access the option selected (equal, not equal, etc.), along with its input box, for each column (the checkboxes on the right) selected. The purpose of this is to allow a non-programming administrator user to create a custom query to access information. I can find out which checkboxes are selected no problem, but finding the accompanying drop-down option and input box is difficult for me. How do I do this?

If you have a suggestion on how to change it, I'm very open. Thank you in advance!



Code: [Select]
if(!isset($_POST['submit']))
{
echo "
<form method='post'>
<table>
 <tr>
  <td valign='top'>SELECT</td>
  <td valign='top'>
   <table>";
 
// LIST ALL COLUMNS IN A TABLE
$result = mysql_query("SELECT * FROM table_name") or die(mysql_error());
$rowcount=mysql_num_rows($result);
$y=mysql_num_fields($result);
for ($x=0; $x<$y; $x++)
{ echo "
    <tr>
<td>
  <input type='checkbox' name='fields[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)."
     </td>
</tr>"; }
 
   echo "
   </table>
  </td>
  <td valign='top'>FROM allocations</td>
  <td valign='top'>WHERE</td>
  <td>
   <table>";
   
// LIST ALL COLUMNS IN A TABLE
$result = mysql_query("SELECT * FROM table_name") or die(mysql_error());
$rowcount=mysql_num_rows($result);
$y=mysql_num_fields($result);
for ($x=0; $x<$y; $x++)
{ echo "
    <tr>
<td>
  <input type='checkbox' name='column[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)."
</td>
<td>
  <select name='operator[]'>
          <option value='='>equals</option>
          <option value='<>'>does not equal</option>
          <option value='>'>greater than</option>
          <option value='<'>less than</option>
          <option value='>='>greater than or equal to</option>
          <option value='<='>less than or equal to</option>
          <option value='LIKE'>is like</option>
         </select>
</td>
     <td><input type='text' name='criteria[]'></td>
</tr>"; }

   echo "
   </table>
  </td>
  <td valign='top'><input type='submit' value='Process Query' name='submit' class='submit'></td>
 </tr>
</table>
</form>";
}
else
{
 echo "<b>Fields to edit:</b> ";
foreach ($_POST['fields'] as $fields) {
echo $fields,", ";
}

 echo "<br><br>";
 echo "<b>Columns to query:</b> ";
foreach ($_POST['column'] as $columns) {
echo $columns," HERE IS THE SPOT, ";
}
}

hey guys
I know this is html but I'm using the php $_POST to grab the information the user chooses, i can't figure out though how to grab the info i'm looking for in this select option form
if they choose PasswordCracker v3.0 what is it i'm looking to set my $_post['']; to?

<FORM action="buy.php" method="POST">
    <select name="passwordcrakers">
      <option value="v2.0">PasswordCracker V2.0</option>
      <option value="v3.0">PasswordCracker V3.0</option>
      <option value="v4.0">PasswordCracker V4.0</option>
      <option value="v5.0">PasswordCracker V5.0</option>
      <option value="v6.0">PasswordCracker V6.0</option>
      <option value="v7.0">PasswordCracker V7.0</option>
      <option value="v8.0">PasswordCracker V8.0</option>
      <option value="v9.0">PasswordCracker V9.0</option>
      <option value="v10">PasswordCracker V10</option>
        </select><br />
<input type="submit" value="Buy" name="submit" />
</FORM>

I use a form to sent date and  use php to display it . However , the code only can working on one page. I can not turn the page. I do not why . Please tell me reason . Thank you very much.

<select name="kind">
  <option >kind</option>
 <option value="Copier Toner">Copier Toner</option>
        <option value="Laser Toner">Laser Toner</option>
      <option value="MICR Toner">MICR Toner</option>
      <option value="Inkjet">Inkjet</option>
    
php code

if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * 18;



$select="select * from $chun where  brand = '$_POST[brand]' or  sort ='$_POST[kind]' or type='$_POST[type]'  LIMIT $start_from, 18";

$result2=mysql_query($select, $connection) or die (mysql_error());

 <?php
   $sql = "select count(*) from $chun  where   brand = '$_POST[brand]' or sort='$_POST[kind]' or type='$_POST[type]' ";

   
$rs_result = mysql_query($sql,$connection);
$row = mysql_fetch_row($rs_result);
$total_records = $row[0];
$total_pages = ceil($total_records / 18);
 
for ($i=1; $i<=$total_pages; $i++) {



?>


      <div class="trunpage"><a href='table2.php?page=<?php echo  "$i" ; ?>&id=<?php echo "$_POST[brand]";?>&cd=<?php echo "$_POST[kind]";?>&td=<?php echo "$_POST[type]";?>'  ><?php echo  "$i" ; ?></a>
      
       </div>
   
The first page is working fine. The second page I get error message.

Undefined index: brand in C:\wamp\www\php1000\table2.php on line 234

Hi guys, running through this tutorial at the moment:

http://www.tizag.com/phpT/forms.php

I seem to keep having problems with the $_POST variable. Is that obsolete syntax now?

Here's the part I get an error on:

<html>
<body>
<?php
$quantity=$_POST['quantity'];
$item=$_POST['item'];

echo "You ordered".$quantity."".$item.".<br/>.";
echo "Thank you for ordering from Boombaby art supppplies!";

?>
</body>
</html>


Here's the error:


( ! ) Notice: Undefined index: quantity in C:\wamp\www\process.php on line 4
Call Stack
#   Time   Memory   Function   Location
1   0.0009   363936   {main}( )   ..\process.php:0

( ! ) Notice: Undefined index: item in C:\wamp\www\process.php on line 5
Call Stack
#   Time   Memory   Function   Location
1   0.0009   363936   {main}( )   ..\process.php:0
You ordered.
.Thank you for ordering from Boombaby art supppplies!



Any help would be appreciated. I tried googling but everything didn't seem to answer my question or was too confusing.

Thanks.

Hi guys,

I have a form using radio buttons.
For the radio button, lets just say i have the id name as 'rim' + number eg; rim0, rim1, rim2....

When i post the data to another file to execute the data collected, naturally i would use the:
Code: [Select]
$rim0=$_POST['rim0'];
$rim1=$_POST['rim1'];
....
$rim10=$_POST['rim10'];
i tried to shorten this process using this method:
Code: [Select]
//$q is part of the post variable.
for($x = 0; $x < count($q); $x++){

$rim[]=$_POST['"rim"."$x"'];
}
But i get this error
Code: [Select]
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Is there something wrong with my POST syntax?

ok am workin on this script its a points market for a text based game but my money is not taking the amount of the players i points on the market ... just say i post 10 points for $29.000.000 ... and when the player  buys the points it takes the money from that user and give the user points but .... when the user buy the points it dont give the user the money it give $290 ?? not sure is its my SQL av post that to


Code: [Select]
<?php
include 'header.php';

$_POST['buypoints'] =  abs(intval($_POST['buypoints']));{


$result = mysql_query("SELECT * FROM `pointsmarket` WHERE `id`='".$_POST['points_id']."'");
    $worked = mysql_fetch_array($result);
    $price = $worked['price'];
    $amount = $worked['amount'];
  $totalcost = $price * prettynum($_POST['amount']);
  $newpointsinmarket = $amount - prettynum($_POST['amount']);
  $user_points = new User($worked['owner']);

if ($worked['owner'] == $user_class->id) {
echo Message("You have taken ".$_POST['amount']." points off the market.");
$newpoints = $user_class->points + $_POST['amount'];;
$result = mysql_query("UPDATE `grpgusers` SET `points` = '".$newpoints."' WHERE `id`='".$user_class->id."'");
$user_class = new User($_SESSION['id']);
if ($newpointsinmarket == 0){
$result = mysql_query("DELETE FROM `pointsmarket` WHERE `id`='".$worked['id']."'");
} else {
$result = mysql_query("UPDATE `pointsmarket` SET `amount` = '".$newpointsinmarket."' WHERE `id`='".$worked['id']."'");
}
include 'footer.php';
die();
}
  $_POST['amount'] =  abs(intval($_POST['amount']));
$_POST['points_id'] = abs(intval($_POST['points_id']));{

}
$_POST['amount'] =  abs(intval($_POST['amount']));
$_POST['points_id'] = abs(intval($_POST['points_id']));{

}
if ($totalcost > prettynum($user_class->money)){
echo Message("You don't have enough money.");
}
if($_POST['amount'] >= 1 && $_POST['amount'] <= $amount && $totalcost <= $user_class->money){
echo Message("You have bought ".$_POST['amount']." points for $".$totalcost);
$newpoints = $user_class->points + $_POST['amount'];
$newmoney = $user_class->money - $totalcost;
$result = mysql_query("UPDATE `grpgusers` SET `money` = '".$newmoney."', `points` = '".$newpoints."' WHERE `id`='".$user_class->id."'");
$newmoney = $user_points->money + $totalcost;
$result = mysql_query("UPDATE `grpgusers` SET `money` = '".$newmoney."' WHERE `id`='".$user_points->id."'");
$user_class = new User($_SESSION['id']);
if ($newpointsinmarket == 0){
$result = mysql_query("DELETE FROM `pointsmarket` WHERE `id`='".$worked['id']."'");
} else {
$result = mysql_query("UPDATE `pointsmarket` SET `amount` = '".$newpointsinmarket."' WHERE `id`='".$worked['id']."'");
}
}
}

$_POST['addpoints'] =  abs(intval($_POST['addpoints']));
$_POST['id'] = abs(intval($_POST['id']));{

}
if($_POST['amount'] < 1){

}
if($_POST['price'] < 1){

}
if ($_POST['amount'] >= 1 && prettynum($_POST['amount']) <= $user_class->points && $_POST['price'] >= 1){
echo Message("You have added ".$_POST['amount']." points to the market a price of $".$_POST['price']." per point.");
$result= mysql_query("INSERT INTO `pointsmarket` (owner, amount, price)"."VALUES ('$user_class->id', '$_POST[amount]', '$_POST[price]')");
$newpoints = $user_class->points - $_POST['amount'];
$result = mysql_query("UPDATE `grpgusers` SET `points` = '".$newpoints."' WHERE `id`='".$user_class->id."'");
$user_class = new User($_SESSION['id']);
}

?>
<link href="style.css" rel="stylesheet" type="text/css" />

<tr><td class="contenthead">Point Market</td></tr>
<tr><td align="center" class="contentcontent">
<p>&nbsp;</p>
<p><strong>You need to be a Respected Warrior to add points to the market</strong><br>
Use this form to add points to the points market.</p>
<p><strong>Bank Account[<? echo prettynum($user_class->bank) ?>]</strong><strong></strong><br />
  <strong><a href="pointmarket.php">[Refresh</a>]</strong></p>
<form method='post'>
  <table align="center">
  <tr>
<td>Amount of points</td><td>&nbsp;&nbsp;<input name='amount' type='text' class="areatest" value='0' size='10' maxlength='20'></td>
</tr>
<tr>
<td>Price per point</td><td>$<input name='price' type='text' class="areatest" value="0" size='10' maxlength='20'></td>
<tr><td align="center" colspan="2"><input name='addpoints' type='submit' class="buttong" value='Add Points'></form></td>
</tr></table>
</td></tr>
<tr><td class="contentcontent">
<?php
$result = mysql_query("SELECT * FROM `pointsmarket` ORDER BY `price` DESC");
while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$user_points = new User($line['owner']);
if ($user_points->id == $user_class->id){
$submittext = "Remove";
} else {
$submittext = "Buy";
}
echo "<form method='post'>";
echo $user_points->formattedname." - ".$line['amount']." points for ".prettynum($line['price'],1)." per point <input type='text' name='amount' size='3' maxlength='20' value='".prettynum($line['amount'])."'><input type='hidden' name='points_id' value='".$line['id']."'><input type='submit' name='buypoints' value='".$submittext."'></form><br>";
}
?>
</td></tr>
<?php
include 'footer.php';
?>



SQL
Code: [Select]
CREATE TABLE IF NOT EXISTS `pointsmarket` (
  `owner` int(10) NOT NULL default '0',
  `amount` text NOT NULL,
  `price` text NOT NULL,
  `id` int(10) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=81 ;

Hello,

My script here is not sending POST vars from form to script. I can't figure it out.

Form:
Code: [Select]
<form action="train2.php" method="POST">
 <tr>
<td colspan="4"><center><img src="pic/toppage16.gif" /></center></td>
       </tr>

<TR> <TD><FONT COLOR="white">Reassign Miners</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size="6" maxlength="8" value="0" name="miner>"</FONT></TD>

</TR>

<TR>

<TD><FONT COLOR="white">Reassign Normal Attackers</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size="6" maxlength="8" value="0" name="atsold"></FONT></TD>

</TR>

 <TR>
 
<TD><FONT COLOR="white">Reassign Normal Defenders</FONT></TD>


<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size=6 maxlength=8 value=0 name="defsold"></FONT></TD>

</TR>

<TR>

 <TD><FONT COLOR="white">Reassign Covert Agents</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size=6 maxlength=8 value=0 name="spy"></FONT></TD>

</TR>

<TR> <TD><FONT COLOR="white">Anti Covert Agents</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD><TD align=middle><FONT COLOR="white"><INPUT size="6" maxlength=8 value=0 name="spykiller"></FONT></TD></TR>

<TR> <TD align=middle colSpan=3><FONT COLOR="white"><INPUT type="submit" value="UnTrain!" name="untrain">
</FONT>

</TD>

</form>

Code: [Select]
<?php
if(isset($_POST['untrain'])){

die($_POST['miner']);
$miners = securevar($_POST['miner']);
$nattackers = securevar($_POST['atsold']);
$ndefenders = securevar($_POST['defsold']);
$covertunits = securevar($_POST['spy']);
$anticovertunits = securevar($_POST['spykiller']);

$totalunits+=$miners;
$totalunits+=$nattackers;
$totalunits+=$ndefenders;
$totalunits+=$covertunits;
$totalunits+=$anticovertunits;

if($totalunits>=1){
$q = "UPDATE `accountinfo_db` SET `miners_1` = `miners_1`-'$miner', `attackers_1` = `attackers_1`-'$natta', `defenders_1` = `defenders_1`-'$ndefe', `covertagents` = `covertagents`-'$cover', `anticovertagents` = `anticovertagents`+'$antic', `untrainedunits` = `untrainedunits`+'$totalunits' WHERE `id` = '$id'"; 
$res = mysql_query($q) or die(mysql_error());

if(isset($res)){
header("Location: train.php?strmsg=".$totalunits."Troops Untrained! For 0 Naquadah.");
}

}else{
header("Location: train.php?strmsg=You must enter atleast 1 troop to be un-trained!");
}

}


?>

when I die($_GET['miner'); nothing is outputed even tho I submited the data.

Thank you,
Brian

Hi guys! I need your help..
I'm having a problem in getting the post values from my form,
I have 2 arrays and some values:
Code: [Select]
$total = 3;
$array1 = (branch1, branch2, branch3);
$array2 = (100, 200, 300);
$count = count($array1) - $total;
then i combine them
Code: [Select]
$array3 = combine_array($array1, $array2);
if $count is 0, using a foreach loop i echo each value and key
Code: [Select]
foreach($combined_array as $value => $key)
{
echo "<tr>";

echo "<td><input type='hidden' name='branch' value='{$value}'></td>";
        echo "<td id='edit'>" . "<input type='submit' name='edit' value='' />" . "</td>";
echo "<td id='sep'> / </td>";
echo "<td><input type='hidden' name='id' value='{$key}'></td>";
echo "<td id='del'>" . "<input type='submit' name='delete' value='' />" . "</td>";
very simple and it works perfectly fine,
but  if the variable $count is not equal to 0, i append both arrays(1 & 2) so that it will be equal to 0. (data appended is not important i just need them for the table output.)
Code: [Select]
for($i = 0; $i < $count; $i++)
{
     $array1[] = "null" . $i;
     $array2[] = $i;
}
// then combine
    $array3 = combine_array($array1, $array2);

// echo each value and key
foreach($combined_array as $value => $key)
{
echo "<tr>";

echo "<td><input type='hidden' name='branch' value='{$value}'></td>";
        echo "<td id='edit'>" . "<input type='submit' name='edit' value='' />" . "</td>";
echo "<td id='sep'> / </td>";
echo "<td><input type='hidden' name='id' value='{$key}'></td>";
echo "<td id='del'>" . "<input type='submit' name='delete' value='' />" . "</td>";
       echo "</tr>";
i tried to view the code souce and both hidden fields contain correct data but if i tried to delete/edit it doesn't work.
i tried echoing/print_r the $_POST['branch'] & $_POST['id'] after i click on delete/edit and it always gives me the last $value and $key of the combined array for all the submit buttons..

Any thoughts?
As i said the appended data is not important but the problem is once i click delete  the original values in array1 and 2 are not what post is giving me..therefore i cannot delete or edit them..
Sorry if my post is too long..
Thanks in advance!

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>

I have a button that uses $_POST to send information to another page.  The data is in a hidden input so it's not possible for users to change information.  I have nothing to check if the data is correct on the other page.  Is it still possible for people to change the $_POST data though?  Or somehow send false $_POST data to the other page?

hi good day, im a little bit confuse. what i want to do is instead of $username = $_POST['username']; is to transform it into OOP?

please help me. thanks.

Hi guys i am a PHP newbie trying to learn from the beginning. I am reading a php book and i can't get past a particular example because $_GET and $_POST just won't work. Below is the code i am working with:

HTML File
<form action="welcome1.php" method="get">
    <div>
     <label for="firstname">First name: <input type="text" name"firstname"
      id="firstname"/></label>
    </div>
    <div>
        <label for="lastname">
            Last name: <input type="text" name="lastname" id="lastname"/>
        </label>
    </div>
    <div>
        <input type="submit" value="GO" />
    </div>

PHP file

<?php
 $firstname = $_GET['firstname'];
 $lastname = $_GET['lastname'];
 print 'Welcome to our website, ' .
    htmlspecialchars($firstname, ENT_QUOTES, 'UTF-8') . ' ' .
    htmlspecialchars($lastname, ENT_QUOTES, 'UTF-8') . '!';
?>

I am working on a windows pc with Vista home edition installed. I run a localhost server installed via XAMMP. Please this has been a recurring problem for me. Each time i get to this stage in the past i always get stuck. $_GET and $_POST just does not work for me. Please heeeelp!

I think this belongs here, but my $_POST['gender'] won't grab the gender that was submitted through a form.

I am using AJAX so the page doesn't have to reload so it can go in a smooth transition, but the AJAX is grabbing the value perfectly fine.
I have a feeling the $_POST isn't grabbing the value because the page isn't reloading.. but I don't want to reload it.
These codes are all on the same page.

Here is my Javascript:
Code: [Select]
<script>
function chooseGender()
{
var gender = $('input[name=gender]:checked', '#submitgender').val();
if(gender)
{
$.ajax(
{
type: "POST",
url: window.location.pathname,
data: gender,
success: function()
{
alert("You have chosen to be a " + gender); //It's grabbing it perfectly fine!
$("#submitgender").hide(); //It hides the gender table so they can't choose a gender since they already have chosen one.
$("#rest").fadeIn(); //Shows the other table that's labeled "rest" as it's ID so they can choose what base, eyes, etc for that specific gender they've chosen.
}
});
}
else
{
alert('Select a gender.');
}
}

$(function tabs()
{
$( "#tabs" ).tabs();
});
</script>
But here is the PHP inside the #rest table:
Code: [Select]
<?php
$gender = $_POST['gender'];

$sql = "SELECT * FROM habases WHERE gender='".$gender."'";
$result = mysqli_query($cxn, $sql) or die(mysqli_error($cxn));
print_r($sql);
while ($row = mysqli_fetch_assoc($result))
{
$baseimage = $row['image'];
$baseskin = $row['skin'];

echo "<img src=\"http://www.elvonica.com/".$baseimage."\" value=\"".$baseskin."\">";
}
?>
And this is what I'm getting for the print_r:
Quote

SELECT * FROM habases WHERE gender=''