if (!$db) { echo json_encode(array('testing' => true, 'result' => 'error', 'error_msg' => 'Error connecting to the MySQL server.')); return; } $opendb = @mysql_select_db($db_config['name'], $db); if (!$opendb) { echo json_encode(array('testing' => true, 'result' => 'error', 'error_msg' => 'Error selecting the database.')); return; } $sql = "SELECT email FROM users where id=1"; $rs = @mysql_query($sql, $db); if (!$rs) { echo json_encode(array('testing' => true, 'result' => 'error', 'error_msg' => 'Error executing query: "' . $sql . '"')); return; } $data = mysql_fetch_object($rs); if (!$data) { echo json_encode(array('testing' => true, 'result' => 'error', 'error_msg' => 'Error fetching the resulting object.')); } mysql_free_result($rs); mysql_close($db); unset($rs, $sql); echo json_encode(array('testing' => true, 'result' => 'success', 'data' => $data)); } } $registrationController = new Registration(); if (isset($_GET['test'])) { $registrationController->testWebservice(); } else { $registrationController->invoke(); }