- Function
used to retrieve the
next tuple from
the $result variable:
- mysqli_fetch_row ( $result ):
- The mysqli_fetch_row( )
function
returns the
next tuple
as an array
with integer indices
- If there are no more tuples, the mysqli_fetch_row( ) function returns NULL
- The mysqli_fetch_row( )
function
returns the
next tuple
as an array
with integer indices
- mysqli_fetch_row ( $result ):
- Syntax to retrieve
one row (= tuple) from the
result set:
$arrayVar = mysqli_fetch_row ( $result )
Returns: 1. 0 (= false) if there is an error 2. Otherwise, an array containing the next tuple in the result set $arrayVar[0] = value of the first attribute $arrayVar[1] = value of the second attribute ... $arrayVar[ count($arrayVar)-1 ] = value of the last attribute
- Example:
- Suppose we
execute the
following query:
select fname, lname, salary from employeeAnd the selected tuples is as follows:
+--------+---------+----------+ | John | Smith | 30000.00 | | Frankl | Wong | 40000.00 | | Alicia | Zelaya | 25000.00 | | Jennif | Wallace | 43000.00 | | Ramesh | Narayan | 38000.00 | | Joyce | English | 25000.00 | | Ahmad | Jabbar | 25000.00 | | James | Borg | 55000.00 | +--------+---------+----------+Then:
- After executing
$row = mysqli_fetch_row
( $result ),
we will have:
$row(0) = "John" $row(1) = "Smith" $row(2) = 30000.00
- After executing
$row = mysqli_fetch_row
( $result )
another time,
we will have:
$row(0) = "Frankl" $row(1) = "Wong" $row(2) = 40000.00
And so on....
- After executing
$row = mysqli_fetch_row
( $result ),
we will have:
- Suppose we
execute the
following query:
- Example of
some code that
prints the
attribute values (value)
in the entire result set:
($result is the output of mysqli_query( ) I.e.: $result = mysqli_query( $conn, "SQL-command" )
while ( ($row = mysqli_fetch_row( $result )) != NULL ) { /* ================================================ $row is an array !!! =============================================== */ for ( $i = 0; $i < count($row); $i++ ) { print ( $row[$i] ); } print("================"); }
- Example:
our first
(incomplete)
PHP program to access
the MySQL Database server:
<?php # -------------------------------- # 1. Connect and select DB #--------------------------------- $conn = mysqli_connect("holland.mathcs.emory.edu", "cs377", "abc123", "companyDB"); if ( mysqli_connect_errno( ) != 0 ) { /* ----------------------------------------- Error code > 0 means there was an error ----------------------------------------- */ printf("Connect failed: %s\n", mysqli_connect_error()); exit(1); } # -------------------------------- # 2. Execute a query # -------------------------------- $query = 'select fname, lname, salary from employee'; if ( ( $result = mysqli_query($conn, $query) ) == NULL ) { printf("Error: %s\n", mysqli_error($conn)); exit(1); } # -------------------------------- # 3. Fetch the tuples # -------------------------------- while ( ( $row = mysqli_fetch_row( $result ) ) != NULL ) { for ( $i = 0; $i < count($row); $i++ ) { printf($row[$i] . "\t"); // \t is TAB to make output "pretty" } print("\n"); } # NOTE: We must still: # # 1. free resource and # 2. close connection # # This will be discussed LATER ! ?>Sample output: ('select fname, lname, salary from employee')
John Smith 30000.00 Frankl Wong 40000.00 Alicia Zelaya 25000.00 Jennif Wallace 43000.00 Ramesh Narayan 38000.00 Joyce English 25000.00 Ahmad Jabbar 25000.00 James Borg 55000.00
- Example Program:
(Demo above code)
Login to holland.mathcs.emory.edu Run: php /home/cs377001/PHP/intro-PHP/employee.php Also, try this version that prints $result and $row using print_r( ): php /home/cs377001/PHP/intro-PHP/employee1.php