I'm doing simply php query to database and it responds with weird object, I can't find what did I asked for here. I know how to code in js but I'm new in PHP.
Response: http://imgur.com/rLeeoLI
Here's the code:
index.php
<!DOCTYPE html>
<html>
<head>
<script type='text/javascript'>
function spytajBazy(request)
{
var wynik = $.ajax({
type: "post",
url: "ajax_requests.php",
data: {request: request},
success: function (result) {
return result;
}
});
var array = $.map(wynik, function(value, index) {
return [value];
});
return array;
}
</script>
<script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.0/jquery.min.js"></script>
<title>Admin check</title>
<meta charset="UTF-8">
</head>
<body>
<script type='text/javascript'>
var wynik = spytajBazy("sprawdz_ile_grup");
var array = jQuery.makeArray(wynik);
console.log(wynik);
</script>
Functions.php
<?php
class Functions
{
private $db;
public function __construct(Database $db)
{
$this->db = $db;
}
public function sprawdz_ile_grup()
{
$query = "SELECT * FROM `groups`";
$result = $this->db->dataQuery($query);
return $result->fetchAll();
}
public function insert_something()
{
$query = "INSERT INTO `myDB`.`groups` (`id` ,`nazwa` ,`data_utworzenia`)VALUES ('5', 'randomsecond', '2016-05-18');";
$result = $this->db->dataQuery($query);
return $true;
}
}
Database.php
<?php
class Database
{
private $conn = null;
public function __construct()
{
try {
$username = "usrnm";
$password = "pass";
$servername = "server";
$dbname = "dbname";
$this->conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->conn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (PDOException $e) {
trigger_error("Error: " . $e->getMessage());
}
}
public function dataQuery($query, $params = array())
{
try {
$stmt = $this->conn->prepare($query);
$stmt->execute($params);
return $stmt;
} catch (PDOException $e) {
trigger_error("Error: " . $e->getMessage());
};
}
}
ajax_requests.php
<?php
if (!empty($_POST)) {
$method = $_POST['request'];
include 'Database.php';
include 'Functions.php';
$db = new Database();
$functions = new Functions($db);
if (method_exists($functions, $method)) {
$data = $functions->$method();
header('Content-Type: application/json');
echo json_encode($data);
}
}
?>
