display data from SQL database into php html table

Question

OK I have a database on phpmyadmin  sql  and I want to display one of my tables into a table on HTML PHP  I have searched online and can not implement this feature  so I m wondering if someone could help me with the coding on this   database    hrmwaitrose  username    root  host    localhost    NO PW  I would like to display the data from table name employee

User · Accepted Answer

You say you have a database on PhpMyAdmin, so you are using MySQL. PHP provides functions for connecting to a MySQL database.

$connection = mysql_connect('localhost', 'root', ''); //The Blank string is the password
mysql_select_db('hrmwaitrose');

$query = "SELECT * FROM employee"; //You don't need a ; like you do in SQL
$result = mysql_query($query);

echo "<table>"; // start a table tag in the HTML

while($row = mysql_fetch_array($result)){   //Creates a loop to loop through results
echo "<tr><td>" . $row['name'] . "</td><td>" . $row['age'] . "</td></tr>";  //$row['index'] the index here is a field name
}

echo "</table>"; //Close the table in HTML

mysql_close(); //Make sure to close out the database connection

In the while loop (which runs every time we encounter a result row), we echo which creates a new table row. I also add a to contain the fields.

This is a very basic template. You see the other answers using mysqli_connect instead of mysql_connect. mysqli stands for mysql improved. It offers a better range of features. You notice it is also a little bit more complex. It depends on what you need.

User · Answer

Look in the manual http   www php net manual en mysqli query php   lt  php  mysqli   new mysqli  localhost    my user    my password    world        check connection    if   mysqli- gt connect errno        printf  Connect failed   s n    mysqli- gt connect error       exit          Create table doesn t return a resultset    if   mysqli- gt query  CREATE TEMPORARY TABLE myCity LIKE City       TRUE        printf  Table myCity successfully created  n          Select queries return a resultset    if   result    mysqli- gt query  SELECT Name FROM City LIMIT 10          printf  Select returned  d rows  n    result- gt num rows           free result set         result- gt close          If we have to retrieve large amount of data we use MYSQLI USE RESULT    if   result    mysqli- gt query  SELECT   FROM City   MYSQLI USE RESULT             Note  that we can t execute any functions which interact with the        server until result set was closed  All calls will return an         out of sync  error        if    mysqli- gt query  SET  a   this will not work               printf  Error   s n    mysqli- gt error              result- gt close        mysqli- gt close      gt

User · Answer

refer to http   www w3schools com php php mysql select asp     If you are a beginner and want to learn  w3schools is a good place    lt  php      con mysqli connect  localhost   root   YOUR PHPMYADMIN PASSWORD   hrmwaitrose           Check connection     if  mysqli connect errno                  echo  Failed to connect to MySQL      mysqli connect error                  result   mysqli query  con  SELECT   FROM employee         while  row   mysqli fetch array  result                 echo  row  FirstName            row  LastName      these are the fields that you have stored in your database table employee       echo   lt br   gt                 mysqli close  con         gt    You can similarly echo it inside your table   lt  php  echo   lt table gt     while  row   mysqli fetch array  result                         echo   lt tr gt  lt td gt      row  FirstName       lt  td gt  lt td gt       row  LastName       lt  td gt  lt  tr gt      these are the fields that you have stored in your database table employee              echo   lt  table gt     mysqli close  con     gt

User · Answer

Here s a simple function I wrote to display tabular data without having to input each column name   Also  be aware  Nested looping   function display data  data         output     lt table gt        foreach  data as  key   gt   var             output      lt tr gt            foreach  var as  k   gt   v                if   key     0                     output      lt td gt  lt strong gt      k     lt  strong gt  lt  td gt                  else                    output      lt td gt      v     lt  td gt                                     output      lt  tr gt               output      lt  table gt        echo  output        UPDATED FUNCTION BELOW  Hi Jack   your function design is fine  but this function always misses the first dataset in the array  I tested that    Your function is so fine  that many people will use it  but they will always miss the first dataset  That is why I wrote this amendment   The missing dataset results from the condition if key     0  If key   0 only the columnheaders are written  but not the data which contains  key 0 too  So there is always missing the first dataset of the array   You can avoid that by moving the if condition above the second foreach loop like this   function display data  data         output     lt table gt        foreach  data as  key   gt   var               output      lt tr gt            if  key   0                 output      lt tr gt                foreach  var as  col   gt   val                     output      lt td gt      col     lt  td gt                               output      lt  tr gt                foreach  var as  col   gt   val                     output      lt td gt      val     lt  td gt                               output      lt  tr gt                      else                output      lt tr gt                foreach  var as  col   gt   val                     output      lt td gt      val     lt  td gt                               output      lt  tr gt                         output      lt  table gt        echo  output      Best regards and thanks - Axel Arnold Bangert - Herzogenrath 2016  and another update that removes redundant code blocks that hurt maintainability of the code    function display data  data     output     lt table gt    foreach  data as  key   gt   var         output      lt tr gt        foreach  var as  k   gt   v            if   key     0                 output      lt td gt  lt strong gt      k     lt  strong gt  lt  td gt              else                output      lt td gt      v     lt  td gt                         output      lt  tr gt       output      lt  table gt    echo  output

[php] display data from SQL database into php/ html table

Examples related to php

Examples related to html

Examples related to mysql

Examples related to phpmyadmin

Examples related to xampp