/** * gets all answers for the the given qid */ public static function _get_all_answer_by_qid($ref_qid) { $all_answers = array(); $connection = _database::get_connection(); $query = "SELECT * FROM `_answers` WHERE `_a_qid` = {$ref_qid} ORDER BY `_a_time` DESC"; if ($res = $connection->query($query)) { $i = 0; while ($arr = $res->fetch_array()) { $obj = new _answers(); $obj->setAid($arr['_aid']); $obj->setDescription($arr['_description']); $obj->setAUid($arr['_a_uid']); $obj->setAQid($arr['_a_qid']); $obj->setApt($arr['_apt']); $obj->setNotApt($arr['_notapt']); $obj->setATime($arr['_a_time']); $all_answers[$i] = $obj; $i++; } return $all_answers; } else { return false; } }
<?php /** * sagarpatel * Date: 03-Apr-15 * Time: 3:55 PM */ include_once 'utils/utils.php'; include_once 'classes/_answers.php'; session_start(); if (isset($_POST['ad']) && isset($_POST['qid']) && isset($_SESSION['uid'])) { $ad = cleanString($_POST['ad']); $qid = $_POST['qid']; $uid = $_SESSION['uid']; if (strlen($ad) != 0) { $ans = new _answers(); $ans->setDescription($ad); $ans->setAQid($qid); $ans->setAUid($uid); if ($ans->_insert_db()) { header("Location: ../index.php"); } else { header("Location: ../index.php"); } die; } setcookie('fonas', 1, time() + 3); header("Location: ../index.php"); die; }