<? 
    # Filename : database.php 
    # Author : Mitch Vroege 
        # Projectname : SMART PoLL 
        # Projectversion : 0.7.1 
        # Releasedate : 16-08-2004 
     
    class database 
    { 
        # Database vars 
        var $user = "space_4660476"; 
        var $pass = "xxxxxx"; 
        var $host = "sql110.000space.com"; 
        var $name = "space_4660476_crime"; 
         
        # Functie die mysql_num_rows teruggeeft 
        function num_rows($sql) 
        { 
            $this->connect(); 
            $res = mysql_query($sql); 
            $aantal = mysql_num_rows($res); 
            mysql_close(); 
             
            return $aantal; 
        } 
         
        # Functie de mysql_fetch_array teruggeeft 
        function get_array($sql) 
        { 
            $this->connect(); 
            $res = mysql_query($sql); 
            while($data = mysql_fetch_array($res)) 
                $row[] = $data; 
                 
            mysql_close(); 
                 
            return $row; 
        } 
         
        # Zelfde als hierboven maar dan 1 row 
        function get_single($sql) 
        { 
            $this->connect(); 
            $res = mysql_query($sql); 
            $data = mysql_fetch_array($res); 
            mysql_close(); 
             
            return $data; 
        } 
         
        # Functie die een normale query runt 
        function execute($sql) 
        { 
            $this->connect(); 
            $res = mysql_query($sql); 
            mysql_close(); 
             
            return $res; 
        } 
         
        # Functie die de database connectie maakt 
        function connect() 
        { 
            return mysql_select_db($this->name, mysql_connect($this->host, $this->user, $this->pass)); 
        } 
    } 
?>