function utf8ize($d)
{
if (is_array($d)) {
foreach ($d as $k => $v) {
$d[$k] = utf8ize($v);
}
} else {
if (is_string($d)) {
return utf8_encode($d);
}
}
return $d;
}
function utf8ize($mixed)
{
if (is_array($mixed)) {
foreach ($mixed as $key => $value) {
$mixed[$key] = utf8ize($value);
}
} else {
if (is_string($mixed)) {
if (function_exists('mb_convert_encoding')) {
return mb_convert_encoding($mixed, "UTF-8", "auto");
} else {
return utf8_encode($mixed);
}
}
}
return $mixed;
}
function utf8ize($mixed) {
if (is_array($mixed)) {
foreach ($mixed as $key => $value) {
$mixed[$key] = utf8ize($value);
}
} else if (is_string ($mixed)) {
return utf8_encode($mixed);
}
return $mixed;
}
function getList($tableName, $tableColumn)
{
$sql = "select * FROM {$tableName} ORDER BY {$tableColumn}";
try {
$db = getConnection();
$stmt = $db->query($sql);
$list = $stmt->fetchAll(PDO::FETCH_ASSOC);
$db = null;
echo json_encode(utf8ize($list), JSON_NUMERIC_CHECK);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function get_by_user($user, $db)
{
$exercises = array();
$exercises["data"] = '';
$exercises["status"] = 'failed';
$exercises["error_message"] = '';
if ($db->connect_errno) {
$exercises["status"] = 'failed';
$exercises["error_message"] = $db->connect_error;
} else {
if ($sql_cmd = $db->prepare("SELECT DISTINCT(e.`id`), e.`title`, e.`content`,\n\t\t\t\t\t\t\t\t\t\t\te.`user_create`, e.`created_time`,\n\t\t\t\t\t\t\t\t\t\t\ted.`rating`, ed.`difficulty`, ed.`view_count`,\n\t\t\t\t\t\t\t\t\t\t\tc.`name`\n\t\t\t\t\t\t\t\t\t FROM `exercise` e\n\t\t\t\t\t\t\t\t\t INNER JOIN `exercise_detail` ed ON ed.`id` = e.`id`\n\t\t\t\t\t\t\t\t\t INNER JOIN `category` c ON c.`id` = e.`cat_id`\n\t\t\t\t\t\t\t\t\t WHERE e.`user_create` = ?\n\t\t\t\t\t\t\t\t\t ORDER BY ed.`view_count`\n\t\t\t\t\t\t\t\t\t LIMIT 10")) {
$sql_cmd->bind_param("s", $user);
if ($sql_cmd->execute()) {
$sql_cmd->bind_result($id, $title, $content, $user_create, $created_time, $rating, $difficulty, $view_count, $cat_name);
while ($sql_cmd->fetch()) {
$exercise = array();
$exercise["id"] = $id;
$exercise["title"] = $title;
$exercise["content"] = $content;
$exercise["user_create"] = $user_create;
$exercise["created_time"] = $created_time;
$exercise["rating"] = $rating;
$exercise["difficulty"] = $difficulty;
$exercise["view_count"] = $view_count;
$exercise["cat_name"] = $cat_name;
$exercises["data"][] = $exercise;
}
} else {
$exercises["status"] = 'failed';
$exercises["error_message"] = $sql_cmd->error;
}
$sql_cmd->close();
} else {
$exercises["status"] = 'failed';
$exercises["error_message"] = $db->error;
}
get_tag($exercises, $db);
$exercises["status"] = $exercises["error_message"] == '' ? 'success' : 'failed';
echo json_encode(utf8ize($exercises['data']), JSON_PRETTY_PRINT);
// printf("<pre>%s</pre>", $json);
$db->close();
}
}
require_once dirname(__DIR__) . "/includes/db_instance.php";
require_once dirname(__DIR__) . "/includes/utf8_utils.php";
$t = json_decode(file_get_contents("php://input"));
$key = $t->key;
$key = "%{$key}%";
$db = DbInstance::getInstance();
$tags = array();
if ($db->connect_errno) {
printf("Connect failed: %s\n", $db->connect_error);
} else {
if ($sql_cmd = $db->prepare("SELECT `id`, `name` FROM `tag` WHERE `name` LIKE ? LIMIT 5")) {
$sql_cmd->bind_param("s", $key);
if ($sql_cmd->execute()) {
$sql_cmd->bind_result($id, $name);
while ($sql_cmd->fetch()) {
$tag = array();
$tag["id"] = $id;
$tag["name"] = $name;
$tags[] = $tag;
}
} else {
printf("Command execution failed: %s", $sql_cmd->error);
}
$sql_cmd->close();
} else {
echo "Can not prepare the command get like";
}
echo json_encode(utf8ize($tags), JSON_PRETTY_PRINT);
$db->close();
}
require_once dirname(__DIR__) . "/includes/db_instance.php";
require_once dirname(__DIR__) . "/includes/utf8_utils.php";
$solution = json_decode(file_get_contents("php://input"));
$user_id = (int) $solution->user_id;
$db = DbInstance::getInstance();
if ($db->connect_errno) {
printf("Connect failed: %s\n", $db->connect_error);
} else {
if ($sql_cmd = $db->prepare("SELECT `id`, `content`, `ex_id` FROM `solution` WHERE `user_create` = ? LIMIT 20")) {
$sql_cmd->bind_param("i", $user_id);
if ($sql_cmd->execute()) {
$sql_cmd->bind_result($id, $content, $ex_id);
$solutions = array();
while ($sql_cmd->fetch()) {
$solution = array();
$solution["id"] = $id;
$solution["content"] = $content;
$solution["ex_id"] = $ex_id;
$solutions[] = $solution;
}
echo json_encode(utf8ize($solutions), JSON_PRETTY_PRINT);
} else {
printf("Command execution failed: %s", $sql_cmd->error);
}
$sql_cmd->close();
} else {
echo "Can not prepare the command";
}
$db->close();
}
<?php
require_once dirname(__DIR__) . "/includes/db_instance.php";
require_once dirname(__DIR__) . "/includes/utf8_utils.php";
$comment = json_decode(file_get_contents("php://input"));
$content = $comment->content;
$user_create = $comment->user_create;
$ex_id = (int) $comment->ex_id;
$db = DbInstance::getInstance();
if ($db->connect_errno) {
printf("Connect failed: %s\n", $db->connect_error);
} else {
if ($sql_cmd = $db->prepare("INSERT INTO `comment`(`content`, `ex_id`, `user_create`) VALUES (?, ?, ?)")) {
$sql_cmd->bind_param("sii", $content, $ex_id, $user_create);
if ($sql_cmd->execute()) {
// echo ($sql_cmd->affected_rows == 1) ? "success" : "No comment inserted";
$comment = array();
$comment["id"] = $sql_cmd->insert_id;
$comment["content"] = $content;
$comment["user_name"] = $user_create;
echo json_encode(utf8ize($comment), JSON_PRETTY_PRINT);
} else {
echo $sql_cmd->error;
}
$sql_cmd->close();
} else {
echo "Can not prepare the command";
}
$db->close();
}
<?php
require_once dirname(__DIR__) . "/includes/db_instance.php";
require_once dirname(__DIR__) . "/includes/utf8_utils.php";
$report = json_decode(file_get_contents("php://input"));
$user_id = (int) $report->user_id;
$db = DbInstance::getInstance();
if ($db->connect_errno) {
printf("Connect failed: %s\n", $db->connect_error);
} else {
if ($sql_cmd = $db->prepare("SELECT `id`, `content` FROM `report` WHERE user_create = ? LIMIT 20")) {
$sql_cmd->bind_param("i", $user_id);
if ($sql_cmd->execute()) {
$reports = array();
$sql_cmd->bind_result($id, $content);
while ($sql_cmd->fetch()) {
$reports[$id] = $content;
}
echo json_encode(utf8ize($reports), JSON_PRETTY_PRINT);
} else {
echo $sql_cmd->error;
}
$sql_cmd->close();
} else {
echo "Can not prepare the command";
}
$db->close();
}
<?php
require_once dirname(__DIR__) . "/includes/db_instance.php";
require_once dirname(__DIR__) . "/includes/utf8_utils.php";
$id = 8;
$db = DbInstance::getInstance();
if ($db->connect_errno) {
printf("Connect failed: %s\n", $db->connect_error);
} else {
if ($sql_cmd = $db->prepare("SELECT `content`, `user_create` FROM `solution` WHERE `id` = ? LIMIT 20")) {
$sql_cmd->bind_param("i", $id);
if ($sql_cmd->execute()) {
$sql_cmd->bind_result($content, $user_id);
$solution = array();
while ($sql_cmd->fetch()) {
$solution["id"] = $id;
$solution["content"] = $content;
$solution["user_id"] = $user_id;
}
echo json_encode(utf8ize($solution));
} else {
printf("Command execution failed: %s", $sql_cmd->error);
}
$sql_cmd->close();
} else {
echo "Can not prepare the command";
}
$db->close();
}
$exercise["view_count"] = $view_count;
$exercise["cat_name"] = $cat_name;
$exercises[] = $exercise;
}
} else {
printf("Command execution failed: %s", $sql_cmd->error);
}
$sql_cmd->close();
} else {
echo "Can not prepare the command [get exercise detail]";
}
for ($i = 0; $i < count($exercises); $i++) {
$ex_id = $exercises[$i]["id"];
$exercises[$i]["tag"] = get_tag((int) $ex_id, $db);
}
$json = json_encode(utf8ize($exercises), JSON_PRETTY_PRINT);
printf("<pre>%s</pre>", $json);
$db->close();
}
function get_tag($id, $db)
{
$tags = array();
if ($sql_cmd = $db->prepare("SELECT DISTINCT (t.`id`), t.`name`\n\t\t\t\t\t\t\t\t FROM `tag` t\n\t\t\t\t\t\t\t\t INNER JOIN `exercise_tag` et ON et.`tag_id` = t.`id`\n\t\t\t\t\t\t\t\t WHERE et.`ex_id` = ?")) {
$sql_cmd->bind_param("i", $id);
if ($sql_cmd->execute()) {
$sql_cmd->bind_result($tag_id, $name);
while ($sql_cmd->fetch()) {
$tag = array();
$tag["id"] = $id;
$tag["name"] = $name;
$tags[] = $tag;
function updateSupporter($id)
{
global $app;
$req = $app->request();
$supporter = json_decode($req->getBody());
$sql = "UPDATE sustinatori SET prenume=:prenume, nume=:nume, observatii=:observatii, companie=:companie, telefon=:telefon, email=:email,\n adresa=:adresa, localitate=:localitate, sustin=:sustin, suma=:suma, fixa=:fixa, promisi=:promisi, suma_platita=:suma_platita, \n platiti=:platiti, tipPlata=:tipPlata, documentJustificativ=:documentJustificativ, dataPlata=:dataPlata, anonim=:anonim, contactOrganizatie=:contactOrganizatie \n WHERE sustinatorID=:sustinatorID";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
$stmt->bindParam("prenume", $supporter->prenume);
$stmt->bindParam("nume", $supporter->nume);
$stmt->bindParam("observatii", $supporter->observatii);
$stmt->bindParam("companie", $supporter->companie);
$stmt->bindParam("telefon", $supporter->telefon);
$stmt->bindParam("email", $supporter->email);
$stmt->bindParam("adresa", $supporter->adresa);
$stmt->bindParam("localitate", $supporter->localitate);
$stmt->bindParam("sustin", $supporter->sustin);
$stmt->bindParam("suma", $supporter->suma);
$stmt->bindParam("fixa", $supporter->fixa);
$stmt->bindParam("promisi", $supporter->promisi);
$stmt->bindParam("suma_platita", $supporter->suma_platita);
$stmt->bindParam("platiti", $supporter->platiti);
$stmt->bindParam("tipPlata", $supporter->tipPlata);
$stmt->bindParam("documentJustificativ", $supporter->documentJustificativ);
$stmt->bindParam("dataPlata", $supporter->dataPlata);
$stmt->bindParam("anonim", $supporter->anonim);
$stmt->bindParam("contactOrganizatie", $supporter->contactOrganizatie);
$stmt->bindParam("sustinatorID", $id);
$stmt->execute();
$db = null;
echo json_encode(utf8ize($supporter));
} catch (PDOException $e) {
echo json_encode($e->getMessage());
}
}
<?php
require_once dirname(__DIR__) . "/includes/db_instance.php";
require_once dirname(__DIR__) . "/includes/utf8_utils.php";
$db = DbInstance::getInstance();
$categories = array();
if ($db->connect_errno) {
printf("Connect failed: %s\n", $db->connect_error);
} else {
if ($sql_cmd = $db->prepare("SELECT `id`, `name` FROM `category` LIMIT 20")) {
if ($sql_cmd->execute()) {
$categories = array();
$sql_cmd->bind_result($id, $name);
while ($sql_cmd->fetch()) {
$category = array();
$category["id"] = $id;
$category["name"] = $name;
$categories[] = $category;
}
echo json_encode(utf8ize($categories), JSON_PRETTY_PRINT);
} else {
echo $sql_cmd->error;
}
$sql_cmd->close();
} else {
echo "Can not prepare the command";
}
$db->close();
}
function safe_json_encode($value)
{
$encoded = json_encode($value);
return json_last_error() == JSON_ERROR_NONE ? $encoded : json_encode(utf8ize($value));
}
$exercise["reports"] = $reports;
} else {
printf("Command execution failed: %s", $sql_cmd->error);
}
$sql_cmd->close();
} else {
echo "Can not prepare the command [get report]";
}
// Get tags
if ($sql_cmd = $db->prepare("SELECT t.`id`, t.`name`\n\t\t\t\t\t\t\t\tFROM `tag` t\n\t\t\t\t\t\t\t\tINNER JOIN `exercise_tag` et ON et.`tag_id` = t.`id`\n\t\t\t\t\t\t\t\tWHERE et.`ex_id` = ?;")) {
$sql_cmd->bind_param("i", $ex_id);
if ($sql_cmd->execute()) {
$sql_cmd->bind_result($id, $name);
$tags = array();
while ($sql_cmd->fetch()) {
$tag = array();
$tag["id"] = $id;
$tag["name"] = $name;
$tags[] = $tag;
}
$exercise["tags"] = $tags;
} else {
printf("Command execution failed: %s", $sql_cmd->error);
}
$sql_cmd->close();
} else {
echo "Can not prepare the command [get solution]";
}
echo json_encode(utf8ize($exercise), JSON_PRETTY_PRINT);
$db->close();
}
function utf8ize(&$mixed)
{
if (is_array($mixed)) {
foreach ($mixed as $key => $value) {
$mixed[$key] = utf8ize($value);
}
} else {
if (is_string($mixed)) {
return utf8_encode($mixed);
}
}
#return mb_convert_encoding($mixed,'UTF-8','Windows-1252');#
return $mixed;
}
function utf8ize($d)
{
if (is_array($d)) {
foreach ($d as $k => $v) {
$d[$k] = utf8ize($v);
}
} else {
if (is_object($d)) {
foreach ($d as $k => $v) {
$d->{$k} = utf8ize($v);
}
} else {
return utf8_encode($d);
}
}
return $d;
}
