if (isset($_POST['is_cover'])) { $result = $itemModel->addCoverImage($_POST['item_name'], $_POST['owner'], $_POST['image_url']); } else { $result = $itemModel->addNonCoverImage($_POST['item_name'], $_POST['owner'], $_POST['image_url']); } if ($result == true) { $result = "<p class='text-success'>Item Image Successfully Created!</p>"; } else { $result = "<p class='text-danger'>Error Occured! Try checking your database constraint.</p>"; } } else { if (isset($_POST['item_name']) && isset($_POST['owner']) && isset($_POST['commentor']) && isset($_POST['content'])) { // adding comment entry include 'models/commentModel.php'; $commentModel = new commentModel(); $result = $commentModel->addComment($_POST['item_name'], $_POST['owner'], $_POST['commentor'], $_POST['content']); if ($result == true) { $result = "<p class='text-success'>Review Successfully Created!</p>"; } else { $result = "<p class='text-danger'>Error Occured! Try checking your database constraint.</p>"; } } else { if (isset($_POST['reviewer']) && isset($_POST['reviewee']) && isset($_POST['content'])) { // adding review entry include 'models/reviewModel.php'; $reviewModel = new reviewModel(); if (isset($_POST['has_like'])) { $result = $reviewModel->addNewReview($_POST['reviewer'], $_POST['reviewee'], $_POST['content'], 1); } else { $result = $reviewModel->addNewReview($_POST['reviewer'], $_POST['reviewee'], $_POST['content'], 0); }
<?php require_once 'commentModel.class.php'; $commentModel = new commentModel(); // $commentModel->getComments('1'); $action = $_GET['action']; $blogId = $_REQUEST['blogId']; switch ($action) { case 'getComments': $result = $commentModel->getComments($blogId); echo json_encode($result); break; case 'addComment': $content = $_POST['content']; if (strlen($content) >= 10) { $result = $commentModel->addComment($blogId, $content); if ($result) { // require_once 'swiftmailer-master/lib/swift_required.php'; // $email = '*****@*****.**'; // //发送邮件,以QQ邮箱为例 // //配置邮件服务器,得到传输对象 // $transport=Swift_SmtpTransport::newInstance('smtp.qq.com',25); // //设置登陆帐号和密码 // $transport->setUsername('*****@*****.**'); // $transport->setPassword('songwanfu0531'); // //得到发送邮件对象Swift_Mailer对象 // $mailer=Swift_Mailer::newInstance($transport); // //得到邮件信息对象 // $msg=Swift_Message::newInstance(); // //设置管理员的信息 // $msg->setFrom(array('*****@*****.**'=>'Meet Better Me'));
function postComment($login, $article, $comment) { $commentModel = new commentModel(); $comment = $commentModel->addComment($login, $article, $comment); include 'view/viewArticle.php'; }
public function view() { session_start(); $owner = ''; $itemName = ''; if (!empty($_GET['owner']) && !empty($_GET['item'])) { $owner = $_GET['owner']; $itemName = $_GET['item']; } // get item info include 'models/itemModel.php'; include 'models/memberModel.php'; include 'models/itemAvailabilityModel.php'; include 'models/commentModel.php'; include 'models/loanRequestModel.php'; $loanRequestModel = new loanRequestModel(); $itemModel = new itemModel(); $memberModel = new memberModel(); $itemAvailabilityModel = new itemAvailabilityModel(); $commentModel = new commentModel(); $result = $itemModel->getByKey($owner, $itemName); $item = pg_fetch_array($result); $submitSuccess = false; $submitError = false; if (!empty($_POST)) { if ($_POST['action'] == 'requestLoan') { if ($_POST['start'] == '' || $_POST['end'] == '' || $_POST['bidPrice'] == '') { $submitError = true; } else { // process loan request $start = $_POST['start']; $end = $_POST['end']; $bidPrice = $_POST['bidPrice']; $request = $loanRequestModel->addLoanRequest($item['item_name'], $item['owner'], $_SESSION['username'], $start, $end, $bidPrice); if ($request) { $submitSuccess = true; } else { $submitError = true; } } } if ($_POST['action'] == 'submitComment') { $commentModel->addComment($_POST['item_name'], $_POST['owner'], $_SESSION['username'], $_POST['content']); } } // get all available dates $result = $itemAvailabilityModel->getAllByItemKey($owner, $itemName); $availabilityArray = pg_fetch_all($result); // get all accepted pending $result = $loanRequestModel->getAllAcceptedByItem($itemName, $owner); $acceptedArray = pg_fetch_all($result); if ($acceptedArray) { $acceptedDates = []; foreach ($acceptedArray as $accepted) { $startDate = strtotime($accepted['date_start']); $endDate = strtotime($accepted['date_end']); $yearStart = intval(date("Y", $startDate)); $monthStart = intval(date("m", $startDate)); $dateStart = intval(date("d", $startDate)); $yearEnd = intval(date("Y", $endDate)); $monthEnd = intval(date("m", $endDate)); $dateEnd = intval(date("d", $endDate)); for ($y = $yearStart; $y <= $yearEnd; $y++) { for ($m = $monthStart; $m <= $monthEnd; $m++) { for ($d = $dateStart; $d <= $dateEnd; $d++) { $acceptedDates[] = $d . '-' . $m . '-' . $y; } } } } } $freeDates = []; if ($availabilityArray) { foreach ($availabilityArray as $availability) { $startDate = strtotime($availability['date_start']); $endDate = strtotime($availability['date_end']); $yearStart = intval(date("Y", $startDate)); $monthStart = intval(date("m", $startDate)); $dateStart = intval(date("d", $startDate)); $yearEnd = intval(date("Y", $endDate)); $monthEnd = intval(date("m", $endDate)); $dateEnd = intval(date("d", $endDate)); for ($y = $yearStart; $y <= $yearEnd; $y++) { for ($m = $monthStart; $m <= $monthEnd; $m++) { for ($d = $dateStart; $d <= $dateEnd; $d++) { $freeDates[] = $d . '-' . $m . '-' . $y; } } } } } if ($acceptedArray) { for ($i = 0; $i < count($freeDates); $i++) { for ($j = 0; $j < count($acceptedDates); $j++) { if (strcmp($freeDates[$i], $acceptedDates[$j]) == 0) { $freeDates[$i] = -1; } } } } // get all comments date_default_timezone_set("Asia/Singapore"); $result = $commentModel->getCommentsByItemKey($owner, $itemName); $commentArray = pg_fetch_all($result); include 'views/item.php'; }