File: examples/testsequence.php

Recommend this page to a friend!
  Classes of Jorge Castro  >  PHP PDO One  >  examples/testsequence.php  >  Download  
File: examples/testsequence.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP PDO One
Access to database with PDO and run common queries
Author: By
Last change: 1.19
Date: 11 months ago
Size: 1,380 bytes
 

Contents

Class file image Download
<?php

use eftec\PdoOne;

include
"../vendor/autoload.php";


// connecting to database sakila at 127.0.0.1 with user root and password abc.123
$dao=new PdoOne("mysql","127.0.0.1","root","abc.123","sakila","");
$dao->logLevel=3;
$dao->throwOnError=true;
$dao->nodeId=1; // optional
$dao->tableSequence='snowflake'; // optional
try {
    echo
"<h1>connection. The instance 127.0.0.1, base:sakila user:root and password:abc.123 must exists</h1>";
   
$dao->connect();
    echo
"Connected A-OK!<br>";
} catch (
Exception $e) {
    echo
"<h2>connection error:</h2>";
    echo
$dao->lastError()."-".$e->getMessage()."<br>";
    die(
1);
}

echo
"<h1>creating table sequence:</h1>";
try {

    if (
$dao->tableExist('mysequence2')) {
       
$dao->dropTable('mysequence2');
        echo
"<h3>Table dropped</h3>";
    }
    if (
$dao->objectExist('next_mysequence2','function')) {
       
$dao->drop('next_mysequence2','function');
        echo
"<h3>Function dropped</h3>";
    }
   
$dao->createSequence('mysequence2');
    echo
"<h3>Table created</h3>";

} catch (
Exception $e) {
    echo
"<h2>Error on creation of table</h2>";
    echo
$dao->lastError()."-".$e->getMessage()."<br>";
}
echo
"<h1>obtaining table sequence:</h1>";
for(
$i=0;$i<1000;$i++) {
   
var_dump($dao->getSequence(false,false,'mysequence2'));
    echo
"<br>";
   
var_dump($dao->getSequence(true,false,'mysequence2'));
    echo
"<br>";
}


For more information send a message to info at phpclasses dot org.