Queryfy

Queryfy query builder de Artify

<?php

use App\core\DB;

//Ejemplo 1 - (Consulta generada -> SELECT `empId`,`firstName`,`lastName` FROM `emp` )
//Specify column names
$queryfy = DB::Queryfy();
$queryfy->columns = array("empId", "firstName", "lastName");
$result =  $queryfy->select("emp");
 
//Ejemplo 2 - (Consulta generada -> SELECT * FROM `emp` WHERE `age`>= ? )
//Specify where condition
$queryfy->where("age",30,">=");
$result =  $queryfy->select("emp");
 
//Ejemplo 3 - (Consulta generada -> SELECT * FROM `emp` WHERE `status`= ? AND `age`>= ? AND ( `firstName`= ? OR `firstName`= ? )  )
// Ejemplo of use of multiple "and" and "or" with brackets
$queryfy->where("status", 1);
$queryfy->where("age",30,">=");
$queryfy->openBrackets = "(";
$queryfy->where("firstName", 'John');
$queryfy->andOrOperator = "OR";
$queryfy->where("firstName", 'bob');
$queryfy->closedBrackets = ")";
$result =  $queryfy->select("emp");
 
//Ejemplo 4 - (Consulta generada ->SELECT * FROM `emp` GROUP BY `age` ORDER BY `firstName` LIMIT 0,5  )
//groupby, order by and limit example
$queryfy->groupByCols = array("age");
$queryfy->orderByCols = array("firstName");
$queryfy->limit = "0,5";
$result =  $queryfy->select("emp");
 
//Ejemplo 5 - (Consulta generada ->SELECT * FROM `emp` WHERE `firstName`LIKE ? AND `age` BETWEEN ? AND ? AND `empId`IN (?,?) ORDER BY `firstName` LIMIT 0,5 )
// LIKE, BETWEEN, IN, NOT IN example
$queryfy->andOrOperator = "AND";
$queryfy->where("firstName", "Jo%", "LIKE");
$queryfy->where("age", array(10,50), "BETWEEN");
$queryfy->where("empId", array(30,50), "IN");
$queryfy->limit = "0,5";
$result =  $queryfy->select("emp");
 
//Ejemplo 6 - (Consulta generada ->SELECT count(*), concat(firstname, ' ' , lastname) AS `fullname` FROM `emp` ORDER BY `firstName` )
// Aggregate functions like count example
$queryfy->columns = array("count(*), concat(firstName, ' ' , lastName) as fullName");
$result =  $queryfy->select("emp");
 
//Ejemplo 7 - (Consulta generada ->SELECT * FROM `emp` GROUP BY `firstName` HAVING sum(age)>10 ORDER BY `firstName` )
$queryfy->groupByCols = array("firstName");
$queryfy->havingCondition = array("sum(age)>10");
$result =  $queryfy->select("emp");
 
//Ejemplo 8 - (Consulta generada ->SELECT * FROM `wp_postmeta` WHERE `post_id` IN (select post_id from wp_posts where post_id>?) )
//use of subquery with where condition 
$queryfy->where_subquery("post_id", "select post_id from wp_posts where post_id>?", "IN", array(1));
$result =  $queryfy->select("wp_postmeta");
 
//Ejemplo 9 - (Consulta generada ->SELECT * FROM `emp` ORDER BY `firstName` LIMIT 0,3 )
$queryfy->fetchType = "OBJ";
$queryfy->limit = "0,3";
$result =  $queryfy->select("emp");

?>

Seleccionar Datos de una tabla

<?php

$queryfy = DB::Queryfy();
$data = $queryfy->select("mi_tabla");
print_r($data);

?>

Insertar Datos de una tabla

<?php

$data = [
    'campo' => 'valor',
    'campo' => 'valor',
    'campo' => 'valor',
    'campo' => 'valor',
    'campo' => 'valor'
];

$queryfy = DB::Queryfy();
$queryfy->insert("mi_tabla", $data);

?>

Actualizar Datos de una tabla

<?php

$data = [
    'campo' => 'valor'
];

$queryfy = DB::Queryfy();
$queryfy->where("id_tabla", "valor");
$queryfy->update("mi_tabla", $data);

?>

Eliminar Datos de una tabla

<?php

$data = [
    'campo' => 'valor'
];

$queryfy = DB::Queryfy();
$queryfy->where("id_tabla", "valor");
$queryfy->delete("mi_tabla", $data);

?>