Fatal error: Call to a member function fetch_all() on a non-object in C:\OpenServer\domains\fyuzyt.local\functions.php on line 41
Вот код:
PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- function SELECT($name){
- global $records;
- $connection = @new mysqli(DBHOST, DBUSER, DBPASS, DBNAME, DBPORT);
- }
- $connection->query('SET NAMES UTF-8');
- $sql = "SELECT `name`, `password`, `sex` FROM `users` WHERE `name` = ?";
- if($stmt = $connection->prepare($sql)){
- $stmt->bind_param('s', $name);
- $stmt->execute();
- $result = $connection->query($sql);
- while($records = $result->fetch_all(MYSQLI_ASSOC)){
- echo $records['id'];
- }
- $stmt->close();
- }
- $connection->close();
- }