Returning MySQL Results as HTML Tables... Or something like that.

Mega Mario · 12-20-2007, 11:11 PM

Hi all.

No time no see.

I'm working on my own community called World 9 Gaming & Hacking. It's a community for gamers and hackers that hack games like Half-Life 2 and such, but not computer hacking.

I'm working on a Hack Database Page.

The thing is, I don't know how to get a MySQL Query to output HTML Table Rows. Here is what I mean:

The HTML tables' titles are:

Hack Name | Description | Version | Hack Author | Download

And I want a result to be like this:

Test Hack | A Test Hack | 1 | Mega Mario | Click here

So the end result is something like this:

Hack Name | Description | Version | Hack Author | Download
Test Hack | A Test Hack | 1 | Mega Mario | Click here

Can anyone post a example of what I would do? I've read many tutorials, and I'm lost. Then I remembered you guys.

Thanks,
Mega Mario

jdspc · 12-21-2007, 01:40 AM

This is an example of what I use to table a list of recent topics by topic, author and date to my index.php page.
Definitly get another opinion, I am just swingin in the dark here but it might spark an idea at least.

PHP Code:


		
			
<?php require("path/to/myDB"); ?>

<html>

<head></head>

<body>

blah blah

<?php

    $array = myDB(field1,field2,field3,field4,field5,'array');

    foreach ($array as $hack)

    {

        echo '

            <table border="0" width="100%" align="center" class="ssi_table">

                <tr>

                    <td><b>', $hack['field1'], '</b></td>

                </tr>

                <tr>

                    <td><b>', $hack['field2'], '</b></td>

                </tr>

                <tr>

                    <td><b>', $hack['field3'], '</b></td>

                </tr>

                <tr>

                    <td><b>', $hack['field4'], '</b></td>

                </tr>

                <tr>

                    <td>', '<a href="' . $hack['href'] . '">' . $hack['field5'], '<br /><br /></td>

                </tr>

            </table>

            <br />';

        if (!$hack['is_last'])

            echo '

            <hr width="100%" />

            <br />';

    }

?>

</body>

</html>

Mega Mario · 12-21-2007, 04:47 PM

Thanks, but what is the "/path/to/myDB" part? Is that your SQL Settings?

jdspc · 12-21-2007, 04:52 PM

Yes
Sorry for the lack of clarity...my fault there...
It should point to your db...

jdspc · 12-21-2007, 05:04 PM

btw
There is a cat here in v7n that seems to rule at this kind of stuff - 'exam' (and others I am sure!)

I posted that tidbit up for some ideas to ponder until exam or someone else saw it and possibly added clarity to it or at least showed me the errors of my ways.

That works for me though...
You can check out an example http://jdspc.com/indexCss.php
But I warn you, I am editing css on the fly right now so it looks a bit messy

Good Luck and keep me posted!

Mega Mario · 12-21-2007, 05:15 PM

Interesting. So, I replace the path to db part with the SQL Connect commands and such?

jdspc · 12-21-2007, 05:28 PM

correct

create a php file that contains all of your db info - connection etc
call it ssi.php
then point to that.

Using that 'require' function or 'include' on any page allows connectivity/interactivity with your db.

http://w3schools.com/php/func_mysql_connect.asp

There is a good amount of info on that link....

Mega Mario · 12-21-2007, 06:14 PM

Ok, I created the ssi.php and put that code in. What table in the database do I create now?

jdspc · 12-21-2007, 07:39 PM

Quote:

Originally Posted by Mega Mario

Ok, I created the ssi.php and put that code in. What table in the database do I create now?

The php file 'ssi.php' should just contain info for connection and be placed in the root folder of your site, then use the 'require' function at the begining of your webpage(s) pointing to that file.

Then in the body of that webpage(s) use the example I posted above to connect and call your db fields. It will place them in a table.

I understand where you are at right now and I wish I could be more insightful, so I will rely on the kindness of a friend to help us further your intent. - mySQL is not my forte.

I will get back with you when I get better information...but that is a start.

Jeff

Capo64 · 12-22-2007, 07:20 AM

You have a database with your hacks in it, right?