[Resolved] Getting a dynamic name

dmacman1962

I have a logic/code question.

I am creating a dynamic tables from a MySQL database. They contain a radiobox and a dropdown list (For quantity selection) that are dynamically named.

IE:
The order name is

Ordered.$ID

And the quantity name is

 Quantity.$ID

$path = "images/";
		$connpt = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR); 
		mysql_select_db($database, $connpt);
		$result = mysql_query("SELECT * FROM dealer1");
		echo   "<table>"; 
		  		 echo "   <tr>".  

       "  <td width=\"100\">".'ID'."</td>"."<td width=\"100\">".'Item Name'."</td>"."<td width=\"150\">".'Item Description'."</td>"."<td width=\"150\">".'Body Copy'."</td>"."<td width=\"100\">".'Image'.
       "  </tr>";
			while ($row = mysql_fetch_assoc($result)) { 
			$ID = $row['ID']; 
 		 echo "   <tr>".  

       "  <td width=\"100\">".$row['ID']."</td>"."<td width=\"100\">".$row['ItemName']."</td>"."<td width=\"150\">".$row['ItemDescription']."</td>"."<td width=\"150\">".$row['BodyCopy']."</td>"." <td width=\"100\"><img src =$path".$row['ImageName']." width=\"100\" height=\"125\"></td>"."<td width=\"150\">"."<input name=\"Order.$ID\" type=\"radio\" value=\"Ordered.$ID\">"."</td>"."<td width=\"150\">"."<select name=\"Quantity.$ID\" id=\"Quantity.$ID\"><option value=\"0\">0</option><option value=\"1\">1</option><option value=\"2\">2</option><option value=\"3\">3</option><option value=\"4\">4</option><option value=\"5\">5</option></select>"."</td>".
       "  </tr>";  

}  

echo "</table>";

My predicament is in the sendmail.php page I need to build an array of the items ordered, quantity, etc, and the name I need to get from the

 $Quantity.$ID = $_REQUEST['Quantity.$ID];

is not going to work, at least I dont think so.

I hope this is making sense.

My second question is the code for the dropdown list (Quantity) could get quite long. Would a Function or OOP be a better way to handle this, although I am weak in both areas.

This by far is the toughest questions I have posted to date.

Thanks in advance for any help,

Don

bpat1434

Well, the building of the array can be done while the name is Order[] or: Order[id][].

Not sure about the other question. I would suggest OOP.

~Brett

dmacman1962

I am not sure how to create the while loop for a variable name.

The info being passed from my order page is as follows.

Ordered.1
Ordered.2
Etc.

Heres what I wrote, but it times out after 30 seconds.

$ID = $_REQUEST['ID'];
$ItemOrdered = ($Ordered.".".$ID);
while ($ID != "0") {
    $ItemOrdered = $_REQUEST['ItemOrdered'];
    echo $ItemOrdered;
}

The REQUEST needs to be a variable and I am not sure how to code that. I can do it as a "known" name, but not Item.1 Item.2 etc.

And as far as the OOP or Function for the Value list, I was looking for an opinion on which way would be the smarter way of programming and any thoughts on that.

Thanks a lot,

Don

liquorvicar

try changing

<select name=\"Quantity.$ID\" id=\"Quantity.$ID\">

<select name=\"Quantity[]\" id=\"Quantity.$ID\">

and

<input name=\"Order.$ID\" type=\"radio\" value=\"Ordered.$ID\">

<input name=\"Order[]\" type=\"radio\" value=\"Ordered.$ID\">

you can then have two $REQUEST arrays with your values

$quantity = $_REQUEST['Quantity'];
$ordered = $_REQUEST['Ordered'];

dmacman1962

I tried your suggestion and here is the error I get:

Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in c:\wamp\www\Testing\proforma2.php on line 26

I either made a mistake or there is a problem with the code you supplied.

Here is that line:

       "  <td width=\"100\">".$row['ID']."</td>"."<td width=\"100\">".$row['ItemName']."</td>"."<td width=\"150\">".$row['ItemDescription']."</td>"."<td width=\"150\">".$row['BodyCopy']."</td>"." <td width=\"100\"><img src =$path".$row['ImageName']." width=\"100\" height=\"125\"></td>"."<td width=\"150\">"."<input name="Order[]\" type=\"radio\" value=\"Ordered.$ID\">"."</td>"."<td width=\"150\">"."<select name="Quantity[]\" id=\"Quantity.$ID\"><option value=\"0\">0</option><option value=\"1\">1</option><option value=\"2\">2</option><option value=\"3\">3</option><option value=\"4\">4</option><option value=\"5\">5</option></select>"."</td>"."  </tr>";

The second part of my question is the values for the Quantity. I wondered if a function of OOP would be smarter, though I am a newbie in those areas.

Thanks,

Don

bpat1434

You forgot to escape quotes during your inputs:

"  <td width=\"100\">".
$row['ID']."</td>".
"<td width=\"100\">".
$row['ItemName']."</td>".
"<td width=\"150\">".
$row['ItemDescription']."</td>".
"<td width=\"150\">".
$row['BodyCopy']."</td>".
" <td width=\"100\"><img src =$path".
$row['ImageName']." width=\"100\" height=\"125\"></td>".
"<td width=\"150\">".
"<input name="Order[]\" type=\"radio\" value=\"Ordered.$ID\">"."</td>".
"<td width=\"150\">".
"<select name="Quantity[]\" id=\"Quantity.$ID\">
<option value=\"0\">0</option>
<option value=\"1\">1</option>
<option value=\"2\">2</option>
<option value=\"3\">3</option>
<option value=\"4\">4</option>
<option value=\"5\">5</option></select>".
"</td>"."  </tr>";

To:

"  <td width=\"100\">".
$row['ID']."</td>".
"<td width=\"100\">".
$row['ItemName']."</td>".
"<td width=\"150\">".
$row['ItemDescription']."</td>".
"<td width=\"150\">".
$row['BodyCopy']."</td>".
" <td width=\"100\"><img src =$path".
$row['ImageName']." width=\"100\" height=\"125\"></td>".
"<td width=\"150\">".
"<input name=\"Order[]\" type=\"radio\" value=\"Ordered.$ID\">"."</td>".
"<td width=\"150\">".
"<select name=\"Quantity[]\" id=\"Quantity.$ID\">
<option value=\"0\">0</option>
<option value=\"1\">1</option>
<option value=\"2\">2</option>
<option value=\"3\">3</option>
<option value=\"4\">4</option>
<option value=\"5\">5</option></select>".
"</td>"."  </tr>";

~Brett

dmacman1962

Oops!

That fixed the front end, but my coding on the backend is obviously flawed.

I get a fatal error and the words "ArrayArrayArray" about 100,000 times across my page!

Wow, Here is the backend code.

$ID = $_REQUEST['ID'];
while ($ID != "0") {
    $quantity = $_REQUEST['Quantity']; 
	$ordered = $_REQUEST['Ordered'];
    echo $ordered;
	echo $quantity;
}

echo "Done!";

Thanks again,

Don

bpat1434

Probably should be:

$id = $_REQUEST['ID'];
while($id != 0)
{
    foreach($_REQUEST['Quantity'] as $qty)
    {
        echo $qty;
    }
    foreach($_REQUEST['Ordered'] as $ordrd)
    {
        echo $ordrd;
    }
}

When you set the name of an input to "Something[]" you are implying that it is to be an array. So just grabbing the info will grab two arrays.

You could also do this if you don't want to echo just the list of quantities and ordered:

$id = $_REQUEST['ID'];
$k = 0;
$j = 0;
while($id != 0)
{
    foreach($_REQUEST['Quantity'] as $qty)
    {
        $quantity[$k] == $qty;
        $k++;
    }
    foreach($_REQUEST['Ordered'] as $ordrd)
    {
        $ordered[$j] == $ordrd;
    }

for($x=0; $x<=count($quantity); $x++)
{
    echo "Quantity: ".$quantity[$x]." Ordered: ".$ordered[$x];
}
}

~Brett

dmacman1962

Something really weird is happening.

I used your code and I get zip.

I tried to get other REQUESTs from the form that are not variable and "was" working before, and I still get nothing???

I tried restarting all my services and still nothing.

I dont know whats happening.

I can echo text to the screen.

Anyone have a clue?

Thanks,

Don

liquorvicar

try this :

$id = $_REQUEST['ID'];
$k = 0;
$j = 0;
while($id != 0)
{
   $quantity = $_REQUEST['Quantity']; 
   $ordered = $_REQUEST['Ordered'];
   foreach ($quantity as $key=>$qty) {
      echo "Quantity: ".$qty." Ordered: ".$ordered[$key];
    }
}

Brett - you don't need to recreate the arrays like you did. you can just copy them across.

dmacman1962

Thanks for helping Brett,

I still cannot get it to work, but I am pretty sure its my computer. I used your code and I get nothing. I put in a few echo's to see if PHP is still working, and it is.

But the echo's for the quantity and ordered print nothing?

I went over all my code with a fine tooth comb, and I can see nothing wrong.

Anyone have any ideas?

Thanks,

Don

Also. I do not understand the purpose of the following:

$k = 0; 
$j = 0;

And I noticed since we changed the Ordered from a static name (ie ordered1, ordered2, etc) to a dynamic name:

<input name=\"Order[]\" type=\"radio\" value=\"Ordered.$ID\">"."</td>

that you can only choose one item on he page. Before you could select multiple items and they were passed to the process.php page. This may explain why (somewhat) there is nothing being passed to the process.php page.