CODEWITHSUNDEEP
phparraysmultidimensional-arraypdo
user4383363
user4383363

Reputation:

Create array with key and value in loop PHP

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);        
 }

Upvotes: 1

Views: 88

Answers (1)

Sashant Pardeshi
Sashant Pardeshi

Reputation: 1095

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();

Upvotes: 1

Related Questions