Intresting Problem

Anon

In my current project I am using a combination of PHP, MySQL, and JavaScript.

Using PHP I have a search setup to return results in this format:
<name><price><add/subtract buttons><cost input box>

Cost is a textbox. Now, I've setup my PHP to set the name of each textbox to prod$id ($id being the product's id in the mysql db). I've done this because javascript will not recognise just a number for the document.form.inputboxname.value function.

Now the problem lies in reading the results once the submit button is pushed. I need to be able to loop through in PHP like so:
$sql = "SELECT COUNT(*) FROM products";
$res = mysql_query($sql);
$num = mysql_num_rows($res);
for($i;$i >= $num;$i++){
if(isset($prod{$i})){
if($prod{$i} != 0){
$prods .= "$i,";
$quants .= "$prod{$i},";
}
}

Now I know php won't read $prod{$id} as $prod1, $prod2, etc how can I get it to read as that? would something like this work:

if(isset("$prod" . $i)

Mark

badman

hello Mark,
i have worked out a solution for you, i guess this is what you wanted to do.

i am sending the codes in their bare minimum format! Try this code to get the solution and apply to your case accordingly.

// file z.php
<FORM METHOD=POST ACTION="z1.php">
<?for($i=0;$i<5;$i++)
echo "<INPUT TYPE=\"text\" NAME=\"prod$i\">";
?>
<INPUT TYPE="submit">
</FORM>
// will generate 5 text boxes with names prod0..prod5

// file z1.php
// prints values of textboxes from z.php
<?for($i=0;$i<5;$i++)
{
$tmp="prod$i";
echo ${$tmp};
}
?>

Adapt it to your needs. the basic idea here is to reconstruct the name of the text boxes and then prfixing a '$' to get values
cheers!

Anon

Intresting... $tmp will contain the value of prod0 (or 3 or 5 whatever the case)?
and ${$tmp} will contain the actual name prod0?

I was thinking of just doing ${"prod".$i} I have no idea if it works or not though since I can't log into my db (stupid Directoris.com is constantly locking people out cause they think authorised users are hackers... increadibly annoying)

Mark

PS Thanks for your response 🙂

badman

did you try to run the code i sent?
i tried to simulate your problem in bare minimum lines and it works..

but reading your response i feel this is not what you wanted..is there something more to it?
or is your prob solved?

write back

Anon

I've been unable to run it. 🙁 First the lockouts and now its completely down. I'll let you know as soon as I test it fully.

Thanks for your help either way 🙂

Mark

Anon

I finally got a chance to test it. my code doesn't work at all. your code returns the correct variable name I want to use but it doesn't return the value of that variable.

Mark

badman

i have tried it again after getting your response and seems to work ok....

just see if you have put the names of vars and {} properly in the destination file....

shud work fella!

Anon

I had. I tried every combination I could think of and all I could get it to return was "prod(id number)" and "$prod(id number)" so I switched to $HTTP_POST_VARS and it seems to work ok now.

Mark