<?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