запрос к базе через $sql->query()

[sunyang]

частенько встречаю запросы к базе не типа mysql_query(), а типа:

$sql->query()
$sql-> $sql->selectRow()
и.т.д.
Что за вид запросов?

 

[Juri]

Обычная ооп обертка вот например, из дле

class db
{
    var $db_id = false;
    var $connected = false;
    var $query_num = 0;
    var $query_list = array();
    var $mysql_error = '';
    var $mysql_version = '';
    var $mysql_error_num = 0;
    var $mysql_extend = "MySQL";
    var $MySQL_time_taken = 0;
    var $query_id = false;
 
    function connect($db_user, $db_pass, $db_name, $db_location = 'localhost', $show_error=1)
    {
        if(!$this->db_id = @mysql_connect($db_location, $db_user, $db_pass)) {
            if($show_error == 1) {
                $this->display_error(mysql_error(), mysql_errno());
            } else {
                return false;
            }
        }
 
        if(!@mysql_select_db($db_name, $this->db_id)) {
            if($show_error == 1) {
                $this->display_error(mysql_error(), mysql_errno());
            } else {
                return false;
            }
        }
 
        $this->mysql_version = mysql_get_server_info();
 
        if(!defined('COLLATE'))
        {
            define ("COLLATE", "cp1251");
        }
 
        if (version_compare($this->mysql_version, '4.1', ">=")) mysql_query("/*!40101 SET NAMES '" . COLLATE . "' */");
 
        $this->connected = true;
 
        return true;
    }
 
    function query($query, $show_error=true)
    {
        $time_before = $this->get_real_time();
 
        if(!$this->connected) $this->connect(DBUSER, DBPASS, DBNAME, DBHOST);
     
        if(!($this->query_id = mysql_query($query, $this->db_id) )) {
 
            $this->mysql_error = mysql_error();
            $this->mysql_error_num = mysql_errno();
 
            if($show_error) {
                $this->display_error($this->mysql_error, $this->mysql_error_num, $query);
            }
        }
         
        $this->MySQL_time_taken += $this->get_real_time() - $time_before;
     
 
//            $this->query_list[] = array( 'time'  => ($this->get_real_time() - $time_before),
//                                        'query' => $query,
//                                        'num'  => (count($this->query_list) + 1));
 
        $this->query_num ++;
 
        return $this->query_id;
    }
 
    function get_row($query_id = '')
    {
        if ($query_id == '') $query_id = $this->query_id;
 
        return mysql_fetch_assoc($query_id);
    }
 
    function get_affected_rows()
    {
        return mysql_affected_rows($this->db_id);
    }
 
    function get_array($query_id = '')
    {
        if ($query_id == '') $query_id = $this->query_id;
 
        return mysql_fetch_array($query_id);
    }
 
 
    function super_query($query, $multi = false)
    {
 
        if(!$multi) {
 
            $this->query($query);
            $data = $this->get_row();
            $this->free();         
            return $data;
 
        } else {
            $this->query($query);
         
            $rows = array();
            while($row = $this->get_row()) {
                $rows[] = $row;
            }
 
            $this->free();         
 
            return $rows;
        }
    }
 
    function num_rows($query_id = '')
    {
 
        if ($query_id == '') $query_id = $this->query_id;
 
        return mysql_num_rows($query_id);
    }
 
    function insert_id()
    {
        return mysql_insert_id($this->db_id);
    }
 
    function get_result_fields($query_id = '') {
 
        if ($query_id == '') $query_id = $this->query_id;
 
        while ($field = mysql_fetch_field($query_id))
        {
            $fields[] = $field;
        }
     
        return $fields;
      }
 
    function safesql( $source )
    {
        if(!$this->db_id) $this->connect(DBUSER, DBPASS, DBNAME, DBHOST);
 
        if ($this->db_id) return mysql_real_escape_string ($source, $this->db_id);
        else return addslashes($source);
    }
 
    function free( $query_id = '' )
    {
 
        if ($query_id == '') $query_id = $this->query_id;
 
        @mysql_free_result($query_id);
    }
 
    function close()
    {
        @mysql_close($this->db_id);
    }
 
    function get_real_time()
    {
        list($seconds, $microSeconds) = explode(' ', microtime());
        return ((float)$seconds + (float)$microSeconds);
    } 
 
    function display_error($error, $error_num, $query = '')
    {
        if($query) {
            // Safify query
            $query = preg_replace("/([0-9a-f]){32}/", "********************************", $query); // Hides all hashes
            $query_str = "$query";
        }
     
        echo '<?xml version="1.0" encoding="iso-8859-1"?>
        <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
        <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
        <title>MySQL Fatal Error</title>
        <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
        <style type="text/css">
        <!--
        body {
            font-family: Verdana, Arial, Helvetica, sans-serif;
            font-size: 10px;
            font-style: normal;
            color: #000000;
        }
        -->
        </style>
        </head>
        <body>
            <font size="4">MySQL Error!</font>
            <br />------------------------<br />
            <br />
         
            <u>The Error returned was:</u>
            <br />
                <strong>'.$error.'</strong>
 
            <br /><br />
            </strong><u>Error Number:</u>
            <br />
                <strong>'.$error_num.'</strong>
            <br />
                <br />
         
            <textarea name="" rows="10" cols="52" wrap="virtual">'.$query_str.'</textarea><br />
 
        </body>
        </html>';
     
        exit();
    }
 
}

После инициализации запросы будут выглядеть так

$db->query();
$db->get_array();
$db->get_row();
$db->num_rows();

и Так далее

 

[t3s]

ТС, полагаю что вам будет полезно ознакомиться
1. с правилами форума, и научиться задавать вопросы в тематических разделах
2. с классами
тему переношу, при рецидиве получите предупреждение