PHP download

PHP code example of midorikocak / querymaker

1. Go to this page and download the library: Download midorikocak/querymaker library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

midorikocak / querymaker example snippets


$queryMaker = new QueryMaker();
$queryMaker->select('users');
echo $queryMaker->getQuery();


$queryMaker = new QueryMaker();
$queryMaker->select('users', ['id', 'email']);
echo $queryMaker->getQuery();


$queryMaker = new QueryMaker();
$queryMaker->select('users', ['id', 'email'])->where('id', '3', '>=');
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();


$queryMaker = new QueryMaker();
$queryMaker->delete('users');
echo $queryMaker->getQuery();


$queryMaker = new QueryMaker();
$queryMaker->select('users', ['id', 'email'])->where('id', 3);
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();


$queryMaker = new QueryMaker();
$queryMaker->select('users', ['id', 'email'])->where('id', 3)->and('email', '[email protected]')->or('username', 'midori');
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();


$queryMaker = new QueryMaker();
$queryMaker->select('users', ['id', 'email'])->where('email', '[email protected]')->and('id', '>3')->and('id', '<5');


$queryMaker = new QueryMaker();
$queryMaker->select('users')->orderBy('id');
echo $queryMaker->getQuery();


$queryMaker = new QueryMaker();
$queryMaker->select('users')->orderBy('id')->limit(3)->offset(2);
echo $queryMaker->getQuery();


$db = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);

$queryMaker = new QueryMaker();

$queryMaker->select('users', ['id', 'email'])->where('id', 3)->and('email', '[email protected]')->or('username', 'midori');

$statement = $db->prepare($query->getStatement());

$statement->execute($query->getParams());



$queryMaker = new QueryMaker();
$queryMaker->insert('users', ['email' => '[email protected]', 'username' => 'midorikocak']);
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();


$queryMaker = new QueryMaker();
$queryMaker->update('users', ['email' => '[email protected]', 'username' => 'midorikocak'])->where('id', 3);
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();