Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 10th, 2012  |  syntax: None  |  size: 0.73 KB  |  hits: 10  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Inserting array into database Yii
  2. User = array(
  3.     fname => "Joe"
  4.     lname => "Schmidt"
  5. )
  6.        
  7. $user = new User;
  8. $user->fname = User['fname'];
  9. $user->lname = User['lname'];
  10. $user->save();
  11.        
  12. $user->attributes=$_POST['User'];
  13.        
  14. $user = array("fname" => "Joe", "lname" => "Schmidt");
  15. $serialized = serialize($user);
  16.  
  17. //Store the $serialized variable in the database
  18.        
  19. //Get your data from the database
  20.  
  21. $unserialized = unserialize($usersFromDB);
  22. $fname = $unserialized['fname']; //Joe
  23.        
  24. function insert($table, $fields_values = array())
  25.   {
  26.     $q1 = join(",", array_keys($fields_values));
  27.  
  28.     $q2 = "'".join("','", array_values($fields_values))."'";
  29.  
  30.     $query = "INSERT INTO $table($q1) VALUES($q2)";
  31.  
  32.     // do your DB insert here
  33.   }