Array Help Needed!

glerma

I am looking for some coding help on a problem that I'm having.

I am trying to parse a string from an ORACLE CLOB column. The string is comma-delimited.
Example: Value1 "1", Value2 "2", Value3 "3",

I want to parse the string and get only the values between the double-quotes. Then I want to create a Table Form Field using the output. I have found somewhat of a way to do it.
$contents = $querystring;
$fields = preg_split('/"/',$contents);
$fldField1 = $fields[0];
$fldField2 = $fields[1];
$fldField3 = $fileds[2];

The problem is the string array built by the preg_spilt function can be variable lengths, depending on what was put into the CLOB column. This means that I never know how many array indexes have been built.

Anyone know how to know how many pointers/indexes have been built by the array? Or better yet, how can I dynamically create form field variables based on how many values were found? Maybe a for loop?

Thanks.

capricorn732

You can get no. of indexes in a array useing count(ARRAY); it will return a numeric figure representing no. of indexes in given ARRAY.

vat you need to do is

1 - Create variable name dynamicaly. You can do this by using double dollar sign. LIKE $$strFieldName. This will make value of $strFieldName a variable.

Ex:
$strFieldName = "emp_name"
$$strFiledName = "George"

Here is how you will do all this

$contents = $querystring;
$fields = preg_split('/"/',$contents);

if(count($fields)){
$strQuery = "CREATE TABLE (";
for($nI=1; $nI <= count($fields); $nI++){
$strFieldName = "fldField" . $nI;
$$strFieldName = $fields[$nI-1];
$strQuery .= $$strFieldName . " varchar(255),";
} // end of for

$strQuery = substr($strQuery, 0, strlen($strQuery)-1);

$strQuery .= ");";
} // end of if

glerma

This is actually working pretty well. I would ask on more piece of advice.

How can I get the dynamic variables that are getting created into an html table? Not an actual database table.