<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();
?>
