// Need the BASE_URL, defined in the config file:
include '../includes/config.inc.php';
// Redirect to the index page:
$url = BASE_URL . 'index.php';
header("Location : {$url}");
exit;
}
$db = new DbPdoClass();
$apikey = "ArAIzaSyBdXbZEsLOkQmuHpIJrEIeEg3l07fJPwO8YaN";
$id = 2;
//$_GET['id'];
$lat = 0;
$long = 0;
$zoom = 8;
$findmap = "SELECT center_lat, center_long, zoom FROM maps WHERE id={$id}";
$db->prepareQuery($findmap);
$row = $db->fetchSingleRow();
//echo "<br>row=<pre>";print_r($row);echo "</pre>";
$lat = $row['center_lat'];
$long = $row['center_long'];
$zoom = $row['zoom'];
?>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
<style type="text/css">
#map-canvas { height: 100% }
</style>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=<?php
echo $apikey;
?>
echo '<br>table droped';
//$db->prepareQuery('CREATE TABLE users(id SERIAL NOT NULL, user_name character varying(20) NOT NULL, user_password character varying(20) NOT NULL, CONSTRAINT users_pkey PRIMARY KEY (id))');
$db->prepareQuery('CREATE TABLE users(id SERIAL NOT NULL, user_name character varying(128) NOT NULL, user_password character varying(128) NOT NULL, user_email character varying(128) NOT NULL, user_role character varying(64) NOT NULL, created_time timestamp DEFAULT current_timestamp, last_modified_time timestamp DEFAULT current_timestamp, status smallint NOT NULL DEFAULT 1, CONSTRAINT users_pkey PRIMARY KEY (id))');
$db->executeQuery();
echo '<br>table created';*/
/*$db->prepareQuery('INSERT INTO users (user_name, user_password) VALUES (:user_name, :user_password)');
$db->bindQueryValue(':user_name', 'John');
$db->bindQueryValue(':user_password', 'Smith');*/
/*$db->prepareQuery("INSERT INTO users (user_name, user_password) VALUES ('John', 'Smith')");
$db->executeQuery();
echo '<br>lastInsertId=' . $db->lastInsertId();*/
//$db->prepareQuery('SELECT user_name, user_password FROM users WHERE user_name = :user_name');
//$db->bindQueryValue(':user_name', 'John');
//$db->prepareQuery("SELECT user_name, user_password FROM users WHERE user_name = 'John'");
$db->prepareQuery("SELECT * FROM users");
//$row = $db->fetchSingleRow();
$rows = $db->fetchResultset();
echo "<br>rows=<pre>";
print_r($rows);
//var_dump($rows);
echo "</pre>";
/*$db->prepareQuery('DELETE FROM users WHERE user_name = :user_name');
$db->bindQueryValue(':user_name', 'aryan');
$db->executeQuery();
echo '<br>record deleted';*/
// google map integration
/*$createmaptable = 'CREATE TABLE IF NOT EXISTS maps (
id SERIAL,
center_lat numeric(5,3),
center_long numeric(6,3),
<?php
$db = new DbPdoClass();
$db->prepareQuery('INSERT INTO users (user_name, user_password) VALUES (:user_name, :user_password)');
$db->bindQueryValue(':user_name', 'John');
$db->bindQueryValue(':user_password', 'Smith');
$db->executeQuery();
echo '<br>lastInsertId=' . $db->lastInsertId();
$db->prepareQuery('SELECT user_name, user_password FROM users WHERE user_name = :user_name');
$db->bindQueryValue(':user_name', 'John');
$row = $db->fetchSingleRow();
echo "<br>row=<pre>";
print_r($row);
echo "</pre>";
