Ranije sam se konektovao sa
db.php
<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "root";
$mysql_database = "messages";
$prefix = "";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Error");
mysql_select_db($mysql_database, $bd) or die("Eror");
?>
a dio koda koji treba za paginaciju izgleda ovako
load_data.php
$query_pag_data = "SELECT msg_id,message from messages LIMIT $start, $per_page";
$result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());
$msg = "";
while ($row = mysql_fetch_array($result_pag_data)) {
$htmlmsg=htmlentities($row['message']);
$msg .= "<li></b> " . $htmlmsg . "</li>";
}
$msg = "<div class='data'><ul>" . $msg . "</ul></div>"; // Content for Data
/* --------------------------------------------- */
$query_pag_num = "SELECT COUNT(*) AS count FROM messages";
$result_pag_num = mysql_query($query_pag_num);
$row = mysql_fetch_array($result_pag_num);
$count = $row['count'];
$no_of_paginations = ceil($count / $per_page);
i ovo je radilo odlično.
E sad sam ja promenio konekciju
db_novo.php
<?php
$prefix = "";
try {
$pdo = new PDO('mysql:host=localhost;dbname=messages', 'root', 'root');
} catch (PDOException $e){
exit('Datebase error.');
}
?>
i javlja mi grešku jer ne uspevam da prepravim load_data.php
load_data_novo.php
$query = $pdo->prepare("SELECT msg_id,message from messages LIMIT $start, $per_page");
$query->bindValue(1, $message);
$msg = "";
while ($row = mysql_fetch_array($result_pag_data)) {
$htmlmsg=htmlentities($row['message']);
$msg .= "<li></b> " . $htmlmsg . "</li>";
}
$msg = "<div class='data'><ul>" . $msg . "</ul></div>"; // Podaci
/* --------------------------------------------- */
$query = $pdo->prepare("SELECT COUNT(*) AS count FROM messages");
$query->bindValue(1, $row);
$count = $row['count'];
$no_of_paginations = ceil($count / $per_page);
Verovatno da u load_data_novo.php ništa nije tačno pa ako može neko da mi kaže šta da uradim...
[Ovu poruku je menjao -Godfather- dana 03.07.2013. u 21:12 GMT+1]