example_mysql.php

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

require_once 'vendor/autoload.php';

define('DB_TYPE', 'mysql');
  
  define('DB_HOST', 'localhost');
  define('DB_NAME', 'zf1app_db');
  define('DB_USER', 'root');
  define('DB_PASS', '');
  


/* //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';
// multiple rows
$q = "SELECT * FROM ".$tableName;
$array_expression = $db->fetchAll ( $q );
foreach ( $array_expression as $value ) {
	echo  $value ['username'];
	echo '<br>';
}

// single row
$q = "SELECT * FROM ".$tableName ." where id=1";
$array_expression = $db->fetch ( $q );


	echo $value ['username'];



//print_r($array_expression);



// query metod mysq only 
$q = "ALTER TABLE users MODIFY COLUMN id  int(11) NOT NULL AUTO_INCREMENT FIRST";
 $db->query ( $q );


// insert data
$data = array (
		'first_name' => "john",
		'last_name' => "carter",
		'username' => "rob",
		'password' => "12345",

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

// update metod

$data = array (
		'first_name' => "johnx",
		'last_name' => "carter",
);

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

 $db-> update ( $tableName, $data, $where );

$where = array (
		'id' => 5
);
$db->delete ( $tableName, $where );


//last id 
$db->lastID();

///NEW MTEOD //Chaining methods where update //orm step 2
$db->where('id', '=', 1)->update2(['username' =>'selman sedat']);

//orm step 1
$db->tableName=$tableName;
$array_expression = $db->where_test ( 'id','=','1' );