Example #1
0
<?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'];
Example #2
0
<?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';