Location: PHPKode > scripts > Singleton PDO > singleton-pdo/spdo.sample.php
<?php

require_once("spdo.php");

function foo()
{
	/*
	 *  get single global instance
	 */
	 
	$pdo = SPDO::getInstance();
	
	
	
	/*
	 * sample query
	 */
	
	echo "<pre>";
	$stmt = $pdo->query("SELECT * FROM `users`");
	
	foreach($stmt as $row)
	{
		print_r($row);
	}
	echo "</pre>";
	
	
	
	
	
	/*
	 * modifyTable
	 */	 
	
	
	// fill values to assoc. array	
	$set = array();
	$set["field1"] = "value1";
	$set["field2"] = 5;
	$set["field3"] = NULL;
	
	
	// insert new line
	$pdo->modifyTable("test", $set);
	// SQL: INSERT INTO `test` (field1, field2, field3) VALUES ('value1', '5', NULL)
	
	// update
	$pdo->modifyTable("test", $set, "id = '5'");
	// SQL: UPDATE `test` SET field1 = 'value1', field2 = '5', field3 = NULL WHERE id = '5'
	
}

try
{
	$pdo = SPDO::connect("mysql:dbname=test;host=localhost", "root", "root");
	$pdo->exec("SET NAMES 'utf8'");

	foo();
}
catch(Exception $e)
{
	echo $e->getMessage();
}



?>
Return current item: Singleton PDO