encrypt_getquestion.php

<?php
 include 'db_config.php';
 include 'security.php';
$link =mysql_connect(DB_SERVER , DB_USER, DB_PASSWORD);
if(!$link){
    die(('Could not connect :' .mysql_error($link)));
}
$select = mysql_select_db(DB_DATABASE,$link);
mysql_set_charset('utf8',$link);
mysql_query("SET NAMES 'UTF8'");
//$id = $_REQUEST["id"];
//echo $id;
$query = "SELECT * FROM `requestion` ";
$result = mysql_query($query,$link);
$row = array();
while ( $r = mysql_fetch_assoc($result)){
    //$row[] = $r;
    $arr = array();
    $arr['_id'] = Security::encrypt($r['_id'], KEY_QUESTION);
    $arr['requestion'] = Security::encrypt($r['requestion'], KEY_QUESTION);
    $arr['ansa'] = Security::encrypt($r['ansa'], KEY_QUESTION);
    $arr['ansb'] = Security::encrypt($r['ansb'], KEY_QUESTION);
    $arr['ansc'] = Security::encrypt($r['ansc'], KEY_QUESTION);
    $arr['ansd'] = Security::encrypt($r['ansd'], KEY_QUESTION);
    $arr['answer'] = Security::encrypt($r['answer'], KEY_QUESTION);
    $arr['note'] = Security::encrypt($r['note'], KEY_QUESTION);
    $row[] = $arr;

    /*
    echo $r['_id']." - " . $arr['_id'] . "<br>";
    echo $r['requestion']."<br>";
    echo $r['ansa']."<br>";
    echo $r['ansb']."<br>";
    echo $r['ansc']."<br>";
    echo $r['ansd']."<br>";
    echo $r['answer']."<br>";
    echo $r['note']."<br>";
    echo "<hr><br>";
    */
}

$data["ListQuestion"]= $row;
echo json_encode($data);
mysql_close($link);
?>