Create array with key and value in loop PHP

Question

I'm using PDO, and I managed to get the table columns despite the table name and create the bind variables, like in ... VALUES (:foo, :bar);.

The method I'm trying to do this is insert().

public function insert()
{
    // the variable names depend on what table is being used at the moment the script runs.
    // These methods use the PDO `getColumnMeta()` to retrieve the name of each column
    $sql = "INSERT INTO {$this->getTableName()}({$this->getTableColumns()}) "
            . "VALUES ({$this->getTableColumns(true)})";

    // The previous method gets the name of each column and returns a single string, like "foo, bar, [...]"
    // and this function is used to separate each word, with the specified delimiter
    $col = explode(", ", $this->getTableColumns());

    // Now here lays the problem.
    // I already know how to retrieve the columns name as a variable, and
    // how to dynamically create the get method, using `ucfirst()`
    // What I need would be something like this being inside of a
    // loop to retrieve all the separated words from `$col` array.
    $data = array(
        $col[$i] => "\$this->entity->get".ucfirst($col[$i])."()",
    )

    /*
     * From now on, is what I need to do.
     */
    // Lets pretend the column names are "foo, bar".
    $data = array(
        ":foo" => $this->entity->getFoo(),
        ":bar" => $this->entity->getBar()
    )

    // That'd be the final array I need, and then continue with
    $stm = $this->db->prepare($sql);
    $stm->execute($data);        
 }

Please add the code how you create your prepared statement, so we see which variables you used and so on — Rizier123
– Rizier123, Commented Jun 8, 2015 at 13:31

Sashant Pardeshi · Accepted Answer · 2015-06-08 14:34:30Z

1

You have to loop over $data array and add function as per your requirement. Fetch values from `... VALUES (:foo, :bar); Then explode as you did in your code , then loop over $col array and add values to $data as required

foreach($col as $val){
    $method = "get".ucfirst( $val);
    $data[ $val] =  call_user_func(array( $this->entity,$method));
}

Above code may work as follow

$data[':foo'] =  $this->entity->getFoo();
$data[':bar'] =  $this->entity->getBar();

edited Jun 8, 2015 at 14:34

answered Jun 8, 2015 at 13:45

Sashant Pardeshi

1,0957 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user4383363 Over a year ago

Hello. I edited my question and tried to make it clearer about my need. Thank you. :)

Sashant Pardeshi Over a year ago

Please replace $data = array( $col[$i] => "\$this->entity->get".ucfirst($col[$i])."()", ) with my code $data[$temp] = call_user_func(array( $this->entity,$method)); and try.

Collectives™ on Stack Overflow

Create array with key and value in loop PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related