<h1>Pruebas de base de datos</h1> <?php include 'extensions/db/dbscheme.class.php'; include 'extensions/db/mysql_db.plugin.php'; include 'extensions/db/db.php'; /*db::connect('name1', 'mysql', 'localhost', 'pruebas', 'root', 'test'); db::createcommand('SELECT * FROM alumnos', 'name1')->execute(); */ $db = new mysql_db(); $db->connect('localhost', 'pruebas', 'root', 'test'); $t = $db->createcommand('SELECT * FROM alumnos', 'name1'); while ($row = mysql_fetch_assoc($t)) { print_r($row); echo '<hr />'; } echo '<h2>Other</h2>'; $db2 = new mysql_db(); $db2->connect('localhost', 'arrayzone', 'root', 'test'); $t = $db2->createcommand('SELECT * FROM az_users', 'name1'); while ($row = mysql_fetch_assoc($t)) { print_r($row); echo '<hr />'; } /*echo '<h2>Another</h2>'; $t = $db->select(array('*'))->from(array('cargos')); while ($row = mysql_fetch_assoc($t)) { print_r($row); echo '<hr />'; }*/
<?php define('MYSQL_HOSTNAME', 'localhost'); define('MYSQL_USERNAME', 'root'); define('MYSQL_PASSWORD', 'Sycamore'); define('MYSQL_DATABASE', 'pawful'); require_once 'mysql_db.class.php'; $db = new mysql_db(); $db->connect(MYSQL_HOSTNAME, MYSQL_USERNAME, MYSQL_PASSWORD) or die(mysql_error()); $db->select_db(MYSQL_DATABASE) or die(mysql_error()); $db->set_magic_quotes_off(); ?>