国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Home php教程 php手冊(cè) PHP mysql操作類(lèi)程序

PHP mysql操作類(lèi)程序

Jun 13, 2016 am 11:27 AM
mysql php 。 No code use share study operate program kind

一個(gè)不錯(cuò)的PHP mysql操作類(lèi) ,分享給大家學(xué)習(xí)使用。

?代碼如下 復(fù)制代碼

//數(shù)據(jù)庫(kù)處理類(lèi)
class db
{
??? //SQL執(zhí)行后的數(shù)據(jù)保存變量;
??? var $db;
??? //讀取或設(shè)置當(dāng)前數(shù)據(jù)的位置
??? var $position=0;
??? //執(zhí)行SQL語(yǔ)句并把結(jié)果保存為db變量中;

??? function sub_sql($str)
??? {
??????? global $prefix;//全局函數(shù),表前綴
??????? return str_replace("dede_",$prefix,$str);
??? }
??? function Sql($str)
??? {
??????? $str=$this->sub_sql($str);
??????? $result = mysql_query($str);
??????? $i=0;
??????? while($row = mysql_fetch_array($result))
??????? {
??????????? $str_array[$i]=$row;
??????????? $i++;
??????? }
??????? if(empty($str_array))
??????? {
??????????? $str_array=array();
??????? }
??????? $this->db=$str_array;
??? }
??? //讀取一條數(shù)據(jù)并把數(shù)據(jù)往后移一位,如果數(shù)據(jù)為空則返回為null;
??? function Get_One()
??? {
??????? $re=empty($this->db[$this->position])?null:$this->db[$this->position];
??????? $this->position=$re?$this->position+1:$this->position;
??????? return $re;
??? }
??? //判斷是否數(shù)據(jù)讀取到結(jié)尾了
??? function Judge()
??? {
??????? $re=empty($this->db[$this->position])?true:false;
??????? return $re;
??? }
??? //取得db里面的個(gè)數(shù)
??? function Get_Num()
??? {
??????? return count($this->db);
??? }
??? //更新數(shù)據(jù)庫(kù)里面的數(shù)據(jù),$t為表名,$v格式為數(shù)組格式,上標(biāo)為字段名,下標(biāo)為數(shù)據(jù);$w為條件上標(biāo)為字段名下標(biāo)為數(shù)據(jù),$p為條件0為等號(hào),1為大于,-1為小于;
??? function Set_Updata($t,$v,$w,$p=0)
??? {
??????? $this->Sql($t);
??????? $v_str="";
??????? $w_str="";
??????? $f="";
??????? foreach($v as $key=>$vaule)
??????? {
??????????? if(!is_numeric($key))
??????????? {
??????????????? if(empty($v_str))
??????????????? {
??????????????????? $v_str=htmlspecialchars($key)."='".htmlspecialchars($vaule)."'";
??????????????? }else
??????????????? {
??????????????????? $v_str=$v_str.",".htmlspecialchars($key)."='".htmlspecialchars($vaule)."'";
??????????????? }
??????????? }
??????? }
??????? switch($p)
??????? {
??????????? case 0:
??????????????? $f="=";
??????????????? break;
??????????? case 1:
??????????????? $f=">";
??????????????? break;
??????????? case -1:
??????????????? $f="??????????????? break;
??????? }
??????? if(!empty($f))
??????? {
??????????? foreach($w as $key=>$vaule)
??????????? {
??????????????? if(!is_numeric($key))
??????????????? {
??????????????????? if(empty($v_str))
??????????????????? {
??????????????????????? $w_str=htmlspecialchars($key).$f.htmlspecialchars($vaule)."'";
??????????????????? }else
??????????????????? {
??????????????????????? $w_str=$w_str.",".htmlspecialchars($key).$f.htmlspecialchars($vaule)."'";
??????????????????? }
??????????????? }
??????????? }
??????? }
??????? $sql="UPDATE ".$t." SET ".$v_str." where ".$w_str;
??????? return $result = mysql_query($sql);
??? }
??? //刪除一數(shù)據(jù)$w為條件上標(biāo)為字段名下標(biāo)為數(shù)據(jù),$p為條件0為等號(hào),1為大于,-1為小于;
??? function Set_Del($t,$w,$p=0)
??? {
??????? $this->sub_sql($t);
??????? $w_str="";
??????? $f="";
??????? switch($p)
??????? {
??????????? case 0:
??????????????? $f="=";
??????????????? break;
??????????? case 1:
??????????????? $f=">";
??????????????? break;
??????????? case -1:
??????????????? $f="??????????????? break;
??????? }
??????? if(!empty($f))
??????? {
??????????? foreach($w as $key=>$vaule)
??????????? {
??????????????? if(!is_numeric($key))
??????????????? {
??????????????????? if(empty($v_str))
??????????????????? {
??????????????????????? $w_str=htmlspecialchars($key).$f.htmlspecialchars($vaule)."'";
??????????????????? }else
??????????????????? {
??????????????????????? $w_str=$w_str.",".htmlspecialchars($key).$f.htmlspecialchars($vaule)."'";
??????????????????? }
??????????????? }
??????????? }
??????? }
??????? $str="DELETE FROM ".$t." WHERE ".$w_str;
??????? return $result = mysql_query($str);
??? }
??? function Add($t,$v)
??? {
??????? $this->sub_sql($t);
??????? $k_str="";
??????? $v_str="";
??????? foreach($v as $key=>$vaule)
??????? {
??????????? if(!is_numeric($key)){
??????????????? if(empty($k_str))
??????????????? {
??????????????????? $k_str=htmlspecialchars($key);
??????????????????? $v_str="'".htmlspecialchars($vaule)."'";
??????????????? }else
??????????????? {
??????????????????? $k_str=$k_str.",".htmlspecialchars($key);
??????????????????? $v_str=$v_str.","."'".htmlspecialchars($vaule)."'";
??????????????? }
??????????? }
??????? }
??????? $str="INSERT INTO ".$t."(".$k_str.")"."value(".$v_str.")";
??????? return $result = mysql_query($str);
??? }
}
?>


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

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

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

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Using std::chrono in C Using std::chrono in C Jul 15, 2025 am 01:30 AM

std::chrono is used in C to process time, including obtaining the current time, measuring execution time, operation time point and duration, and formatting analysis time. 1. Use std::chrono::system_clock::now() to obtain the current time, which can be converted into a readable string, but the system clock may not be monotonous; 2. Use std::chrono::steady_clock to measure the execution time to ensure monotony, and convert it into milliseconds, seconds and other units through duration_cast; 3. Time point (time_point) and duration (duration) can be interoperable, but attention should be paid to unit compatibility and clock epoch (epoch)

How does PHP handle Environment Variables? How does PHP handle Environment Variables? Jul 14, 2025 am 03:01 AM

ToaccessenvironmentvariablesinPHP,usegetenv()orthe$_ENVsuperglobal.1.getenv('VAR_NAME')retrievesaspecificvariable.2.$_ENV['VAR_NAME']accessesvariablesifvariables_orderinphp.iniincludes"E".SetvariablesviaCLIwithVAR=valuephpscript.php,inApach

mysql common table expression (cte) example mysql common table expression (cte) example Jul 14, 2025 am 02:28 AM

CTE is a temporary result set in MySQL used to simplify complex queries. It can be referenced multiple times in the current query, improving code readability and maintenance. For example, when looking for the latest orders for each user in the orders table, you can first obtain the latest order date for each user through the CTE, and then associate it with the original table to obtain the complete record. Compared with subqueries, the CTE structure is clearer and the logic is easier to debug. Usage tips include explicit alias, concatenating multiple CTEs, and processing tree data with recursive CTEs. Mastering CTE can make SQL more elegant and efficient.

Why We Comment: A PHP Guide Why We Comment: A PHP Guide Jul 15, 2025 am 02:48 AM

PHPhasthreecommentstyles://,#forsingle-lineand/.../formulti-line.Usecommentstoexplainwhycodeexists,notwhatitdoes.MarkTODO/FIXMEitemsanddisablecodetemporarilyduringdebugging.Avoidover-commentingsimplelogic.Writeconcise,grammaticallycorrectcommentsandu

PHP prepared statement with IN clause PHP prepared statement with IN clause Jul 14, 2025 am 02:56 AM

When using PHP preprocessing statements to execute queries with IN clauses, 1. Dynamically generate placeholders according to the length of the array; 2. When using PDO, you can directly pass in the array, and use array_values to ensure continuous indexes; 3. When using mysqli, you need to construct type strings and bind parameters, pay attention to the way of expanding the array and version compatibility; 4. Avoid splicing SQL, processing empty arrays, and ensuring data types match. The specific method is: first use implode and array_fill to generate placeholders, and then bind parameters according to the extended characteristics to safely execute IN queries.

how to avoid undefined index error in PHP how to avoid undefined index error in PHP Jul 14, 2025 am 02:51 AM

There are three key ways to avoid the "undefinedindex" error: First, use isset() to check whether the array key exists and ensure that the value is not null, which is suitable for most common scenarios; second, use array_key_exists() to only determine whether the key exists, which is suitable for situations where the key does not exist and the value is null; finally, use the empty merge operator?? (PHP7) to concisely set the default value, which is recommended for modern PHP projects, and pay attention to the spelling of form field names, use extract() carefully, and check the array is not empty before traversing to further avoid risks.

Choosing appropriate data types for columns in MySQL tables Choosing appropriate data types for columns in MySQL tables Jul 15, 2025 am 02:25 AM

WhensettingupMySQLtables,choosingtherightdatatypesiscrucialforefficiencyandscalability.1)Understandthedataeachcolumnwillstore—numbers,text,dates,orflags—andchooseaccordingly.2)UseCHARforfixed-lengthdatalikecountrycodesandVARCHARforvariable-lengthdata

PHP header redirect not working PHP header redirect not working Jul 14, 2025 am 01:59 AM

Reasons and solutions for the header function jump failure: 1. There is output before the header, and all pre-outputs need to be checked and removed or ob_start() buffer is used; 2. The failure to add exit causes subsequent code interference, and exit or die should be added immediately after the jump; 3. The path error should be used to ensure correctness by using absolute paths or dynamic splicing; 4. Server configuration or cache interference can be tried to clear the cache or replace the environment test.

See all articles