Array to DB::insert()->values(), which is in different order with the columns

Question

Hi folks! I'm trying to transfer data as array from the controller to the model, and then paste the data into the query builder, but the data must be in the same order as specified in the columns.

What options do I have?
And do you think this is a bad practice?

Controller:

            $responseNotes = Model::factory('Notes')-> createTicket([
                'description'   => htmlspecialchars($_POST['description']),
                'contact_id'    => $_POST['contact_id'],
                'pref_contact'  => $_POST['pref_contact'],
                'dog_id'        => $_POST['document_id'],
                'type'          => $_POST['type'],
                'owner_id'      => Auth::instance()->get_user()->id,
                'cc'            => $_POST['cc-emails'],
                'title'         => $_POST['title']
            ]);

Model:

public function createNote(array $data)
{
    $columns = [
        'type',
        'owner_id',
        'cc',
        'title',
        'description',
        'contact_id',
        'pref_contact',
        'dog_id'
    ];
    if (!array_diff($columns, array_keys($data))) {
        // All needed values exists
        $result = DB::insert($this->NOTES, $columns)-> values($data)-> execute($this->SCHEMA);
    }
    return  ($result) ? $result : false ;
}

Norman Edance · Accepted Answer · 2018-05-23 04:55:59Z

3

Thanks to this answer. Solved this by:

// Order $data array according to $column.values
$orderedData = [];
foreach ($columns as $key) {
    $orderedData[$key] = $data[$key];
}
$result = DB::insert($this->TICKETS, $columns)
    -> values($orderedData)
    -> execute($this->SCHEMA);

edited May 23, 2018 at 4:55

answered Nov 17, 2017 at 11:23

Norman Edance

4026 silver badges17 bronze badges

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

Comments

bato3 · Accepted Answer · 2018-02-07 03:27:28Z

Why you don't use ORM Model?

in controller:

$responseNotes = ORM::factory('Notes')-> values([
                'description'   => htmlspecialchars($_POST['description']),
                'contact_id'    => $_POST['contact_id'],
                'pref_contact'  => $_POST['pref_contact'],
                'dog_id'        => $_POST['document_id'],
                'type'          => $_POST['type'],
                'owner_id'      => Auth::instance()->get_user()->id,
                'cc'            => $_POST['cc-emails'],
                'title'         => $_POST['title']
            ])
try{
   $responseNotes->save();
} catch (ORM_Validation_Exception $ex) { 
   print_r($ex->errors('models'));
}

And don't use htmlspecialchars($_POST['description'])

In model class modify function (doc):

public function filters()
{
    return array(
      'description' => array( array('htmlspecialchars') ),
    );
}

leosek · Accepted Answer · 2018-04-13 14:50:23Z

0

It looks like You have associative array with structure db_column=>value right? Than You can simply insert like this:

DB::Insert('table_name',array_keys($data))->values(array_values($data))->execute();

answered Apr 13, 2018 at 14:50

leosek

163 bronze badges

Collectives™ on Stack Overflow

Array to DB::insert()->values(), which is in different order with the columns

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related