Display mysql table fields and data - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

goldfish · 08-02-2005, 07:57 PM

Hello All,

I need to create a php script to display a mysql table fields and the data. Any assistance is much appreciated.

thanks

Jim_Westergren · 08-02-2005, 08:42 PM

Here I give you:

<CENTER>
<H1>MySQL Database</H1>
</CENTER>

<?php

// Database connection
require ("../db.cnf.php");

$sql = mysql_query("SELECT * FROM table ORDER BY column ASC");

echo "<table border='0' CELLPADDING=5 STYLE='font-size:13px'>";
echo "<tr> <td><H3>Column 1 Name</h3></td> <td><H3>Column 2 Name</H3></td> <td><H3>Column 3 Name</H3></td><td><H3>Column 4 Name</H3></td></tr>";
// keeps getting the next row until there are no more to get
while ($row = mysql_fetch_array($sql)) {

// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['Column 1 Name'];
echo "</td><td>";
echo $row['Column 2 Name'];
echo "</td><td>";
echo $row['Column 3 Name'];
echo "</td><td>";
echo $row['Column 4 Name'];
echo "</td></tr>";
}
echo "</table>";

?>

Hope this helped you.

sandman · 08-02-2005, 08:55 PM

Here is another example although ~Jim_Westergren's code should work fine. Replace the connection and table variables with your own.

viewall.php

PHP Code:


		
			
<html> 

<head><title>Your Page Title</title></head> 

<body> 

<?php 

$database="yourdbname"; 

mysql_connect ("localhost", "yourusername", "yourpassword"); 

@mysql_select_db($database) or die( "Unable to select database"); 

$result = mysql_query( "SELECT * FROM yourtable" ) 

or die("SELECT Error: ".mysql_error()); 

$num_rows = mysql_num_rows($result); 

print "There are $num_rows records.<P>"; 

print "<table width=400 border=1>\n"; 

while ($get_info = mysql_fetch_row($result)){ 

print "<tr>\n"; 

foreach ($get_info as $field) 

print "\t<td><font face=arial size=1/>$field</font></td>\n"; 

print "</tr>\n"; 

} 

print "</table>\n"; 

?> 

</body> 

</html>

viewcertainfields.php

PHP Code:


		
			
<html> 

<head><title>Your Page Title</title></head> 

<body> 

<?php 

$database="yourdbname"; 

mysql_connect ("localhost", "yourusername", "yourpassword"); 

@mysql_select_db($database) or die( "Unable to select database"); 

$result = mysql_query( "SELECT field1, field2, field3 FROM yourtable" ) 

or die("SELECT Error: ".mysql_error()); 

$num_rows = mysql_num_rows($result); 

print "There are $num_rows records.<P>"; 

print "<table width=200 border=1>\n"; 

while ($get_info = mysql_fetch_row($result)){ 

print "<tr>\n"; 

foreach ($get_info as $field) 

print "\t<td><font face=arial size=1/>$field</font></td>\n"; 

print "</tr>\n"; 

} 

print "</table>\n"; 

?> 

</body> 

</html>

You can also add limit and order to the query...

Chikenty · 09-04-2006, 10:44 AM

wondering if any1 could help me with to put a limit and to put a sort on it..oh yeah and if colum names if u could :-) i just need sum help thanks

pr0gr4mm3r · 09-04-2006, 11:51 AM

I have this function in my main include file to debug SQL queries:

PHP Code:


		
			
function DumpSQL($result)

{    

    if($result == 0)

    {

        echo "<b>Error ".mysql_errno().": ".mysql_error()."</b>";

    }

    elseif (@mysql_num_rows($result) == 0)

    {

        echo("<b>Query completed. No results returned.</b><br>");

    }

    else

    {

        echo "<table border='1'>

            <thead>

            <tr><th>[Num]</th>";

        for($i = 0;$i < mysql_num_fields($result);$i++)

        {

            echo "<th>" . $i . "&nbsp;-&nbsp;" . mysql_field_name($result, $i) . "</th>";

        }

        echo "  </tr>

            </thead>

            <tbody>";

        for ($i = 0; $i < mysql_num_rows($result); $i++)

        {

            echo "<tr><td>[$i]</td>";

            $row = mysql_fetch_row($result);

            for($j = 0;$j < mysql_num_fields($result);$j++) 

            {

                echo("<td>" . $row[$j] . "</td>");

            }

            echo "</tr>";

        }

        echo "</tbody>

        </table>";

    }  //end else

}

Then to use it, do it this way:

PHP Code:


		
			
$query = "SELECT * FROM Table";

$result = mysql_query($query);

DumpSQL($result);

Query to limit your results (The limit clause goes after the WHERE, ORDER BY clause if exists):

Code:

SELECT * FROM table LIMIT 20

Query that sorts:

Code:

SELECT * FROM table ORDER BY field

Chikenty · 09-04-2006, 04:42 PM

nittounlimited.com/view.php shows All Ratios is my current display page..and nittounlimited.com/view3.php is the 1 i want to add something similar of sorting to..thanks

ganeshkmb · 05-14-2008, 04:49 AM

[quote=goldfish]Hello All,

I need to have INBOX and Sent Items ina form . how can i receive a mail from the others and how can i send a file from my PHP script.. How can i save the mails ..

Tell me its very Urgent.
Thank u all..