MySQL results display

Codewalkers Forums Sponsor:

AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!

July 20th, 2002, 10:58 PM

mhoward

Join Date: Apr 2007

Location: UK

Posts: 49

Time spent in forums: < 1 sec
Reputation Power: 2

MySQL results display

I have a script where a user can connect to my MySQL server and view information in any of their databases. Problem I am having is that when I want to display the content of any one of their tables, I cannot place them neatly into a table.
I have worked out how to put the tables field names into a table using...

$fields = mysql_list_fields("$userdbase", "$tbls");
$columns = @mysql_num_fields($fields);

$content = "<div align="center">n";
$content .= "<table border="1" cellspacing="0" cellpadding="0"n>";
$content .= "<tr>n";

for ($i = 0; $i < $columns; $i++) {
$headers = mysql_field_name($fields, $i) . "n";

$content .= "<td align="center" class="mainboxfont"><b>$headers</b></td>n";
}
$content .= "</tr>n";
but am struggling to put the actual information from the table into new rows in the same table.
I am using PHP templates which is the reason the code may look unusual.
Any help appreciated.

thanks

July 21st, 2002, 01:06 AM

mikesgt2

Join Date: Apr 2007

Posts: 21

Time spent in forums: < 1 sec
Reputation Power: 0

RE: MySQL results display

I wrote a script like that once for some IT coursework, the script is copied here:

php Code:

Original - php Code

<html>
<head>
<title>Accessing data from a MySql Database with PHP</title>
</head>
<body>
<h2>Listing Data From a MySql Table</h2>
<table border="1" width="300">
<?php
$link = mysql_connect() or die("Could not connect to Server");
mysql_select_db("sample", $link);
$result = mysql_query("SELECT * FROM blah", $link);
print "<tr>";
    for($i = 0; $i < mysql_num_fields($result); $i++)
    {
        print "<th>".mysql_field_name($result, $i)."</th>";
    }
print "</tr>n";
    while($row = mysql_fetch_row($result))
    {
        print "<tr>";
            foreach($row as $val)
            {
                print "<td>$val</td>";
            }
        print "</tr>n";
    }
mysql_close($link);
?>
</table>
</body>
</html>

Hope this helps!

Viewing: Codewalkers Forums > PHP Related > PHP Coding > MySQL results display

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump