$requiredfields = array('id');
// validate required fields
if (!RequiredFields($req->get(), $requiredfields)) {
return false;
}
$id = $req->get("id");
global $conn;
$sql = 'SELECT * from users where id=' . $id;
$rs = $conn->query($sql);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
echo json_encode(array("error" => 0, "message" => "User data fetch successfully", "users" => $arr));
});
$app->get('/login', function () use($app) {
$req = $app->request();
$requiredfields = array('email', 'password');
// validate required fields
if (!RequiredFields($req->get(), $requiredfields)) {
return false;
}
$email = $req->get("email");
$password = $req->get("password");
global $conn;
$sql = 'SELECT * from users where EmailAddress="' . $email . '" and Password="******"';
$rs = $conn->query($sql);
$arr = $rs->fetch_array(MYSQLI_ASSOC);
if ($arr == null) {
echo json_encode(array("error" => 1, "message" => "Email-id or Password doesn't exist"));
return;
}
echo json_encode(array("error" => 0, "message" => "User logged in successfully", "users" => $arr));
});
* @post
* @email
* @phone
* @contact
* @notes
*/
$app->post('/company', function () use($app) {
// check for required params
$requiredfields = array('name', 'address1', 'city');
$req = $_REQUEST;
if ($_SERVER['REQUEST_METHOD'] == 'PUT') {
$app = \Slim\Slim::getInstance();
parse_str($app->request()->getBody(), $req);
}
// validate required fields
if (!RequiredFields($req, $requiredfields)) {
return false;
}
// il_company_acc
// il_company_name
// il_company_addr1
// il_company_addr2
// il_company_cityId
// il_company_post
// il_company_email
// il_company_phone
// il_company_contact
// il_company_fax
// il_company_notes
if (isset($req['name'])) {
$name = $req['name'];
