Viewing a Database

[old.Pac]

Copy and past this code to view a database:



<?php

// Set the variables for the database access:

$Host = "freesql.org";

$User = "Username";

$Password = "Password";

$DBName= "DBName";

$TableName = "TableName";


// Connects to the database

$Link = mysql_connect ($Host, $User, $Password);


$Query = "select * from $TableName";

$Result = mysql_db_query ($DBName, $Query, $Link);


// Create a HTML Table on your page
// You can add as many files as you like.

print ("<table border=0 cellpadding=3 cellspacing=1 width=\"75%\" align=center>\n");

print ("<tr align=center valign=top>\n");

print ("<td align=center valign=top>Name</td>\n");

print ("<td align=center valign=top>Email Address</td>\n");

print ("<td align=center valign=top>Comments</td>\n");

print ("</tr>\n");


// Fetch the results from the database

while ($Row = mysql_fetch_array

($Result)) {

print ("<tr align=center valign=top>\n");

print ("<td align=center valign=top>$Row[FirstName] $Row[LastName]</td>\n");

print ("<td align=center valign=top>$Row[EmailAddress]</td>\n");

print ("<td align=center valign=top>$Row[Comments]</td>\n");

print ("</tr>\n");

}

mysql_close ($Link);

print ("</table>\n");

?>

 

[old.Zaldbag]

WOW! That's THE BEST example I have seen yet! Now I motivated to learn PHP!

 

[old.Pac]

Well thats what the forums are for, to share our knowledge.

If you want to see a Roster running this script go to my site (In my sig) and click Roster. Its using the exact script above, only with a few modifications.

 

[Testin da Cable]

hehe you've even made _me_ interested
btw, can we have a perl tech forum pweeeeeezeee

 

[old.^S0LIDUS^]

is there some sort of proceedure for requesting a new forum??

 

[Testin da Cable]

yeah begging

nah, I believe one may present a reasoned argument for it via irc/mail/the forum and the request will be considered by the powers that be.

-TdC