- PHP Basics
- PHP Home
- PHP Environment Setup
- PHP Getting Started
- PHP Basic Syntax
- PHP echo
- PHP print
- PHP echo Vs print
- PHP Comments
- PHP Data Types
- PHP Variables
- PHP Variable Scope
- PHP gettype()
- PHP Constants
- PHP Operators
- PHP Program Control
- PHP Decision Making
- PHP if-elseif-else
- PHP switch
- PHP Loops
- PHP for Loop
- PHP while Loop
- PHP do-while Loop
- PHP foreach Loop
- PHP break & continue
- PHP Popular Topics
- PHP Arrays
- PHP print_r()
- PHP Strings
- PHP Functions
- PHP References
- PHP Object Oriented
- PHP Object Oriented
- PHP Classes & Objects
- PHP Member Variable
- PHP Member Function
- PHP Encapsulation
- PHP Data Abstraction
- PHP Inheritance
- PHP Constructor Destructor
- PHP Polymorphism
- PHP Web Developments
- PHP Web Developments
- PHP GET & POST
- PHP Read Requested Data
- PHP File Handling (I/O)
- PHP File Handling (I/O)
- PHP fopen() | Open File
- PHP Create a File
- PHP fwrite() | Write to File
- PHP fread() | Read File
- PHP feof()
- PHP fgetc()
- PHP fgets()
- PHP fclose() | Close File
- PHP unlink() | Delete File
- PHP Append to File
- PHP copy() | Copy File
- PHP file_get_contents()
- PHP file_put_contents()
- PHP file_exists()
- PHP filesize()
- PHP rename() | Rename File
- PHP fseek()
- PHP ftell()
- PHP rewind()
- PHP disk_free_space()
- PHP disk_total_space()
- PHP mkdir() | Create Directory
- PHP rmdir() | Remove Directory
- PHP glob() | Get Files/Directories
- PHP basename() | Get filename
- PHP dirname() | Get Path
- PHP filemtime()
- PHP file()
- PHP Advanced
- PHP Cookies
- PHP Sessions
- PHP Send Emails
- PHP Serialization
- PHP Namespaces
- PHP File Upload
- PHP Date and Time
- PHP Image Processing
- PHP Regular Expression
- PHP Predefined Variables
- PHP Error Handling
- PHP Debugging
- PHP and MySQLi Tutorial
- PHP and MySQLi Home
- PHP MySQLi Setup
- PHP MySQLi Create DB
- PHP MySQLi Create Table
- PHP MySQLi Connect to DB
- PHP MySQLi Insert Record
- PHP MySQLi Fetch Record
- PHP MySQLi Update Record
- PHP MySQLi Delete Record
- PHP MySQLi SignUp Page
- PHP MySQLi LogIn Page
- PHP MySQLi Store User Data
- PHP MySQLi Close Connection
- PHP connect_errno
- PHP connect_error
- PHP query()
- PHP fetch_row()
- PHP fetch_assoc()
- PHP fetch_array()
- PHP free_result()
- PHP error
- PHP prepare()
- PHP bind_param()
- PHP execute()
- PHP fetch()
- PHP store_result()
- PHP num_rows
- PHP bind_result()
- PHP get_result()
- PHP mysqli_result Class
- PHP Error Constants
- PHP mysqli_driver()
- PHP Misc
- PHP error_reporting()
- PHP Escape Special Characters
- PHP htmlspecialchars()
- PHP new
- PHP header()
- PHP getallheaders()
- PHP empty()
- PHP isset()
- PHP unset()
- PHP exit()
- PHP exit Vs break
- PHP include()
- PHP require()
- PHP include() Vs require()
- PHP AJAX & XML
- PHP AJAX
- PHP XML
- PHP File Handling Functions
- PHP abs()
- PHP Test
- PHP Online Test
- Give Online Test
- All Test List
PHP fetch() and mysqli_stmt_fetch()
This article is created to cover the two functions of PHP, that are:
- fetch()
- mysqli_stmt_fetch()
Both functions are used to fetch results from a prepared statement into bound variables. The only difference is, the fetch() is used with PHP MySQLi object-oriented script, whereas the mysqli_stmt_fetch() is used with PHP MySQLi procedural script.
PHP fetch()
The PHP fetch() function is used to fetch results from a prepared statement into bound variables, in PHP MySQLi object-oriented style. For example:
<?php $conn = new mysqli("localhost", "root", "", "codescracker"); if(!$conn->connect_errno) { $stmt = $conn->prepare("SELECT name, age FROM customer"); $stmt->execute(); $stmt->bind_result($x, $y); while($stmt->fetch()) { echo "Name: ", $x, "<BR>"; echo "Age: ", $y, "<HR>"; } } $conn->close(); ?>
The output produced by above PHP example on fetch() function, is shown in the snapshot given below:
That is, the result fetched into the bound variables, that are $x and $y.
Note - The mysqli() is used to open a connection to the MySQL database server, in object-oriented style.
Note - The new keyword is used to create a new object.
Note - The connect_errno is used to get/return the error code (if any) from last connect call, in object-oriented style.
Note - The prepare() is used to prepare an SQL statement before its execution on the MySQL database, in object-oriented style, to avoid SQL injection.
Note - The execute() is used to execute a prepared statement on the MySQL database, in object-oriented style.
Note - The bind_result() is used to bind variables to a prepared statement for result storage, in object-oriented style.
Note - The close() is used to close an opened connection, in object-oriented style.
PHP fetch() Syntax
The syntax of fetch() function in PHP, is:
$mysqli_stmt -> fetch()
PHP mysqli_stmt_fetch()
The PHP mysqli_stmt_fetch() function is used to fetch results from a prepared statement into bound variables, in PHP MySQLi procedural style. For example:
<?php $conn = mysqli_connect("localhost", "root", "", "codescracker"); if(!mysqli_connect_errno()) { $stmt = mysqli_prepare($conn, "SELECT name, age FROM customer"); mysqli_stmt_execute($stmt); mysqli_stmt_bind_result($stmt, $x, $y); while(mysqli_stmt_fetch($stmt)) { echo "Name: ", $x, "<BR>"; echo "Age: ", $y, "<HR>"; } } mysqli_close($conn); ?>
Note - The mysqli_connect() is used to open a connection to the MySQL database server, in procedural style.
Note - The mysqli_connect_errno() is used to get/return the error code (if any) from last connect call, in procedural style.
Note - The mysqli_prepare() is used to prepare an SQL statement before its execution on the MySQL database, in procedural style, to avoid SQL injection.
Note - The mysqli_stmt_execute() is used to execute a prepared statement on the MySQL database, in procedural style.
Note - The mysqli_stmt_bind_result() is used to bind variables to a prepared statement for result storage, in procedural style.
Note - The mysqli_close() is used to close an opened connection to the MySQL database, in procedural style.
PHP mysqli_stmt_fetch() Syntax
The syntax of mysqli_stmt_fetch() function in PHP, is:
mysqli_stmt_fetch($mysqli_stmt)
« Previous Tutorial Next Tutorial »
Like/Share Us on Facebook 😋