为什么无法使用php中mysqli的准备语句进行数据库中数据的查询(绑定参数或者绑定结果),项目急用!
代码如下:
<br /> <?php<br /> /*<br /> 利用mysqli扩展来绑定结果<br /> */<br /> //新建服务器连接<br /> $mysqli=new mysqli('localhost','root','root','searcdb');<br /> //创建查询<br /> $query="SELECT adminName,adminPwd FROM admininfo";<br /> //创建语句对象<br /> $stmt=$mysqli->stmt_init();<br /> //为执行准备语句<br /> $stmt->prepare($query);<br /> //执行语句<br /> $stmt->execute();<br /> //绑定结果参数<br /> $stmt->bind_result($name,$pwd);<br /> //循环处理结果并输出数据<br /> while($stmt->fetch()){<br /> printf("%s, %s, %s <br />",$name,$pwd);<br /> }<br /> //恢复语句资源<br /> $stmt->close();<br /> //关闭连接<br /> $mysqli->close();<br /> ?><br />这个语句到底有什么问题啊 我直接做增删改查是可以,但是无论是采用mysqli绑定结果或者绑定参数的方法都不行,求大侠指导啊,公司实习很快就要用它做项目了,急用急用!!
------解决方案--------------------
printf("%s, %s, %s
",$name,$pwd); ???
少了一个参数
或者说多了一个格式符
------解决方案--------------------
多一个占位符。你不是只有两个参数吗?
------解决方案--------------------
少了一行代码,要把查询结果临时存储才能使用。
仅供参考:
<br /> function selectLink($oid){<br /> $sql = "select o.oid,l.lid,c.cid,comName,comPrice,ordTime<br /> from mis_order o,mis_link l,mis_commodity c<br /> where o.oid=l.lid and c.cid=l.cid and o.oid=?";<br /> $stmt = $this->mysqli->prepare($sql);<br /> $stmt->bind_param("i",$oid);<br /> $stmt->execute();<br /> $stmt->store_result();<br /> $stmt->bind_result($oid,$lid,$cid,$comName,$comPrice,$ordTime);<br /> $rows = $stmt->affected_rows;<br /> if($rows > 0){<br /> $arrLink = array();<br /> while($stmt->fetch()){<br /> $arr = array(<br /> "oid" => $oid,<br /> "lid" => $lid,<br /> "cid" => $cid,<br /> "comName" => $comName,<br /> "comPrice" => $comPrice,<br /> "ordTime" => $ordTime<br /> );<br /> array_push($arrLink,$arr);<br /> }<br /> return $arrLink;<br /> }else{<br /> echo "查询订单明细失败!<br/>";<br /> }<br /> }<br />

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

PHPisusedforsendingemailsduetoitsbuilt-inmail()functionandsupportivelibrarieslikePHPMailerandSwiftMailer.1)Usethemail()functionforbasicemails,butithaslimitations.2)EmployPHPMailerforadvancedfeatureslikeHTMLemailsandattachments.3)Improvedeliverability

PHP performance bottlenecks can be solved through the following steps: 1) Use Xdebug or Blackfire for performance analysis to find out the problem; 2) Optimize database queries and use caches, such as APCu; 3) Use efficient functions such as array_filter to optimize array operations; 4) Configure OPcache for bytecode cache; 5) Optimize the front-end, such as reducing HTTP requests and optimizing pictures; 6) Continuously monitor and optimize performance. Through these methods, the performance of PHP applications can be significantly improved.

DependencyInjection(DI)inPHPisadesignpatternthatmanagesandreducesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itallowspassingdependencieslikedatabaseconnectionstoclassesasparameters,facilitatingeasiertestingandscalability.

CachingimprovesPHPperformancebystoringresultsofcomputationsorqueriesforquickretrieval,reducingserverloadandenhancingresponsetimes.Effectivestrategiesinclude:1)Opcodecaching,whichstorescompiledPHPscriptsinmemorytoskipcompilation;2)DatacachingusingMemc


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

Hot Tools

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SublimeText3 Linux new version
SublimeText3 Linux latest version
