Location: PHPKode > scripts > Easy Query > example.php
<?php
require_once	'EasyQuery.php';
$db = new EasyQuery;

/**
* define values to return, if params is null then return all the
* values of the table else just return the values espeficied
*/
$db->values();
display($db->get('easyquery'));
echo $db->myQuery();

/*using chaining*/
display($db->values()->get('easyquery'));
echo $db->myQuery();

/**
* return records especified by the where condition, when the records to
* return is a single return, then the second param of get() will be TRUE
* 
* note: you can make multiple calls to where() method to make AND conditions
*/
$db->values();
$db->where('id_user',	1);
display($db->get('easyquery', TRUE));
echo $db->myQuery();

/*using chaining*/
display($db->values()->where('id_user', 1)->get('easyquery', TRUE));
echo $db->myQuery();

/**
* returns a range of records
* 
* this method will set the offset to second position and return three records
* this method can help you when you're paginating records
*/
$db->values();
$db->limit(2, 3);
display($db->get('easyquery'));

/*using chaining*/
display($db->values()->limit(2, 3)->get('easyquery'));

/**
* custom query
* 
* use the setQuery method when you can't make the query with the methods of the
* class fetchQuery had a boolean param to specified singlerow
*/
$db->setQuery('select * from easyquery where id_user <> 1');
$db->execute();
display($db->fetchQuery(FALSE));
echo $db->myQuery();

/**
* insert records
* 
* you can also use insertId(), this method will retur the id generated by the last 
* insert query
*/
$data = array('user_name'	=>	'username',
 		'user_password'	=>	md5('password'),
		'user_mail'	=>	'hide@address.com');
$db->insert('easyquery', $data);
echo $db->myQuery();

/**
* delete records 
* 
* you can also use rowsAfected() at the end to display the rows affected by the query
*/
$db->where('id_user',	1);
$db->limit(1);
$db->delete('easyquery');
echo $db->myQuery();

/*using chaining*/
$db->where('id_user', 1)->limit(1)->delete('easyquery');

/**
* update records 
* 
* you can also use rowsAfected() at the end to display the rows affected by the query
*/
$data = array('user_name'	=>	'funny name');
$db->where('id_user',	2);
$db->limit(1);
$db->update('easyquery', $data);
echo $db->myQuery();

/*using chaining methods*/
$db->where('id_user', 2)->limit(1)->update('easyquery', $data);

/**
* count records
* 
* numRows() will count the records of the las query executed
*/
$db->values();
$records = $db->get('easyquery');
echo $db->numRows();

/*using chaining methods*/
$records = $db->values()->get('easyquery');
echo $db->numRows();

/**
* check if exists records in a table
*/
if ($db->haveRows('easyquery')) {
	echo 'Table is not empty';
} else {
	echo 'table is empty';
}

/**
* function to display the result of the query
*/
function display($data) {
	echo '<pre>';
	print_r($data);
	echo '</pre>';
}
/*
+ __construct()							:void
+ connect()								:object
+ setQuery(string)						:object
+ insert(string, arrays)				:void
+ update(string, array)					:void
+ delete(string)						:void
+ values(string)						:object
+ where(string, mixed)					:object
+ order(string, string)					:object
+ group(string)							:object
+ tableJoin(string, string, string)		:object
+ limit(integer, integer)				:object
+ getValues()							:string
+ getWhere()							:string
+ getOrder()							:string
+ getGroup()							:string
+ getTableJoin()						:string
+ getLimit()							:string
+ get(string, bool)						:array
- _reset()								:void
+ haveRows(string)						:bool
+ numRows()								:integer
+ insertId()							:mixed
+ rowsAfected()							:mixed
+ freeResult()							:mixed
+ disconnect()							:void
+ myQuery()								:string
+ execute()								:bool
+ fetchQuery(bool)						:array
+ scape(mixed)							:mixed
*/
?>
Return current item: Easy Query