Recommend this page to a friend! |
Download .zip |
Info | View files (3) | Download .zip | Reputation | Support forum | Blog | Links |
Last Updated | Ratings | Unique User Downloads | Download Rankings | |||||
2024-01-10 (3 days ago) | Not enough user ratings | Total: 687 This week: 4 | All time: 4,735 This week: 89 |
Version | License | PHP version | Categories | |||
query-builder-pdo 0.19 | MIT/X Consortium ... | 5 | PHP 5, Databases |
Description | Author | ||||||||
This class can compose and execute SQL queries using PDO. |
|
What is the best PHP mysql pdo connection class?
PDO MySQL Connection and Query
<h1>Query builder for PDO with memcache support</h1>
It’s developed as fluent interface design. You can easily access to database just by using select functions anywhere you want.
<b>Build query:</b> select(‘users’)->where(‘user_id = “’. $user_id .’” ’)->limit(1);
<b>Run query:</b> select(‘users’)->where(‘user_id = “’. $user_id .’” ’)->limit(1)->run;
<b>Fetch result</b> select(‘users’)->where(‘user_id = “’. $user_id .’” ’)->limit(1)->result();
Easy to read & write, isn’t it? You can use helper functions insert(), replace(), update(), delete() and select() in everywhere including functions without calling global $pdo. For other features please call global $pdo variable.
Let’s look it deeply with examples… For examples I will use ‘users’ as table name of users, and ‘langs’ for table name of available languages
<b>find(‘users’, 1)</b> Returns just one row of selected table with the match of first column
<b>select(‘users’)</b> Returns the row of selected table It means “select from” to change use ->which() after select()
<b>left(‘langs ON langs.lang_id = users.lang_id’)</b> LEFT JOIN statement for select, usage is; select(‘users’)->left(‘langs ON langs.lang_id = users.lang_id’)->results();
<b>insert(‘users’)->values(array)</b> insert(‘users’)->values(array(‘user_name’=>’Jon Snow’));
<b>replace(‘users’)->values(array)</b> replace(‘users’)->values(array(‘user_name’=>’Jon Snow’));
<b>update(‘users’)->values(array)</b> update(‘users’)->values(array(‘user_name’=>’Jon Snow’))->where(‘user_id = 1’);
<b>where()</b> select(‘users’)->where(‘user_id = 1’)->result();
<b>* which()</b> I know which statement is a little bit odd but it’s simple and points * for select queries like; select(‘users’)->which(‘user_name, users.lang_id AS lang_id)
<b>group()</b> select(‘users’)->group(‘lang_id’);
<b>have()</b> select(‘users’)->have(‘lang_id’);
<b>order()</b> ->order(‘user_id ASC’);
<b>limit()</b> ->limit(10);
<b>offset()</b> ->offset(10);
<b>column() – final function </b> column(‘users’)
<b>write() – final function</b> shows query
<b>* run() – final function</b> ->run();
<b>* result() – final function</b> ->result();
<b>* results() – final function</b> ->results();
<b>results_pairs() – final function (Beta)</b> Gather results as pair, is very useful when working with lists ->results_pairs();
<b>PS:</b> You can send arrays as parameters to insert or update a column, query builder will automatically detect and change it into json
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
100% |
|
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.