<?php
class ez_select
{
var $fields = array(); // fields to select
var $tables = array(); // tables to select from
var $where = array(); // WHERE clauses
var $order_by = array(); // fields for ORDER BY clause
var $group_by = array(); // fields for GROUP BY clause
var $query; // the actual, constructed query
var $order_type; // ASC or DESC
var $have_limit; // whether or not to put a limit on this query
var $limit_offset; // what record to start on for a limit
// how many records to get
var $limit_num_records;
function select_query()
{
// nothing yet
}
function add_field($fields)
{
// adds fields from which we'll be selecting stuff
$this->fields[] = $fields;
}
function add_table($table)
{
// adds a table from which to select results
$this->tables[] = $table;
}
function add_where_clause($clause)
{
// adds a where clause to the query
$this->where[] = $clause;
}
function add_order_by($field)
{
// adds a field to order by
$this->order_by[] = $field;
}
function add_group_by($field)
{
// adds a field to group by
$this->group_by[] = $field;
}
function set_order_type($type)
{
// sets order type (ASC or DESC)
$this->order_type = $type;
}
function set_limit($offset=0, $num_records)
{
// adds a limit to the query
$this->have_limit = true;
$this->limit_offset = $offset;
$this->limit_num_records = $num_records;
}
function show()
{
// shows the query so far, color coded
// a select query...
$query = '<b>SELECT</b> ';
// fields to select, comma separated
$query .= '<font color=blue>';
$query .= implode(', ', $this->fields);
$query .= '</font>';
// tables to select from
$query .= ' <b>FROM</b> ';
$query .= '<font color=green>';
$query .= implode(', ', $this->tables);
$query .= '</font>';
// if there are any where clauses
if( count($this->where) )
{
$query .= ' <b>WHERE</b> <font color=red>';
$query .= implode(' </font><b>AND</b><font color=red> ', $this->where);
$query .= '</font>';
}
// if there are any fields to group by
if( count($this->group_by) )
{
$query .= ' <b>GROUP BY</b> <font color=orange>';
$query .= implode(', ', $this->group_by);
$query .= '</font>';
}
// any fields to order by
if( count($this->order_by) )
{
$query .= ' <b>ORDER BY</b> <font color=purple>';
$query .= implode(', ', $this->order_by);
$query .= '</font>';
$query .= ' <b>' . $this->order_type . '</b>';
}
// a limit
if($this->have_limit)
{
$query .= " <b>LIMIT</b> <font color=magenta>$this->limit_offset, ";
$query .= $this->limit_num_records;
$query .= '</font>';
}
echo "<br>" . $query;
} // end function show()
function make()
{
// creates and returns the query
// a select query...
$this->query = 'SELECT ';
// fields to select, comma separated
$this->query .= implode(',', $this->fields);
// tables to select from
$this->query .= ' FROM ';
$this->query .= implode(',', $this->tables);
// if there are any where clauses
if( count($this->where) )
{
$this->query .= ' WHERE ';
$this->query .= implode(' AND ', $this->where);
}
// if there are any fields to group by
if( count($this->group_by) )
{
$this->query .= ' GROUP BY ';
$this->query .= implode(',', $this->group_by);
}
// any fields to order by
if( count($this->order_by) )
{
$this->query .= ' ORDER BY ';
$this->query .= implode(',', $this->order_by);
$this->query .= ' ' . $this->order_type;
}
// a limit
if($this->have_limit)
{
$this->query .= " LIMIT $this->limit_offset,";
$this->query .= $this->limit_num_records;
}
return $this->query;
} // end function make()
} // end class ez_select
?>
|