Show values from a MySQL database table inside a HTML table on a webpage

Question

I want to retrieve the values from a database table and show them in a html table in a page  I already searched for this but I couldn t find the answer  although this surely is something easy  this should be the basics of databases lol   I guess the terms I ve searched are misleading  The database table name is tickets  it has 6 fields right now  submission id  formID  IP  name  email and message  but should have another field called ticket number  How can I get it to show all the values from the db in a html table like this    lt table border  1  gt     lt tr gt       lt th gt Submission ID lt  th gt       lt th gt Form ID lt  th gt       lt th gt IP lt  th gt       lt th gt Name lt  th gt       lt th gt E-mail lt  th gt       lt th gt Message lt  th gt     lt  tr gt     lt tr gt       lt td gt 123456789 lt  td gt       lt td gt 12345 lt  td gt       lt td gt 123 555 789 lt  td gt       lt td gt John Johnny lt  td gt       lt td gt johnny example com lt  td gt       lt td gt This is the message John sent you lt  td gt     lt  tr gt   lt  table gt    And then all the other values below  john

User · Accepted Answer

Example taken from W3Schools  PHP Select Data from MySQL   lt  php  con mysqli connect  example com   peter   abc123   my db       Check connection if  mysqli connect errno      echo  Failed to connect to MySQL      mysqli connect error        result   mysqli query  con  SELECT   FROM Persons     echo   lt table border  1  gt   lt tr gt   lt th gt Firstname lt  th gt   lt th gt Lastname lt  th gt   lt  tr gt     while  row   mysqli fetch array  result     echo   lt tr gt    echo   lt td gt      row  FirstName       lt  td gt    echo   lt td gt      row  LastName       lt  td gt    echo   lt  tr gt      echo   lt  table gt     mysqli close  con     gt    It s a good place to learn from

User · Answer

lt  DOCTYPE html gt   lt html gt   lt head gt   lt style gt  table  th  td        border  1px solid black     lt  style gt   lt  head gt   lt center gt   lt body gt    lt  php   con   mysql connect  localhost   root       mysql select db  rachna   con       query    SELECT SUM  Ivalue   AS RESULT FROM loan WHERE cname    A  GROUP BY Iyear    result   mysql query  query  or die mysql error      if  mysql num rows  result   gt  0         echo   lt table gt  lt tr gt  lt th gt  lt  th gt  lt th gt 1999 lt  th gt  lt th gt 2000 lt  th gt  lt th gt 2001 lt  th gt  lt th gt 2003 lt  th gt  lt  tr gt         echo   lt th gt A lt  th gt             Code for A Customer-------------------------------------------      while  row  mysql fetch array  result              echo   lt th gt      row  RESULT       lt  th gt                          echo  lt tr gt  lt  tr gt                    COde of B Customer--------------------------------------           echo   lt th gt B lt  th gt          query    SELECT SUM  Ivalue   AS RESULT FROM loan WHERE cname    B  GROUP BY Iyear        result1   mysql query  query  or die mysql error            while  row   mysql fetch array  result1              echo   lt th gt       row  RESULT      lt  th gt                echo   lt  table gt      else        echo  0 results         gt     lt  center gt   lt  body gt   lt  html gt

User · Answer

lt  php  mysql hostname    localhost    mysql user        ram    mysql password    ram    mysql database    mydb    bd               mysql connect  mysql hostname   mysql user   mysql password  or die  Oops some thing went wrong    mysql select db  mysql database   bd  or die  Oops some thing went wrong      we are now connected to database   result   mysql query  SELECT   FROM users       selecting data through mysql query    echo   lt table border 1px gt        opening table tag echo  lt th gt No lt  th gt  lt th gt Username lt  th gt  lt th gt Password lt  th gt  lt th gt Email lt  th gt      table headers  while  data   mysql fetch array  result        we are running a while loop to print all the rows in a table echo  lt tr gt       printing table row echo   lt td gt    data  id     lt  td gt  lt td gt    data  username     lt  td gt  lt td gt    data  password     lt  td gt  lt td gt    data  email     lt  td gt       we are looping all data to be printed till last row in the table echo  lt  tr gt       closing table row    echo   lt  table gt       closing table tag   gt    it would print the table like this  just read line by line so that you can understand it easily

User · Answer

Here is an easy way to fetch data from a MySQL database using PDO  define  quot DB HOST quot    quot localhost quot          Using Constants define  quot DB USER quot    quot YourUsername quot    define  quot DB PASS quot    quot YourPassword quot    define  quot DB NAME quot    quot Yourdbname quot      dbc   new PDO  quot mysql host  quot  DB HOST  quot  dbname  quot  DB NAME  quot  charset-utf8mb4 quot   DB USER  DB PASS     print    quot  quot      assign an empty string   stmt    dbc- gt query  quot SELECT   FROM tableName quot       fetch data  stmt- gt setFetchMode PDO  FETCH OBJ     print      lt table border  quot 1px quot  gt     print      lt tr gt  lt th gt First name lt  th gt     print      lt th gt Last name lt  th gt  lt  tr gt     while   names    stmt- gt fetch         loop and display data      print      lt tr gt         print     quot  lt td gt   names- gt firstname  lt  td gt  quot        print     quot  lt td gt   names- gt lastname  lt  td gt  quot        print      lt  tr gt        print     quot  lt  table gt  quot   echo  print

User · Answer

mysql connect  localhost   root       mysql select db  database     query mysql query  select   from studenti     x  mysql num rows  query    echo   lt a href  file html  gt back lt  a gt    echo   lt table gt     y mysql num fields  query   echo   lt tr gt     for  i 0   i lt  y  i         values mysql field name  query  i     echo   lt th gt  values lt  th gt       echo   lt  tr gt     while list  p   n  your table list  mysql fetch row  query       print   lt tr gt  n       lt td gt  p lt  td gt        lt  tr gt  n        gt

User · Answer

First  connect to the database    conn mysql connect  hostname   username   password    mysql select db  databasename   conn     You can use this to display a single record   For example  if the URL was  index php sequence 123  the code below would select from the table  where the sequence   123    lt  php  sql  SELECT   from table where sequence        GET  sequence          rs mysql query  sql  conn  or die mysql error      result mysql fetch array  rs    echo   lt table gt   lt tr gt   lt td gt Forename lt  td gt   lt td gt Surname lt  td gt   lt  tr gt   lt tr gt   lt td gt    result  forename     lt  td gt   lt td gt    result  surname     lt  td gt   lt  tr gt   lt  table gt      gt    Or  if you want to list all values that match the criteria in a table    lt  php echo   lt table gt   lt tr gt   lt td gt Forename lt  td gt   lt td gt Surname lt  td gt   lt  tr gt     sql  SELECT   from table where sequence        GET  sequence          rs mysql query  sql  conn  or die mysql error     while  result mysql fetch array  rs     echo   lt tr gt   lt td gt    result  forename     lt  td gt   lt td gt    result  surname     lt  td gt   lt  tr gt      echo   lt  table gt      gt

User · Answer

Object-Oriented with PHP 5 6 25 and MySQL 5 7 17 using MySQLi  Dynamic  Learn more about PHP and the MySQLi Library at PHP net  First  start a connection to the database  Do this by making all the string variables needed in order to connect  adjust them to fit your environment  then create a new connection object with new mysqli   and initialize it with the previously made variables as its parameters  Now  check the connection for errors and display a message whether any were found or not  Like this   lt  php  servername    quot localhost quot    username    quot root quot    password    quot yourPassword quot    database    quot world quot   mysqli report MYSQLI REPORT ERROR   MYSQLI REPORT STRICT    conn   new mysqli  servername   username   password   database   echo  quot Connected successfully lt br gt  quot     gt   Next  make a variable that will hold the query as a string  in this case its a select statement with a limit of 100 records to keep the list small  Then  we can execute it by calling the mysqli  query   function from our connection object  Now  it s time to display some data  Start by opening up a  lt table gt  tag through echo  then fetch one row at a time in the form of a numerical array with mysqli  fetch row   which can then be displayed with a simple for loop  mysqli  field count should be self explanatory  Don t forget to use  lt td gt  lt  td gt  for each value  and also to open and close each row with echo quot  lt tr gt  quot  and echo quot  lt  tr gt   Finally we close the table  and the connection as well with mysqli  close     lt  php  query    quot select   from city limit 100  quot    queryResult    conn- gt query  query   echo  quot  lt table gt  quot   while   queryRow    queryResult- gt fetch row          echo  quot  lt tr gt  quot       for  i   0   i  lt   queryResult- gt field count   i             echo  quot  lt td gt  queryRow  i  lt  td gt  quot             echo  quot  lt  tr gt  quot     echo  quot  lt  table gt  quot    conn- gt close      gt

User · Answer

Try this   Completely Dynamic       lt  php  host       localhost    user       username here    pass       password here    db name    database name here      create connection  connection   mysqli connect  host   user   pass   db name      test if connection failed if mysqli connect errno         die  connection failed              mysqli connect error                    mysqli connect errno                        get results from database  result   mysqli query  connection  SELECT   FROM products     all property   array       declare an array for saving property    showing property echo   lt table class  data-table  gt           lt tr class  data-heading  gt       initialize table tag while   property   mysqli fetch field  result         echo   lt td gt      property- gt name     lt  td gt       get field name for header     array push  all property   property- gt name      save those to array   echo   lt  tr gt      end tr tag    showing all data while   row   mysqli fetch array  result         echo   lt tr gt        foreach   all property as  item            echo   lt td gt      row  item      lt  td gt      get items using property value           echo   lt  tr gt      echo   lt  table gt      gt

User · Answer

Surely a better solution would by dynamic so that it would work for any query without having to know the column names  If so  try this  obviously the query should match your database      You ll need to put your db connection details in here   conn   new mysqli  server hostname   server username   server password   server database       Run the query   result    conn- gt query  quot SELECT   FROM table LIMIT 10 quot        Get the result in to a more usable format   query   array    while  query     mysqli fetch assoc  result    array pop  query       Output a dynamic table of the results with column headings  echo   lt table border  quot 1 quot  gt    echo   lt tr gt    foreach  query 0  as  key   gt   value        echo   lt td gt        echo  key      echo   lt  td gt      echo   lt  tr gt    foreach  query as  row        echo   lt tr gt        foreach  row as  column            echo   lt td gt            echo  column          echo   lt  td gt              echo   lt  tr gt      echo   lt  table gt     Taken from here  https   www antropy co uk blog handy-php-snippets

User · Answer

OOP Style    At first connection with database    lt  php class database     public  host    localhost    public  user    root    public  pass        public  db      db    public  link    public function   construct           this- gt connect         private function connect          this- gt link   new mysqli  this- gt host   this- gt user   this- gt pass   this- gt db       return  this- gt link       public function select  query          result    this- gt link- gt query  query  or die  this- gt link- gt error   LINE          if  result- gt num rows gt 0              return  result             else              return false            gt    Then         lt  php          db   new database              query    select   from data            result    db- gt select  query            echo   lt table gt             echo   lt tr gt                echo   lt th gt Name  lt  th gt                echo   lt th gt Roll  lt  th gt             echo   lt  tr gt             while  row   mysqli fetch array  result                           echo   lt tr gt                echo   lt td gt   row name  lt  td gt                echo   lt td gt   row roll  lt  td gt                echo   lt  tr gt                      echo   lt  table gt       gt

[php] Show values from a MySQL database table inside a HTML table on a webpage

Examples related to php

Examples related to mysql

Examples related to database

Examples related to html-table