PHP download

PHP code example of agjino / php-mysql-layer

1. Go to this page and download the library: Download agjino/php-mysql-layer 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/ */

agjino / php-mysql-layer example snippets


// get the ids 1, 2,5,9  from products
$db->select('products', array('id' => 'in (1,2,5,9)'), false, false,'OR');


echo $db->select('candy', array('sweet' => 1), 10)->count();


// Move an employee to another department and update their positions count
$db->update(
	'employees',
	array( // fields to be updated
		'department' => 'IT',
		'positions!' => 'positions + 1' //Note the exclamation mark (!) at the end
	),
	array( // 'WHERE' clause
		'id' => '815'
	)
);