mysql fetch array mysql fetch assoc mysql fetch row mysql num rows etc expects parameter 1 to be resource

Question

I am trying to select data from a MySQL table  but I get one of the following error messages      mysql fetch array   expects parameter 1 to be resource  boolean given   This is my code    username     POST  username     password     POST  password      result   mysql query  SELECT   FROM Users WHERE UserName LIKE  username     while  row   mysql fetch array  result         echo  row  FirstName

User · Answer

Please check once the database selected are not because some times database is not selected

Check

mysql_select_db('database name ')or DIE('Database name is not available!');

before MySQL query and then go to next step

$result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');

f($result === FALSE) {
    die(mysql_error());

User · Answer

Try this  it must be work  otherwise you need to print the error to specify your problem   username     POST  username     password     POST  password      sql    SELECT   from Users WHERE UserName LIKE   username     result   mysql query  sql  con    while  row   mysql fetch array  result         echo  row  FirstName

User · Answer

lt  php        username     POST  username            password     POST  password           result   mysql query  SELECT   FROM Users WHERE UserName LIKE    mysql real escape string  username      or die mysql error     while  row mysql fetch array  result        echo  row  FirstName          gt

User · Answer

You can also check  wether  result is failing like so  before executing the fetch array     username     POST  username     password     POST  password     result   mysql query  SELECT   FROM Users WHERE UserName LIKE  username    if   result         echo  error executing query    mysql error      else         while  row   mysql fetch array  result                     echo  row  FirstName

User · Answer

Try this code it work fine   assign the post  variable to the variable            username     POST  uname         password     POST  pass        result   mysql query  SELECT   FROM userData WHERE UserName LIKE  username     if  empty  result         while  row   mysql fetch array  result            echo  row  FirstName

User · Answer

Your code should be something like this   username     POST  username     password     POST  password     query    SELECT   FROM Users WHERE UserName LIKE   username    echo  query   result   mysql query  query    if  result     FALSE        die mysql error  error message for the user         while  row   mysql fetch array  result         echo  row  FirstName        Once done with that  you would get the query printed on the screen  Try this query on your server and see if it produces the desired results  Most of the times the error is in the query  Rest of the code is correct

User · Answer

As scompt com explained  the query might fail  Use this code the get the error of the query or the correct result    username     POST  username     password     POST  password      result   mysql query   SELECT   FROM Users  WHERE UserName LIKE    mysql real escape string  username          if  result        while  row   mysql fetch array  result                 echo  row  FirstName            else       echo  Invalid query      mysql error       n       echo  Whole query       query       See the documentation for mysql query   for further information   The actual error was the single quotes so that the variable  username was not parsed  But you should really use mysql real escape string  username  to avoid SQL injections

User · Answer

Go to your config php  I had the same problem  Verify the username and the password  and also sql select is the same name as the config

User · Answer

Put quotes around  username  String values  as opposed to numeric values  must be enclosed in quotes    result   mysql query  SELECT   FROM Users WHERE UserName LIKE   username       Also  there is no point in using the LIKE condition if you re not using wildcards  if you need an exact match use   instead of LIKE

User · Answer

If you don t have any MySQL Error appearing while checking  make sure that you properly created your database table  This happened to me  Look for any unwanted commas or quotes

User · Answer

Make Sure You re Not Closing Database By using db close   Before To   Running Your Query    If you re using multiple queries in a script even you re including other pages which contains queries or database connection  then it might be possible that at any place you use db close   that would close your database connection so make sure you re not doing this mistake in your scripts

User · Answer

Error occurred here was due to the use of single quotes      You can put your query like this   mysql query   SELECT   FROM Users  WHERE UserName  LIKE    mysql real escape string   username           It s using mysql real escape string for prevention of SQL injection   Though we should use MySQLi or PDO MYSQL extension for upgraded version of PHP  PHP 5 5 0 and later   but for older versions mysql real escape string will do the trick

User · Answer

query    SELECT Name Mobile Website Rating FROM grand table order by 4    while   data   mysql fetch array  query         echo   lt tr gt  lt td gt  data 0  lt  td gt  lt td gt  data 1  lt  td gt  lt td gt  data 2  lt  td gt  lt td gt  data 3  lt  td gt  lt  tr gt               Instead of using a WHERE query  you can use this ORDER BY query  It s far better than this for use of a query   I have done this query and am getting no errors like parameter or boolean

User · Answer

username     POST  username     password     POST  password     result   mysql query  SELECT   FROM Users WHERE UserName LIKE    username     or die mysql error      while  row   mysql fetch array  result         echo  row  FirstName        Sometimes suppressing the query as  mysql query your query

User · Answer

Usually an error occurs when your database conectivity fails  so be sure to connect your database or to include the database file   include once db connetc php      OR     Create a connection  connection   mysql connect  localhost    root       or die mysql error        Select database mysql select db  db name    connection  or die mysql error       employee query    SELECT   FROM employee WHERE  id        POST  id          employee data   mysql query  employee query    if  mysql num rows  employee data   gt  0         while   row   mysql fetch array  employee data            echo  row  emp name             end of while loop      end of if    Best practice is to run the query in sqlyog and then copy it into your page code  Always store your query in a variable and then echo that variable  Then pass to mysql query  query variable

User · Answer

Check your connection first   Then if you want to fetch the exact value from the database then you should write    username     POST  username     password     POST  password     result   mysql query  SELECT   FROM Users WHERE UserName    usernam       Or you want to fetch the LIKE type of value then you should write    result   mysql query  SELECT   FROM Users WHERE UserName LIKE    username

User · Answer

First  check your connection to the database  Is it connected successfully or not   If it s done  then after that I have written this code  and it works well   if  isset   GET  q1mrks     amp  amp  isset   GET  marks     amp  amp  isset   GET  qt1            Q1mrks     GET  q1mrks         marks     GET  marks         qt1     GET  qt1          qtype qry   mysql query           SELECT           FROM s questiontypes         WHERE quetype id     qt1               row   mysql fetch assoc  qtype qry        qcode    row  quetype code          sq qry             SELECT           FROM s question         WHERE quetype code     qcode          ORDER BY RAND   LIMIT  Q1mrks             sq qry   mysql query           SELECT           FROM s question         WHERE quetype code     qcode          LIMIT  Q1mrks             while   qrow   mysql fetch array  sq qry              qm    qrow  marks       lt br   gt             total     qm     lt br   gt              echo  total          marks

User · Answer

This query should work    result   mysql query  SELECT   FROM Users WHERE UserName LIKE    username      while  row   mysql fetch array  result         echo  row  FirstName        The problem is single quotes  thus your query fails and returns FALSE and your WHILE loop can t execute  Using   allows you to match any results containing your string  such as SomeText- username-SomeText    This is simply an answer to your question  you should implement stuff  mentioned in the other posts  error handling  use escape strings  users can type anything into the field  and you MUST make sure it is not arbitrary code   use PDO instead mysql connect which is now depricated

User · Answer

This error message is displayed when you have an error in your query which caused it to fail  It will manifest itself when using    mysql fetch array mysqli fetch array   mysql fetch assoc   mysqli fetch assoc   mysql num rows   mysqli num rows     Note  This error does not appear if no rows are affected by your query  Only a query with an invalid syntax will generate this error   Troubleshooting Steps   Make sure you have your development server configured to display all errors  You can do this by placing this at the top of your files or in your config file  error reporting -1    If you have any syntax errors this will point them out to you  Use mysql error    mysql error   will report any errors MySQL encountered while performing your query   Sample usage   mysql connect  host   username   password  or die  cannot connect     mysql select db  db name  or die  cannot select DB      sql    SELECT   FROM table name    result   mysql query  sql    if  false      result        echo mysql error       Run your query from the MySQL command line or a tool like phpMyAdmin  If you have a syntax error in your query this will tell you what it is  Make sure your quotes are correct  A missing quote around the query or a value can cause a query to fail  Make sure you are escaping your values  Quotes in your query can cause a query to fail  and also leave you  open to SQL injections   Use mysql real escape string   to escape your input  Make sure you are not mixing mysqli   and mysql   functions  They are not the same thing and cannot be used together   If you re going to choose one or the other stick with mysqli    See below for why     Other tips  mysql   functions should not be used for new code  They are no longer maintained and the community has begun the deprecation process   Instead you should learn about prepared statements and use either PDO or MySQLi  If you can t decide  this article will help to choose  If you care to learn  here is good PDO tutorial

User · Answer

Traditionally PHP has been tolerant to bad practice and failures in code  which makes debugging quite hard  The problem in this specific case is that both mysqli and PDO by default don t tell you  when a query failed and just return FALSE   I will not talk about the depricated mysql extention  The support for prepared statements is reason anough to switch either to PDO or mysqli   But you can change the default behavior of PHP to always throw exceptions when a query fails  For PDO  Use  pdo- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION   error reporting E ALL     pdo   new PDO  quot mysql host localhost dbname test quot    quot test quot   quot  quot     pdo- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION     result    pdo- gt query  select emal from users     data    result- gt fetchAll     This will show you the following   Fatal error  Uncaught exception  PDOException  with message  SQLSTATE 42S22   Column not found  1054 Unknown column  emal  in  field list   in E  htdocs test mysql errors pdo php on line 8 PDOException  SQLSTATE 42S22   Column not found  1054 Unknown column  emal  in  field list  in E  htdocs test mysql errors pdo php on line 8  As you see  it tells you exactly  what is wrong with the query  and where to fix it in your code  Without  pdo- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION   you will get  Fatal error  Call to a member function fetchAll   on boolean in E  htdocs test mysql errors pdo php on line 9  For mysqli  Use mysqli report MYSQLI REPORT ERROR   MYSQLI REPORT STRICT   error reporting E ALL    mysqli report MYSQLI REPORT ERROR   MYSQLI REPORT STRICT    mysqli   new mysqli  localhost    test        test      result    mysqli- gt query  select emal from users     data    result- gt fetch all     You will get  Fatal error  Uncaught exception  mysqli sql exception  with message  Unknown column  emal  in  field list   in E  htdocs test mysql errors mysqli php on line 8 mysqli sql exception  Unknown column  emal  in  field list  in E  htdocs test mysql errors mysqli php on line 8  Without mysqli report MYSQLI REPORT ERROR   MYSQLI REPORT STRICT   you only get  Fatal error  Call to a member function fetch all   on boolean in E  htdocs test mysql errors mysqli php on line 10  Of course  you could manually check the MySQL errors  But I would go crazy if I had to do that every time I made a typo - or worse - every time I want to query the database

User · Answer

since  username is a php variable we need to pass it as string to mysqli so since in the query u started with a single quote we will use the double quote  single quote and a fullstop for the concatination purposes      username     if you started  with a double quote you would then reverse the quotes      username        username     POST  username     password     POST  password     result   mysql query  SELECT   FROM Users WHERE UserName LIKE     username        while  row   mysql fetch array  result                echo  row  FirstName             username     POST  username     password     POST  password     result   mysql query  SELECT   FROM Users WHERE UserName LIKE     username         while  row   mysql fetch array  result                echo  row  FirstName             but use of Mysql has depreciated much  use PDO instead it is simple but very secure

User · Answer

If you tried everything here  and it does not work  you might want to check your MySQL database collation  Mine was set to to a Swedish collation  Then I changed it to utf8 general ci and everything just clicked into gear

User · Answer

Try the following code  It may work fine    username     POST  username     password     POST  password     result   mysql query  SELECT   FROM Users WHERE UserName    username      while  row   mysql fetch array  result         echo  row  FirstName

User · Answer

Try This   username     POST  username     password     POST  password     result   mysqli query  SELECT   FROM Users WHERE UserName LIKE  username     if  result   while  row   mysqli fetch array  result         echo  row  FirstName

User · Answer

Don t use the depricated mysql   function  depricated in php 5 5 will be removed in php 7   and you can make this with mysqli or pdo  here is the complete select query    lt  php  servername    localhost    username    username    password    password    dbname    myDB       Create connection  conn   new mysqli  servername   username   password   dbname      Check connection if   conn- gt connect error        die  Connection failed       conn- gt connect error        sql    SELECT id  firstname  lastname FROM MyGuests    result    conn- gt query  sql    if   result- gt num rows  gt  0           output data of each row     while  row    result- gt fetch assoc                 code here          else       echo  0 results      conn- gt close      gt

User · Answer

Include a connection string variable before the MySQL query  For example   connt in this code    results   mysql query  connt   SELECT   FROM users

User · Answer

A query may fail for various reasons in which case both the mysql   and the mysqli extension will return false from their respective query functions methods  You need to test for that error condition and handle it accordingly   mysql   extension      NOTE The mysql  functions are deprecated and have been removed in php version 7    Check  result before passing it to mysql fetch array  You ll find that it s false because the query failed  See the mysql query documentation for possible return values and suggestions for how to deal with them    username   mysql real escape string   POST  username      password     POST  password     result   mysql query  SELECT   FROM Users WHERE UserName LIKE   username      if  result     FALSE         die mysql error        TODO  better error handling    while  row   mysql fetch array  result         echo  row  FirstName        mysqli extension procedural style    username   mysqli real escape string  mysqli    POST  username      result   mysqli query  mysqli   SELECT   FROM Users WHERE UserName LIKE   username         mysqli query returns false if something went wrong with the query if  result     FALSE         yourErrorHandler mysqli error  mysqli      else          as of php 5 4 mysqli result implements Traversable  so you can use it with foreach     foreach   result as  row                   oo-style      username    mysqli- gt escape string   POST  username      result    mysqli- gt query  SELECT   FROM Users WHERE UserName LIKE   username      if  result     FALSE         yourErrorHandler  mysqli- gt error      or  mysqli- gt error list   else          as of php 5 4 mysqli result implements Traversable  so you can use it with foreach     foreach   result as  row                 using a prepared statement    stmt    mysqli- gt prepare  SELECT   FROM Users WHERE UserName LIKE      if     stmt         yourErrorHandler  mysqli- gt error      or  mysqli- gt error list   else if     stmt- gt bind param  s     POST  username            yourErrorHandler  stmt- gt error      or  stmt- gt error list   else if     stmt- gt execute           yourErrorHandler  stmt- gt error      or  stmt- gt error list   else        result    stmt- gt get result           as of php 5 4 mysqli result implements Traversable  so you can use it with foreach     foreach   result as  row                   These examples only illustrate what should be done  error handling   not how to do it  Production code shouldn t use or die when outputting HTML  else it will  at the very least  generate invalid HTML  Also  database error messages shouldn t be displayed to non-admin users  as it discloses too much information

User · Answer

lt  php      username     POST  username         password     POST  password         result   mysql query  SELECT   FROM Users WHERE UserName LIKE     username            while  row   mysql fetch array  result                 echo  row  FirstName            gt    And if there is a user with a unique user name  you can use     for that  There is no need to like   Your query will be   mysql query  SELECT   FROM Users WHERE UserName      username

User · Answer

Any time you get the         Warning  mysqli fetch object   expects parameter 1 to be mysqli result  boolean given       it is likely because there is an issue with your query  The prepare   or query   might return FALSE  a Boolean   but this generic failure message doesn t leave you much in the way of clues  How do you find out what is wrong with your query  You ask   First of all  make sure error reporting is turned on and visible  add these two lines to the top of your file s  right after your opening  lt  php tag   error reporting E ALL   ini set  display errors   1     If your error reporting has been set in the php ini you won t have to worry about this  Just make sure you handle errors gracefully and never reveal the true cause of any issues to your users  Revealing the true cause to the public can be a gold engraved invitation for those wanting to harm your sites and servers  If you do not want to send errors to the browser you can always monitor your web server error logs  Log locations will vary from server to server e g   on Ubuntu the error log is typically located at  var log apache2 error log  If you re examining error logs in a Linux environment you can use tail -f  path to log in a console window to see errors as they occur in real-time    or as you make them   Once you re squared away on standard error reporting adding error checking on your database connection and queries will give you much more detail about the problems going on  Have a look at this example where the column name is incorrect  First  the code which returns the generic fatal error message    sql    SELECT  foo  FROM  weird words  WHERE  definition         query    mysqli- gt prepare  sql       assuming  mysqli is the connection  query- gt bind param  s    definition    query- gt execute      The error is generic and not very helpful to you in solving what is going on   With a couple of more lines of code you can get very detailed information which you can use to solve the issue immediately  Check the prepare   statement for truthiness and if it is good you can proceed on to binding and executing    sql    SELECT  foo  FROM  weird words  WHERE  definition        if  query    mysqli- gt prepare  sql        assuming  mysqli is the connection      query- gt bind param  s    definition        query- gt execute           any additional code you need would go here    else        error    mysqli- gt errno          mysqli- gt error     1054 Unknown column  foo  in  field list         handle error     If something is wrong you can spit out an error message which takes you directly to the issue  In this case  there is no foo column in the table  solving the problem is trivial   If you choose  you can include this checking in a function or class and extend it by handling the errors gracefully as mentioned previously

User · Answer

There might be two reasons    Have you opened the connection to the database prior to calling mysql query function  I don t see that in your code  Use mysql connect before making the query  See php net manual en function mysql-connect php The variable  username is used inside a single quote string  so its value will not be evaluated inside the query  The query will definitely fail    Thirdly  the structure of query is prone to SQL injection  You may use prepared statements to avoid this security threat

User · Answer

result   mysql query  SELECT   FROM Users WHERE UserName LIKE  username      You define the string using single quotes and PHP does not parse single quote delimited strings  In order to obtain variable interpolation you will need to use double quotes OR string concatenation  or a combination there of   See http   php net manual en language types string php for more information   Also you should check that mysql query returned a valid result resource  otherwise fetch    num rows  etc will not work on the result as is not a result  IE    username     POST  username     password     POST  password     result   mysql query  SELECT   FROM Users WHERE UserName LIKE  username     if   result     FALSE        trigger error  Query failed returning error     mysql error   E USER ERROR     else      while   row   mysql fetch array  result            echo  row  username             http   us php net manual en function mysql-query php for more information

[php] mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc... expects parameter 1 to be resource

Examples related to php

Examples related to mysql