Skip to content

stnc/pdo-database

Repository files navigation

pdo-database

easy ,basic ,simple mysql provider
A super simple function that returns the full SQL query from your PDO statements
a PDO database service provider for mysql and portgreSQL

Composer install

composer require stnc/pdo-database

1. Installing-Connections

require_once 'vendor/autoload.php';
  define('DB_TYPE', 'mysql');
  define('DB_HOST', 'localhost');
  define('DB_NAME', 'wordpress');
  define('DB_USER', 'root');
  define('DB_PASS', '');

2. Connections

/* //use 1 
use Stnc\Db\MysqlAdapter ;
$db = new MysqlAdapter();
*/

/* //use 2
use Stnc\Db\MysqlAdapter as dbs;
$db = new dbs();
*/


//use 3
$db = new Stnc\Db\MysqlAdapter();
$tableName = 'users';

3. Select multiple rows

$q = "SELECT * FROM ".$tableName;
$array_expression = $db->fetchAll ( $q );
foreach ( $array_expression as $value ) {
	echo  $value ['name'];
	echo '<br>';
}

4. Select single row

$tableName = 'wp_options';//wordpress 
$q = "SELECT * FROM ".$tableName;
$array_expression = $db->fetch ( $q );
echo $array_expression ['name'];
//or 
$q = 'SELECT * FROM '.$tableName.' where option_name="siteurl" ';
$array_expression = $db->fetch ( $q );
print_r ($array_expression);
echo $array_expression ['option_name'];

5. Query

$q = "ALTER TABLE users MODIFY COLUMN user_id  int(11) NOT NULL AUTO_INCREMENT FIRST";
$db->query ( $q );

6. insert data

$data = array (
		'name' => "john",
		'lastname' => "carter",
		'status' => 1,
		'age' => 25 
);


$db->insert ( $tableName, $data );

7. update metod

$data = array (
		'name' => "john",
		'lastname' => "carter",
		'status' => 1,
		'age' => 25 
);
$where = array (
		'user_id' => 1 
);
$db-> update ( $tableName, $data, $where );

8. Delete metod

$where = array (
		'user_id' => 1 
);

return $db->delete ( $tableName, $where );

9. last id

$db->lastID();

10. Orm Mass Updates

$db->tableName=$tableName;
$db->where('id', '=', 1)->update2(['username' =>'selman sedat']);