PHP Client::escape_string Examples

Example #1

File: recherche.php Project: anti-conformiste/thelia1

    ?>

<div class="entete_general">
	<div class="titre">RESULTATS CLIENT</div>
</div>
<ul id="Nav">
		<li style="width:160px;">N&deg; de client</li>
		<li style="width:200px; border-left:1px solid #96A8B5;">Nom</li>
		<li style="width:200px; border-left:1px solid #96A8B5;">Prénom</li>
		<li style="width:305px; border-left:1px solid #96A8B5;">E-mail</li>
		<li style="width:50px; border-left:1px solid #96A8B5;">&nbsp;</li>
</ul>
    <?php 
    $i = 0;
    $client = new Client();
    $motcle = $client->escape_string(trim($motcle));
    $search = "and nom like \"%{$motcle}%\" or prenom like \"%{$motcle}%\" or ville like \"%{$motcle}%\" or email like \"%{$motcle}%\"";
    $query = "select * from {$client->table} where 1 {$search}";
    $cliresul = mysql_query($query, $client->link);
    $clilist = "";
    while ($row = mysql_fetch_object($cliresul)) {
        $clilist .= "'{$row->id}', ";
        if (!($i % 2)) {
            $fond = "ligne_claire_rub";
        } else {
            $fond = "ligne_fonce_rub";
        }
        $i++;
        ?>
  	<ul class="<?php 
        echo $fond;