PHP - For Each Loop And $_post Variables

How do I post a for loop array in the next page. I am printing Question ID and choices for these and would like the for loop to print Question ID and choice that are checked for these. If the choice is ticked then it shoul return a 1 if the choice is empty then it should print 0. and I would like to insert this to a new table.  How would I do this.

Code: [Select]
$intNum = 1;
$intnumber = 1;
 while( $info = mysql_fetch_array( $sqll )){
 

 echo "<input type='hidden' name=\"Que_ID\" value=\"{$info['Que_ID']}\" /> ";
  echo " $intNum, {$info['Que_Question']} <br />\n";
   $intNum++;
 ?>
 <br>
<?PHP
 for ($i =1; $i < 5; $i++) { 
 
 echo "<input type=\"checkbox\" name=\"choice[{$intnumber}]\" />{$info['Que_Choice'.$i]}"; 
  $intnumber++;
 
 }

this is my form that print the question and it works fine.

Code: [Select]
<?PHP
foreach ($_POST["Que_ID"] as $question) {
$_POST["choice"] = $choice;
echo "Question id: ".$question. $choice"<br />"; This is the post code but I know I need to do so much more but not sure how? Ayone help me or direct me to a source or tutorial or something.

I am trying to post while loop array. But I dont know how to do this and I used foreach and it works for each array but doesnt loop this. My table has Que_ID, Question, choice1, choice2, choice3 and choice 4. I would like to do something like.. For each Que_id (choice1, choice2, choice3 , choice4), this should be looped for each que_id

so far I have

Code: [Select]
$counter = 1;
 while( $info = mysql_fetch_array( $sqll ))
 //))
 {
 echo "{$info['Que_ID']} <br />\n";
echo "<input type='hidden' name=\"Que_ID\" value=\"{$info['Que_ID']}\" /> ";
echo "{$info['Que_Question']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice1']}\" /> ";
echo "{$info['Que_Choice1']} <br />\n";
$counter++;
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice2']}\" /> ";
echo "{$info['Que_Choice2']} <br />\n";
$counter++;
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice3']}\" /> ";
echo "{$info['Que_Choice3']} <br />\n";
$counter++;
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice4']}\" /> ";
echo "{$info['Que_Choice4']} <br />\n";

$counter++;
How would go on to posting these while loop and display Que_ID and all the choices that are ticked for this que_ID and if its not ticked then its 0.

I have a php search page that takes form data to create its queries, then reload the original search page. The form is long, so there are numerous $_POST's to convert to variables for use in the query. I've looked at "extract" and a few other code snippets. But it's a form and I don't want any security issues. I'm hoping there's a "foreach" solution, but I'm a beginner. What's a proper way to to simplify this:

$s1 = $_POST["s1"];
$s2 = $_POST["s2"];
$s3 = $_POST["s3"];
$s4 = $_POST["s4"];
$s5 = $_POST["s5"];
$s6 = $_POST["s6"];
$s7 = $_POST["s7"];
$s8 = $_POST["s8"];
$s9 = $_POST["s9"];
$s10 = $_POST["s10"];
$s11 = $_POST["s11"];
$s12 = $_POST["s12"];

Hello Guys,

I have a question. 

I have the following code to grab all of my $_POST vars and run through my filter function

Code: [Select]
foreach($_POST as $key => $value) {
    $mydata[$key] = filter($value);
     }

Before using the foreach loop I was just doing the basic

$var1 = $_POST['var1'];
$var2 = $_POST['var2'];

I'm going to have about 40 - 50 $_POST vars so my question is how do i return it as just a $var name instead of having to do this

 echo "<br><br><br>example1" . $mydata['var1'];
 echo "<br><br><br>example2" . $mydata['var2'];

I guess its hard for me to explain..

Thanks for your help!

hope to input the below data via $_POST into a while loop to preg_split by comma and then recursively create xml element tag with the various firstName lastName's and even separate further aliasFirstName aliasLastName's into an attribute field

NAMES: firstName lastName [aliasFirstName aliasLastName], firstName lastName [aliasFirstName aliasLastName], firstName lastName [aliasFirstName aliasLastName], firstName lastName [aliasFirstName aliasLastName]



$xml .= '

<element1 attribute="' . $_POST('AGE') . '">';

while ($row = ' . $_POST('NAMES') . ')
{
$row = preg_split('/[\s]*[,][\s]*/',' . $_POST["Actors"] . ',PREG_SPLIT_OFFSET_CAPTURE);


$xml .= '
<element2>
  <NAME names="' . $_POST('NAMES') . '" alias="' . $_POST('NAMES') . '"></NAME>

$xml .= '';

I need to create a loop where I can cycle through three variables and determine the maximum output.  Here is an example...

First loop
$var_one = .01
$var_two = .01
$var_three = .98

run calculation for vars

Second Loop
$var_one = .02
$var_two = .01
$var_three = .97

run calculation for vars

This loop would run through ALL possible values making sure that the total of all variables would always equal 1.  There could be more than three variables so this will be dynamic.  I have no idea how to make this. Any thoughts?

Hi

Already looked around, and although I've found some solution I simply don't understand them (not skilled at all).

I'm getting 10 random results using this, which works fine and list 10 random results.

$sql = "SELECT name FROM db ORDER BY RAND() LIMIT 10;";
$result = mysqli_query($con,$sql);
 while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC))
  { 
echo $row['name']."<br>";
  }

How can I make 10 new variables for each result?

I guess I'll rephrase since my wording wasn't very clear. Why don't

echo "<p>\n";
if (!empty($locations) && is_array($locations)) {
  foreach ($locations as $field => $val) {
  if ($field == "City") {
     echo $field  . ' : ' . $val . "<br />\n";
        $val = $cityvar;
}
  if ($field == "ZipPostalCode") {
     echo $field . ' : ' . $val . "<br />\n";
        $val = $zipvar;
}
  if ($field == "CountryName") {
     echo $field . ' : ' . $val . "<br />\n";
        $val = $countryvar;
}
  }
}
echo "</p>\n";

Hello All,

Attached are 2 screenshots of the form and output for better reference.

What I am trying to do is select all or some checkboxes and for those boxes that are checked, echo out their Payment Method.

---If a checkbox is checked but the Payment Method box == select, give an error.

---If checkbox is checked and Payment Method != select, echo out the ID and selection from the drop down box.

Currently, I am echoing the correct ID(s) when certain boxes are checked, but I'm getting every drop down box selection when the corresponding box is not selected.

Any help would be greatly appreciated.

This is the HTML / PHP Form:

$results .= '<table align="center" width="70%" border="0" bgcolor="'.$bg.'" cellpadding="2" cellspacing="0" class="resultsUnderline">';
$results .= '<tr>';
$results .= '<td width="30%" align="left">'.'<input type="checkbox" name="checkbox[]" value="'.$app_pmt_id.'" id="checkbox" />'
.$full.'<FONT size="1" color="maroon"> ( '.$app_id.' )</FONT></td>';
$results .= '<td width="30%" align="center">'.$created.'</td>';
$results .= '<td width="20%" align="center">
<select name="pay_method[]" class="drop" id="pay_method">
<option value="select">-- Method --</option>
<option value="check">Check</option>
<option value="credit">Credit Card</option></td>';
$results .= '<td width="10%" align="center">'.$paid.'</td>';
$results .= '<td width="10%" align="right">'.$fee.'</td>';
$results .= '</tr>';
$results .= '</table>';

Here is the PHP getting the results:
if(isset($_POST['action_box']) && $_POST['action_box'] == 'mark_paid')
{
    $checked = array();
    $checked2 = array();
    
    if(!isset($_POST['checkbox']))
    {
        $val_error[] = 'You have not selected any applications.';
    }
        elseif($_POST['pay_method'] == 'select')
        {
            $val_error[] = 'Please select a Payment Method.';
        }
    else
    {
        foreach($_POST['checkbox'] as $value)
        {
            $checked[] = $value;
        }
        foreach($_POST['pay_method'] as $value2)
        {
            $checked2[] = $value2;
        }
            
        echo implode(",", $checked);
        echo implode(",", $checked2);

        //$result = mysql_query("UPDATE app_pmt SET paid = '1' WHERE app_pmt_id IN(" . implode(",", $checked) . ")");
        //header('Location: bal_due.php?id='.$_GET['id']);
    }
}

I'm looking for a more efficient way of declaring variables within a class. What I normally use is a class which is actually a database object. Every time I make a new table in my database I make a new class and new attributes to match the fields in the db table. Looks something like this:

    Code: [Select]
protected static $table_name="myTable";
protected static $db_fields=array('id', 'name', 'address', 'tel_number', 'fax_number');

public $name;
public $address;
public $tel_number;
public $fax_number;

//etc. etc.
At the moment I am manually adding the attribute, everytime I add a field to the db table. I'm guessing there should be a way to loop through the $db_fields array and add an attribute in the loop? Can anyone help me with the syntax for this. Is there also a way that I don't have to list the fields everytime in $db_fields....can $db_fields not just look at the relevant db table and pull out the field names in some kind of clever method?

Hello,

If I have this string:

$tags="baseball glove face" (this can vary from 1 to 15 different words)

how would i loop through and divide these into different

$tag1=baseball
$tag2=glove
$tag3=face
.. and so on (if more words)

Thanks for help

This is really blowing my mind... the code is as follows the table, the column names everything is right and contains information but the variables aren't being filled... I don't get it... Anyone have any ideas or options I might not have thought of for debugging?


                        $item_name = ("SELECT * FROM items WHERE id = '$grab_item'");
$que_items = mysql_query($item_name);
while ($item_todel = mysql_fetch_array($que_items, MYSQL_BOTH)) {
$name = $item_todel['name'];
$desc = $item_todel['desc'];
}
echo ($name . "<br>" . $desc . "<br>" . $grab_item);


the only variable thats set is grab_item, fetch_array throws no errors, if I plug in the query straight to the sql I get all the proper information... It's just not filling the two variables....

I have this simple while loop which retrieves data from a mysql query and displays several links on my homepage.

I would like to avoid using the php get function and add query strings to my urls

I am thinking of using session variables but I need help and I'm pretty sure this can't be done.

When a visitor clicks a link from the several ones displayed by the while loop, that particular variable would be set in a session.

In my code, the session will always send the last var

Can this be done?

    Code: [Select]
<? session_start(); // Start Session Variables

    $result = mysql_query("my query");

    while($slice = mysql_fetch_assoc($result)){
        $url = $slice['url'];
        $name  = $slice['name']; ?>

        <a href="<? echo $url; ?>"><? echo $name; ?></a>

    <? }

    $_SESSION['name'] = $name; // Store session data  ?>

First page adds a new job number, then the order page loaded with the job number id as a get id. Basically there is a while loop in the order page which shows products/services client can order and he chooses what he requires 'one or eight services' (8 in total) and some other variables like date of order and client name etc. Here is the order item code

The first sql statement executes fine, but in the second sql query nothing happens


$sql="insert into job_order(order_num,order_date,order_customer_id, order_remarks) values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');"; $res=mysql_query($sql);  $id=mysql_insert_id();   foreach($_POST as $key => $value) {          if(!empty($value)) {           $key.' => '.trim(strip_tags($value));            $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES ('$_GET[id]','$value','$value','$value');"; $orderres=mysql_query($order) or die(mysql_error()); } }?>$sql="insert into job_order(order_num,order_date,order_customer_id,
order_remarks)
values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');";
$res=mysql_query($sql);

$id=mysql_insert_id();


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


        if(!empty($value)) { 
 
         $key.' => '.trim(strip_tags($value));  
     
         $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES
('$_GET[id]','$value','$value','$value');";
$orderres=mysql_query($order) or die(mysql_error());
}
}
?>



=============

This is the formI have removed parts which are irrelevant. Please note that dateBox and companyBox are not required to be looping as they are only for first table,



echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";?><table><tr><td><h4>JOB ORDER</H4></TD><TD></TD></TR><TR><TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td></tr><tr><td>ORDER DATE</td><td><input type=text name=dateBox></td></tr> <tr><td>COMPANY NAME</td><td><?PHP$sql="select * from customers";$res=mysql_query($sql);echo "<select name=companyBox><option value=''>Please select</option>";WHILE($fetch=mysql_fetch_assoc($res)){ echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";} echo "</select>"; echo "</td></tr>"; ?>   </table> <table><tr><th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th></tr><tr><?PHP$sql="select * from products";$res=mysql_query($sql); WHILE($fetch=mysql_fetch_assoc($res)){ echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td><td><input type=text name=quantBox></td><td><input type=text name=teethBox></td>";echo "</tr>";}echo "</table>";?>echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";
?>
<table>
<tr>
<td><h4>JOB ORDER</H4></TD><TD></TD>
</TR>
<TR>
<TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td>
</tr>
<tr>
<td>ORDER DATE</td><td><input type=text name=dateBox></td>
</tr>

<tr>
<td>COMPANY NAME</td><td>
<?PHP
$sql="select * from customers";
$res=mysql_query($sql);
echo "<select name=companyBox><option value=''>Please select</option>";
WHILE($fetch=mysql_fetch_assoc($res)){

echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";}
echo "</select>";
echo "</td></tr>";
?>



</table>

<table>
<tr>
<th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th>
</tr>
<tr>
<?PHP
$sql="select * from products";
$res=mysql_query($sql);

WHILE($fetch=mysql_fetch_assoc($res)){

echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td>
<td><input type=text name=quantBox></td>
<td><input type=text name=teethBox></td>";
echo "</tr>";}
echo "</table>";
?>



HERE IS THE IMAGE showing the populated services.
http://dubads.com/images/order.jpg

Hey.   So the issue I'm having is consecutive loops on semi-large arrays, over and over. Consider this array:

$firstArray = array(
'row1' => array(
'dates' => array(
'2014-01-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
),
'row2' => array(
'dates' => array(
'2014-02-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-08' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-09' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
)
);

Originally the data comes from ~2-3 database tables, of course. But to ilustrate the point, this is how the main array looks like. This array usually contains anywhere between 10-50 rows, each row containing at least 10 dates, with 10 key/values each.   And after setting up all the data, it needs to be processed. Currently this is how a friend of mine did it..

$placeDataHere = array();
foreach($firstArray as $key => $dates) {
foreach($dates as $date => $values) {
foreach($values as $key => $value) {
$placeDataHere['DV_' . $date]['SM_' . $key] = 'KS_' . $value;
//Followed by another ~50-70 lines of processing the 3 loop's data..
...
...
....
....
....
....
....
....
}
}
}

Obviously this isn't good practise, but we can't seem to figure out a better way of doing it, since both the data and the loops are horribly nested.   This loop and setup of $firstArray is run anywhere between 10-20 times/request, due to amount of users we wish to process. So, the result is that this code can take up to over 2-3 minutes to complete, which isn't really optimal performance.   In short my question is, are there any better methods of handling this with the data setup we currently have?