Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.
I've been trying to format my PHP output on my script. So far I can do three things... Bold Italic Underline using b i u but thats it.. I have no clue how to use color or font or anything.
Any ideas? It would be ideal to be able to have no border.. which I know how to do.. and have alternating font/text backing color for each row.
<?php
include('dbconnect.php');
?><style type="text/css">
<!--
body {
}
-->
</style>
...
<?php
// Get all the data from the "Groups" table
$result = mysql_query("SELECT * FROM Groups")
or die(mysql_error());
echo "<table border='1'>";
echo "<tr> <th><b>University</b></th> <th>Group</th> <th>State</th> <th>Zip Code</th> <th>Website</th> <th>Email</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['University_Name'];
echo "</td><td>";
echo $row['Group_Name'];
echo "</td><td>";
echo $row['State'];
echo "</td><td>";
echo $row['Zipcode'];
echo "</td><td>";
echo $row['Website'];
echo "</td><td>";
echo $row['Email'];
echo "</td></tr>";
}
echo "</table>";
?>
To remove the border change echo "<table border='1'>"; to echo "<table border='0>";. To alternate rows you can to switch back and forth between colors using PHP, or you have use a Javascript library to change the output once the document loads.
<?php
include('dbconnect.php');
?><link href="custom.css" rel="stylesheet" type="text/css">
<!--
body {
}
-->
</style>
...
<?php
// Get all the data from the "Groups" table
$result = mysql_query("SELECT * FROM Groups")
or die(mysql_error());
$num='0';
echo "<table border='1'>";
echo "<tr> <th><b>University</b></th> <th>Group</th> <th>State</th> <th>Zip Code</th> <th>Website</th> <th>Email</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr>";
if ($num%2=='1') {
echo "<td class='white'>";
} else {
echo "<td class='blue'>"; }
echo $row['University_Name'];
echo "</td><td>";
echo $row['Group_Name'];
echo "</td><td>";
echo $row['State'];
echo "</td><td>";
echo $row['Zipcode'];
echo "</td><td>";
echo $row['Website'];
echo "</td><td>";
echo $row['Email'];
echo "</td></tr>";
$num++;
}
echo "</table>";
?>
I placed the css file in the directory.. and it changes the font style on the University column but nothing else.. no color or font changes.