- This topic is empty.
-
Good afternoon, I recently developed a php file which now links to my MySQL database (finally pulling the data successfully). The php file refreshes every 5 seconds. We have a youth league and I am looking to make the webpage more exciting. I am just a beginner (finance person not a web person) so not sure where to go from here. I read about php and html5 and MySQL but have not been able to find how to get started on formatting.
The table of data is below but looking to format like the score board or insert data into the scoreboard picture (making sure it refreshes automatically every 5 seconds for the kids viewing)
Any help would be appreciated
Cheers,
DavidWeb link
http://dvrhome.ca/search2.php?term=2My beginner code:
<?php
$url1=$_SERVER[‘REQUEST_URI’];
header(“Refresh: 5; URL=$url1”);
?>
<?php
mysql_connect(“localhost”,”username”,”password”);
mysql_select_db(“database”);
$results = mysql_query(“SELECT * FROM Games WHERE Id LIKE ‘%$_GET[term]%'”);
echo “<table border=’1′ style=’background-color:#cecece;’ align=’center’>
<tr>
<th>Game #</th>
<th>Gender</th>
<th>Age Group</th>
<th>Home Team</th>
<th>Home Score</th>
<th>Away Team</th>
<th>Away Score</th>
<th>Quarter</th>
<th>Date</th>
<th>Location</th>
</tr>”;
while($ser = mysql_fetch_array($results)) {
echo “<tr>”;
echo “<th>$ser[Id]</th>”;
echo “<th>$ser[Gender]</th>”;
echo “<th>$ser[AgeGroup]</th>”;
echo “<th>$ser[HomeTeam]</th>”;
echo “<th>$ser[HomeScore]</th>”;
echo “<th>$ser[AwayTeam]</th>”;
echo “<th>$ser[AwayScore]</th>”;
echo “<th>$ser[Quarter]</th>”;
echo “<th>$ser[Date]</th>”;
echo “<th>$ser[Location]</th>”;echo "</tr>";}
?>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=windows-1252″>
<title>What is the score</title>
</head>
<body bgcolor=”#000000″>
<center>
</center>
<hr>
</body>
</html>
- The forum ‘Design’ is closed to new topics and replies.
