1 2 3 4 5 6 7 8 9 10
|
$connection= mysqli_connect('localhost', 'utilisateur', 'motdepass', 'base_de_donnée');
$nom=$_POST["nom"];
mysqli_set_charset($connection,"utf8");//modification de jeu de caractère en utf8.
$sql_marequette = "SELECT * from `ma_table` WHERE Nom LIKE '%".mysqli_real_escape_string($connection,$nom)."%' ORDER BY Nationalite ASC, Nom ASC, Prenom ASC";
$qry_matable = mysqli_query($connection, $sql_marequette) or die ('Echec de la requete '.$sql_marequette' : '.mysqli_error($connection));
$matable_row = mysqli_fetch_array($qry_matable);
$num__matable = mysqli_num_rows($qry_matable);
mysqli_free_result($qry_matable );
mysqli_close($connection); |