/**
* 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>';
