search
HomeBackend DevelopmentPHP Tutorial为什么不能调用函数里面的变量?

<?php  //定义常量define("EntTime", "2012-08-01");define("EntTime2", "2012-08-31");define("Query_field", "品号");define("Operate", "包含");define("requirement", "WDZ");//将常量转换为变量$EntTime = EntTime;$EntTime2 = EntTime2;$Query_field = Query_field;$Operate = Operate;$requirement = requirement;//自定义函数function jhRepPd(){	GLOBAL $PUR,$MOC;	switch($Operate){		case "包含":			if($Query_field=="品号"){				$PUR = "PURTH.TH004 like'%".$requirement."%' AND ";			}			break;	}}//去除日期中的"-"$a_date = "PURTG.TG003 >='".str_replace("-","",$EntTime)."'";$b_date = "PURTG.TG003 <='".str_replace("-","",$EntTime2)."'";//判断变量是否为空if(!empty($EntTime) && !empty($EntTime2) && $requirement!==""){	$date = "(".$a_date." AND ".$b_date.") AND ";	jhRepPd();};//sql语句$sql = "SELECT * FROM TB where {$date}{$PUR}dbId in('1','2','3')";//打印SQL语句echo $sql;?>
--这是打印结果,但不是正确的。因为函数中的变量没有输出,为什么?SELECT * FROM TB where (PURTG.TG003 >='20120801' AND PURTG.TG003 <='20120831') AND dbId in('1','2','3')--正确的结果应该是:SELECT * FROM TB where (PURTG.TG003 >='20120801' AND PURTG.TG003 <='20120831') AND PURTH.TH004 like'%WDZ%' AND dbId in('1','2','3')


回复讨论(解决方案)

GLOBAL不会,看楼下~

请指教

function jhRepPd(){
    GLOBAL $PUR,$MOC;
    switch( $Operate){
        case "包含":
            if( $Query_field=="品号"){
                $PUR = "PURTH.TH004 like'%".$requirement."%' AND ";
            }
            break;
    }
}
中,套红的是外部变量,没有声明。被视为局部变量,无值
所以变量 $PUR 并未赋值。当然就没有期望的结果了
应写作

function jhRepPd(){    GLOBAL $PUR,$MOC;    switch(Operate){ //既然定义有常量,为什么不用        case "包含":            if(Query_field=="品号"){ //这里也是                $PUR = "PURTH.TH004 like'%".requirement."%' AND ";//还有这里            }            break;    }}

Statement
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
What is the best way to send an email using PHP?What is the best way to send an email using PHP?May 08, 2025 am 12:21 AM

ThebestapproachforsendingemailsinPHPisusingthePHPMailerlibraryduetoitsreliability,featurerichness,andeaseofuse.PHPMailersupportsSMTP,providesdetailederrorhandling,allowssendingHTMLandplaintextemails,supportsattachments,andenhancessecurity.Foroptimalu

Best Practices for Dependency Injection in PHPBest Practices for Dependency Injection in PHPMay 08, 2025 am 12:21 AM

The reason for using Dependency Injection (DI) is that it promotes loose coupling, testability, and maintainability of the code. 1) Use constructor to inject dependencies, 2) Avoid using service locators, 3) Use dependency injection containers to manage dependencies, 4) Improve testability through injecting dependencies, 5) Avoid over-injection dependencies, 6) Consider the impact of DI on performance.

PHP performance tuning tips and tricksPHP performance tuning tips and tricksMay 08, 2025 am 12:20 AM

PHPperformancetuningiscrucialbecauseitenhancesspeedandefficiency,whicharevitalforwebapplications.1)CachingwithAPCureducesdatabaseloadandimprovesresponsetimes.2)Optimizingdatabasequeriesbyselectingnecessarycolumnsandusingindexingspeedsupdataretrieval.

PHP Email Security: Best Practices for Sending EmailsPHP Email Security: Best Practices for Sending EmailsMay 08, 2025 am 12:16 AM

ThebestpracticesforsendingemailssecurelyinPHPinclude:1)UsingsecureconfigurationswithSMTPandSTARTTLSencryption,2)Validatingandsanitizinginputstopreventinjectionattacks,3)EncryptingsensitivedatawithinemailsusingOpenSSL,4)Properlyhandlingemailheaderstoa

How do you optimize PHP applications for performance?How do you optimize PHP applications for performance?May 08, 2025 am 12:08 AM

TooptimizePHPapplicationsforperformance,usecaching,databaseoptimization,opcodecaching,andserverconfiguration.1)ImplementcachingwithAPCutoreducedatafetchtimes.2)Optimizedatabasesbyindexing,balancingreadandwriteoperations.3)EnableOPcachetoavoidrecompil

What is dependency injection in PHP?What is dependency injection in PHP?May 07, 2025 pm 03:09 PM

DependencyinjectioninPHPisadesignpatternthatenhancesflexibility,testability,andmaintainabilitybyprovidingexternaldependenciestoclasses.Itallowsforloosecoupling,easiertestingthroughmocking,andmodulardesign,butrequirescarefulstructuringtoavoidover-inje

Best PHP Performance Optimization TechniquesBest PHP Performance Optimization TechniquesMay 07, 2025 pm 03:05 PM

PHP performance optimization can be achieved through the following steps: 1) use require_once or include_once on the top of the script to reduce the number of file loads; 2) use preprocessing statements and batch processing to reduce the number of database queries; 3) configure OPcache for opcode cache; 4) enable and configure PHP-FPM optimization process management; 5) use CDN to distribute static resources; 6) use Xdebug or Blackfire for code performance analysis; 7) select efficient data structures such as arrays; 8) write modular code for optimization execution.

PHP Performance Optimization: Using Opcode CachingPHP Performance Optimization: Using Opcode CachingMay 07, 2025 pm 02:49 PM

OpcodecachingsignificantlyimprovesPHPperformancebycachingcompiledcode,reducingserverloadandresponsetimes.1)ItstorescompiledPHPcodeinmemory,bypassingparsingandcompiling.2)UseOPcachebysettingparametersinphp.ini,likememoryconsumptionandscriptlimits.3)Ad

See all articles

Hot AI Tools

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.

Undress AI Tool

Undress AI Tool

Undress images for free

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

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

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function