[insert_php]
//page EXPERTREC
global $chemin;
global $wpdb;
global $table_experts;
if (empty($_GET[‘myvar’]))
{$myvar = ‘AER’;}
else
{$myvar = $_GET[‘myvar’];}
//echo ‘myvar=’ . $myvar . ‘
‘;
$sql = ‘SELECT ‘ . $table_experts . ‘.NE, ‘ . $table_experts . ‘.Nom, ‘ . $table_experts . ‘.Prenom ‘;
$sql = $sql . ‘FROM ‘ . $table_experts . ‘ ‘;
$sql = $sql . ‘WHERE (((‘ . $table_experts . ‘.Nom) LIKE « %’. $myvar .’% »))’;
$cpfexperts = $wpdb->get_results($sql);
$numcpfexperts = count($cpfexperts);
//echo ‘nombre cpf expert ‘ . $numcpfexperts . ‘
‘;
// on affiche le code CPF
echo ‘
‘;
if ($numcpfexperts > 0){
echo ‘
no such expert>‘; } [/insert_php] PHP Code Snippets Powered By : XYZScripts.com
|