$db = new Database(); $db->connect(); // Import External SQL File echo "Import External SQL File"; echo "<br />------------------<br />"; $sqlFile = file_get_contents('src/example.sql'); $db->import($sqlFile); $response = $db->getResponse(); echo $response[0] == TRUE ? 'TRUE' : 'FALSE'; echo "<br/><br/>"; $db->disconnect(); $db->connect(); // Get all Tables in your Database echo "Get all Tables in your Database"; echo "<br />------------------<br />"; $db->tables(); $response = $db->getResponse(); for ($x = 0; $x < count($response); $x++) { echo $response[$x] . "<br/>"; } echo "<br/><br/>"; // Get Full Table echo "Get Full Table"; echo "<br />------------------<br />"; $db->sql('SELECT * FROM users'); $response = $db->getResponse(); foreach ($response as $row) { echo $row["username"] . "<br />"; echo $row["email"] . "<br />"; echo $row["first_name"] . "<br />"; echo $row["last_name"] . "<br />";
<?php require_once "{$dir}/server/config.php"; require_once "{$dir}/server/database/database.php"; // Load the database $db_filename = ''; if (preg_match('#sqlite://(.+)#', $db_path, $matches)) { list(, $db_filename) = $matches; } $db = new Database($db_path); if ($db->tables() == array()) { // Setup the initial database configuration $db->setup("{$dir}/server/init.sql"); $db->query("\n INSERT INTO user\n (username, status)\n VALUES ('shiftspace', 1)\n "); } // Set up the user session session_register('user'); $user = $_SESSION['user']; if (empty($user) && !empty($_COOKIE['auth'])) { list($username, $password) = explode(':', $_COOKIE['auth']); $user = $db->row("\n SELECT *\n FROM user\n WHERE username = '******'\n AND password = '******'\n "); if (!empty($user)) { $_SESSION['user'] = $user; } } if (!empty($_GET['v'])) { $client_version = $_GET['v']; } $server = 'http://' . $_SERVER['SERVER_NAME'] . dirname($_SERVER['PHP_SELF']) . '/'; if (get_magic_quotes_gpc()) { function strip_quotes(&$var)
foreach ($results as $item) { ?> <tr> <td><?php echo $item->getId(); ?> </td> <td><?php echo $item->getTble(); ?> </td> <td><?php echo $item->getKlass(); ?> </td> <td><?php echo $item->getLabel(); ?> </td> </tr> <?php } print_r(Database::fields(Database::tables()[1])); ?> </tbody> </table> <?php #页脚 ////////////////////////////////////////////////////////////////////////////////////////////// include_once "include/footer.php";
/** * @return array */ public static function getTables() { if (!isset(Database::$tables)) { $tables = Database::query("SHOW TABLES"); Database::$tables = array(); foreach ($tables as $table) { array_push(Database::$tables, array_pop($table)); } } return Database::$tables; }