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
Post a Comment