PHP ML\SQL SQL::createByDSN Exemples

Exemple #1

Fichier : SQLTest.php Projet : renq/ML-Lib

	public function testCreateByDSNUnknownDatabase() {
		$this->setExpectedException('\ML\SQL\Exception');
    	$dsn = 'someUnknownDatabase://someUser@someServer/someDtabase/';
    	$sql = \ML\SQL\SQL::createByDSN($dsn);
    }

Exemple #2

Fichier : 004.php Projet : renq/ML-Lib

<?php

use ml\sql\SQL;

include('../ml/ml.php');
$dsn = 'pgsql://*****:*****@localhost/postgres';

$sql = SQL::createByDSN($dsn);
$sql->query("TRUNCATE TABLE cat");
/*$conn = $sql->getConnection();
$conn->query("INSERT INTO cat (name, colour) VALUES (?, ?)", array('Nennek', 'black'));
var_dump($conn->lastInsertId('cat', 'id'));
*/
var_dump($sql->save('cat', array('name' => 'Nennek', 'colour' => 'black')));