DATABASE.CLASS.PHP


<h1>DATABASE.CLASS.PHP</h1>

<h2>NAME</h2>

<p><code>database.class.php</code> - a simple database abstraction class</p>

<h2>SYNOPSIS</h2>

<p><code>database.class.php</code> abstracts MYSQL databases using native php PDO</p>

<h2>DESCRIPTION</h2>

<p><code>database.class.php</code> allows the execution of any SQL query against a MYSQL database and returns any result set. It can be easily modified for databases other than MYSQL</p>

<p>The connection object is persistent within a database object</p>

<p>Query parameters are embedded into the query rather than bound to the query</p>

<p>Result sets are not cached within the database object</p>

<h2>APPLICATION</h2>

<pre>
 class Database
 Read/write data to mysql database, uses PDO
 No external dependencies
 Sql staements dont have a ";" terminator
 
     Constructor for this database connection
     $dh or DIE = new Database(dsn,username,password,[options() = null])
     dsn for mysql = mysql:host=localhost;dbname=testdb
     dsn for sqlite = sqlite2:/opt/databases/mydb.sq2
    
     Execute SQL (INSERT, UPDATE, DELETE, etc) on database
     count or FALSE = dh-&gt;putQuery(sql)
    
     Execute SELECT on database, return multiple rows with multiple columns
     array of row objects or FALSE = dh-&gt;getRange(sql)
    
     Execute SELECT on database, return a single column single row cell
     mixed or FALSE = dh-&gt;getCell(sql)
    
     Execute SELECT on database, return single row of multiple columns
     row object or FALSE = dh-&gt;getRow(sql)
    
     Execute SELECT on database, return a single column of multiple rows
     array of mixed or FALSE = dh-&gt;getColumn(sql)
    
     Return sql from last executed query for debugging
     $string = dh-&gt;lastSql()
     last sql string is sticky
    
     Quote and escape (if required) any string or number
     quoted string = dh-&gt;quoteArg(argument)
    
     Begin transaction on database
     null = dh-&gt;beginTransaction()
    
     Commit transaction on database
     null = dh-&gt;commitTransaction()
    
     Rollback transaction on database
     null = dh-&gt;rollbackTransaction()
    
     Get id of last INSERT
     integer = dh-&gt;lastInsertId()
</pre>

<h2>BUGS</h2>

<p>None</p>

<h2>AUTHOR</h2>

<p>John Bartlett<br>johnb@thesolution.com.au</p>

<h2>SEE ALSO</h2>

<p>Requires php PDO module</p>
<br>