1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| try {
$user="root";
$pass="";
$dsn = 'mysql:host=inscription.mysql.db; dbname=inscription.command;charset=latin1_swedish_ci';
$dbh = new PDO($dsn, '$user' , '$password');
foreach ($data as $key => $value) {
$n = count($data[$key]);
$nb=$dbh->query("SELECT count(*) FROM `wp_bookly_customers`")->fetchColumn();
for ($i=0; $i <$n ; $i++) {
$search=$value[$i]['OperationCaisseID'];
//Selection, execution et recuperation des données
$user = $dbh->query("SELECT id, search_id FROM `wp_bookly_customers` WHERE search_id like '$search'")->fetchAll();
// Pour afficher les resultats de la recherche
foreach ($user as $cle => $row) {
if($row['id'] != $search){
echo $i.' '.$search."<br>";
}
}
}
}
} catch (Exception $e) {
echo $e;
exit();
} |
Partager