<?php
session_start();
require_once 'api/AbzuDB.php';
$db = new PDO("sqlite:storage/data.db");
$AbzuDB = new AbzuDB($db);
// var_dump($AbzuDB);
if (isset($_POST['btn-login'])) {
$user_name = trim($_POST['username']);
$user_password = trim($_POST['password']);
// var_dump($user_name);
// var_dump($user_password);
// $password = md5($user_password);
try {
// $stmt = $db_con->prepare("SELECT * FROM tbl_users WHERE user_email=:email");
// $stmt->execute(array(":email"=>$user_name));
// $row = $stmt->fetch(PDO::FETCH_ASSOC);
// $count = $stmt->rowCount();
// var_dump($user_name);
// var_dump($user_password);
// echo $AbzuDB->check_credentials($user_name, $user_password);
if ($AbzuDB->check_credentials($user_name, $user_password) == 'True') {
echo "ok";
// log in
$_SESSION['user_session'] = $user_name;
} else {
echo "Username or password does not exist.";
// wrong details
}
} catch (PDOException $e) {
echo $e->getMessage();
#!/usr/bin/php
<?php
require "../api/Init.php";
require "../api/AbzuDB.php";
$AbzuDB = new AbzuDB($db);
echo $AbzuDB->get_gauge_to_date("7813517", "month", "2016-03") . "\n";
// $AbzuDB->get_meter_data("7813517", "week");
// $AbzuDB->insert_meter_data("042014", "01245", "10/Oct/2000:13:55:36 -0700");
</div>
</div>
</div>
</body>
</html>
<?php
//include("database/db_conection.php");
if (isset($_POST['login'])) {
include 'api/Init.php';
include 'api/DataImporter.php';
include 'api/AbzuDB.php';
$AbzuDB = new AbzuDB($db);
$user_username = $_POST['username'];
$user_pass = $_POST['pass'];
/*
$check_user="******";
$run=mysqli_query($dbcon,$check_user);
if(mysqli_num_rows($run))
{
echo "<script>window.open('welcome.php','_self')</script>";
$_SESSION['username']=$user_username;//here session is used and value of $user_username store in $_SESSION.
}
else
