function getConnection()
{
global $dbConnection;
$dbConnector = new DatabaseConnector();
$dbConnection = $dbConnector->connect();
if ($dbConnection == "Failed to connect") {
return json_encode("Connection to the database has failed");
} else {
return json_encode("Connection successful");
}
}
<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");
include 'connectDatabase.php';
$connection = new DatabaseConnector();
$con = $connection->connect();
$response = array();
if ($con) {
// Selecting database
$database = mysql_select_db("leaf_me_alone");
if ($database) {
$select_query = "select * from leafs";
$result = mysql_query($select_query) or die(mysql_error());
if (!empty($result)) {
if (mysql_num_rows($result) > 0) {
$response["leafs"] = array();
while ($row = mysql_fetch_array($result)) {
$leaf = array();
$leaf["id"] = $row["id"];
$leaf["location"] = $row["location"];
$leaf["defect_percentage"] = $row["defect_percentage"];
$leaf["time_stamp"] = $row["time_stamp"];
$leaf["salt_name"] = $row["salt_name"];
array_push($response["leafs"], $leaf);
}
$response["success"] = 1;
echo json_encode($response);
} else {
$response["success"] = 0;
$response["message"] = "No found";
<?php
require_once 'php/DatabaseConnection.php';
$connect = new DatabaseConnector();
$connect->connect();
$username = filter_input(INPUT_POST, 'username', FILTER_SANITIZE_SPECIAL_CHARS);
$country = $_POST['country'];
$state = $_POST['state'];
$city = $_POST['city'];
$accounttype = $_POST['accounttype'];
$email = $_POST['email'];
$password = $_POST['password'];
$hashedPass = md5($password);
if (isset($_POST)) {
$sql = "INSERT INTO members VALUES('{$username}','{$country}','{$state}','{$city}','{$accounttype}','{$email}','{$hashedPass}', now())";
$connect->getConnection()->query($sql);
$id = $connect->insert_id;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<title>Activation Tester | Rolando Moreno | Full Stack Web Developer</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
<!-- Bootstrap -->
