PDO_MySQL Queries

PDO_MySQL Connector:

$pdo = new PDO(
    'mysql:host=192.168.0.1;dbname=MyDB',
    'root',
    '1234',
    array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")
);


PDO_MySQL Queries:

$sql = 'select * from MyDB where status = ? and type = ? and way = ?';
$stmt = $pdo->prepare($sql);
$stmt->execute(array(1, 2, 5));
$row = $stmt->fetchAll();


$stmt = $pdo->prepare('update project set column = ? where id = ?');
$stmt->execute(array('3', '4'));