Menu
Community /Pin to ProfileBookmark
@NogDogJan 17.2018 — #mysqli_query() does not return a value or even a result row. For a select query, it either returns a mysqli_result object, or false if there was some error. So you could do something like:
@NogDogJan 18.2018 — #The result row is an array, but since you only selected one field, it's an array with only one element, thus the zeroth element of that array.
The PDO database extension has a fetchColumn() method which makes it simpler in that sort of case (only need that one method call to get that one column), but it does not appear that the mysqli_result object has the same sort of thing, so it takes that extra step to actually grab the value of interest.
. @NogDogJan 18.2018 — #Not saying you have to use PDO -- though personally I prefer it. ? I find it a bit cleaner to use, along with the benefit that you can generally use the same code flow/methods regardless of whether you use MySQL or any other supported DBMS. (I happen to use PostgreSQL a lot.) One step at a time is fine, however. ?
Get a result date from sql with php?
hi, i have a date on mysqli and i am tryying to get it with php with this code
[code=php]
$queryt = mysqli_query($link,”SELECT mest FROM inventario WHERE user = ‘$id'”);
but this dont return nothing, then i used a fetch arrayy but just returned the word “array” someone know the function for get the result of a date on mysqli ?
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogJan 17.2018 — #mysqli_query() does not return a value or even a result row. For a select query, it either returns a mysqli_result object, or false if there was some error. So you could do something like:[code=php]
$result = mysqli_query($link,"SELECT mest FROM inventario WHERE user = '$id'");
if($result == false) {
error_log(mysqli_error($link));
die("DB error, error message logged");
}
if(($row = mysqli_fetch_row($result)) != false) {
$queryt = $row[0];
}
else {
// whatever you want to do if no match was found
}
[/code]0
@NogDogJan 18.2018 — #The PDO database extension has a fetchColumn() method which makes it simpler in that sort of case (only need that one method call to get that one column), but it does not appear that the mysqli_result object has the same sort of thing, so it takes that extra step to actually grab the value of interest.
.
0
@NogDogJan 18.2018 — #Not saying you have to use PDO -- though personally I prefer it. ? I find it a bit cleaner to use, along with the benefit that you can generally use the same code flow/methods regardless of whether you use MySQL or any other supported DBMS. (I happen to use PostgreSQL a lot.) One step at a time is fine, however. ?