Ma premiere requete MySQLi
bonjour,
j'ai fait ma 1ere requete MySQLi en POO, ca marche pas, je ne me suis pas habitue a le faire:
Code:
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 31 32 33 34 35 36 37 38 39 40 41
|
<?php
include 'connect.php';
$mysqli = new mysqli($db_host, $db_user, $db_passwd);
if ($mysqli->connect_error) {
die('Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
}
$mysqli->set_charset("utf8");
$db = $mysqli->select_db($db_name);
$query = 'SELECT id_gp1, spg_name_ar FROM users_sgroups';
/* determine number of rows result set */
$row_cnt = $query->num_rows;
echo 'nbre: '.$row_cnt;
if ($stmt = $mysqli->prepare($query)) {
/* execute query */
$stmt->execute();
/* bind result variables */
$stmt->bind_result($id_gp1, $spg_name_ar);
/* fetch values */
while ($stmt->fetch()) {
echo $id_gp1l.'<br>';
echo $spg_name_ar.'<br>';
}
/* close statement */
$stmt->close();
}
$mysqli->close();
?> |
merci pour votre aide