|
PHP - Football Stats Center
I tried to code this, but failed miserably.
What I wanted was a admin page that contained various stats of a football match. TEAM 1....................TEAM 2 0...........Score...........0 0.......Shots on target.......0 0.......Shots off target.......0 ect, ect.... The first way I layed it out was a table, i entered the data and it saved to a text file, which then displayed on stats.php in a table format. That then displayed elsewhere via an iframe. I was wondering if someone would code me a stats center like I've explained! You could even help me do it, I don't mind....As long as I get it! Similar TutorialsHi All I am trying to insert a feed on my site that automatically updates the football league etc like this one http://news.bbc.co.uk/sport1/hi/football/eng_div_1/table/default.stm is there a way to do this please? thanks Hiya, What's the best way of finding out and displaying the total number of users currently online, along a breakdown of how many of these users are members or guests? I also wish to find out and display the total number of users who were online today, along with a breakdown of how many of these users are members or guests. I've noticed that users of the same computer could of course use a different browser preference to another user of the same computer. What should happen in this situation? Any help is much appreciated. Cheers! Hello i whant to creat stats page for my website can sombady help me how can SELECT database id |user_id | site_id | date 1 | 2222 | 18 | 2011-11-28 06:10:06 select id COUNT(site_id ) from table WHERE date = ? i whant to select last 7 days from database and count site_id per day . I have a table of members (18) with games played, won, drawn, lost and would like to know if its possible to have the points and percentage update automatically, example- ID Member Grade Played Won Drawn Lost Points % 1 Player name 142 13 1 10 2 6 46.15 My web-page is currently static and i go to http://math.about.com/library/weekly/aa061502a.htm fill in the games played and points and it gives the percentage, i have very little knowledge of php and by some miracle have managed to create a database using wamp and have extracted the data onto local host web page, my code as follows please let me know if i have any errors- Code: [Select] <?php require "connect.inc.php"; echo "<table width='700'> <tr> <th></th> <th>Member</th> <th>Grade</th> <th>Played</th> <th>Won</th> <th>Drawn</th> <th>Lost</th> <th>Points</th> <th>&#37;</th> </tr>"; $result = mysql_query("SELECT * FROM members"); while ($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['id'] . "</td>"; echo "<td>" . $row['member'] . "</td>"; echo "<td>" . $row['grade'] . "</td>"; echo "<td>" . $row['played'] . "</td>"; echo "<td>" . $row['won'] . "</td>"; echo "<td>" . $row['drawn'] . "</td>"; echo "<td>" . $row['lost'] . "</td>"; echo "<td>" . $row['points'] . "</td>"; echo "<td>" . $row['percentage'] . "</td>"; echo "</tr>"; } echo "</table>"; ?> Please tell me how i can have the points and percentage update automatically and keep in mind im a novice with php. Best wishes, John Hi Everyone, I have seen on the web that you can purchase some server monitoring applications, which mainly run using PHP. Because I don't necesserally need something so powerful, I just want to monitor memory usage and cpu usage. Is there anyway that I can do this using PHP? I have SMNP enabled if that helps? Thanks Matt Hey guys, I want to create stats of visitors and some other values in the database depending on time. The stats are supposed to be created one time per hour. What can I use for it? Cronjob? What will be if it doesn't work?? Thanks for helping! I need a simple line graph for my PHP site showing page views against date (monthly). Have tried to find plugins but can't find an appropriate one. Can someone please help with a script or direct me to a plugin. Attached is the kind of graph I'd like to have. Hi, Competitors vs. against each other and are recorded in a database. Each participant equally has 4 matches each, as you can see in the attatchment following the points gained in their played matches. I want to be able to determine the qualified participants according to either their "points" or "wins/losses". If two competitors have the same points, then I have already made a solution that another match must be generated for the two participants with the same points and draws can not be submitted which means the points will always be different for each team. I want to pick out half of participants 8/16 (screenshot below) with highest points which will be the qualifiers, or pick out half participants 8/16 with best match stats according to wins/losses. Any help I would be very grateful, thanks. I want to automatically import some affiliate stats from a few sites into my website. How can I do it? I am new to php. Hey guys, What im trying to do is get the users screen resolution and place it into a database so that i can call it up and place it onto a stats page. So far i get the idea that you have to use Javascript to get the resolution then use PHP to pull that information. What i want to do is pull the screen resolutions and place them into a database so that i can call upon them to place into a stats page So far i have the following getting certain bits of information and banging them into the database using the stats.inc.php then calling them up and placing them onto stats.php. the stats.inc.php is included on every page of my site so it can track where a users has been etc etc. Im assuming i can insert something into my headerLoggedin.inc.php file that will pull the users resolution then use some PHP in the stats.inc.php script to pull that information and then insert it into my database which i can then easily pull from and place into the stats.php page. I know this seems like a bit of a silly thing to be doing, its for a college assignment and im pretty stumped. Any help is appreciated thanks guys. headerLoggedin.php Code: [Select] <?php include('includes/security.inc.php'); ?> <?php include('includes/stats.inc.php');?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-type" content="text/html; charset=utf-8" /> <meta http-equiv="Content-Language" content="en-us" /> <link rel="stylesheet" href="css/index.css" type="text/css"/> <title>############</title> </head> <body> <!-- Start of wrapper div--> <div id="wrapper"> <!-- Start of header div--> <div id="header"> <div id="logo"><img src="./images/logo.png" width="412" height="32" alt="Elite Recruitment Services" /></div> <div id="navigation"> <ul class="nav"> <li><a href="news.php">News Page</a></li> <li><a href="edit.php">Edit text file</a></li> <li><a href="upload.php">Upload text file</a></li> <li><a href="stats.php">Stats</a></li> <li><a href="logout.php">Logout</a></li> </ul> </div> </div> <!--End of header div--> <!--Start of loginContainer div--> <div id="formsContainer"> stats.inc.php Code: [Select] <?php $db_host = "localhost"; // Databases host name $db_username ="#######"; // Database Username $db_password ="#######"; // Database Password $db_name ="dannymit_stats"; // Databases name $db_table="statTracker"; // Database table where the logins are stored mysql_connect("$db_host", "$db_username", "$db_password"); // Connects to the database using the preset host, username and password mysql_select_db("$db_name"); // Selects the database. //collect information... $browser = $_SERVER['HTTP_USER_AGENT']; // get the browser name $curr_page = $_SERVER['PHP_SELF'];// get page name $ip = $_SERVER['REMOTE_ADDR']; // get the IP address $from_page = $_SERVER['HTTP_REFERER'];// page from which visitor came $page = $_SERVER['PHP_SELF'];//get current page $width = $_GET['width']; //Gets users screen width $height = $_GET[['height']; //Gets users screen height //Insert the data in the table... $query_insert = "INSERT INTO statTracker (browser,ip,thedate_visited,page,from_page) VALUES ('$browser','$ip',now(),'$page','$from_page')" ; $result=mysql_query ( $query_insert); if(!$result){ die(mysql_error()); } ?> stats.php Code: [Select] <?php // Header include include('includes/headerLoggedin.inc.php'); include('includes/stats.inc.php'); ?> <br/><br/> <?php $db_host = "localhost"; // Databases host name $db_username ="######"; // Database Username $db_password ="######"; // Database Password $db_name ="dannymit_stats"; // Databases name $db_table="statTracker"; // Database table where the logins are stored mysql_connect("$db_host", "$db_username", "$db_password"); // Connects to the database using the preset host, username and password mysql_select_db("$db_name"); // Selects the database. $sqlquery = "SELECT * FROM `$db_table`"; $result = mysql_query($sqlquery); $num = mysql_num_rows($result); mysql_close(); while ($row = mysql_fetch_array($result, MYSQL_NUM)) { printf ("Browser:<br/> %s<br/> IP Address:<br/> %s<br/> Date Visited:<br/> %s<br/> Page Visited:<br/> %s<br/> Paged Visited From:<br/> %s<br/>", $row[1], $row[2], $row[3], $row[4], $row[5]); echo "<br />"; } ?> <?php include('includes/footer.inc.php');?> Hi! So I'm working for someone, and they want me to fix this error in a PHP file.. Here is the code: <?php
include_once('config.php');
$online = mysql_query("SELECT * FROM bots WHERE status LIKE 'Online'");
$offline = mysql_query("SELECT * FROM bots WHERE status LIKE 'Offline'");
$dead = mysql_query("SELECT * FROM bots WHERE status LIKE 'Dead'");
$admintrue = mysql_query("SELECT * FROM bots WHERE admin LIKE 'True'");
$adminfalse = mysql_query("SELECT * FROM bots WHERE admin LIKE 'False'");
$windows8 = mysql_query("SELECT * FROM bots WHERE so LIKE '%8%'");
$windows7 = mysql_query("SELECT * FROM bots WHERE so LIKE '%7%'");
$windowsvista = mysql_query("SELECT * FROM bots WHERE so LIKE '%vista%'");
$windowsxp = mysql_query("SELECT * FROM bots WHERE so LIKE '%xp%'");
$unknown = mysql_query("SELECT * FROM bots WHERE so LIKE 'Unknown'");
$totalbots = mysql_num_rows(mysql_query("SELECT * FROM bots"));
$onlinecount = 0;
$offlinecount = 0;
$deadcount = 0;
$admintruecount = 0;
$adminfalsecount = 0;
$windows8count = 0;
$windows7count = 0;
$windowsvistacount = 0;
$windowsxpcount = 0;
$unknowncount = 0;
while($row = mysql_fetch_array($online)){
$onlinecount++;
}
while($row = mysql_fetch_array($offline)){
$offlinecount++;
}
while($row = mysql_fetch_array($dead)){
$deadcount++;
}
while($row = mysql_fetch_array($admintrue)){
$admintruecount++;
}
while($row = mysql_fetch_array($adminfalse)){
$adminfalsecount++;
}
while($row = mysql_fetch_array($windows8)){
$windows8count++;
}
while($row = mysql_fetch_array($windows7)){
$windows7count++;
}
while($row = mysql_fetch_array($windowsvista)){
$windowsvistacount++;
}
while($row = mysql_fetch_array($windowsxp)){
$windowsxpcount++;
}
while($row = mysql_fetch_array($unknown)){
$unknowncount++;
}
$statustotal = $onlinecount + $offlinecount + $deadcount;
$admintotal = $admintruecount + $adminfalsecount;
$sototal = $windows7count + $windowsvistacount + $windowsxpcount + $unknowncount;
?>
Can anyone tell me the error here, can how to fix it? Hi! I have this code
<?php
/**
* @Project: Virtual Airlines Manager (VAM)
* @Author: Alejandro Garcia
* @Web http://virtualairlinesmanager.net
* Copyright (c) 2013 - 2016 Alejandro Garcia
* VAM is licensed under the following license:
* Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)
* View license.txt in the root, or visit http://creativecommons.org/licenses/by-nc-sa/4.0/
*/
?>
<!DOCTYPE html>
<html>
<head>
<script
src="https://maps.googleapis.com/maps/api/js?key=XXX&callback=initMap" type="text/javascript">
</script>
<meta http-equiv="refresh" content="300">
</head>
<body>
<?php
include('./db_login.php');
$db_map = new mysqli($db_host , $db_username , $db_password , $db_database);
$db_map->set_charset("utf8");
if ($db_map->connect_errno > 0) {
die('Unable to connect to database [' . $db_map->connect_error . ']');
}
$sql_map = "select plane_type,ias,flight_id,u.gvauser_id as gvauser_id,u.callsign as callsign,u.name as name,gs,altitude,surname,departure,arrival,latitude,longitude,flight_status,heading,perc_completed,
pending_nm, a1.latitude_deg as dep_lat, a1.longitude_deg as dep_lon , a2.latitude_deg as arr_lat, a2.longitude_deg as arr_lon , network
from vam_live_flights lf, gvausers u , airports a1, airports a2 where u.gvauser_id=lf.gvauser_id and lf.departure=a1.ident and lf.arrival=a2.ident";
if (!$result = $db_map->query($sql_map)) {
die('There was an error running the query [' . $db_map->error . ']');
}
unset($flights_coordinates);
unset($flight);
unset($liveflights);
unset($datos);
unset($jsonarray);
$flights_coordinates = array();
$datos = array ();
$flight = array();
$liveflights = array ();
$jsonarray = array ();
$index = 0;
$index2=0;
$flightindex=0;
while ($row = $result->fetch_assoc()) {
$flight["gvauser_id"]=$row["gvauser_id"];
$flight["callsign"]=$row["callsign"];
$flight["name"]=$row["name"];
$flight["gs"]=$row["gs"];
$flight["ias"]=$row["ias"];
$flight["altitude"]=$row["altitude"];
$flight["surname"]=$row["surname"];
$flight["departure"]=$row["departure"];
$flight["arrival"]=$row["arrival"];
$flight["latitude"]=$row["latitude"];
$flight["longitude"]=$row["longitude"];
$flight["flight_status"]=$row["flight_status"];
$flight["heading"]=$row["heading"];
$flight["dep_lat"]=$row["dep_lat"];
$flight["dep_lon"]=$row["dep_lon"];
$flight["arr_lat"]=$row["arr_lat"];
$flight["arr_lon"]=$row["arr_lon"];
$flight["perc_completed"]=$row["perc_completed"];
$flight["pending_nm"]=$row["pending_nm"];
$flight["network"]=$row["network"];
$flight["plane_type"]=$row["plane_type"];
$liveflights[$flightindex] =$flight;
$sql_map2 = "select * from vam_live_acars where flight_id='".$row["flight_id"]."' order by id asc";
if (!$result2 = $db_map->query($sql_map2)) {
die('There was an error running the query [' . $db_map->error . ']');
}
while ($row2 = $result2->fetch_assoc()) {
$flights_coordinates ["gvauser_id"] = $row2["gvauser_id"];
$flights_coordinates ["latitude"] = $row2["latitude"];
$flights_coordinates ["longitude"] = $row2["longitude"];
$flights_coordinates ["heading"] = $row2["heading"];
$datos [$index2][$index] = $flights_coordinates;
$index ++;
}
$index=0 ;
$index2 ++;
$flightindex ++;
}
$jsonarray[0]=$liveflights;
$jsonarray[1]=$datos;
?>
<div class="container">
<div class="row">
<div id="map-outer" class="col-md-11">
<div id="map-container" class="col-md-12"></div>
<div id="over_map"></div>
</div><!-- /map-outer -->
</div> <!-- /row -->
</div><!-- /container -->
<style>
body { background-color:#FFFFF }
#map-outer {
padding: 0px;
border: 0px solid #CCC;
margin-bottom: 0px;
background-color:#FFFFF }
#map-container { height: 500px }
@media all and (max-width: 800px) {
#map-outer { height: 650px }
}
</style>
<style>
#wrapper { position: relative; }
#over_map { position: absolute; top: 50px; left: 10px; z-index: 99; background: white;}
</style>
</body>
<script type="text/javascript">
var mapCentre;
var map ;
function init_map() {
var flights = <?php echo json_encode($jsonarray[0]); ?>;
var locations = <?php echo json_encode($jsonarray[1]); ?>;
var numpoints=(locations.length);
console.log(locations);
var var_location = new google.maps.LatLng(<?php echo $datos[0][0]["latitude"]; ?>,<?php echo $datos[0][0]["longitude"]; ?>);
var var_mapoptions = {
center: var_location,
zoom: 5,
styles: [{"featureType":"all","elementType":"all","stylers":[{"saturation":"0"},{"lightness":"0"}]},{"featureType":"all","elementType":"geometry","stylers":[{"lightness":"20"}]},{"featureType":"administrative","elementType":"all","stylers":[{"visibility":"off"}]},{"featureType":"administrative","elementType":"geometry.stroke","stylers":[{"visibility":"on"}]},{"featureType":"administrative","elementType":"labels","stylers":[{"visibility":"on"},{"color":"#716464"},{"weight":"0.01"}]},{"featureType":"administrative.country","elementType":"labels","stylers":[{"visibility":"on"}]},{"featureType":"landscape","elementType":"all","stylers":[{"visibility":"simplified"}]},{"featureType":"landscape.natural","elementType":"geometry","stylers":[{"visibility":"simplified"}]},{"featureType":"landscape.natural.landcover","elementType":"geometry","stylers":[{"visibility":"simplified"}]},{"featureType":"poi","elementType":"all","stylers":[{"visibility":"simplified"}]},{"featureType":"poi","elementType":"geometry.fill","stylers":[{"visibility":"simplified"}]},{"featureType":"poi","elementType":"geometry.stroke","stylers":[{"visibility":"simplified"}]},{"featureType":"poi","elementType":"labels.text","stylers":[{"visibility":"simplified"}]},{"featureType":"poi","elementType":"labels.text.fill","stylers":[{"visibility":"simplified"}]},{"featureType":"poi","elementType":"labels.text.stroke","stylers":[{"visibility":"simplified"}]},{"featureType":"poi.attraction","elementType":"geometry","stylers":[{"visibility":"on"}]},{"featureType":"road","elementType":"all","stylers":[{"visibility":"on"}]},{"featureType":"road","elementType":"labels","stylers":[{"visibility":"on"}]},{"featureType":"road.highway","elementType":"all","stylers":[{"visibility":"off"}]},{"featureType":"road.highway","elementType":"geometry","stylers":[{"visibility":"on"}]},{"featureType":"road.highway","elementType":"geometry.fill","stylers":[{"visibility":"on"},{"color":"#ffad99"},{"lightness":"45"}]},{"featureType":"road.highway","elementType":"geometry.stroke","stylers":[{"visibility":"on"},{"color":"#fbac99"},{"lightness":"1"}]},{"featureType":"road.highway","elementType":"labels","stylers":[{"visibility":"on"}]},{"featureType":"road.highway.controlled_access","elementType":"geometry.fill","stylers":[{"color":"#ffff80"},{"lightness":"50"}]},{"featureType":"road.highway.controlled_access","elementType":"geometry.stroke","stylers":[{"color":"#ff6666"},{"lightness":"59"},{"visibility":"on"},{"weight":"1.10"}]},{"featureType":"road.arterial","elementType":"geometry.fill","stylers":[{"visibility":"on"},{"color":"#fff13a"}]},{"featureType":"road.arterial","elementType":"geometry.stroke","stylers":[{"color":"#f2d344"},{"visibility":"off"},{"weight":"1.41"}]},{"featureType":"road.local","elementType":"all","stylers":[{"visibility":"on"}]},{"featureType":"transit","elementType":"all","stylers":[{"visibility":"simplified"}]},{"featureType":"transit","elementType":"geometry","stylers":[{"visibility":"simplified"}]},{"featureType":"transit.station","elementType":"geometry","stylers":[{"visibility":"on"}]},{"featureType":"water","elementType":"all","stylers":[{"visibility":"simplified"},{"color":"#12586f"},{"lightness":"20"},{"gamma":"6.95"},{"saturation":"-29"}]},{"featureType":"water","elementType":"geometry","stylers":[{"visibility":"on"}]},{"featureType":"water","elementType":"geometry.fill","stylers":[{"visibility":"on"}]}]
};
map = new google.maps.Map(document.getElementById('map-container'), var_mapoptions);
var mapas=[];
var flightPlanCoordinates=[];
var flightPath = new google.maps.Polyline({
strokeColor: "#c3524f",
strokeOpacity: 1,
strokeWeight: 2,
geodesic: true
});
var k=0;
var z=0;
var coordinate;
while (k<numpoints) {
while (z < locations[k].length)
{
coordinate =new google.maps.LatLng(locations[k][z]['latitude'],locations[k][z]['longitude']);
flightPlanCoordinates.push(coordinate);
z=z+1;
}
ruta = new google.maps.Polyline({
geodesic: true,
strokeColor: '#FF0000',
strokeOpacity: 1.0,
strokeWeight: 2
});
ruta.setPath(flightPlanCoordinates);
mapas.push(ruta);
z=0;
k=k+1;
};
function createMarker(pos, t) {
var coord=[];
var pathcoord=[];
var flight_id = t;
currentPath = new google.maps.Polyline({
geodesic: true,
strokeColor: '#FF0000',
strokeOpacity: 1.0,
strokeWeight: 2
});
// Plane marker begin
var image = new google.maps.MarkerImage("./map_icons/"+flights[t]['heading'] +".png",null,new google.maps.Point(0,0),new google.maps.Point(15, 15),new google.maps.Size(30, 30));
var icon_airport = new google.maps.MarkerImage("./map_icons/airport_yellow_marker.png");
var lineSymbol = {path: 'M 0,-1 0,1', strokeOpacity: 1, scale: 1 };
var lat1 = flights[t]["dep_lat"];
var lat2 = flights[t]["arr_lat"];
var lng1 = flights[t]["dep_lon"];
var lng2 = flights[t]["arr_lon"];
var dep = new google.maps.LatLng(lat1, lng1)
var arr = new google.maps.LatLng(lat2, lng2)
var icon_plane = 'images/plane.png';
var marker = new google.maps.Marker({
position: pos,
icon: image,
name: t ,
contenido: flights[t]['callsign']+ ' '+flights[t]['name']+ ' '+flights[t]['surname'] ,
icao1:new google.maps.Marker({
position: dep,
map: map,
icon: icon_airport,
visible: false
}),
icao2:new google.maps.Marker({
position: arr,
map: map,
icon: icon_airport,
visible: false
}),
line1:new google.maps.Polyline({
path: [dep, pos],
strokeColor: "#08088A",
strokeOpacity: 1,
strokeWeight: 2,
geodesic: true,
map: map,
polylineID: t,
visible: false
}) ,
line2:new google.maps.Polyline({
path: [pos, arr],
strokeColor: "#FE2E2E",
strokeOpacity: .3,
geodesic: true,
map: map,
icons: [{
icon: lineSymbol,
offset: '0',
repeat: '5px'
}],
polylineID: t,
visible: false
})
});
// On mouse over
google.maps.event.addListener(marker, 'mouseover', function () {
//infowindow.open(map, marker);
this.get('line1').setVisible(true);
this.get('line2').setVisible(true);
this.get('icao1').setVisible(true);
this.get('icao2').setVisible(true);
infowindow.open(map,marker);
infowindow.setContent(marker.contenido);
var s=0;
coord.length = 0;
pathcoord.length = 0;
while (s < locations[flight_id].length)
{
coord= new google.maps.LatLng(locations[flight_id][s]['latitude'],locations[flight_id][s]['longitude']);
pathcoord.push(coord);
s=s+1;
}
currentPath.setPath(pathcoord);
currentPath.setMap(map);
});
// On mouse end
// mouse out
google.maps.event.addListener(marker, 'mouseout', function () {
//infowindow.close();
//this.get('line1').setVisible(false);
//this.get('line2').setVisible(false);
//this.get('icao1').setVisible(false);
//this.get('icao2').setVisible(false);
//currentPath.setMap(null);
});
// mouse out end
// On Click begin
google.maps.event.addListener(marker, 'click', function() {
infowindow.open(map,marker);
infowindow.setContent(marker.contenido);
var s=0;
coord.length = 0;
pathcoord.length = 0;
while (s < locations[flight_id].length)
{
coord= new google.maps.LatLng(locations[flight_id][s]['latitude'],locations[flight_id][s]['longitude']);
pathcoord.push(coord);
s=s+1;
}
currentPath.setPath(pathcoord);
currentPath.setMap(map);
if (this.get('line1').visible ='true')
{
this.get('line1').setVisible(false);
}
if (this.get('line2').visible ='true')
{
this.get('line2').setVisible(false);
}
if (this.get('icao1').visible ='true')
{
this.get('icao1').setVisible(false);
}
if (this.get('icao2').visible ='true')
{
this.get('icao2').setVisible(false);
}
flight_detail='<div class="panel panel-map">\
<!-- Default panel contents -->\
<div class=\"panel-heading\">'+flights[t]['departure'] + ' <i class="fa fa-arrow-right"></i> ' + flights[t]['arrival']+'</div>\
<table class="table-map">\
<tr>\
<td><small>Flight completed</small><br><div class="progress-bar progress-bar-success" role="progressbar" aria-valuenow="\
'+flights[t]['perc_completed'] + '" aria-valuemin="0" aria-valuemax="100" style="width:'+flights[t]['perc_completed']+'%">\
'+flights[t]['perc_completed'] + ' %</div></td>\
</tr>\
<tr>\
<td><small>Callsign</small><br><strong>\
'+flights[t]['callsign'] + '</strong></td>\
</tr>\
<tr>\
<td><small>Flight Status</small><br><strong>\
'+flights[t]['flight_status'] + '</strong></td>\
</tr>\
<tr>\
<td><small>Plane Type</small><br><strong>\
'+flights[t]['plane_type'] + '</strong></td>\
</tr>\
<tr>\
<td><small>Network</small><br><strong>\
'+flights[t]['network'] + '</strong></td>\
</tr>\
<tr>\
<td><small>Pending NM</small><br><strong>\
'+flights[t]['pending_nm'] + '</strong></td>\
</tr>\
<tr>\
<td><small>GS</small><br><strong>\
'+flights[t]['gs'] + '</strong></td>\
</tr>\
<tr>\
<td><small>IAS</small><br><strong>\
'+flights[t]['ias'] + '</strong></td>\
</tr>\
<tr>\
<td><small>Altitude</small><br><strong>\
'+flights[t]['altitude'] + '</strong></td>\
</tr>\
<tr>\
<td><small>Heading</small><br><strong>\
'+flights[t]['heading'] + '</strong></td>\
</tr>\
</table>\
</div>';
//flights[t]['departure'] + '-' + flights[t]['arrival'] + '<br />' + flights[t]['callsign']+ ' '+flights[t]['name']+ ' '+flights[t]['surname'] + '<br />' + 'ALTITUDE: ' + flights[t]['altitude'] + '<br />' + 'GS: ' + flights[t]['gs']+ '<br />' + 'HEADING: ' + flights[t]['heading'] + '<br />' + flights[t]['flight_status'];
$('#over_map').html("<div id='mySecondDiv'>"+flight_detail+"</div>");
});
// On Click end
return marker;
}
var numflight=0
while (numflight < flights.length )
{
var avionicon =new google.maps.LatLng(flights[numflight]['latitude'],flights[numflight]['longitude']);
var m1 = createMarker(avionicon, numflight);
m1.setMap(map);
numflight = numflight +1;
}
var s=0;
while (s < mapas.length)
{
s=s+1;
}
var infowindow = new google.maps.InfoWindow({
});
google.maps.event.addListener(infowindow, 'closeclick', function() {
$('#over_map').html("");
});
}
google.maps.event.addDomListener(window, 'load', init_map);
$( document ).ready(refreshflights);
function refreshflights(){
setInterval(function () {$.ajax({
url: 'get_map_coordinates.php',
data: "",
dataType: 'json',
success: function(data, textStatus, jqXHR) {
init_map();
}
})}, 120000);
}
</script>
</html>
I need map to be centered on marker every time i go on my webpage. Right now is centered on deparrture aiport. So this is map for flights, as flight is ongoing , aircraft (marker) on route, map should be tracking it so every time i refresh my wepage, map should point to marker, not to departure airport. Can anyone halp me. Thank you Edited December 23, 2020 by mrshiljoHey guys, I am having trouble centering a navbar with css on my template.
Here is a jsfiddle live preview for you.
http://jsfiddle.net/LRS38/
I added text-align:center; to it but it still wont center. I also added a margin:0 auto; but no luck.
Can anyone see what I am doing wrong?
<div id="navigation"> <ul> <li><a href="#">Home</a></li> <li><a href="#">About</a></li> <li class="current"><a href="#">Services</a></li> <li><a href="#">Contact us</a></li> </ul> </div>and
#navigation {
text-align:center;
background-color:#ef6b51;
overflow:hidden;
}
Hi, I have the code below: <? /* * search.php * * Script for searching a datbase populated with keywords by the * populate.php-script. */ print "<html><head><title>[Squashy] Search! NOT MESSED UP.</title></head><body>\n"; if( $_POST['keyword'] ) { /* Connect to the database: */ mysql_pconnect("www.freesqldatabase.com","sql01_44052","censored") or die("ERROR: Could not connect to database!"); mysql_select_db("sql01_4405hahamo1"); /* Get timestamp before executing the query: */ $start_time = getmicrotime(); /* Execute the query that performs the actual search in the DB: */ $query = ' SELECT p.page_url AS url, COUNT(*) AS occurrences FROM page p, word w, occurrence o WHERE p.page_id = o.page_id AND w.word_id = o.word_id AND (false '; $words = explode(' ', $_POST['keyword']); foreach ($words as $word) { $query .= 'OR w.word_word = "' . $word . '" '; } $query .= ') GROUP BY p.page_id ORDER BY occurrences DESC LIMIT ' . $_POST['results']; $result = mysql_query($query); /* Get timestamp when the query is finished: */ $end_time = getmicrotime(); /* Present the search-results: */ print "<h2>[Squashy] Search Results For '".$_POST['keyword']."':</h2>\n"; for( $i = 1; $row = mysql_fetch_array($result) or die(mysql_error()); $i++ ) { print "$i. <a href='".$row['url']."'>".$row['url']."</a>\n"; print "(occurrences: ".$row['occurrences'].")<br><br>\n"; } /* Present how long it took the execute the query: */ print "This search took: ".(substr($end_time-$start_time,0,5))." seconds."; } else { /* If no keyword is defined, present the search-page instead: */ print "<form method='post'>[Squashy Search] <input type='text' size='20' name='keyword'>\n"; print "Results: <select name='results'><option value='5'>5</option>\n"; print "<option value='10'>10</option><option value='15'>15</option>\n"; print "<option value='20'>20</option></select>\n"; print "<input type='submit' value='Search [Squashy]'></form>\n"; } print "</body></html>\n"; /* Simple function for retrieving the currenct timestamp in microseconds: */ function getmicrotime() { list($usec, $sec) = explode(" ",microtime()); return ((float)$usec + (float)$sec); } ?> How do I: a) Center the search box and title and add an image above it like in google, the code for the search box and title is (taken from the code above) { /* If no keyword is defined, present the search-page instead: */ print "<form method='post'>[Squashy Search] <input type='text' size='20' name='keyword'>\n"; print "Results: <select name='results'><option value='5'>5</option>\n"; print "<option value='10'>10</option><option value='15'>15</option>\n"; print "<option value='20'>20</option></select>\n"; print "<input type='submit' value='Search [Squashy]'></form>\n"; } b) How do I protect the code so that people can't see the database name and password? Thanks, Will Dear All, Hope all are fine. Need one hep to align the logo in the center of the footer. I tried align = Center but didn't help, please see below code ad advise. <div class="image"> <img src="images/icon/logo.jpg" alt="John Doe"/> </div>
Kind Regards, Naveed. Edited August 2, 2020 by Naveed786Hello,
Trying to rearrange a data on the website. Looks normal when looking through preview on IE and chrome. But once moved to live website, the whole alignment changes from left to center , including the text that needs to show up. I am a newbie to coding and dont have a clue. tried puttng something together based on what i foud on the web. attaching screenshot and the code that i did. any help is highly appreciated. also attached is a screenshot of what happens when the php file is uploaded. Prior to doing that, the menu on the left is aligned properly and the assets that we have show properly.
What we are trying to do is rearrage the whole assets into different categories.
many thanks
Attached Files
portfolio.php 3.27KB
2 downloads
noalignment.png 11KB
0 downloads <html> |
|||||||