Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]

by

You are trying to print a mysql resource variable instead of the values contained within the resource it references. You must first try to extract the values you have gotten by using a function such as mysql_fetch_assoc().

You might also try mysql_fetch_array() or mysql_fetch_row(), but I find associative arrays quite nice as they allow you to access their values by the field name as in Mike’s example.

More Related Contents:

  1. Sign in form always showing "Wrong Credentials"
  2. Prevent creating duplicate entries in PHP
  3. i have stored array in database as a string how can retrieve that array?
  4. Insert array into MySQL database with PHP
  5. Sum values of multidimensional array by key without loop
  6. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  7. Save PHP array to MySQL?
  8. Notice: Array to string conversion in
  9. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  10. How get all values in a column using PHP?
  11. mysql select query within a serialized array
  12. PDO fetch one column from table into 1-dimensional array
  13. Get all mysql selected rows into an array
  14. Select from mysql table WHERE field=’$array’?
  15. MySQL query using an array [duplicate]
  16. How to insert json array into mysql database
  17. PHP/SQL Insert Error when using Named Placeholders
  18. Create PHP array from MySQL column
  19. Save array in mysql database
  20. MySQL PHP – SELECT WHERE id = array()? [duplicate]
  21. Create hyperlink from html table row to open record on a new page
  22. Modify array values in foreach loop
  23. SELECT COUNT(*) AS count – How to use this count
  24. How to upload images into MySQL database using PHP code
  25. Convert flat array to the multi-dimensional
  26. How to echo out table rows from the db (php)
  27. Using usort in php with a class private function
  28. MySQL statement takes more than minute to execute
  29. Using utf8mb4 with php and mysql
  30. How to write a stored procedure in phpMyAdmin?

Leave a Comment