
Untitled
By: a guest on
Aug 10th, 2012 | syntax:
None | size: 0.73 KB | hits: 10 | expires: Never
Inserting array into database Yii
User = array(
fname => "Joe"
lname => "Schmidt"
)
$user = new User;
$user->fname = User['fname'];
$user->lname = User['lname'];
$user->save();
$user->attributes=$_POST['User'];
$user = array("fname" => "Joe", "lname" => "Schmidt");
$serialized = serialize($user);
//Store the $serialized variable in the database
//Get your data from the database
$unserialized = unserialize($usersFromDB);
$fname = $unserialized['fname']; //Joe
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
}