Login   Register  
PHP Classes
elePHPant
Icontem

File: test

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of alessandro  >  PDO wrapper singleton  >  test  >  Download  
File: test
Role: Example script
Content type: text/plain
Description: test class
Class: PDO wrapper singleton
Database access wrapper using PDO
Author: By
Last change: extend PDO Class , remove singleton
Date: 2008-09-09 07:00
Size: 863 bytes
 

Contents

Class file image Download
<?php
require_once('myAccessPDO.class.php');

$zzz = new myAccessPDO('192.168.195.253','template1','postgres','postgres','pgsql');

// show tables
echo "<pre>";
print_r($zzz->fetchRow('select * from information_schema.tables where table_schema=\'public\' and table_type=\'BASE TABLE\''));
echo 
"</pre>";

echo 
"<pre>";
print_r($zzz->prepare('SELECT * from programmattori WHERE nome = ?',array('giggighe')));
echo 
"</pre>";




$zzz->simpleQuery("INSERT INTO \"memcache\" (id, nome,numero) VALUES (DEFAULT,'caio',1111) ");

echo 
"<br /> ".$zzz->getLog();


echo 
"<pre>";
print_r(mydb::getInstance()->fetchRow('SELECT * from programmattori '));
echo 
"</pre>";


//echo "<pre>";
//print_r(mydb::getInstance()->getLog());
//echo "</pre>";
//
//
//
//echo "<pre>";
//print_r(mydb::getInstance()->getError());
//echo "</pre>";
//
?>