public static function addReviews($articleId, $userName, $body, $face)
{
$sql = "insert into reviews(articleId,userName,body,face)values({$articleId},'{$userName}','{$body}','{$face}')";
$conn = new DbConn();
$row = $conn->executeUpdate($sql);
$conn->close();
return $row;
}
public static function checkLogin($userName, $password)
{
$sql = "select * from manager where userName='******' and password='******'";
$conn = new DbConn();
$result = $conn->executeQuery($sql);
$conn->close();
return $result[0];
}
public static function getNewsTypes()
{
$sql = "select * from newsTypes";
$conn = new DbConn();
$result = $conn->executeQuery($sql);
$conn->freeResult();
$conn->close();
return $result;
}
$sql1 = "INSERT INTO users (email, reg_date) VALUES ('" . $input['email'] . "', " . time() . ")";
$result1 = $DbConn->conn->query($sql1);
$sql2 = "INSERT INTO profile (user_id, " . $fields . ", last_modified) VALUES (" . mysqli_insert_id($DbConn->conn) . ", " . $values . ", " . time() . ")";
$result2 = $DbConn->conn->query($sql2);
if ($result1 && $result2) {
echo mysqli_insert_id($DbConn->conn);
$DbConn->conn->commit();
} else {
echo "Error occured";
$DbConn->conn->rollback();
}
} catch (Exception $e) {
$DbConn->conn->rollback();
echo $e->getMessage();
}
$DbConn->close();
});
$app->post('/addAdmin', function () use($app) {
$input = $app->request()->post();
$mongo = new MongoClient();
$db = $mongo->people;
$a = $db->peoples->insert($input);
var_dump($a);
});
$app->post('/addAddress', function () use($app) {
$input = $app->request()->post();
// $mongo = new MongoClient ();
// $db = $mongo->people;
// $a = $db->peoples->insert($input);
var_dump($input);
});
public static function getNewsTwo($typeId)
{
$sql = "select * from newsArticles where typeId={$typeId} order by dateandtime desc limit 0,2";
$conn = new DbConn();
$result = $conn->executeQuery($sql);
$conn->freeResult();
$conn->close();
return $result;
}
