<?php // Loading demo class require 'DemoCRUD.php'; // Example with Multiple Instances echo '<h2><a href=".">DEMOS</a> › 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();
<?php // Loading demo class require 'DemoCRUD.php'; // Example with Insert, Update and Delete echo '<h2><a href=".">DEMOS</a> › INSERT/UPDATE/DELETE</h2>'; // Creating an instance $demo = new DemoCRUD(); // Example with inserting multiple records $demo->multipleInsert(); // Example to update multiple records $demo->multipleUpdate(); // Example with multiple exclusion of records $demo->multipleDelete();
<?php // Loading demo class require 'DemoCRUD.php'; // Example with All Selects echo '<h2><a href=".">DEMOS</a> › SELECTS</h2>'; // Creating an instance $demo = new DemoCRUD(); // Displaying records between different instances of base $demo->allSelects();
<?php // Loading demo class require 'DemoCRUD.php'; // Example with text from HTML Editor echo '<h2><a href=".">DEMOS</a> › HTML EDITOR</h2>'; // Creating an instance $demo = new DemoCRUD(); // Sample text $sample_text = '<p style="color: #CBF;">Lorem ipsum "dolor" sit amet</p>'; // Escape double quotes $sample_text = addslashes($sample_text); // UPDATE books SET description = ? WHERE id = 1 $demo->updateWhere($sample_text, 1);