1. Go to this page and download the library: Download finesse/query-scribe 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/ */
finesse / query-scribe example snippets
$query = (new Query)
->from('posts')
->where('level', '>', 3)
->whereIn('category_id', function ($query) {
$query
->addSelect('id')
->from('categories')
->where('categories.name', 'Interesting');
})
->where(new Raw('MONTH(date)'), 4)
->orderBy('date', 'desc')
->limit(10);
$prefixer = new TablePrefixer('demo_');
$grammar = new MySQLGrammar();
$compiled = $grammar->compile($query->apply($prefixer));
echo $compiled->getSQL();
/*
SELECT *
FROM `demo_posts`
WHERE
`level` > ? AND
`category_id` IN (
SELECT `id`
FROM `demo_categories`
WHERE `demo_categories`.`name` = ?
) AND
(MONTH(date)) = ?
ORDER BY `date` DESC
LIMIT ?
*/
echo $compiled->getBindings();
/*
[3, 'Interesting', 4, 10]
*/
Loading please wait ...
Before you can download the PHP files, the dependencies should be resolved. This can take some minutes. Please be patient.