converting a string to a var..

CoryMathews · 11-08-2007, 03:19 PM

another question again.
i got an array of strings (which are my database table names) and i want to check them each to see if they are set from the form submitted. so my array looks like

$tables = array('table1', 'table2' ... 'table50')
now i want to access them something like this.

with my for loop

for (loop through array.)
convert the indexed array so say $tables[1] to be the var $table1 instead of just table.

i didnt think about this before i started the array and dont really want to retype since i got close to 100 tables.

i think that made sense.

Salathe · 11-08-2007, 04:36 PM

Perhaps the extract function is what you're looking for? That seems to do what you're wanting, if I've understood your post correctly.

CoryMathews · 11-12-2007, 08:04 PM

I have been playin around with this for a couple days but cant seem to get it to work... this is the first time ive tried to do something like this in any language so that could be my problem. anyways heres what im workin with.

PHP Code:


			
if ($_POST['Submit']) {

   $tablesArray = array('table1', 'table2', 'table3', 'table4', 'table5');

   $checkTheseFieldsArray = array('pname', 'version', 'link');

   $checkTheseFieldsLen = count($checkTheseFieldsArray);

   extract($checkTheseFieldsArray);

   extract($tablesArray);

   $tablesLen = count($tableArray);

  

 //create a date and time.

   $date = date("Y-m-d");

   $time = $_SERVER["REQUEST_TIME"];



 //Tried using it the old fasioned way.

   for ($x=0; $x < $tablesLen; $x++) {

      if(!$_POST[eval("\$tablesArray\[\$x\]")]) {

         $tablesArray[$x] = "";

      } else {

         $tablesArray[$x] = $_POST[$tablesArray[$x]]; }

      }



   //Tried using foreach loop

   foreach($checkTheseFieldsArray as $value2) {

      if(!$_POST[$value2]) {

         $value2 = "";

      } else {

         $value2 = $_POST[$value2];  } }



   foreach($tablesArray as $value3) {

      if(${$value3} != "") {

         $sql=mysql_query("INSERT INTO $value3 (area1, area2 , area3 , area4)

         "."VALUES ('NULL', '$pname', '$version', '$link')") or die(mysql_error()); 

} }

}





//Contine on to form if not submitted

ex 1 input field

Link: 

<input name="link" type="text" size="28" maxlength="128" />



//And one example checkbox for the tables.

<input type="checkbox" name="table1" />Table 1

As of now with real table values this inserts into all 5 of the tables instead of just the one defined (or checked).

Any Tips?