Menu
Community /Pin to ProfileBookmark
@NogDogFeb 20.2018 — #That means that the database itself was not happy with the query you sent it, so it returned an error. As a result, mysqli_query() returned a Boolean false instead of a mysqli_result object. Therefore, you need to add some debugging in order to figure out what went wrong, e.g.:
My guess is that you'll find out it's a quoting problem. Also, you should escape any values being injected into your query:
My preferred approach would be to use prepared statements with bound parameters, removing the need to do the escape-string stuff (using object-oriented syntax):http://php.net/manual/en/mysqli.prepare.php
_
mysqli frustration mysqli_fetch_assoc
I have been struggling with this all morning, perhaps someone help me with this.
[code=php]
if (isset($_GET[‘confirmPlayer’]) === true) {
$name = $_POST[‘name’];
$pass = $_POST[‘pass’];
$result = mysqli_query($link, ‘SELECT * FROM player WHERE name = ‘.$name.’ & pass = ‘.$pass.”);
$row = mysqli_fetch_assoc($result);
print_r($row);
if ($row === true) {
echo ‘true’;
} else{
echo ‘false’;
}
}
more specifically line 60
[code=php]
$row = mysqli_fetch_assoc($result);
[QUOTE]
<b>Warning</b>: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in <b>C:xampphtdocsmessenger.php</b> on line <b>60</b><br />
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogFeb 20.2018 — #That means that the database itself was not happy with the query you sent it, so it returned an error. As a result, mysqli_query() returned a Boolean false instead of a mysqli_result object. Therefore, you need to add some debugging in order to figure out what went wrong, e.g.:[code=php]
if($result == false) {
error_log(mysqli_error($link);
die("DB error, data logged");
}
[/code]My guess is that you'll find out it's a quoting problem. Also, you should escape any values being injected into your query:
[code=php]
$sql = "SELECT * FROM player WHERE name = '" . mysqli_real_escape_string($name) . "'";
$result = mysqli_query($link, $sql);
if($result == false) {
error_log(mysqli_error($link)."n$sql");
die("DB query failed, error logged!");
}
[/code]My preferred approach would be to use prepared statements with bound parameters, removing the need to do the escape-string stuff (using object-oriented syntax):
_