active record class in codeigniter (Insert)


<?php
/************* Inserting Data with Codeigniter *******************/
// By passing an array to the insert function

$data = array('title' => 'My Title', 'name' => 'My Name', 'date' => 'My Date');
$this -> db -> insert ('tablename', $data);

// By Passing an object to the function
class Myclass {
   var $title = 'My Title';
 var $content = 'My Content';
    var $date = 'My Date'; }
$object = new Myclass;
$this -> db -> insert('tablename', $object);


// Generates an insert string based on the data you supply .
$data = array(
   array(
      'title' => 'My title' ,
      'name' => 'My Name' ,
      'date' => 'My date'
   ),
   array(
      'title' => 'Another title' ,
      'name' => 'Another Name' ,
      'date' => 'Another date'
   )
);

$this -> db -> insert_batch('mytable', $data); 


// $this -> db -> set () is used instead of passing a data array 
// directly to the insert or update function

//Single function call
$this -> db -> set('name', $name); 
$this -> db -> insert('mytable'); 

//Multiple function call

$this -> db -> set('name', $name);
$this -> db -> set('title', $title);
$this -> db -> set('status', $status);
$this -> db -> insert('mytable');


//set() function will also accept an optional third parameter ($escape) that will
// prevent data from being escaped if set to FALSE

$this -> db -> set('field', 'field+1', FALSE);
$this -> db -> insert('mytable'); 
// gives INSERT INTO mytable (field) VALUES (field+1)

$this -> db -> set('field', 'field+1');
$this -> db -> insert('mytable'); 
// gives INSERT INTO mytable (field) VALUES ('field+1')


// One can pass an associative array to this function

$array = array('name' => $name, 'title' => $title, 'status' => $status);

$this -> db -> set($array);
$this -> db -> insert('mytable');

//Or an Object
class Myclass 
{
      var $title = 'My Title';
    var $content = 'My Content';
       var $date = 'My Date';
    }

$object = new Myclass;

$this -> db -> set($object);
$this -> db -> insert('mytable');

?>

Comments

Popular posts from this blog

371 - Ackermann Functions

Create many folder with one click