MySQLi equivalent of mysql_result()?

by

The following function fully replicates the mysql_result() function, and returns false when you are out-of-bounds on your request (empty result, no row of that number, no column of that number). It does have the added benefit that, if you don’t specify the row, it assumes 0,0 (one less value to be passed). The function allows for the numerical offset of the field or the field name.

function mysqli_result($res,$row=0,$col=0){ 
    $numrows = mysqli_num_rows($res); 
    if ($numrows && $row <= ($numrows-1) && $row >=0){
        mysqli_data_seek($res,$row);
        $resrow = (is_numeric($col)) ? mysqli_fetch_row($res) : mysqli_fetch_assoc($res);
        if (isset($resrow[$col])){
            return $resrow[$col];
        }
    }
    return false;
}

More Related Contents:

  1. About how does mysqli_query() Function and mysqli_fetch_array($result) work?
  2. Can I mix MySQL APIs in PHP?
  3. How to change mysql to mysqli?
  4. Best way to INSERT many values in mysqli?
  5. Call to a member function bind_param() on a non-object [duplicate]
  6. MySQLi prepared statements error reporting [duplicate]
  7. mysqli last insert id
  8. mysqli: can it prepare multiple queries in one statement?
  9. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  10. MySQLi query returns only one row
  11. How to call a MySQL stored procedure from within PHP code?
  12. Converting MySQL result array to JSON [duplicate]
  13. Fatal error: Cannot use object of type mysqli_result [closed]
  14. Do I have to guard against SQL injection if I used a dropdown?
  15. Inserting data to table (mysqli insert) [duplicate]
  16. Using MySQLi from another class in PHP
  17. How to echo a MySQLi prepared statement?
  18. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  19. MySQLi prepared statements with IN operator [duplicate]
  20. MySQLI binding params using call_user_func_array
  21. Unknown database error in PHP but it exists in PHPMyAdmin
  22. Can I blindly replace all mysql_ functions with mysqli_?
  23. Is mysqli_real_escape_string safe?
  24. Call to undefined method mysqli_result::fetch()
  25. Which is fastest in PHP- MySQL or MySQLi?
  26. prepared parameterized query with PDO
  27. How to make mysqli connect function?
  28. Dynamically bind mysqli_stmt parameters and then bind result
  29. Check to see if an email is already in the database using prepared statements
  30. How to insert into MySQL using mysqli

Leave a Comment