Error Resource Id #3 En Php
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the resource id #4 error in php company Business Learn more about hiring developers or posting ads with us Stack Overflow php mysql resource id #3 Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 resource id #5 php mysql million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Getting Resource id #3 Error in MySql up vote 3 down vote favorite 1 I ran this code and I resource id 8 php mysql got a Resource id #3 error where it should have showed the full movies table. mysql_connect("localhost", "root", "password") or die(mysql_error()); mysql_select_db("treehouse_movie_db") or die(mysql_error()); $data = mysql_query("SELECT * FROM movies") or die(mysql_error()); echo $data; php mysql database echo share|improve this question asked Jul 2 '13 at 4:16 user2533901 16112 Possible duplicate: stackoverflow.com/questions/17385404 –Thomas Kelley Jul 2 '13 at 4:19 add a comment| 2 Answers 2 active oldest votes up vote 8 down
Resource Id Sql
vote This is not an error Your query is getting executed and you are getting appropriate resource from mysql_query() as it should be returned. To get the response you have to use mysql_fetch_array() or mysql_fetch_assoc() mysql_connect("localhost", "root", "password") or die(mysql_error()); mysql_select_db("treehouse_movie_db") or die(mysql_error()); $data = mysql_query("SELECT * FROM movies") or die(mysql_error()); while($row = mysql_fetch_assoc($data)) { print_r($row); } SUGGESTION: mysql_* are no longer maintained .Try switching to mysqli_* or PDO share|improve this answer edited May 8 '15 at 16:13 Fred -ii- 69.4k93973 answered Jul 2 '13 at 4:20 alwaysLearn 4,03421548 +1 to you for a compelete and clear answer. –ncm Jul 2 '13 at 4:28 add a comment| up vote 0 down vote You're not getting an error, the MySQL API is just doing what you're asking it to: echoing the contents of $data, which is a MySQL query resource at this point. Extend the code to actually retrieve the results: while($row = mysql_fetch_object($data)) var_dump($row); And you'll see the output. Note that the mysql_* API is deprecated since PHP 5.5 by the way. share|improve this answer answered Jul 2 '13 at 4:18 Niels Keurentjes 26.9k53987 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post a
#3 error (was "Who can help with this one?") The SitePoint
Resource Id #3 Fopen
Forums have moved. You can now find them here. resource(3) of type (mysql result) This forum is now closed to new posts, but you can browse existing content. You php resource id #4 can find out more information about the move and how to open a new account (if necessary) here. If you get stuck you can http://stackoverflow.com/questions/17417308/getting-resource-id-3-error-in-mysql get support by emailing forums@sitepoint.com If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want http://www.sitepoint.com/forums/showthread.php?404526-Resource-id-3-error-(was-quot-Who-can-help-with-this-one-quot-) to visit from the selection below. SitePoint Sponsor User Tag List Results 1 to 10 of 10 Thread: Resource id #3 error (was "Who can help with this one?") Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jul 18, 2006,05:06 #1 Jenser View Profile View Forum Posts SitePoint Member Join Date Jul 2006 Posts 13 Mentioned 0 Post(s) Tagged 0 Thread(s) Resource id #3 error (was "Who can help with this one?") Hi, I'm a beginner to PHP.The following script is based on a book by Kevin Yank. I've tried to modify it a bit,though unfortunately unsuccessful: PHP Code: Detected You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access https://forums.phpfreaks.com/topic/137145-resource-id-3-error/ full functionality. Resource ID #3 error Started by kigroy, Dec 16 2008 03:17 AM Please log in to reply 2 replies to this topic #1 kigroy kigroy Advanced http://lists.mysql.com/mysql/195677 Member Members 32 posts Posted 16 December 2008 - 03:17 AM I get the resource ID #3 error when I run this code: In my header tags: resource id In my body tags: My server is WAMPSERVER 2.0 and my php running is 5.2.7. Thoughts? Thanks Back to top #2 rhodesa rhodesa Advanced Member Staff Alumni 5,254 posts LocationBoston, MA Posted 16 December 2008 - 03:19 AM you need to fetch a row from the result... Aaron RhodesPHP Developer Back to top #3 kigroy kigroy Advanced Member Members 32 posts Posted 16 December 2008 - 03:25 AM Thanks! Worked like a charm. BTW, I'm a noob if you haven't figured it out. Back to top Back to PHP Coding Help · Next Unread Topic → 0 user(s) are reading this topic 0 members, 0 guests, 0 anonymous users Reply to quoted pos Hi, This is more a question of how to use php, so perhaps this page may be of more use http://us2.php.net/manual/en/function.mysql-query.php It gives a good explanation there of how the SELECT statement will return the resource number on success, if you wish to access the data returned, you need to use one of several other functions eg. mysql_fetch_array etc. In other words, your query worked fine, you just haven't accessed the data returned yet. http://www.php.net is a valuable resource on how to use this fine language. Regards --------------------------------------------------------------- ********** _/ ********** David Logan ******* _/ ******* ITO Delivery Specialist - Database ***** _/ ***** Hewlett-Packard Australia Ltd **** _/_/_/ _/_/_/ **** E-Mail: david.logan@stripped **** _/ _/ _/ _/ **** Desk: +618 8408 4273 **** _/ _/ _/_/_/ **** Mobile: 0417 268 665 ***** _/ ****** ****** _/ ******** Postal: 148 Frome Street, ******** _/ ********** Adelaide SA 5001 Australia i n v e n t --------------------------------------------------------------- -----Original Message----- From: Pat Adams [mailto:pat@stripped] Sent: Sunday, 12 March 2006 4:45 PM To: Mysql Subject: Re: mysql_query gives Resource id #3 error On Sat, 2006-03-11 at 12:53 -0500, fbsd_user wrote: > $sql = "SELECT logon_id > FROM members > WHERE logon_id = '$logonid' AND logon_pw = > '$logonpw'"; > > $result = mysql_query($sql) or die('Query failed. ' . > mysql_error()); > > print "$result"; shows Resource id #3 > > Where can I find meaning for what this means? > > And why does mysql_error() not contain the description of this > error? > > And why was the 'or die' condition not taken? Try print($result[0]) or print($result['logon_id']); $result is a handle to the result set, not something you can print. It's the same thing as if you tried to print out the return value of mysql_connect, which should return a resource id. There wasn't an error with the query, so the or die shouldn't execute, and mys "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
if(!isset($_GET['antwort'