PHP code example of neutronstars / database-sql

1. Go to this page and download the library: Download neutronstars/database-sql 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/ */

neutronstars / database-sql example snippets



  eutronStars\Database\Database;


$options = [
  'url'      => '127.0.0.1',
  'port'     => 3306,
  'user'     => 'root',
  'password' => '',
  'charset'  => 'utf8mb4'
];
$database = new Database('database_name', $options);


$results = $database->query('table')
                    ->select('*')
                    ->getResults();


$result = $database->query('table')
                   ->select('name', 'email')
                   ->where('id=:id')
                   ->setParameters([
                      ':id' => 4
                   ])
                   ->getResult();


$results = $database->query('table')
                   ->select('*')
                   ->limit(10, 20)
                   ->getResults();


use NeutronStars\Database\Query;

$results = $database->query('table')
                   ->select('*')
                   ->orderBy('points', Query::ORDER_BY_DESC)
                   ->getResults();


$results = $database->query('table')
                   ->select('*')
                   ->groupBy('name')
                   ->getResults();


use NeutronStars\Database\Query;

$results = $database->query('table t1')
                   ->select('*')
                   ->join('table2 t2', 't1.id = t2.id', Query::LEFT_JOIN)
                   ->getResults();


$database->query('table')
         ->delete()
         ->where('id=:id')
         ->setParameters([
            ':id' => 4
         ])
         ->execute();


$database->query('table')
         ->update('name=:name')
         ->where('lastname=:lastname')
         ->setParameters([
             ':name'     => 'Doe',
             ':lastname' => 'John'
         ])
         ->execute();


$database->query('table')
         ->insertInto('name,lastname', ':name1,:lastname1', ':name2,:lastname2')
         ->setParameters([
            ':name1'     => 'Doe',
            ':lastname1' => 'John',
            ':name2'     => 'Doe',
            ':lastname2' => 'Jane'
         ])
         ->execute();


$database->query('table')
         ->insertInto('name,lastname', ':name,:lastname')
         ->onDuplicateKeyUpdate('name=:name,lastname=:lastname')
         ->setParameters([
            ':name'     => 'Doe',
            ':lastname' => 'John'
         ])
         ->execute();


use NeutronStars\Database\QueryBuilder;

$builder = (new QueryBuilder('table'))->select('*');
$results = $database->withQuery($builder, 'test')
                    ->getResults();


use NeutronStars\Database\QueryBuilder;
use NeutronStars\Database\Query;

$builder = (new QueryBuilder('test'))->select('*');
$results = $database->query('users u')
                    ->select('*')
                    ->joinQuery($builder, 't', 't.id=u.id', Query::LEFT_JOIN)
                    ->where('u.points>:points')
                    ->setParameters([
                       ':points'     => 5
                    ])
                    ->getResults();


$results = $database->query('users')
                   ->select('u.*')
                   ->union('profile p', true)
                   ->select('p.*')
                   ->getResults();