PHP encapsulated database addition, deletion, modification and query-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

PHP encapsulated database addition, deletion, modification and query

不言

May 09, 2018 am 09:34 AM

php encapsulation database

This article mainly introduces the addition, deletion, modification and query of the PHP package database. It has certain reference value. Now I share it with everyone. Friends in need can refer to it

Package:

<?php
    class mysqlSql{//封装函数
        public $db;
        public function __construct($dbname){//构造函数
            $this->db = new PDO("mysql:host=localhost;dbname=".$dbname,&#39;root&#39;,&#39;root&#39;);//数据库连接
        }
        public function zengjia($table,$title,$body){//数据库增加
            $time=time();//当前时间
            $sql = "INSERT INTO ".$table .&#39; (id,title,body,create_time)&#39;." VALUES (null,&#39;$title&#39;,&#39;$body&#39;,$time)";
            $db = $this->db;
            $row = $db->query($sql);
            return $row;
 
        }
        public function shanchu($table,$id){//数据库删除
            $sql = "DELETE FROM ".$table." WHERE id=".$id; 
            $db = $this->db;
            $row = $db->exec($sql);
            return $row;
        }
        public function gengxin($table,$title,$body,$id){//数据库更新
            $time=time();//当前时间
            $sql = "UPDATE ".$table." SET title=&#39;$title&#39;,body=&#39;$body&#39;,update_time=$time where id=".$id;
            $db =$this->db;
            $row = $db->exec($sql);
            return $row;
        }
        public function chaxunOne($table,$id){//数据库查询单条记录
            $sql = "SELECT * FROM ".$table." WHERE id=".$id;
            $db = $this->db;
            $sth = $db->query($sql);
            $row = $sth->fetch(PDO::FETCH_ASSOC);
            return $row;
        }
        public function chaxunAll($table){//数据库查询全部记录
            $sql = "SELECT * FROM ".$table;
            $db = $this->db;
            $sth = $db->query($sql);
            while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
                $arr[] = $row;
            }
            return $arr;
        }
    }
?>

Copy after login

Call:

<?php
    require "sql.php";
    $root = new mysqlSql(&#39;wanlala_1&#39;);
    //var_dump($root->chaxunAll(&#39;boke_wz&#39;));
    //var_dump($root->chaxunOne(&#39;boke_wz&#39;,2));
    //var_dump($root->zengjia(&#39;boke_wz&#39;,"是盛大发售","的飒飒是打算打算撒大大大是实打实的所说的是答案是"));
    //var_dump($root->shanchu(&#39;boke_wz&#39;,30));
    var_dump($root->gengxin(&#39;boke_wz&#39;,&#39;啊哈哈哈哈哈&#39;,&#39;尽快尽快尽快和交换机好就好&#39;,31));
 
?>

Copy after login

The above is the entire content of this article. For more related content, please pay attention to the PHP Chinese website.

Related recommendations:

Simple method of encapsulating curl in PHP

Detailed explanation of PHP encapsulating Mysql operation class

The above is the detailed content of PHP encapsulated database addition, deletion, modification and query. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Grow A Garden - Complete Mutation Guide

4 weeks ago By DDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Nordhold: Fusion System, Explained

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Clair Obscur: Expedition 33 - How To Get Perfect Chroma Catalysts

2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1677

CakePHP Tutorial

1429

Laravel Tutorial

1333

PHP Tutorial

1278

C# Tutorial

1257

Related knowledge

Oracle's Role in the Business World Apr 23, 2025 am 12:01 AM

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.

What happens if session_start() is called multiple times? Apr 25, 2025 am 12:06 AM

Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.

The Compatibility of IIS and PHP: A Deep Dive Apr 22, 2025 am 12:01 AM

IIS and PHP are compatible and are implemented through FastCGI. 1.IIS forwards the .php file request to the FastCGI module through the configuration file. 2. The FastCGI module starts the PHP process to process requests to improve performance and stability. 3. In actual applications, you need to pay attention to configuration details, error debugging and performance optimization.

Redis: Understanding Its Architecture and Purpose Apr 26, 2025 am 12:11 AM

Redis is a memory data structure storage system, mainly used as a database, cache and message broker. Its core features include single-threaded model, I/O multiplexing, persistence mechanism, replication and clustering functions. Redis is commonly used in practical applications for caching, session storage, and message queues. It can significantly improve its performance by selecting the right data structure, using pipelines and transactions, and monitoring and tuning.

Composer: Aiding PHP Development Through AI Apr 29, 2025 am 12:27 AM

AI can help optimize the use of Composer. Specific methods include: 1. Dependency management optimization: AI analyzes dependencies, recommends the best version combination, and reduces conflicts. 2. Automated code generation: AI generates composer.json files that conform to best practices. 3. Improve code quality: AI detects potential problems, provides optimization suggestions, and improves code quality. These methods are implemented through machine learning and natural language processing technologies to help developers improve efficiency and code quality.

What is the significance of the session_start() function? May 03, 2025 am 12:18 AM

session_start()iscrucialinPHPformanagingusersessions.1)Itinitiatesanewsessionifnoneexists,2)resumesanexistingsession,and3)setsasessioncookieforcontinuityacrossrequests,enablingapplicationslikeuserauthenticationandpersonalizedcontent.

H5: Key Improvements in HTML5 Apr 28, 2025 am 12:26 AM

HTML5 brings five key improvements: 1. Semantic tags improve code clarity and SEO effects; 2. Multimedia support simplifies video and audio embedding; 3. Form enhancement simplifies verification; 4. Offline and local storage improves user experience; 5. Canvas and graphics functions enhance the visualization of web pages.

PHP and IIS: Making Them Work Together Apr 21, 2025 am 12:06 AM

Configuring and running PHP on IIS requires the following steps: 1) Download and install PHP, 2) Configuring IIS and adding FastCGI module, 3) Create and set up an application pool, 4) Create a website and bind to an application pool. Through these steps, you can easily deploy PHP applications on your Windows server and improve application stability and efficiency by configuring scaling and optimizing performance.

See all articles