stnc / pdo-database
A super simple function that returns the full SQL query from your PDO statements
2.2.4
2019-04-30 21:13 UTC
Requires
- php: >=5.4.0
- ext-pdo: *
README
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']);