MySQL add, delete, modify, check PHP class

<?php
header("content-type:text/html;charset=utf-8");
class DBUtils{
    /**
     *通用更新方法 insert update delete 操作
     *@param sql
     *@return bool  true false
     */
    public function update($sql){
        $link = $this->getConn();
        mysql_query($sql);
        //如果出错显示
        if(DEBUG){
            echo mysql_error();
        }
        $rs = mysql_affected_rows($link);
        $rs = $rs > 0;
        mysql_close($link);
        return $rs;
    }

MySQL is a relational database developed by the Swedish MySQL AB company and currently belongs to Oracle. MySQL is the most popular relational database management system. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software. MySQL is a relational database management system that stores data in different tables instead of putting all the data in one big warehouse, which increases speed and flexibility. The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual authorization policy (this entry "Authorization Policy"), which is divided into community version and commercial version. Due to its small size, fast speed and low total cost of ownership, especially the characteristics of open source, it is generally used by small and medium-sized users. For website development, MySQL is chosen as the website database. Due to the excellent performance of its community version, it can form a good development environment with PHP, Linux and Apache. After years of web technology development, it has become one of the widely used web server solutions in the industry, called LAMP.

Related Article

PHP MySql add, delete, modify, check, phpmysql add, delete, modify_PHP tutorial

12Jul2016

PHP MySql add, delete, modify, check, phpmysql add, delete, modify. PHP MySql addition, deletion and modification query, phpmysql addition, deletion and modification mysql_connect() connects to the database mysql_select_db selects the database mysql_fetch_assoc() obtains the result set mysql_query() executes the sql statement. Examples are as follows:

PHP data access add, delete, modify and check operations, PHP data access add and delete_PHP tutorial

12Jul2016

PHP data access add, delete, modify and check operations, PHP data access add and delete. PHP data access add, delete, modify and check operations, PHP data access add, delete, delete, modify and check operations small exercises, let’s practice. 1. View the news page-----main page htmlheadmeta http-equiv="Conten

Add, delete, modify and view operations of PHP SESSION, phpsession_PHP tutorial

13Jul2016

Add, delete, modify, view operations of PHP SESSION, phpsession. Add, delete, modify, and view operations of PHP SESSION. The difference between phpsession SESSION and COOKIE is that the cookie file is saved on the client, while the session is saved on the server.

How Do I Link Static Libraries That Depend on Other Static Libraries?

13Dec2024

Linking Static Libraries to Other Static Libraries: A Comprehensive ApproachStatic libraries provide a convenient mechanism to package reusable...

How Can I Reliably Check the Success of a MySQL DELETE Query in PHP?

04Dec2024

Determining the Success of MySQL Query in Modifying Database TablesIn PHP, to ascertain the success of a MySQL query that aims to modify table...

How to Silence TensorFlow\'s Debugging Output?

28Oct2024

Suppression of Tensorflow Debugging OutputTensorflow prints extensive information about loaded libraries, found devices, and other debugging data...

See all articles