RE: [PHP-WIN] assigning variable names on the fly, backed myself in to a corner

---------------------------------------------------------------------------- ----------------- Disclaimer: The information contained in this email is intended only for the use of the person(s) to whom it is addressed and may be confidential or contain legally privileged information. If you are not the intended recipient you are hereby notified that any perusal, use, distribution, copying or disclosure is strictly prohibited. If you have received this email in error please immediately advise us by return email at postmaster@normandy.com.au and delete the email document without making a copy. ---------------------------------------------------------------------------- ----------------- I've personally found that whenever you use "variable-variables" you a probably better off using an array. if you have $tag_num[1] = 12345; $tag_type[1] = "My Type of tag"; $tag_cost[1] = 1.23; $tag_num[2] = 98654; $tag_type[2] = "Not my Type of tag"; $tag_cost[2] = 1.66; $tag_num[3] = 109876; $tag_type[3] = "Unknown tag"; $tag_cost[3] = 1.77; reset($tag_num); while(list($key,$value) = each($tag_num)){ $tag_cost[$key] = round($tag_cost[$key],2); echo "The KEY is $key and the VALUE is $value<br>\n"; // Now do your SQL stuff } This is a bit messy because if you dont have a $tag_num it'll ignore tag_type and $tag_cost. I prefere to use 2D arrays, im assuming the $tag_num is some sort of unique identifier.. <? $tag["12345"]["type"] = "My type of Tag"; $tag["12345"]["cost"] = "1.23"; $tag["98654"]["type"] = "Not my type of Tag"; $tag["98654"]["cost"] = "1.66"; $tag["109876"]["type"] = "Unknown Tag"; $tag["109876"]["cost"] = "1.77"; while(list($key,$data) = each($tag)){ $data["cost"] = round($data["cost"],2); //$tag[$key]["cost"] = round($data["cost"],2); // This will modify the original array, but not $data["cost"] echo "The tag is $key, the type is {$data['type']} and the cost is {$data['cost']}<br>\n"; //echo "The tag is $key, the type is $data[type] and the cost is $data[cost]<br>\n"; // This will work but im not sure how correct it is. // Do your SQL thang } ?> These are very useful as you can unset($tag["109876"]) to get rid of data and since you arent using a sequential for() loop you dont have to worry about missing data. This one comes down to taste though. I like the 2d arrays because they are similiar to data sets from your db or a spreadsheet. mn Mark Nold markn@enspace.com <mailto:markn@enspace.com> Senior Consultant   Change is inevitable, except from vending machines. -----Original Message----- From: Asendorf, John [mailto:JAsendorf@lcounty.com] Sent: Wednesday, February 14, 2001 9:49 PM To: Ignatius Teo; Asendorf, John; 'Darvin Andrioli'; 'Php-Windows (E-mail)' Subject: RE: [PHP-WIN] assigning variable names on the fly, backed myself in to a corner Well, here's what I came up with that finally worked for me: for ( $i=1 ; $i <= $tag_count ; $i++ ) { //tag_count came from the post page $tag_num = "tag_num$i"; $tag_type = "tag_type$i"; $tag_cost = "tag_cost$i"; if ( $$tag_cost == "" ) { // can't have empty data per database parameters $$tag_cost = "0.00"; } $tag_late = "tag_late$i"; if ( $$tag_late == "" ) { // can't have empty data per database parameters $$tag_late = "0.00"; } $sql = "INSERT into cfull2.tbl_dl_tags (TAGID_NUM, CUSTID_NUM, TAG_NO, TAG_YEAR, TYPE_CODE, COST, LATE) VALUES( $TAGID_NUM, $CUSTID_NUM, ${$tag_num}, $this_year, '${$tag_type}' , ${$tag_cost}, ${$tag_late} )"; echo $sql; //debug SQL $stmt = OCIParse ( $connection , $sql ); OCIExecute ( $stmt , OCI_DEFAULT ); OCICommit( $connection ); OCIFreeStatement ( $stmt ); $TAGID_NUM++; } John --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 Ipsa scientia potestas est > -----Original Message----- > From: Ignatius Teo [mailto:iteo@scu.edu.au] > Sent: Tuesday, February 13, 2001 5:32 PM > To: 'Asendorf, John'; 'Darvin Andrioli'; 'Ignatius Teo'; > 'Php-Windows > (E-mail)' > Subject: RE: [PHP-WIN] assigning variable names on the fly, backed > myself in to a corner > > > No probs John. I'll take that in non-sequential small US > denominations, thanks! :-) And of course Darvin can have half. > > Ignatius > > > -----Original Message----- > > From: Asendorf, John [mailto:JAsendorf@lcounty.com] > > Sent: Wednesday, 14 February 2001 00:33 > > To: Darvin Andrioli; 'Ignatius Teo'; Asendorf, John; 'Php-Windows > > (E-mail)' > > Subject: RE: [PHP-WIN] assigning variable names on the fly, backed > > myself in to a corner > > > > > > That's the ticket. Thanks a million! > > > > --------------------- > > John Asendorf - jasendorf@lcounty.com > > Web Applications Developer > > http://www.lcounty.com - NEW FEATURES ADDED DAILY! > > Licking County, Ohio, USA > > 740-349-3631 > > Ipsa scientia potestas est > > > > > > > -----Original Message----- > > > From: Darvin Andrioli [mailto:darvin.andrioli@caricese.it] > > > Sent: Tuesday, February 13, 2001 6:52 AM > > > To: 'Ignatius Teo'; 'Asendorf, John'; 'Php-Windows > > > (E-mail)' > > > Subject: RE: [PHP-WIN] assigning variable names on the fly, backed > > > myself in to a corner > > > > > > > > > Ignatius wrote: > > > > > > > try assigning it to another variable first: > > > > for .... > > > > $tag = "$tag_num$i"; > > > > $type = "tag_type$i"; > > > > $sql = .... VALUES (..., $tag, $type....); > > > > > > The last statement must be: > > > $sql = .... VALUES (..., $$tag, $$type....); > > > > > > so you get the value of the variable named tag_type$i, > > > otherwise yo get only the string "tag_type value of $i" > > > > > > Darvin > > > > > > > > > > -----Original Message----- > > > > From: Asendorf, John [mailto:JAsendorf@lcounty.com] > > > > Sent: Tuesday, 13 February 2001 07:58 > > > > To: Php-Windows (E-mail) > > > > Subject: [PHP-WIN] assigning variable names on the fly, > > > > backed myself in > > > > to a corner > > > > > > > > > > > > I've written a little script that makes a form using a simple > > > > for loop: > > > > > > > > if ( $num_reg != "" ) { //we're doing regulars > > > > > > > > for ( $i = 1 ; $i <= $num_reg ; $i++ ) { > > > > echo "<tr><td>A<input type=\"hidden\" > > > > name=\"tag_type${i}\" > > > > value=\"A\"></td>"; > > > > echo "<td><input type=\"text\" > > > > name=\"tag_num${i}\"></td>"; > > > > echo "<td><input type=\"text\" > name=\"tag_cost${i}\" > > > > value=\"\"></td>"; > > > > echo "<td><input type=\"text\" > > > > name=\"tag_late${i}\"></td></tr>\n"; > > > > } > > > > > > > > $tag_count = $num_reg; > > > > > > > > } > > > > > > > > Now what I have is a number of variables that look > > > something like this > > > > > > > > $tag_type1, $tag_num1, $tag_cost1, $tag_late1, $tag_type2, > > > $tag_num2, > > > > $tag_cost2, $tag_late2, etcetera... up to any number of tags... > > > > > > > > now I'm trying to write a little for loop that drops this > > > > information into a > > > > database after the POST: > > > > > > > > for ( $i=1 ; $i <= $tag_count ; $i++ ) { //tag_count came > > > > from the post > > > > (dl_post_3.php) > > > > > > > > $sql = "INSERT into cfull2.tbl_dl_tags (TAGID_NUM, > > > > CUSTID_NUM, TAG_NO, > > > > TAG_YEAR, TYPE_CODE, COST, TYPE) VALUES ($CUSTID_NUM, > > > > $tag_num$i, $tag_year, > > > > '$tag_type$i' , $tag_cost$i )"; > > > > > > > > $stmt = OCIParse ( $connection , $sql ); > > > > > > > > OCIExecute ( $stmt , OCI_DEFAULT ); > > > > OCICommit( $connection ); > > > > OCIFreeStatement ( $stmt ); > > > > } > > > > > > > > > > > > This obviously doesn't work and I'm not really sure what to > > > > do now. Is this > > > > a case of variable variable names? I don't quite get those > > > either :) > > > > > > > > Thanks in advance all, > > > > > > > > John > > > > > > > > > > > > --------------------- > > > > John Asendorf - jasendorf@lcounty.com > > > > Web Applications Developer > > > > http://www.lcounty.com - NEW FEATURES ADDED > > > > DAILY! > > > > Licking County, Ohio, USA > > > > 740-349-3631 > > > > Ipsa scientia potestas est > > > > > > > > > > > > -- > > > > PHP Windows Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > > > For additional commands, e-mail: php-windows-help@lists.php.net > > > > To contact the list administrators, e-mail: > > > > php-list-admin@lists.php.net > > > > > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > >