What is wrong with this code that uses the mysql extension to fetch data from a database in PHP

Question

I want to fetch data from a mysql table using php  Please  can anyone tell me what is wrong with this code  What is the correct code to fetch data from a mysql database     lt  php      dbhost    localhost        dbuser    root        dbpass            connect mysql connect  localhost   root               connect to databsase       mysql select db  form1              enter code here         query the database        query   mysql query  SELECT   FROM users WHERE name    Admin              fetch the result   convert resulte in to array       while   rows   mysql fetch array  query             rows    rows  Name            address    rows  Address            email    rows  Email            subject    rows  Subject            comment    rows  Comment            echo   Name lt br gt  Address lt br gt  Email lt br gt  Subject lt br gt  Comment lt br gt  lt br gt            endwhile            gt

User · Answer

Code      while   rows   mysql fetch array  query            name    rows  Name            address    rows  Address            email    rows  Email            subject    rows  Subject            comment    rows  Comment          echo   name lt br gt  address lt br gt  email lt br gt  subject lt br gt  comment lt br gt  lt br gt    endwhile

User · Answer

If this is the code you have  then you will get an error because  you are reassigning  row while in the loop  so you would never be able to iterate over the results  Replace    rows    rows  Name      with   name    rows  Name      So your code would look like  WHILE   rows   mysql fetch array  query         name    rows  Name        address    rows  Address        email    rows  Email        subject    rows  Subject        comment    rows  Comment      Also I am assuming that the column names in the table users are Name  Address  Email etc  and not name address  email  Remember that every variable name field nameh is case sensitive

User · Answer

Your syntax is wrong    The correct coding is     lt  php mysql connect  localhost   root       mysql select db  form1     query   mysql query  SELECT   FROM users WHERE name    Admin      while  rows   mysql fetch array  query          rows    rows  Name        address    rows  Address        email    rows  Email        subject    rows  Subject        comment    rows  Comment      echo  rows   lt  br gt    address   lt  br gt    email   lt  br gt    subject   lt  br gt    comment         gt

User · Answer

Variables in php are case sensitive  Please replace your while loop with following   while   rows   mysql fetch array  query                 name    rows  Name                address    rows  Address                email    rows  Email                subject    rows  Subject                comment    rows  Comment               echo   name lt br gt  address lt br gt  email lt br gt  subject lt br gt  comment lt br gt  lt br gt                endwhile

User · Answer

use this code    while   rows   mysql fetch array  query         name    rows  Name        address    rows  Address        email    rows  Email        subject    rows  Subject        comment    rows  Comment        echo   name lt br gt  address lt br gt  email lt br gt  subject lt br gt  comment lt br gt  lt br gt        endwhile        gt

User · Answer

Change the  WHILE   to  while   Because php is case sensitive like c c

User · Answer

Try   query   mysql query  SELECT   FROM users WHERE name    Admin    or die mysql error      and check if this throw any error   Then use while  rows   mysql fetch assoc  query     And finally display it as echo  name     lt br  gt      address     lt br  gt      email     lt br  gt      subject     lt br  gt      comment     lt br  gt  lt br  gt        Do not user mysql   as its deprecated

User · Answer

Try this   lt  php    1  Enter Database details  dbhost    localhost    dbuser    root    dbpass    password    dbname    database name       2  Create a database connection  connection   mysql connect  dbhost  dbuser  dbpass   if    connection        die  Database connection failed      mysql error           3  Select a database to use   db select   mysql select db  dbname  connection   if    db select        die  Database selection failed      mysql error         query   mysql query  SELECT   FROM users WHERE name    Admin       while   rows   mysql fetch array  query          name    rows  Name        address    rows  Address        email    rows  Email        subject    rows  Subject        comment    rows  Comment       echo   name lt br gt  address lt br gt  email lt br gt  subject lt br gt  comment lt br gt  lt br gt                gt    Not tested    UPDATED

User · Answer

lt table border  1px  gt        lt tr gt           lt th gt Student Name lt  th gt           lt th gt Email lt  th gt           lt th gt password lt  th gt       lt  tr gt            lt  php              If mysql num rows  result  gt 0                                while  rows mysql fetch array  result                                  gt       lt  php echo   lt tr gt     gt                       lt td gt  lt  php echo  rows  userName     gt   lt  td gt                       lt td gt  lt  php echo  rows  email     gt  lt  td gt                       lt td gt  lt  php echo  rows  password     gt  lt  td gt        lt  php echo   lt  tr gt     gt           lt  php                                        gt   lt  table gt       lt  php                 gt

User · Answer

Select  a database with  identifier mysql select db  form1   connect   Are you getting syntax error  If please put a   next to  comment    rows  Comment    Also the variables should be case sensitive here

[php] What is wrong with this code that uses the mysql extension to fetch data from a database in PHP?

Examples related to php

Examples related to mysql