С версии: 2010-09-07
Автор: Giovanni Ramos (giovannilauro@gmail.com)
Наследование: implements pdo4you\Config
Пример #1
0
 static function delete($arr, $multi = '')
 {
     if ($arr) {
         if ($multi) {
             foreach ($arr as $i => $a) {
                 $delete[] = array("table" => self::$table, "where" => array("id" => $i));
             }
         } else {
             $delete[] = array("table" => self::$table, "where" => array("id" => $arr));
         }
         $json_delete = json_encode($delete);
         return parent::execute('delete:' . $json_delete);
     }
 }
Пример #2
0
 /**
  * Main method
  * 
  * */
 public function __construct()
 {
     // Validates the form input submitted, before writing to database
     if ($_POST) {
         $firstName = filter_input(INPUT_POST, 'firstname', FILTER_SANITIZE_STRING);
         $lastName = filter_input(INPUT_POST, 'lastname', FILTER_SANITIZE_STRING);
         $mail = filter_input(INPUT_POST, 'mail', FILTER_VALIDATE_EMAIL);
         // Performing validation
         if (empty($firstName) || empty($lastName)) {
             $error = 'Enter your name and last name';
         } else {
             if (isset($_POST['mail']) && !empty($_POST['mail']) && $mail == FALSE) {
                 $error = 'Enter a valid email address';
             }
         }
         // Displays a message in case of errors
         if (isset($error)) {
             self::$message = '<i style="color: #f50;">ERROR: ' . $error . '</i><br /><br />';
         } else {
             // SQL insertion in JSON format
             $json = '
             insert : [
                 {
                     table: "users" ,
                     values: { firstname: "' . $firstName . '", lastname: "' . $lastName . '", mail: "' . $mail . '"  }
                 }
             ]
             ';
             // Performs the new record and store the result
             list($total) = PDO4You::execute($json);
             // Displays a success message
             self::$message = 'Register #' . $total . ' added successfully!!<br /><br />';
         }
     }
     // Capture records of all registered users
     self::$hasRecords = PDO4You::select('SELECT * FROM users ORDER BY id DESC');
 }
Пример #3
0
<?php

// Loading demo class
require 'DemoCRUD.php';
// Example with Multiple Instances
echo '<h2><a href=".">DEMOS</a> &rsaquo; MULTIPLE INSTANCES</h2>';
// Importing classes
use PDO4You\PDO4You;
// Creating an instance
$demo = new DemoCRUD();
// Displaying records of the default instance "standard"
$demo->select();
PDO4You::getInstance('bookstore', 'sqlite:data/database_bookstore.db');
PDO4You::getInstance('pdo4you', 'sqlite:data/database_pdo4you.db');
// Displaying records from the data instance: bookstore
$demo->select('bookstore');
// Displaying records from the data instance: pdo4you
$demo->select('pdo4you');
// Sets another instance
PDO4You::setInstance('standard');
#PDO4You::setInstance('bookstore');
// Displaying records from the last data instance set
$demo->select();
Пример #4
0
<?php

// Loading all the necessary files
require __DIR__ . '/src/bootstrap.php';
// Connection class imported
use PDO4You\PDO4You;
// Connection instance started and available
PDO4You::getInstance();
// Applying styling on the page
PDO4You::css();
// Displaying details on the target server's database connected
PDO4You::showServerInfo();
?>
<!doctype html>
<html>
    <head>
        <meta charset="UTF-8" />
        <title>PDO4You</title>
        <style>
            body { background:#FAFAFA; font:normal 12px/1.7em Bitstream Vera Sans Mono,Courier New,Monospace; margin:0; padding:0; }
            a    { color:#08C; text-decoration:none; } b { color:#CCC; }
            #pdo4you h2 { color:#000; background:#FFF; font-size:20px; display:block; margin:0; padding:10px; border-bottom:solid 1px #999; }
            .pagination { margin-top:25px;}
            .pagination a { color:#08C; background:#FFF; border:1px solid #BBB; font-size:12px; font-weight:bold; display:inline-block; min-width:13px; min-height:15px; margin:0 2px; padding:1px 6px; -webkit-border-radius:2px; -moz-border-radius:2px; border-radius:2px; text-align:center; cursor:pointer; }
            .pagination a.selected, .pagination a.selected:hover, .pagination a:hover { color:#FFF; background:#09E; border:1px solid #08C; }
            .pagination a.nolink, .pagination a.nolink:hover { color:#AAA; background:#FFF; border:1px solid #CCC; cursor:default; }
        </style>
    </head>
    <body id="pdo4you">
        <?php 
if ((string) ($page = filter_input(INPUT_GET, 'p'))) {
Пример #5
0
 public function testMultipleInsertInArrayFormat()
 {
     $array['query'] = array(array('table' => 'users', 'values' => array('firstname' => "John", 'lastname' => "Lennon")), array('table' => 'users', 'values' => array('firstname' => "Paul", 'lastname' => "McCartney")));
     // Executes the SQL and stores the result
     $result = test::insert($array);
     $this->assertEquals(2, self::getNumRowsAffected($result), 'Test with Insert method');
 }
Пример #6
0
 /**
  * Format the Result
  * 
  */
 private function getResult($result, $show_lastid = false)
 {
     $result = '<br /><br /> - The code above will output: <pre style="color:blue;">' . print_r($this->sanitize($result), true) . '</pre>';
     $result .= 'Total records affected: <strong style="color:red;">' . PDO4You::rowCount() . '</strong>';
     $result .= $show_lastid ? '&nbsp;&nbsp; Id of the last iteration: <strong style="color:red;">' . PDO4You::lastId() . '</strong>' : null;
     return $result;
 }