Using prepared statements there is no fetch_array()
. Use mysqli_stmt::fetch()
instead or to fetch multiple records use mysqli_result::fetch_all()
Check the manual: mysqli_stmt::fetch() or mysqli_result::fetch_all()
More Related Contents:
- Save the data into a database and return another value from database using PHP
- Can I mix MySQL APIs in PHP?
- How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
- How to change mysql to mysqli?
- How to prevent duplicate usernames when people register?
- Best way to INSERT many values in mysqli?
- How to use mysqli prepared statements?
- MySQLi prepared statements error reporting [duplicate]
- Why is mysqli giving a “Commands out of sync” error?
- mysqli last insert id
- mysqli: can it prepare multiple queries in one statement?
- How to call a MySQL stored procedure from within PHP code?
- MySQLi count(*) always returns 1
- Warning: mysqli_connect(): (HY000/2002): No such file or directory
- Do I have to guard against SQL injection if I used a dropdown?
- Using Mysqli bind_param with date and time columns?
- Using MySQLi from another class in PHP
- How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
- PHP PDO and MySQLi [duplicate]
- PHP + MySql + Stored Procedures, how do I get access an “out” value?
- Unknown database error in PHP but it exists in PHPMyAdmin
- Can I blindly replace all mysql_ functions with mysqli_?
- Get number of rows matched by UPDATE query with PHP mysqli
- How to use mysqli_query() in PHP?
- How to run multiple insert query in SQL using PHP in one go?
- Using Prepared Statement, how I return the id of the inserted row?
- Strange problem with the length of the field gotten from database [duplicate]
- PHP prepared statements and transactions in a loop [duplicate]
- When should I close a database connection in PHP?
- Mysqli multiple row insert, simple multi insert query [duplicate]