Bonjour j'ai 1 probleme Extraction table en php | Fonctione avec phpmyadmin et mysql -u root -p ligne de commande .
Create connection $conn = new mysqli($servername, $username, $password, $dbname); Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }
$sql = "SELECT * FROM `markers`" ; $result = mysqli_query>($sql);
if ($conn->query($sql) === TRUE) { echo "<!---- Location Extract to Marker table.----!>"; } else { echo "Error Extract to Marker table: " . $conn->error; }
var_dump($result,$conn); var_dump($rows); ?>
******************************** Resultat
Error Extract to Marker table: bool(true) object(mysqli)#3 (19) { ["affected_rows"]=> int(1) ["client_info"]=> string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $" ["client_version"]=> int(50012) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(10) ["host_info"]=> string(25) "localhost:3306 via TCP/IP" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(30) "5.5.5-10.1.37-MariaDB-0+deb9u1" ["server_version"]=> int(50505) ["stat"]=> string(138) "Uptime: 596313 Threads: 1 Questions: 60908 Slow queries: 0 Opens: 204 Flush tables: 1 Open tables: 98 Queries per second avg: 0.102" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(8856) ["warning_count"]=> int(0) } NULL