trunk/app/findArchitecte.php

<?php
/**
 * Ce script a pour objet de recuperer la liste des pétionnaires correspondant aux critères de recherche
 *
 * @package openfoncier
 * @version SVN : $Id: findArchitecte.php 4418 2015-02-24 17:30:28Z tbenita $
 */

require_once "../obj/utils.class.php";
$f = new utils("nohtml");
$f->isAccredited(array("donnees_techniques","donnees_techniques_modifier","donnees_techniques_ajouter"), "OR");
//Récupération des valeurs envoyées
$f->set_submitted_value();
// Donnees
$nom = ($f->get_submitted_post_value("nom") != null) ? $f->get_submitted_post_value("nom") : "";
$nom = str_replace('*', '', $nom);
$nom = html_entity_decode($nom, ENT_QUOTES);
$nom = $f->db->escapeSimple($nom);

$prenom = ($f->get_submitted_post_value("prenom") != null) ? $f->get_submitted_post_value("prenom") : "";
$prenom = str_replace('*', '', $prenom);
$prenom = html_entity_decode($prenom, ENT_QUOTES);
$prenom = $f->db->escapeSimple($prenom);

$listData = "";

$f->disableLog();

$requete = "frequent is TRUE AND";
if($nom != "") {
    $requete .= " nom ILIKE '%$nom%'";
    $requete .= " AND";
}
if($prenom != "") {
    $requete .= " prenom ILIKE '%$prenom%'";
    $requete .= " AND";
}

$requete = substr($requete, 0, (strlen($requete)-4));

$sql = 
    "SELECT 
        architecte as value,".
        "trim(concat(nom,' ', prenom, ' ', ".
        " cp, ' ', ville)) as content ".
    "FROM ".DB_PREFIXE."architecte WHERE ".$requete;

$res = $f->db->query($sql);
$f->isDatabaseError($res);
$listData=array();
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
    $listData[] = $row;
}

echo json_encode($listData);

?>
1	mbroquet	3730	<?php
2			/**
3			* Ce script a pour objet de recuperer la liste des pétionnaires correspondant aux critères de recherche
4			*
5			* @package openfoncier
6			* @version SVN : $Id: findArchitecte.php 4418 2015-02-24 17:30:28Z tbenita $
7			*/
8
9			require_once "../obj/utils.class.php";
10			$f = new utils("nohtml");
11			$f->isAccredited(array("donnees_techniques","donnees_techniques_modifier","donnees_techniques_ajouter"), "OR");
12			//Récupération des valeurs envoyées
13			$f->set_submitted_value();
14			// Donnees
15			$nom = ($f->get_submitted_post_value("nom") != null) ? $f->get_submitted_post_value("nom") : "";
16	fmichon	3892	$nom = str_replace('*', '', $nom);
17	softime	7996	$nom = html_entity_decode($nom, ENT_QUOTES);
18	softime	6929	$nom = $f->db->escapeSimple($nom);
19	fmichon	3892
20	mbroquet	3730	$prenom = ($f->get_submitted_post_value("prenom") != null) ? $f->get_submitted_post_value("prenom") : "";
21	fmichon	3892	$prenom = str_replace('*', '', $prenom);
22	softime	7996	$prenom = html_entity_decode($prenom, ENT_QUOTES);
23	softime	6929	$prenom = $f->db->escapeSimple($prenom);
24	fmichon	3892
25	mbroquet	3730	$listData = "";
26
27			$f->disableLog();
28
29			$requete = "frequent is TRUE AND";
30			if($nom != "") {
31	softime	6929	$requete .= " nom ILIKE '%$nom%'";
32	mbroquet	3730	$requete .= " AND";
33			}
34			if($prenom != "") {
35	softime	6929	$requete .= " prenom ILIKE '%$prenom%'";
36	mbroquet	3730	$requete .= " AND";
37			}
38
39			$requete = substr($requete, 0, (strlen($requete)-4));
40
41			$sql =
42			"SELECT
43			architecte as value,".
44			"trim(concat(nom,' ', prenom, ' ', ".
45			" cp, ' ', ville)) as content ".
46			"FROM ".DB_PREFIXE."architecte WHERE ".$requete;
47
48			$res = $f->db->query($sql);
49			$f->isDatabaseError($res);
50			$listData=array();
51			while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
52			$listData[] = $row;
53			}
54
55			echo json_encode($listData);
56
57			?>