تالار گفتمان nCIS.ir

$this->model = new Model();

$this->connect();

$this->connect();

class Model {

protected $con;

public function __construct() {
$this->connect();
}

private function connect() {
if ( ! $this->con ) {
$config = Loader::load( 'Configs' );
$this->con = new mysqli( $config->dbHost, $config->dbUser, $config->dbPassword, $config->dbName );
$this->con->query( "SET NAMES 'utf8'" );
$this->con->set_charset( 'utf8' );
}
}

public function query( $query ) {
$this->connect();
return $this->con->query( $query );
}

public function escape( $param ) {
$this->connect();
if ( $param == null )
return 'NULL';
return $this->con->real_escape_string( $param );
}

public function insertId() {
$this->connect();
return $this->con->insert_id();
}

public function arrayQuery( $query ) {
$this->connect();
$result = [];
$values = $this->query( $query );
if ( $values && $values->num_rows > 0 ) {
while ($value = $values->fetch_assoc()) {
$result[] = $value;
}
}
return $result;
}

}

$this->model = new Model();

class ActiveRecord extends Model {

protected $model;
protected $tableName;
protected $fields;
protected $isNew;

public function __construct() {
$this->model = new Model(); 
foreach ( $this->fields as $key => $value ) {
$this->fields[ $key ] = null;
}
$this->isNew = true;
}
//...
public function findByPk( $id ) {
$className = get_class( $this );
$obj = new $className();
$this->model = new Model();
$id = $this->model->escape( $id );
$sql = "SELECT * FROM `{$this->tableName}` WHERE (`id`='{$id}')";
$data = $this->model->arrayQuery( $sql );
if ( count( $data ) > 0 ) {
foreach ( $data[ 0 ] as $fieldName => $value ) {
$obj->$fieldName = $value;
}
$obj->isNew = false;
return $obj;
}
}
//...
public function update() {
$this->model = new Model();
$fields = array_map( [ $this->model, 'escape' ], $this->fields );
$sql = "UPDATE `{$this->tableName}` SET ";
foreach ( $fields as $key => $value ) {
if ( $key === 'id' ) {
continue;
}
$sql .= "`{$key}`='{$value}',";
}
$sql = substr( $sql, 0, -1 ) . " WHERE (`id`={$fields[ 'id' ]})";
$this->new = false;
}
//... 

class PostsController extends Controller {

public function actionView($params) {
$post = (new Posts())->findByPk($params['id']);
$post->view++;
$post->save();
$this->render( 'view', compact( 'post' ) );
}

}

class Model {

protected $con;

public function __construct() {
$this->connect();
}

private function connect() {
$config = Loader::load( 'Configs' );
$this->con = new mysqli( $config->dbHost, $config->dbUser, $config->dbPassword, $config->dbName );
if ( ! $this->con->error ) {
$this->con->query( "SET NAMES 'utf8'" );
$this->con->set_charset( 'utf8' );
echo 'Ok';
}
}

public function query( $query ) {
// $this->connect();
return $this->con->query( $query );
}

public function escape( $param ) {
// $this->connect();
if ( $param == null )
return 'NULL';
return $this->con->real_escape_string( $param );
}

public function insertId() {
// $this->connect();
return $this->con->insert_id();
}

public function arrayQuery( $query ) {
// $this->connect();
$result = [];
$values = $this->query( $query );
if ( $values && $values->num_rows > 0 ) {
while ($value = $values->fetch_assoc()) {
$result[] = $value;
}
}
return $result;
}

}

$config = Loader::load('Configs');
$this->con = new mysqli($config->dbHost, $config->dbUser, $config->dbPassword, $config->dbName);
    if (!$this->con->connect_error) {
        $this->con->query("SET NAMES 'utf8'");
        $this->con->set_charset('utf8');
        echo 'Ok';
    } else {
        echo $this->con->connect_error;
    }
}

$this->con = new mysqli(...) or die('ERROR: ' . $this->con->connect_error);

(07-06-1399، 03:52 ب.ظ)ADMIN نوشته: [ -> ]این مدل رو امتحان کنید:

$this->con = new mysqli(...) or die('ERROR: ' . $this->con->connect_error);