Example #1
0
 static function query($query, $type = 0, $field = 0, $resource = null, $debug = true)
 {
     global $link;
     if (!is_resource($resource)) {
         $resource = $link;
     }
     $query = trim($query);
     $id = strtolower(substr($query, 0, 3));
     $result = array();
     switch ($id) {
         case 'sel':
         case 'sho':
             $result = DB::read($query, $type, $field, $resource);
             break;
         case 'ins':
         case 'del':
         case 'upd':
         case 'ren':
         case 'cre':
         case 'alt':
         case 'dro':
             $result = DB::write($query, $resource);
             break;
     }
     return $result;
 }
Example #2
0
	print_r($req->whereAssoc);
	echo '</pre>';	
	}
*/
print '<pre>';
/**
 * Database Helper Function templates
 */
/*
	select(table name, where clause as associative array)
	insert(table name, data as associative array, mandatory column names as array)
	update(table name, column names as associative array, where clause as associative array, mandatory columns as array)
	delete(table name, where clause as array)
*/
echo "<h1>With Builder</h1>";
print_r($db->read("customers_php as c")->where("c.id > :id_min")->params(array(":id_min" => 290))->exec());
print_r($db->insert("customers_php")->val(array('name' => 'Miguel', 'email' => '*****@*****.**'))->reqCol(array('name', 'email'))->exec());
print_r($db->update("customers_php")->setVal(array('name' => 'Monica'))->where(array('name' => 'Miguel'))->exec());
print_r($db->delete("customers_php")->where(array('name' => 'Monica'))->exec());
/*
	$rows = $db->select("*","customers_php",array('id'=>171));
	print_r($rows);
	print_r(json_encode($rows,JSON_NUMERIC_CHECK));
	
	
	
	$rows = $db->insert("customers_php",array('name' => 'Ipsita Sahoo', 'email'=>'*****@*****.**'), array('name', 'email'));
	print_r($rows);
	print_r(json_encode($rows,JSON_NUMERIC_CHECK));
	
	
Example #3
0
 function traerAlgoDesdeLaDb()
 {
     $rows = DB::read("SELECT * FROM client_info");
     return $rows;
 }