<?
define("CONTACTFORM_FROM_EMAILADDRESS", "no-reply@it-ekb.ru");
define("CONTACTFORM_TO_EMAILADDRESS", "vm@it-ekb.ru");

define("DB_HOST", "ubrok.mysql");
define("DB_USER", "ubrok_mysql");
define("DB_PASS", "etz2ib9j");
define("DB_PORT", "3306");
define("DB_DATABASE", "ubrok_it");

?>

<?php 
/** 
 * @name dbconnection 
 * @access private 
 * @abstract proviedes a basic set for a connection 
 * @param All needed access data for the db connection will be provided 
 *        by a config file.
 * You can change the constant values to anything you like.
 * This class uses an exception called "mysqlex", in which
 * $ex->getMessage() is replaced by mysql_error()
 * and
 * $ex->getCode() is replaced by mysql_errno()
 */ 

abstract class dbconnection { 

    /** 
    * @name host 
    * @access protected 
    */ 
    protected $host; 

    /** 
    * @name user 
    * @access protected 
    */ 
    protected $user; 

    /** 
    * @name pass 
    * @access protected 
    */ 
    protected $pass; 

    /** 
    * @name port 
    * @access protected 
    */ 
    protected $port; 

    /** 
    * @name database 
    * @access protected 
    */ 
    protected $database; 


    /** 
    * @name constructor 
    * @access public 
    * @param no parameters 
    */ 
    public function __construct() { 

        $this->host    = DB_HOST; //change this to whatever needed
        $this->user    = DB_USER; 
        $this->pass    = DB_PASS; 
        $this->port    = DB_PORT; 
        $this->database = DB_DATABASE; 
    } 

    /** 
    * @name return_connection 
    * @access protected 
    * @param n parameters 
    * returns the connection resource 
    */ 
    protected function return_connection() { 

        try { 
            if(!$link = mysql_connect($this->host.":".$this->port, $this->user, $this->pass)) { 
                throw new Exception(); 
            } 
            else { 
                if(!$return = mysql_select_db($this->database,$link)) { 
                    throw new Exception();
                } 
                else { 
                    return $link; 
                } 
            } 
        } 

        /** 
       * @todo Exception catches missing! 
       */ 
        catch (Exception $ex) {
        }
    } 

}


/** 
 * @name db 
 * @access private 
 */ 

class db extends dbconnection { 

    /** 
    * @name conn 
    * @var contains the resouce returned from the dbconnection 
    */ 
    private $conn; 

    /** 
    * @name last result 
    * @var provied the last positive query result 
    */ 
    public $lastresult; 


    /** 
   * @name construct 
   */ 

    public function __construct() { 

        parent::__construct(); 
        $this->conn = $this->return_connection(); 
    } 


    /** 
    * @name query 
    * @var database query 
    * @param string 
    * @access public 
    */ 
    public function q($sql_input) { 

        try { 
            if(!@$result = mysql_query($sql_input,$this->conn)) { 
                throw new Exception();
            } 
            else { 
                return $result; 
            } 
        } 

        catch (Exception $ex) {
        }
    } 


    /** 
    * @name return 3d array result 
    * @var query result 
    * @param resource id 
    * @access public 
    */ 

    public function get3darray($resource) { 
        try { 
            if(!@mysql_fetch_array($resource)) 
                throw new Exception(); 
             
            else { 
                $i = 0; 
                while($temp = mysql_fetch_array($resource)) { 
                    $return[$i] = $temp; 
                    $i++; 
                }
            }
            return $return; 
        }

        catch (Exception $ex) {
        }

    }

}
?>

    if($_POST['subject'] == 'cartridge')
        $sql = "INSERT INTO issue (created, number, name, company, phone, status, comment) VALUES (now    (),'$number','$name','$company','$phone',0, '$comment')";
    else if($_POST['subject'] == 'application')
        $sql = "INSERT INTO application (created, name, performer, company, phone, status, term, comment, complet) VALUES (now(), '$name', ' ', '$company', '$phone', 0, '$term', '$comment', ' ')";        
    $db = new db();
    $result = $db->q($sql);

    if($_POST['subject'] == 'cartridge')
        $sql = "INSERT INTO issue (created, number, name, company, phone, status, comment) VALUES (now    (),'$number','$name','$company','$phone',0, '$comment')";

    $db = new db();
    $result = $db->q($sql);

    else if($_POST['subject'] == 'application')
        $sql = "INSERT INTO application (created, name, performer, company, phone, status, term, comment, complet) VALUES (now(), '$name', ' ', '$company', '$phone', 0, '$term', '$comment', ' ')";     
   
    $db = new db2();
    $result = $db->q($sql);