Organizational Research By

Surprising Reserch Topic

why does this return resource id 2


why does this return resource id 2  using -'php,sql,mysql'


  Possible Duplicate:
¬†¬†How do i ‚Äúecho‚ÄĚ a ‚ÄúResource id #6‚ÄĚ from a MySql response in PHP? ¬†




I am new at php and SQL and I'm trying to make the php page list the numbers of enries in the table.
I'm using this code but it returns Resource id #2:

$rt=mysql_query("SELECT COUNT(*) FROM persons");
echo mysql_error();
echo "<h1>Number:</h1>".$rt;

    

asked Oct 6, 2015 by kotmus2002
0 votes
3 views



Related Hot Questions

5 Answers

0 votes

Because you get a mysql ressource when you do a mysql_query().

Use something like mysql_fetch_assoc() to get the next row. It returns an array with the column names as indices. In your case it's probably COUNT(*).

Here's a fix and some minor improvements of your snippet:

$rt = mysql_query("SELECT COUNT(*) FROM persons") or die(mysql_error());
$row = mysql_fetch_row($rt);
if($row)
    echo "

Number:

" . $row[0];

If you need to get all rows of the resultset use this snippet:

while($row = mysql_fetch_assoc($rt)) {
    var_dump($row);
}
answered Oct 6, 2015 by param.oncemore
0 votes

In PHP, resources are returned from certain functions so that they can be passed to other related functions. Examples include database connections, database query results, file-handles, etc.

According to the documentation on mysql_query(), a SELECT query returns a resource. You can take that resource and pass it to a number of different functions. To retrieve a count of the rows, you can use mysql_num_rows(), to retrieve the results of the query, you can use either mysql_fetch_array(), mysql_fetch_assoc() or mysql_fetch_object().

A normal pattern for dealing with database results will look something like this:

$result = mysql_query("SELECT * FROM persons"); // run query against database
$count = mysql_num_rows($result); // retrieve a count of the rows in the previous query
while ($row = mysql_fetch_assoc($result)) { // loop through all the rows in the resultset
    // use $row['column_name'] to access columns in your resultset
}

From your example above:

$result = mysql_query("SELECT COUNT(*) AS num FROM persons"); // run query against db
$row = mysql_fetch_assoc($result); // retrieve the 1 (and only) row
$count = $row['num']; // we needed to alias the COUNT(*) column as `num`
answered Oct 6, 2015 by okesh.badhiye
0 votes

mysql_query() doesn't return a value, it returns a resource (see here in the manual).

The returned result resource should be passed to another function for dealing with result tables (like mysql_fetch_array() or mysql_fetch_assoc()), to access the returned data.

Example based on your initial code:

$rt=mysql_query("SELECT COUNT(*) FROM persons");
while($row = mysql_fetch_assoc($rt)) {
  var_dump($row);
}
answered Oct 6, 2015 by sachin valanju
0 votes

Straight from PHP.net.......

"For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error."

answered Oct 6, 2015 by kotmus2002
0 votes

From the documentation on mysql_query:

For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.

answered Oct 6, 2015 by vibhorsingh

...