Detailed explanation of mysql's database operation function encapsulation-PHP Tutorial-php.cn

Detailed explanation of mysql's database operation function encapsulation

小云云

Release： 2023-03-22 19:26:01

Original

1871 people have browsed it

Most of today's PHP operation databases are implemented using mysqli, and it is also very easy to use when implementing mysqli operation database and e-commerce backend management. Since the frequency of use is so high, there is no choice but to To encapsulate the function library, there is no class method for encapsulation here, but a simple structure-oriented method, which is summarized in a unified way:

(1) Connect to the database:

function connect(){

    @$link = mysqli_connect(DB_HOST,DB_USER,DB_PWD);//连接数据库
    mysqli_set_charset($link,DB_CHARSET);//设置数据库字体格式
    mysqli_select_db($link,DB_DBNAME) or die(&#39;数据库打开失败&#39;);//选择数据库

    if(mysqli_connect_errno())
    {
        die(&#39;数据库连接失败 : &#39;.mysqli_connect_errno());
    }

    return $link;
}

Copy after login

(2) Insert data

function insert($link,$table,$array){
    $keys = join(&#39;,&#39;,array_keys($array));
    $values = "&#39;".join(&#39;,&#39;,array_values($array))."&#39;";
    $sql = &#39;insert into {$table}({$keys}) values({$values})&#39;;

    mysqli_query($link,$sql);

    return mysqli_insert_id($link);
}

Copy after login

(3) Modify data

function update($link,$table,$array,$where = null) {
     $setstr = &#39;&#39;; 
     foreach ($array as $key => $value) 
     {
        $setstr .= (&#39; &#39;.$key.&#39;=&#39;.$value.&#39; &#39;); 
        if(!$setstr){ 
             $sep = &#39;&#39;;
        }else{ 
             $sep = &#39;,&#39;; 
        } 
        $setstr .= $sep.$key.&#39;=&#39;."&#39;"$value"&#39;";
     } 

     $sql = "update {$table} set {$setstr}".($where ? &#39;where &#39;.$where : &#39;&#39;); 
     mysqli_query($link,$sql); 

     return mysqli_affected_rows($link); 
}

Copy after login

(4) Delete data

function delete($link,$table,$where = null)
{
    $sql = "delete from {$table}".($where?&#39;where &#39;.$where : &#39;&#39;);
    mysqli_query($link,$sql);

    return mysqli_affected_rows($link); 
}

Copy after login

(5) Find a record

function fetchOne($link,$sql,$result_type=MYSQLI_ASSOC)
{
    $result = mysqli_query($link,$sql);

    $row = mysqli_fetch_array($result,$result_type);

    return $row;
}

Copy after login

(6) Find multiple records

function fetchAll($link,$sql,$result_type=MYSQLI_ASSOC)
{
    $result = mysqli_query($link,$sql);

    while(@$row = mysqli_fetch_array($result,$result_type))
    {
        $row[] = $row;
    }

    return $row;
}

Copy after login

(7) Return the number of rows in the result set

function getResultNum($link,$sql)
{
    $result = mysqli_query($link,$sql);

    return mysqli_num_rows($result);
}

Copy after login

Related recommendations:

Detailed examples of MySQL database design issues

Optimization summary of mysql database

php code sharing for calculating mysql database size

The above is the detailed content of Detailed explanation of mysql's database operation function encapsulation. For more information, please follow other related articles on the PHP Chinese website!