PHP MYSQLInterface Examples

Example #1

File: ajax_post_sample.php Project: JungJihyun/magendas

<?php

// common setting
include_once "../common.inc";
include_once "../db/toast-master/mysql.interface.toast-master.inc";
// GET PARAMS
$result_obj = new stdClass();
$id = $_POST['id'];
$name = $_POST['name'];
$result_obj->id = $id;
$result_obj->name = $name;
// TYPE 2
// DB PROCESS
$wdj_mysql_interface = new MYSQLInterface($wdj_mysql_manager);
$member_list = $wdj_mysql_interface->getMemberList(1, "A");
$result_obj->member_list = $member_list;
// TYPE 3
// json format
// $timezones = ["Asia/Seoul", "America/New_York"];
// echo json_encode($timezones);
// OUTPUT
echo json_encode($result_obj);
?>

Example #2

File: ajax_post_update_meeting_agenda.php Project: JungJihyun/magendas

<?php

// common setting
include_once "../common.inc";
include_once "../db/toast-master/mysql.interface.toast-master.inc";
$wdj_mysql_interface = new MYSQLInterface($wdj_mysql_manager);
$result = new stdClass();
$result->query_output_arr = array();
$debug = "";
$debug_stack_array = array();
function terminate($wdj_mysql_interface, $result, $debug_stack_array, $debug = "")
{
    // CLOSE DB
    $wdj_mysql_interface->close();
    // OUTPUT
    $result->debug = $debug;
    $result->debug_stack_array = $debug_stack_array;
    echo json_encode($result);
    return;
}
// GET PARAMS
//    .aMMMb  .aMMMb  dMMMMMMMMb dMMMMMMMMb .aMMMb  dMMMMb
//   dMP"VMP dMP"dMP dMP"dMP"dMPdMP"dMP"dMPdMP"dMP dMP dMP
//  dMP     dMP dMP dMP dMP dMPdMP dMP dMPdMP dMP dMP dMP
// dMP.aMP dMP.aMP dMP dMP dMPdMP dMP dMPdMP.aMP dMP dMP
// VMMMP"  VMMMP" dMP dMP dMPdMP dMP dMP VMMMP" dMP dMP
// MEETING AGENDA COMMON
$MEETING_ID = $params->getParamNumber($params->MEETING_ID);
//     dMP dMP dMMMMMP .aMMMb  dMMMMb  dMMMMMP dMMMMb
//    dMP dMP dMP     dMP"dMP dMP VMP dMP     dMP.dMP
//   dMMMMMP dMMMP   dMMMMMP dMP dMP dMMMP   dMMMMK"