Login   Register  
PHP Classes
elePHPant
Icontem

File: example_3.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Bogdan Lupandin  >  MySQL Access Wrapper  >  example_3.php  >  Download  
File: example_3.php
Role: Example script
Content type: text/plain
Description: Example of generating an SQL statement
Class: MySQL Access Wrapper
MySQL database access wrapper
Author: By
Last change:
Date: 2009-05-03 14:11
Size: 1,171 bytes
 

Contents

Class file image Download
<p>Generating an SQL statement from an array...</p>
<pre><code>
require_once "db.php";

$db = new db();

$sql = array(
             'SELECT'    => '*',
             'FROM'      => '`database`.`table`',
             'JOIN'      => '`table2',
             'ON'        => '`table1`.`field1` = `table2`.`field2`',
             'WHERE'     => array(
                            '`field1`' => 'value1',
                            '`field2`' => 'value2'),
             'ORDER BY'  => '`field2`',
             'ASC'       => null
);

echo $db->build_key_query($sql);
</code></pre>
<br />
<p>Results in:</p>
<blockquote>
<?php
require_once "db.php";

$db = new db();

$sql = array(
             
'SELECT'    => '*',
             
'FROM'      => '`database`.`table`',
             
'JOIN'      => '`table2',
             
'ON'        => '`table1`.`field1` = `table2`.`field2`',
             
'WHERE'     => array(
                            
'`field1`' => 'value1',
                            
'`field2`' => 'value2'),
             
'ORDER BY'  => '`field2`',
             
'ASC'       => null
);

echo 
$db->build_key_query($sql);
?></blockquote>