Class: Record

[line 45]
Record

an item in a database table.

Usage:

1.  // INSERT
2.   $User = $db->get_record( 'people' );
3.  $User->save();
4.  // UPDATE
5.   $User = $db->get_record( 'people', $req->userid );
6.  $User->set_value( 'first_name', $req->first_name );
7.  // DELETE
8.   $User = $db->get_record( 'people', $req->userid );
9.  $db->delete_record( $User );
10.  // SELECT ONE
11.   $User = $db->get_record( 'people', $req->userid );
12.  print "Hello, $User->first_name!";
13.  // SELECT MULTIPLE
14.   $people = $db->get_recordset( "SELECT * FROM people WHERE disk_usage > 1000" );

More info... http://dbscript.net/record

Tags:

$attributes =

[line 51]

attribute names and data from the database field

$children =

[line 81]

list of related records returned by query

$exists =

[line 111]

true if the record exists in the database

$func_args =

[line 69]

arguments from Record object instantiation

$modified_fields =

[line 57]

list of changed fields since last save_changes

$primary_key =

[line 63]

primary key field

$relationships =

[line 99]

true if this record is an unsaved skeleton record

$select =

[line 75]

fields to SELECT if not *

$selecttext =

[line 87]

sql query used to fetch this record

$skeleton =

[line 93]

true if this is an unsaved skeleton record

$table =

[line 105]

name of database table

---

constructor Record [line 122]

---

method belongs_to [line 344]

---

method ChildCount [line 316]

---

method field_names [line 187]

---

method FirstChild [line 274]

---

method has_and_belongs_to_many [line 331]

---

method has_many [line 357]

---

method has_one [line 370]

---

method is_skeleton [line 382]

---

method NextChild [line 297]

---

method save [line 253]

---

method save_changes [line 237]

---

method set_value [line 208]

---

method validate_field [line 396]