(at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ // We enter the detail in the database if (isset($_POST['id']) == true) { define('IN_APP', true); include_once 'mysql.php'; $db = new sql_db(); $db->sql_open('localhost', 'db_user', 'db_password', 'db_name', true, ''); // Escape everything foreach ($_POST as $key => $value) { if (is_array($_POST[$key]) == false) { $_POST[$key] = mysql_real_escape_string($value); } } $data = 0; // Enter the details in database for ($i = 0; $i < count($_POST['time']); $i++) { $db->sql_insert('markers', 'user_id, phone_id, locked, time, lat, lon, acc, spd', "'1', '{$_POST['id']}', '{$_POST['lock']}', '{$_POST['time'][$i]}', '{$_POST['lat'][$i]}', '{$_POST['lon'][$i]}', '{$_POST['acc'][$i]}', '{$_POST['spd'][$i]}'"); $data++; } echo 'Data received (' . $data . ') ' . time(); } else { ?>
it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ define('IN_APP', true); include_once 'mysql.php'; $db = new sql_db(); $db->sql_open('localhost', 'db_user', 'db_pass', 'db_name', true, 'db_table_prefix'); if ($_GET['reset'] == 'true') { $db->sql_truncate('markers'); } if ($_GET['fullscreen'] == 'true') { $canvas = 'map_canvas_full'; } else { $canvas = 'map_canvas'; } if ($_GET['all'] == 'true') { $markers = $db->sql_select('markers', '1 ORDER BY TIME DESC'); } else { $markers = $db->sql_select('markers', '1 ORDER BY time DESC LIMIT 1'); } if (count($markers) == 0) { echo 'No data availible to display.';