<?php
/**
 * Querying
 *
 * This class contains functions to process the 
 * query and give the outputs
 * 
 *
 * @package		Bin
 * @category	Core
 * @author		AJDF Development Team
 * @link		http://ajdf.ajsquare.com
 * @version 	1.0
 */

class Bin_Query extends Bin_DbConnect {
    var $totrows;
	var $records;
	var $insertid;
	
    public function getbacktrace() {
        foreach (debug_backtrace() as $call) {
            $message[] = 'Filename: <strong>'.$call['file']."</strong>\r\n".'Line Number: <strong>'.
                $call['line'].'</strong>';
        }
        return implode("<br/>", $message).'<br/>';
    }

    public function executeQuery($sql) {
        $this->records = array();
		$i = 0;
        $rs = mysql_query($sql) or die(self::getbacktrace().'<code>'.$sql.'<code>'.mysql_error());
        $this->insertid = mysql_insert_id();

        if (!mysql_affected_rows() || mysql_num_rows($rs) < 1) {
            return false;
        }

        $this->totrows = mysql_num_rows($rs);
        while ($fetch = mysql_fetch_assoc($rs)) {
            $this->records[$i] = $fetch;
            $i++;
        }
        return true;
    }

	public function updateQuery($sql) {
        mysql_query($sql) or die(self::getbacktrace().'<code>'.nl2br($sql).'<code><br/>'.mysql_error());
        $this->insertid = mysql_insert_id();
        return true;
	}

    public function escapeString($string) {
        return mysql_real_escape_string($string);
    }
}