annotate tb.php @ 81:e4e50d4d3b7a

DataAccess: Passage en mysqli
author Franck Deroche <franck@defr.org>
date Tue, 20 Nov 2018 00:53:47 +0100
parents e43b756548b4
children
rev   line source
webmaster@0 1 <?php
webmaster@0 2 header("Content-Type: text/xml");
webmaster@0 3 echo("<?xml version='1.0' encoding='utf-8'?>");
webmaster@65 4 require_once("classes.php");
webmaster@65 5 $Req = new Requete();
webmaster@0 6 $id = $_GET['id'];
webmaster@0 7 $Data->Query("SELECT * FROM Messages WHERE num_mess=$id");
webmaster@0 8 $post_infos = $Data->GetRow();
webmaster@65 9 $titre = $Req->Get('title', 'POST', 'Undefined');
webmaster@65 10 $url = $Req->Get('url', 'POST', '#');
webmaster@65 11 $info = $Req->Get('__info', 'POST', -1);
webmaster@0 12 if($info == 1) {
webmaster@0 13 $error = 0;
webmaster@0 14 $message = "Some informations";
webmaster@0 15 } else if($url == "#") {
webmaster@0 16 $error = 1;
webmaster@0 17 $message = "The url field is needed for trackback to do something usefull !";
webmaster@0 18 } else if($post_infos === 0) {
webmaster@0 19 $error = 1;
webmaster@0 20 $message = "There's no post with this id";
webmaster@0 21 } else {
webmaster@0 22 $excerpt = $_POST['excerpt'];
webmaster@0 23 $DateComment = gmdate("Y-m-d H:i:s");
webmaster@0 24 if(strlen($excerpt) > 255) $excerpt = substr($excerpt, 0, 255) . "...";
webmaster@0 25 $Data = new DataAccess();
webmaster@0 26 $Data->Query("INSERT INTO Commentaires(MessId, Auteur, Adresse, Comment, DateComment, isTrackback)
webmaster@0 27 VALUES({$id}, '{$titre}', '{$url}', '{$excerpt}', '{$DateComment}', 1)");
webmaster@0 28 $Data->Query("UPDATE Mess SET NbCommentaires=NbCommentaires+1 WHERE num_mess={$id}");
webmaster@0 29 $error = 0;
webmaster@0 30 $excerpt = htmlentities(urlencode(substr(strip_tags($post_infos['Message']), 0, 252) . "...")
webmaster@0 31 }
webmaster@0 32
webmaster@0 33 echo "<response>
webmaster@0 34 <error>$error</error>
webmaster@0 35 <message>$message</message>
webmaster@0 36 <engine>Dual Blog custom made PHP script</engine>
webmaster@0 37 <encoding>UTF-8</encoding>
webmaster@0 38 <blog>Dual Blog</blog>
webmaster@0 39 <title>{$post_infos['Titre']}</title>
webmaster@73 40 <url>" . BLOG_URL . "/posts/{$post_infos['num_mess']}</url>
webmaster@0 41 <excerpt>$excerpt</excerpt>
webmaster@0 42 </response>";
webmaster@0 43 ?>