"Insert into" problem

Codewalkers Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

August 10th, 2002, 03:00 PM

merrick

Join Date: Apr 2007

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

"Insert into" problem

Hello, I'm a newbie hoping that anyone reading this may be willing to
help me with my problem. I'm making a database where my dad can store
his records.
I'm using a form with several sets of radio buttons, one for each
record.
To achieve this I've named each array with a counter, so the first
button set is $kat0[0], set 2 is $kat1[0] and so on.
I'm using the following code with a for loop to insert:

for ($counter=0; $counter< $countrecs; $counter++) {

INSERT INTO recs (id, kat) VALUES (NULL, '$kat$counter[0]')
}

But php refuses to read '$kat$counter[0]' as '$kat0[0]', as I want it
to, instead it looks for $kat, then $counter[0] so I end up with 0[0]
inserted into the database instead of the *real* variable from the
form. I have tried using concatenation, still doesn't work because
then php sees '$kat0[0]' as a STRING and simply inserts "$kat0[0]"
into the database.
How should I solve this? Any help would be very appreciated. Thank you
for reading.

August 10th, 2002, 06:18 PM

cjrobs

Join Date: Apr 2007

Location: Southampton, England

Posts: 121

Time spent in forums: < 1 sec
Reputation Power: 2

RE:

you could try

php Code:

Original - php Code
for ($counter=0; $counter< $countrecs; $counter++) { eval('$katcounter = '.$kat . $counter.';'); mysql_query("INSERT INTO recs (id, kat) VALUES (NULL, '$katcounter[0]');"); }

 
for ($counter=0; $counter< $countrecs; $counter++) {
 
eval('$katcounter = '.$kat . $counter.';');
 
mysql_query("INSERT INTO recs (id, kat) VALUES (NULL, '$katcounter[0]');");
}

August 11th, 2002, 10:32 AM

merrick

Join Date: Apr 2007

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

RE:

Thanks I'll try that!

August 11th, 2002, 02:03 PM

Taoism

Contributing User

Join Date: Apr 2007

Location: Winnipeg, MB, Canada

Posts: 81

Time spent in forums: 30 sec
Reputation Power: 2

RE:

The string variable idea was very close to working

if you have a string, '$kat0[0]' and want php to interpret it as a variable, you need to reference it via a holding variable with two dollar signs... like so:

php Code:

Original - php Code
<?php for($counter=0;$counter<$countrecs;$counter++){ //create a string representation of the var $varname='$kat'.$counter.'[0]'; //now make php use the string as a variable name reference echo $$varname; } ?>

 
<?php
for($counter=0;$counter<$countrecs;$counter++){
  //create a string representation of the var
  $varname='$kat'.$counter.'[0]';
  //now make php use the string as a variable name reference
  echo $$varname;
}
?>

Cheers,
Keith.

Viewing: Codewalkers Forums > PHP Related > PHP Coding > "Insert into" problem

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump