Привет!
Есть 3 файла (см. ниже).
В index.php я пытаюсь вызвать функции db() и data_selection().
Но в ответ получаю следующее:
| Цитата |
| Notice: Undefined variable: handler in /includes/functions.inc.php on line 11 Fatal error: Call to a member function query() on a non-object in /includes/functions.inc.php on line 11 |
<?php
error_reporting(E_ALL);
require 'includes/db_connect.inc.php';
require 'includes/functions.inc.php';
db();
data_selection();
foreach ($row as $key)
{
?>
<div id="author">
<?php echo $key['user']; ?>
</div>
<div id="message">
<?php echo $key['message']; ?>
</div>
<?php
}
?>
<?php
function db(){
try
{
$handler = new PDO('mysql:host=localhost;dbname=guestbook;charset=utf8', 'user', 'pass', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
$handler->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e)
{
echo $e->getMessage();
echo "Problem with DB";
die();
}
return $handler;
}
?>
<?php
function data_selection(){
$query = $handler->query('SELECT * FROM comments');
$row = $query->fetchAll(PDO::FETCH_ASSOC);
}
?>