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; }