PHP Classes

File: examples/examples.php

Recommend this page to a friend!
  Classes of GŁnce Bektas  >  PDO Query Builder  >  examples/examples.php  >  Download  
File: examples/examples.php
Role: Example script
Content type: text/plain
Description: examples
Class: PDO Query Builder
Compose and execute SQL queries using PDO
Author: By
Last change: name change
Date: 5 months ago
Size: 1,578 bytes
 

Contents

Class file image Download
<?php
/** @example Insert
 *
 */
$values = array('setting_name' => $_POST['name'],
               
'setting_value' => $_POST['value'],
               
'setting_explanation' => $_POST['desc'], );

insert('settings')->values($values);

/** @example Update
 *
 */
update('calendars_events')->values(array('user_id' => $_SESSION['user_id'],
                                        
'title' => $_POST['title'],
                                        
'text' => $_POST['text'],
                                        
'start' => $_POST['start'],
                                        
'end' => $_POST['end'],
                                        
'allday' => $_POST['allday'],
                                        
'url' => $_POST['url'],
                                        
'color' => '#'.$_POST['color'],
                                        
'textColor' => '#'.$_POST['textColor'], ))->where('calendar_event_id = 1');

/** @example Delete
 *
 */
delete('contents_similars')->where('content_id = 1')->run();

/** @example Select
 *
 */
select('settings')->where('setting_group = 1')->order('setting_id ASC')->results();

/** @example Select
 *
 */
select('dynamic_tables')->where('dynamic_table_name = "settings"')->limit(1)->result('dynamic_table_rules');

/** @example Select with left join
 *
 */
select('contents')->left('langs ON langs.lang_id = contents.lang_id')->results();

/** @example Select with left join and using
 *
 */
select('contents')->left('langs')->using('lang_id')->results();


/** @example
 *
 */
find('contents', 2);

For more information send a message to info at phpclasses dot org.