/** * Tableau rempli à partir de la base bibliothèque **/ function fromDbTab() { //Récupère les données de la BD try { $conn = new PDO('mysql:dbname=bibliotheque;host=127.0.0.1;charset=utf8', 'root', ''); } catch (PDOException $e) { echo 'Connexion impossible : ' . $e->getMessage(); return; } if (!($stmt = $conn->query('SELECT * FROM auteur'))) { die(var_export($conn->errorinfo(), TRUE)); } //Lance la création du tableau $table = new AutoTab\Table('Liste des auteurs'); $table->addHeadersStr(array('Id', 'Nom', 'Prénom', 'Année de naissance')); foreach ($stmt as $data) { $table->addRowStr(array($data['id_auteur'], $data['nom'], $data['prenom'], $data['date_naissance'])); } $table->render(); }
<tr><td><label for="date_sortie"> Date de sortie </label></td><td><input type="text" name="date_sortie" id="date_sortie" value="<?php echo $ouvrages_items['date_de_sortie']; ?> "tabindex ="17"/></td></tr> <tr><td><label for="nombre_exemple"> Nombre d'exemplaire </label></td><td><input type="text" name="nombre_exemple" id="nombre_exemple" value="<?php echo $ouvrages_items['nombre_exemplaire']; ?> "tabindex ="20"/></td></tr> <tr><td><label for="num_rang"> N° de rangé </label></td><td><input type="text" name="num_rang" id="num_rang" value="<?php echo $ouvrages_items['N_range']; ?> "tabindex ="25"/></td></tr> <tr><td><label for="theme1">Théme</label></td><td> <select name="theme1" id="theme1" tabindex ="30"> <?php $themec = $bdd->prepare('SELECT * FROM categorie WHERE ID_theme =?') or die(print_r($bdd->errorinfo())); $themec->execute(array($ouvrages_items['ID_theme'])); $theme_courant = $themec->fetch(); ?> <optgroup label ="Theme Courant"><option value="<?php echo $theme_courant['theme']; ?> "><?php echo $theme_courant['theme']; $themec->closeCursor(); ?> </option></optgroup> <optgroup label ="Nouveau Theme"> <?php $theme = $bdd->query('SELECT * FROM categorie '); while ($theme_items = $theme->fetch()) {
/** * Query the database * * @param integer $type * @param string $sql * @param mixed $as_object * * @return mixed * * @throws \Database_Exception */ public function query($type, $sql, $as_object) { // Make sure the database is connected $this->_connection or $this->connect(); if (!empty($this->_config['profiling'])) { // Get the paths defined in config $paths = \Config::get('profiling_paths'); // Storage for the trace information $stacktrace = array(); // Get the execution trace of this query $include = false; foreach (debug_backtrace() as $index => $page) { // Skip first entry and entries without a filename if ($index > 0 and empty($page['file']) === false) { // Checks to see what paths you want backtrace foreach ($paths as $index => $path) { if (strpos($page['file'], $path) !== false) { $include = true; break; } } // Only log if no paths we defined, or we have a path match if ($include or empty($paths)) { $stacktrace[] = array('file' => \Fuel::clean_path($page['file']), 'line' => $page['line']); } } } $benchmark = \Profiler::start($this->_instance, $sql, $stacktrace); } // run the query. if the connection is lost, try 3 times to reconnect $attempts = 3; do { try { // try to run the query $result = $this->_connection->query($sql); break; } catch (\Exception $e) { // if failed and we have attempts left if ($attempts > 0) { // try reconnecting if it was a MySQL disconnected error if (strpos($e->getMessage(), '2006 MySQL') !== false) { $this->disconnect(); $this->connect(); } else { // other database error, cleanup the profiler isset($benchmark) and \Profiler::delete($benchmark); // and convert the exception in a database exception if (!is_numeric($error_code = $e->getCode())) { if ($this->_connection) { $error_code = $this->_connection->errorinfo(); $error_code = $error_code[1]; } else { $error_code = 0; } } throw new \Database_Exception($e->getMessage() . ' with query: "' . $sql . '"', $error_code, $e); } } else { // and convert the exception in a database exception if (!is_numeric($error_code = $e->getCode())) { if ($this->_connection) { $error_code = $this->_connection->errorinfo(); $error_code = $error_code[1]; } else { $error_code = 0; } } throw new \Database_Exception($e->getMessage() . ' with query: "' . $sql . '"', $error_code, $e); } } } while ($attempts-- > 0); if (isset($benchmark)) { \Profiler::stop($benchmark); } // Set the last query $this->last_query = $sql; if ($type === \DB::SELECT) { // Convert the result into an array, as PDOStatement::rowCount is not reliable if ($as_object === false) { $result = $result->fetchAll(\PDO::FETCH_ASSOC); } elseif (is_string($as_object)) { $result = $result->fetchAll(\PDO::FETCH_CLASS, $as_object); } else { $result = $result->fetchAll(\PDO::FETCH_CLASS, 'stdClass'); } // Return an iterator of results return new \Database_Result_Cached($result, $sql, $as_object); } elseif ($type === \DB::INSERT) { // Return a list of insert id and rows created return array($this->_connection->lastInsertId(), $result->rowCount()); } elseif ($type === \DB::UPDATE or $type === \DB::DELETE) { // Return the number of rows affected return $result->errorCode() === '00000' ? $result->rowCount() : -1; } return $result->errorCode() === '00000' ? true : false; }
<?php #date_default_timezone_set('RPC'); $dsn = "mysql:host=localhost;dbname=zero_php"; $pdo = new PDO($dsn, "root", "root"); #$result = $pdo->exec($sql); // 用于insert update delete $sql = "select * from zp_user order by uuid desc"; $result = $pdo->query($sql); // $userList = NULL; if (!$result) { $userList = $pdo->errorinfo(); } $userList = $pdo->query($sql); // 用于select include_once zeroPath('/pages/index.php'); exit; foreach ($userList as $user) { // var_dump($user); echo "username============>" . $user['user_name'] . "<br>"; echo "password============>" . $user['password'] . "<br>"; if ($user['sex'] == 0) { echo "sex============>女<br>"; } else { echo "sex============>男<br>"; } echo "age============>" . $user['age'] . "<br>"; echo "avatar============>" . $user['avatar'] . "<br>"; echo "login_time============>" . $user['time'] . "<br>"; echo "last_time============>" . $user['last_time'] . "<br>"; echo "login_ip============>" . $user['login_ip'] . "<br>"; echo "-------------------------------------------------------------------------------<br>";
} else { $action = strtoupper($_GET['action']); } switch ($action) { default: case 'LIST': // retrieve contacts and display as table (list) // build query $query = 'SELECT id, firstname, lastname, email FROM contacts'; // send query to server $results = $dbh->query($query); // check server result if ($results === false) { // query error echo '<p>Query error. No soup for you! *snap*</p>'; echo '<p>Error info: ' . $dbh->errorinfo()[2] . '</p>'; break; // terminate case } // process results if applicable $rowHTML = ''; $rowCount = 0; // loop through results while ($row = $results->fetch(PDO::FETCH_ASSOC)) { $rowCount++; $rowHTML .= '<tr>' . '<td>' . $row['id'] . '</td>' . '<td>' . $row['firstname'] . '</td>' . '<td>' . $row['lastname'] . '</td>' . '<td>' . $row['email'] . '</td>' . '</tr>'; } // while if ($rowCount > 0) { // build table echo '<table><tbody>' . $rowHTML . '</tbody></table>';