retrieve data from db and display it in table in php see this code whats wrong with it

Question

db   mysql connect  localhost    root           er   mysql select db  ram       query    insert into names values   name    add1    add2    mail        result   mysql query  query     print   lt p gt  Person s Information Inserted  lt  p gt       result   mysql query  SELECT   FROM names      gt    lt table border  2  gt      lt tr gt         lt th gt Name lt  th gt         lt th gt Address Line 1 lt  th gt         lt th gt Address Line 2  lt  th gt         lt th gt E-mail Id  lt  th gt       lt  tr gt       lt        while   array   mysql fetch row  result                  print   lt tr gt   lt td gt            echo  array 0            print   lt  td gt   lt td gt            echo  array 1            print   lt  td gt   lt td gt            echo  array 2            print   lt  td gt   lt td gt            echo  array 3            print   lt  td gt   lt  tr gt            gt

User · Answer

This is a very simple code I use and you manipulate it to change the colour and size of the table as you see fit.

First connect to the database:

<?php
$connect=mysql_connect('localhost', 'root', 'password');

mysql_select_db("name");
//here u select the data you want to retrieve from the db

$query="select * from tablename";

$result= mysql_query($query);

//here you check to see if any data has been found and you define the width of the table

If($result){

echo "<table width ='340' align='left'>
      <tr color ='#5D9951>";
$i=0;

    If(mysql_num_rows($result)>0)
    {
         //here you fetch the data from the database and print it in the respective columns   
        while($i<mysql_num_fields($result))
        {    
             echo "<th>".mysql_field_name($result, $i)."</th>";
             $i++;
        }
        echo "</tr>";

        $color=1;

        while($rows=mysql_fetch_array($result, MYSQL_ASSOC))
        {    
            If ($color==1){
                echo "<tr color='#'#cccccc'>";

                foreach ($rows as $data){
                    echo "<td align='center'>".$data. "</td>";
                }

                $color=2;
            }
            $color=1;
        }
     } else {
        echo"no results found";
        echo "</table>";
    } else {
        echo "error running query:".MYSQL_error();
}
?>

It's a very elementary piece of code but it helps if you are not used to using functions.

User · Answer

lt html gt       lt head gt           lt meta charset  UTF-8  gt           lt title gt LoginDB lt  title gt       lt  head gt       lt body gt            lt  php          con   mysqli connect  localhost    root        detail     lt  -- detail is the database in MySqli Database -- gt          if   con                      die  not connected                          con   mysqli query  con   select   from signup     lt  -- signup is the table in the detail Database -- gt           gt           lt div gt               lt td gt Login Page Database lt  td gt            lt table border  1  gt               lt th gt  First Name lt  th gt                       lt th gt Last Name lt  th gt                       lt th gt UserName lt  th gt                        lt th gt Password lt  th gt                       lt th gt Gender lt  th gt                       lt th gt D O B  lt  th gt                       lt th gt Phone Number lt  th gt                       lt th gt Address lt  th gt                lt  tr gt            lt  php               while  row   mysqli fetch array  con    lt  -- Fetch each row from signup Table  -- gt                                    gt               lt tr gt                   lt td gt  lt  php echo  row  FirstName      gt  lt  td gt                   lt td gt  lt  php echo  row  LastName      gt  lt  td gt                   lt td gt  lt  php echo  row  Username      gt  lt  td gt                   lt td gt  lt  php echo  row  Password      gt  lt  td gt                   lt td gt  lt  php echo  row  Gender      gt  lt  td gt                   lt td gt  lt  php echo  row  DOB      gt  lt  td gt                   lt td gt  lt  php echo  row  PhoneNumber      gt  lt  td gt                   lt td gt  lt  php echo  row  Address      gt  lt  td gt               lt  tr gt           lt  php                               gt                lt  table gt               lt  div gt       lt  body gt   lt  html gt

User · Answer

In your while statement just replace mysql fetch row with mysql fetch array or mysql fetch assoc    whichever works

User · Answer

Try this    lt  php     Init the MySQL Connection   if      db   mysql connect   localhost     root                 die   Failed to connect to MySQL Database Server -    mysql errno        mysql error      if   mysql select db   ram          die   Connected to Server  but Failed to Connect to Database -    mysql errno        mysql error        Prepare the INSERT Query    insertTPL    INSERT INTO  name  VALUES    s      s      s      s         insertSQL   sprintf   insertTPL                    mysql real escape string   name                      mysql real escape string   add1                      mysql real escape string   add2                      mysql real escape string   mail         Execute the INSERT Query   if      insertRes   mysql query   insertSQL            echo   lt p gt Insert of Row into Database Failed -    mysql errno        mysql error     lt  p gt       else      echo   lt p gt Person  s Information Inserted lt  p gt           Prepare the SELECT Query    selectSQL    SELECT   FROM  names       Execute the SELECT Query   if      selectRes   mysql query   selectSQL            echo  Retrieval of data from Database Failed -    mysql errno        mysql error       else        gt   lt table border  2  gt     lt thead gt       lt tr gt         lt th gt Name lt  th gt         lt th gt Address Line 1 lt  th gt         lt th gt Address Line 2 lt  th gt         lt th gt Email Id lt  th gt       lt  tr gt     lt  thead gt     lt tbody gt       lt  php       if  mysql num rows   selectRes    0            echo   lt tr gt  lt td colspan  4  gt No Rows Returned lt  td gt  lt  tr gt           else          while   row   mysql fetch assoc   selectRes                echo   lt tr gt  lt td gt   row  name    lt  td gt  lt td gt   row  addr1    lt  td gt  lt td gt   row  addr2    lt  td gt  lt td gt   row  mail    lt  td gt  lt  tr gt  n                           gt     lt  tbody gt   lt  table gt       lt  php        gt      Notes  Cautions and Caveats  Your initial solution did not show any obvious santisation of the values before passing them into the Database  This is how SQL Injection attacks  or even un-intentional errors being passed through SQL  occur  Don t do it   Your database does not seem to have a Primary Key  Whilst these are not  technically  necessary in all usage  they are a good practice  and make for a much more reliable way of referring to a specific row in a table  whether for adding related tables  or for making changes within that table   You need to check every action  at every stage  for errors  Most PHP functions are nice enough to have a response they will return under an error condition  It is your job to check for those conditions as you go - never assume that PHP will do what you expect  how you expect  and in the order you expect  This is how accident happen     My provided code above contains alot of points where  if an error has occured  a message will be returned  Try it  see if any error messages are reported  look at the Error Message  and  if applicable  the Error Code returned and do some research   Good luck

User · Answer

Here is the solution total html with php and database connections      lt  doctype html gt       lt html lang  en  gt       lt head gt         lt meta charset  UTF-8  gt         lt title gt database connections lt  title gt       lt  head gt       lt body gt         lt  php        username    database-username          password    database-password          host    localhost           connector   mysql connect  host  username  password            or die  Unable to connect            echo  Connections are made successfully            selected   mysql select db  test db    connector          or die  Unable to connect             execute the SQL query and return records        result   mysql query  SELECT   FROM table one             gt         lt table border  2  style   background-color   84ed86  color   761a9b  margin  0 auto    gt         lt thead gt           lt tr gt             lt th gt Employee id lt  th gt             lt th gt Employee Name lt  th gt             lt th gt Employee dob lt  th gt             lt th gt Employee Adress lt  th gt             lt th gt Employee dept lt  th gt             lt td gt Employee salary lt  td gt           lt  tr gt         lt  thead gt         lt tbody gt           lt  php           while   row   mysql fetch assoc   result                  echo               lt tr gt                 lt td gt   row   employee id     lt  td gt                 lt td gt   row   employee name     lt  td gt                 lt td gt   row   employee dob     lt  td gt                 lt td gt   row   employee addr     lt  td gt                 lt td gt   row   employee dept     lt  td gt                 lt td gt   row   employee sal     lt  td gt                lt  tr gt  n                         gt         lt  tbody gt       lt  table gt        lt  php mysql close  connector     gt       lt  body gt       lt  html gt

[php] retrieve data from db and display it in table in php .. see this code whats wrong with it?

Examples related to php

Examples related to database