updateParentMobile($conn, $yunpian);
} else {
if ($requestMethod == "myRecord") {
getMyRecord($conn);
} else {
if ($requestMethod == "cancelTransaction") {
cancelTransaction($conn);
} else {
if ($requestMethod == "parseCodeForDisplay") {
parseCodeForDisplay($conn);
} else {
if ($requestMethod == "trandactionDetail") {
getTransactionDetail();
} else {
if ($requestMethod == "updateTransaction") {
updateTransaction();
}
}
}
}
}
}
}
}
}
}
function findTeacher()
{
global $conn;
$childId = trim($_GET["childId"]);
$interest = trim($_GET["interest"]);
<?php
include 'db_helper.php';
if ($_GET['f'] == 'add' && $_GET['sid'] && $_GET['tid'] && $_GET['class'] && $_GET['duration']) {
addTransaction($_GET['sid'], $_GET['tid'], $_GET['class'], $_GET['duration']);
} elseif ($_GET['f'] == 'get' && $_GET['p1']) {
getTransaction($_GET['p1']);
} elseif ($_GET['f'] == 'upd' && $_GET['p1'] && $_GET['p2'] && $_GET['p3'] && $_GET['p4']) {
updateTransaction($_GET['p1'], $_GET['p2'], $_GET['p3'], $_GET['p4']);
} elseif ($_GET['f'] == 'list' && $_GET['sid'] && $_GET['con']) {
listTransaction($_GET['sid'], $_GET['con']);
} elseif ($_GET['f'] == 'list' && $_GET['tid'] && $_GET['con']) {
listTransactionWithTutorID($_GET['tid'], $_GET['con']);
} elseif ($_GET['f'] == 'con' && $_GET['tid'] && $_GET['sid'] && $_GET['rate'] && $_GET['class']) {
confirmTrasaction($_GET['tid'], $_GET['sid'], $_GET['rate'], $_GET['class']);
}
function confirmTrasaction($tid, $sid, $rate, $class)
{
$dbQuery = sprintf("UPDATE Transaction SET rate='%d', Confirmed = '%d' WHERE S_ID = '%d'AND T_ID = '%d' AND Class = '%d'", $rate, 1, $sid, $tid, $class);
$result = getDBResultAffected($dbQuery);
//header("Content-type: application/json");
echo json_encode($result);
}
function getTransaction($email)
{
$dbQuery = sprintf("SELECT name FROM Transaction WHERE email = '%s'", mysql_real_escape_string($email));
//
$result = getDBResultRecord($dbQuery);
//header("Content-type: application/json");
echo json_encode($result);
}
