PHP get_info_by_id Examples

Example #1

File: rest-api.php Project: harits-adhi/18213009-18213044

    $info = mysql_fetch_array($result, MYSQL_ASSOC);
    return $info;
}
function get_admin_by_id($id)
{
    $info = array();
    mysql_connect('localhost', 'root', '');
    mysql_select_db('makanan');
    $result = mysql_query('SELECT * FROM admin WHERE id = ' . $id);
    $info = mysql_fetch_array($result, MYSQL_ASSOC);
    return $info;
}
if (isset($_GET["action"])) {
    switch ($_GET["action"]) {
        case "get_info":
            if (isset($_GET["id"])) {
                $value = get_info_by_id($_GET["id"]);
            } else {
                $value = "ERROR";
            }
            break;
        case "get_admin":
            if (isset($_GET["id"])) {
                $value = get_admin_by_id($_GET["id"]);
            } else {
                $value = "ERROR";
            }
            break;
    }
}
exit(json_encode($value));

Example #2

File: rest-api.php Project: AndraWP/18213003-18213004

<?php

# Name/NIM	: Jenika Sutojo/18213003 - Andra Wahyu Purnomo/18213004
# Day, Date	: Thursday, 05 November 2015
# File		: rest-api.php
function get_info_by_id($No_ID)
{
    $info = array();
    mysql_connect('localhost', 'root', '');
    mysql_select_db('hotel');
    $result = mysql_query("SELECT No_ID, Nama FROM pengunjung WHERE No_ID = '{$No_ID}'");
    $info = mysql_fetch_array($result, MYSQL_ASSOC);
    return $info;
}
if (isset($_GET["action"])) {
    switch ($_GET["action"]) {
        case "get_info":
            if (isset($_GET["No_ID"])) {
                $value = get_info_by_id($_GET["No_ID"]);
            } else {
                $value = "ERROR";
            }
            break;
    }
}
exit(json_encode($value));