Forum

<?php
/**
 * smallads.php
 * $Id: smallads.php 18 2012-11-11 19:36:17Z alain091@gmail.com $
 *
 * @author         alain91
 * @copyright      (C) 2008-2012 Alain Gandon
 * @email          alain091@gmail.com
 * @license        GPL version 2
 */
defined('PATH_TO_ROOT') OR define('PATH_TO_ROOT','..');
require_once(PATH_TO_ROOT.'/kernel/begin.php');
require_once(PATH_TO_ROOT.'/smallads/smallads_begin.php');
require_once(PATH_TO_ROOT.'/smallads/smallads.class.php');
require_once(PATH_TO_ROOT.'/kernel/header.php');
$req = new PDO('mysql:host=localhost;dbname=phpboost', 'root', '');
 
$sql = mysql_query("SELECT * FROM phpboost_smallads WHERE id_created='".mysql_real_escape_string(@$_GET['id'])."'");
if(mysql_num_rows($sql) > 0)
{
    $sql = mysql_fetch_assoc($sql);
    /*
Affichage des ventes
    */
$picture = $sql['picture'];
$title = $sql['title'];
$price = $sql['price'];
echo "<img src='/smallads/pics/$picture' ><a href=/smallads/smallads.php?id=".$sql['id']."'>$title</a> pour $price €";
}
else
{
    echo "Ce vendeur n'a publier aucunes petites annonce.";
}
?>