dbscript
[ class tree: dbscript ] [ index: dbscript ] [ all elements ]

Class: MySQL

Source Location: /mysql.php

Class Overview

Database
   |
   --MySQL

MySQL


Author(s):

Version:

  • 0.1.2

Variables

Methods


Inherited Variables

Inherited Methods


Class Details

[line 33]
MySQL

adapter for the MySQL database system

Usage:

  1.  $db new MySQL 'hostname''database_name''username''password' );

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




Tags:

todo:  support array datatypes
version:  0.1.2
access:  public
author:  Brian Hendrickson <brian@dbscript.net>


[ Top ]


Class Variables

$dbname =

[line 39]


Type:   mixed


[ Top ]

$host =

[line 34]


Type:   mixed


[ Top ]

$opt1 =

[line 37]


Type:   mixed


[ Top ]

$opt2 =

[line 38]


Type:   mixed


[ Top ]

$pass =

[line 36]


Type:   mixed


[ Top ]

$user =

[line 35]


Type:   mixed


[ Top ]



Class Methods


constructor MySQL [line 40]

MySQL MySQL( )



[ Top ]

method add_field [line 341]

void add_field( $table, $field, $data_type)



Parameters:

   $table  
   $field  
   $data_type  

[ Top ]

method add_table [line 330]

void add_table( $table, $field_array)



Parameters:

   $table  
   $field_array  

[ Top ]

method blob_value [line 185]

void blob_value( &$rec, $field, &$value)



Parameters:

   &$rec  
   $field  
   &$value  

[ Top ]

method close [line 145]

void close( )



[ Top ]

method connect [line 89]

void connect( )



[ Top ]

method escape_string [line 101]

void escape_string( $string)



Parameters:

   $string  

[ Top ]

method fetch_array [line 167]

void fetch_array( &$result, [ $row = NULL])



Parameters:

   &$result  
   $row  

[ Top ]

method fetch_row [line 173]

void fetch_row( &$result, [ $row = NULL])



Parameters:

   &$result  
   $row  

[ Top ]

method field_name [line 300]

void field_name( &$result, $index)



Parameters:

   &$result  
   $index  

[ Top ]

method get_fields [line 360]

void get_fields( $table)



Parameters:

   $table  

[ Top ]

method get_result [line 110]

void get_result( $sql, [ $returnfalse = NULL])



Parameters:

   $sql  
   $returnfalse  

[ Top ]

method get_table [line 155]

void &get_table( $table)



Parameters:

   $table  

[ Top ]

method get_tables [line 348]

void get_tables( )



[ Top ]

method has_table [line 345]

void has_table( $t)



Parameters:

   $t  

[ Top ]

method large_object_create [line 303]

void large_object_create( $table, $file)



Parameters:

   $table  
   $file  

[ Top ]

method large_object_delete [line 327]

void large_object_delete( $oid)



Parameters:

   $oid  

[ Top ]

method large_object_fetch [line 317]

void large_object_fetch( $table, $blobcol, $pkfield, $pkvalue, [ $return = false])



Parameters:

   $table  
   $blobcol  
   $pkfield  
   $pkvalue  
   $return  

[ Top ]

method last_insert_id [line 129]

void last_insert_id( &$result, $pk, $table)



Parameters:

   &$result  
   $pk  
   $table  

[ Top ]

method model [line 164]

void &model( $model)



Parameters:

   $model  

[ Top ]

method next_primary_key [line 126]

void next_primary_key( $table, $pkfield, [ $sequence_name = NULL])



Parameters:

   $table  
   $pkfield  
   $sequence_name  

[ Top ]

method num_fields [line 297]

void num_fields( &$result)



Parameters:

   &$result  

[ Top ]

method num_rows [line 294]

void num_rows( &$result)



Parameters:

   &$result  

[ Top ]

method post_insert [line 287]

void post_insert( &$rec, &$result)



Parameters:

   &$rec  
   &$result  

[ Top ]

method pre_insert [line 241]

void pre_insert( &$rec, $modified_field, $datatype)



Parameters:

   &$rec  
   $modified_field  
   $datatype  

[ Top ]

method pre_update [line 263]

void pre_update( &$rec, $modified_field, $datatype)



Parameters:

   &$rec  
   $modified_field  
   $datatype  

[ Top ]

method query_limit [line 182]

void query_limit( $limit, $offset)



Parameters:

   $limit  
   $offset  

[ Top ]

method quoted_insert_value [line 238]

void quoted_insert_value( &$rec, $modified_field)



Parameters:

   &$rec  
   $modified_field  

[ Top ]

method quoted_update_value [line 235]

void quoted_update_value( &$rec, $modified_field)



Parameters:

   &$rec  
   $modified_field  

[ Top ]

method result_value [line 137]

void result_value( &$result, $resultindex, $field)



Parameters:

   &$result  
   $resultindex  
   $field  

[ Top ]

method seek_row [line 179]

void seek_row( &$result, $row)



Parameters:

   &$result  
   $row  

[ Top ]

method select_distinct [line 232]

void select_distinct( $field, $table, $orderby)



Parameters:

   $field  
   $table  
   $orderby  

[ Top ]

method sql_delete_for [line 228]

void sql_delete_for( &$rec)



Parameters:

   &$rec  

[ Top ]

method sql_insert_for [line 193]

void sql_insert_for( &$rec)



Parameters:

   &$rec  

[ Top ]

method sql_select_for [line 225]

void sql_select_for( &$rec, $id)



Parameters:

   &$rec  
   $id  

[ Top ]

method sql_update_for [line 210]

void sql_update_for( &$rec)



Parameters:

   &$rec  

[ Top ]


Documentation generated on Mon, 19 Feb 2007 10:24:55 -0800 by phpDocumentor 1.3.1