Просмотр архива Adult video script v8.1


<?php

error_reporting(E_ALL);

include('../adodb.inc.php');



include('../adodb-active-record.inc.php');



###########################



$ADODB_ACTIVE_CACHESECS = 36;



$DBMS = @$_GET['db'];



$DBMS = 'mysql';

if ($DBMS == 'mysql') {

    $db = NewADOConnection('mysql://root@localhost/northwind');

} else if ($DBMS == 'postgres') {

    $db = NewADOConnection('postgres');

    $db->Connect("localhost","tester","test","test");

} else

    $db = NewADOConnection('oci8://scott:natsoft@/');





$arr = $db->ServerInfo();

echo "<h3>$db->dataProvider: {$arr['description']}</h3>";



$arr = $db->GetActiveRecords('products',' productid<10');

adodb_pr($arr);



ADOdb_Active_Record::SetDatabaseAdapter($db);

if  (!$db)  die('failed');









$rec = new ADODB_Active_Record('photos');



$rec = new ADODB_Active_Record('products');





adodb_pr($rec->getAttributeNames());



echo "<hr>";





$rec->load('productid=2');

adodb_pr($rec);



$db->debug=1;





$rec->productname = 'Changie Chan'.rand();



$rec->insert();

$rec->update();



$rec->productname = 'Changie Chan 99';

$rec->replace();





$rec2 = new ADODB_Active_Record('products');

$rec->load('productid=3');

$rec->save();



$rec = new ADODB_Active_record('products');

$rec->productname = 'John ActiveRec';

$rec->notes = 22;

#$rec->productid=0;

$rec->discontinued=1;

$rec->Save();

$rec->supplierid=33;

$rec->Save();

$rec->discontinued=0;

$rec->Save();

$rec->Delete();



echo "<p>Affected Rows after delete=".$db->Affected_Rows()."</p>";