<?php namespace Qnet\Dao; require_once dirname(__FILE__) . '\\..\\util.php'; require_db(); class AnswersDAO { private $selectionsCount; private $labels; public function getOptionName($qid, $option) { $connector = new DBConnector(); $connection = $connector->createConnection(); $query = 'SELECT text FROM qoption WHERE FK_question=' . $qid . ' AND number=' . $option; $result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error()); $answer = mysql_fetch_assoc($result); $text = $answer['text']; mysql_free_result($result); mysql_close($connection); return $text; } public function getOptionNames($qid) { $connector = new DBConnector(); $connection = $connector->createConnection(); $query = 'SELECT text, number FROM qoption WHERE FK_question=' . $qid . ' order by number'; $result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error()); $qoptions = array(); while ($answer = mysql_fetch_assoc($result)) { $qoptions[$answer['number'] - 1] = $answer['text'];
<?php // Database class folder path define('DBPATH', dirname(__FILE__) . '/database/'); // erro reporting error_reporting(E_ALL); // get db environment variables require_once DBPATH . 'config.php'; // include all databse classes require_once DBPATH . 'index.php'; // include all databse classes require_once DBPATH . 'function.php'; //check up to exsist of DB class if (!class_exists('DB')) { error_code('can not find db class.', __FILE__, __LINE__); } //global db variable $db = require_db(); // proceeding for request from mobile require_once DBPATH . 'controlDB.php';