1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
<?php
header("content-type: application/json; charset=utf-8");
// Version avec PDO
$conn = new PDO('mysql:host=localhost;dbname=**', '**', '****');
$currentTimestamp = time();
$lastTimestamp = (isset($_GET['lastTimestamp'])) ? $_GET['lastTimestamp'] : ($currentTimestamp-1);
if (!empty($_POST['pseudo']) && !empty($_POST['message']))
{
$sth->bindParam(":pseudo", $pseudo);
$sth->bindParam(":message", $message);
$sth->bindParam(":timestamp", $currentTimestamp); */
$sth->bindValue('pseudo', (stripslashes($_POST['pseudo'])),PDO::PARAM_STR);
//$sth->bindValue('message',$_POST['message'],PDO::PARAM_STR);PDO::PARAM_INT
$sth->bindValue('message',(stripslashes($_POST['message'])),PDO::PARAM_STR);
$sth->bindValue('timestamp',$currentTimestamp,PDO::PARAM_INT);
$sth->execute();
}
/* $sth = $conn->prepare("SELECT * FROM minichat WHERE timestamp > :lastTimestamp ORDER BY id DESC LIMIT 0,10");
//$sth = $conn->query("SET NAMES UTF8");
$sth = $conn->prepare("SELECT * FROM minichat WHERE timestamp > :lastTimestamp ORDER BY id DESC LIMIT 0,10");
$sth->bindParam(":lastTimestamp", $lastTimestamp);
$sth->execute();
$result_utf8 = $sth->fetchAll(PDO::FETCH_ASSOC);
if(count($result_utf8) > 0)
ini_set("zlib.output_compression", "On");
echo json_encode (htmlspecialchars(stripslashes($result_utf8)));
?> |
Partager