Query from array

[[deleted]]

hi all!
i have a function how create a query from an array

example:

$var1="one";
$var2="two";
$var3="three";

create_query("table",array($var1,$var2,$var3),"insert")

how can have this query?
"insert into table (var1,var2,var3) values ('one','two','three')"

my difficult is print the name of a variable
example: var1 from $var1

[diego25]

my difficult is print the name of a variable

You can't do that in any programming language that I know of...

Diego

[jesus_hairdo]

you would be better creating an indexed array so i would use something like;

function create_query($table, $values, $action)
{
    $query = "$action into $table (";
    foreach ($values as $field => $value) //this loops through the $values variable and forms 2 vars on each loop, the $field is the index of the array ie. 'var1' or 'var2' and $value is the value of each array element ie. 'one' or 'two'
    {
        $field_array[] = $field;//this forms 2 arrays- one an array of fields
        $value_array[]=$value; // array of values
    }
    foreach ($field_array as $key =>$field)
    {
         if ($key == count($field_array) -1) //this is used to decide if there should be a comma after the field name, 
        {
            $query .= $field; //this is the last field, so no comma is required
        }
        else
        {
            $query .="$field,"; //this isn't the last field so a comma is required after the field name
        }
    }
    $query .=") values (";
    foreach ($value_array as $key =>$val)
    {
        if ($key == count($value_array) //this is used to decide if a comma is needed after the value
        {
            $query .= $val; //this is the last value so no comma is required
        }
        else
        {
            $query .= "$val,"; //this isn't the last value so a comma is required after the value
        }
    }
    //query should now be formed
    return $query; //this returns the value of $query to where the function is called.
}
$array[var1] = "one";
$array[var2] = "two";
$array[var3] = "three";

$query = create_query("table", $array,"insert") //the value of $query is set to the return value of the function.