From b2ab51b432e4de4aeb551ca17cba323ad729f406 Mon Sep 17 00:00:00 2001 From: admin Date: Sun, 24 Sep 2006 18:03:40 +0000 Subject: Deleting database folder --- user_guide/libraries/database/examples.html | 183 ---------------------------- 1 file changed, 183 deletions(-) delete mode 100644 user_guide/libraries/database/examples.html (limited to 'user_guide/libraries/database/examples.html') diff --git a/user_guide/libraries/database/examples.html b/user_guide/libraries/database/examples.html deleted file mode 100644 index 566441bec..000000000 --- a/user_guide/libraries/database/examples.html +++ /dev/null @@ -1,183 +0,0 @@ - - - - -Code Igniter User Guide - - - - - - - - - - - - - - - - - - - - - - -
- - - - - -

Code Igniter User Guide Version 1.4.1

-
- - - - - - - - - - -
- - - -
- - - -
- - -

Database Quick Start: Example Code

- -

The following page contains example code showing how the database class is used. For complete details please -read the individual pages describing each function.

- - -

Initializing the Database Class

- -

The following code loads and initializes the database class based on your configuration settings:

- -$this->load->database(); - -

Once loaded the class is ready to be used as described below.

- -

Note: If all your pages require database access you can connect automatically. See the connecting page for details.

- - -

Standard Query With Multiple Results (Object Version)

- -$query = $this->db->query('SELECT name, title, email FROM my_table');
-
-foreach ($query->result() as $row)
-{
-    echo $row->title;
-    echo $row->name;
-    echo $row->email;
-}
-
-echo 'Total Results: ' . $query->num_rows(); - - -

The above result() function returns an array of objects. Example: $row->title

- - -

Standard Query With Multiple Results (Array Version)

- -$query = $this->db->query('SELECT name, title, email FROM my_table');
-
-foreach ($query->result_array() as $row)
-{
-    echo $row['title'];
-    echo $row['name'];
-    echo $row['email'];
-} - -

The above result_array() function returns an array of standard array indexes. Example: $row['title']

- - -

Standard Query With Single Result

- -$query = $this->db->query('SELECT name FROM my_table LIMIT 1');
-
-$row = $query->row();
-echo $row->name;
- - - -

Standard Insert

- - -$sql = "INSERT INTO mytable (title, name)
-        VALUES (".$this->db->escape($title).", ".$this->db->escape($name).")";
-
-$this->db->query($sql);
-
-echo $this->db->affected_rows(); - - - - - -

Active Record Query

- -

The Active Record Pattern gives you a simplified means of retrieving data:

- - -$query = $this->db->get('table_name');
-
-foreach ($query->result() as $row)
-{
-    echo $row->title;
-} - - -

Active Record Insert

- - -$data = array(
-               'title' => $title,
-               'name' => $name,
-               'date' => $date
-            );
-
-$this->db->insert('mytable', $data); -

-// Produces: INSERT INTO mytable (title, name, date) VALUES ('{$title}', '{$name}', '{$date}') - - - - -
- - - - - - - \ No newline at end of file -- cgit v1.2.3-24-g4f1b