Inserting array into database Yii

Question

I would like to insert an array into a MYSQL database, preferably using Yii's active record.

For example, I have a an array:

User = array(
    fname => "Joe"
    lname => "Schmidt"
)

with a User table in my database with columns id, fname and lname. One of the options is creating an object and doing:

$user = new User;
$user->fname = User['fname'];
$user->lname = User['lname'];
$user->save();

However, this seems like so much code for such common functionality. Is there a way to insert an array into the database where array keys match corresponding columns without me writing my own function or doing some SQL query hack? Ideally it uses the already present Active record of Yii.

You can use mass-assignment for this: $user = new User(); $user->attributes = $data_array; if(!$user->save()) { print_r($user->errors, true); }. Assigning an array to the attributes property will do what you want, but only for those attributes which have a validation rule defined for the current scenario. — user1233508
– user1233508, Commented Jul 23, 2012 at 4:28
@DCoder, that is a great and succinct solution that I was looking for! If you put it as an answer I will accept it. — joeschmidt45
– joeschmidt45, Commented Jul 23, 2012 at 5:13

Pentium10 · Accepted Answer · 2012-07-23 05:45:41Z

4

What you want to do is handled by the framework itself.

You can mass assign like:

$user->attributes=$_POST['User'];

Comments

Oliver Spryn · Accepted Answer · 2012-07-23 02:31:43Z

0

I have never worked with Yii before, so I can't offer a solution using that, but you can serialize the array and store it in the single cell in your database, like so:

$user = array("fname" => "Joe", "lname" => "Schmidt");
$serialized = serialize($user);

//Store the $serialized variable in the database

When you are ready to access it:

//Get your data from the database

$unserialized = unserialize($usersFromDB);
$fname = $unserialized['fname']; //Joe

Hope that helps.

answered Jul 23, 2012 at 2:31

Oliver Spryn

17.4k33 gold badges106 silver badges200 bronze badges

Comments

Nick · Accepted Answer · 2012-07-23 03:10:47Z

-1

the function is pretty straightforward, try this:

  function insert($table, $fields_values = array())
  {
    $q1 = join(",", array_keys($fields_values));

    $q2 = "'".join("','", array_values($fields_values))."'";

    $query = "INSERT INTO $table($q1) VALUES($q2)";

    // do your DB insert here
  }

The main trick is the array to query conversion using join and array_keys / array_values.

answered Jul 23, 2012 at 3:10

Nick

91613 silver badges30 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:34:51Z

-1

Depending the amount of data in array you can write you own function e.g

a) check this backUpdate , modify it to insert /remove render view option

b) Follow this thread

c) Possible traps when inserting multiple records

d) check this associated SOQ

If you know what you are doing its easy to do , you just need to take care of

validations
records exists in associated tables ( if there is FKey involved )
option d). will be a posssible answer if you have simple inserts ( with no associated tables)

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Jul 23, 2012 at 3:39

sakhunzai

14.6k27 gold badges107 silver badges163 bronze badges

Collectives™ on Stack Overflow

Inserting array into database Yii

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related