- This topic is empty.
-
AuthorPosts
-
July 14, 2014 at 12:08 pm #175405ddcarreiroParticipant
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> -
AuthorPosts
- The forum ‘Design’ is closed to new topics and replies.