很久没写程序了,由于php5.0升级的mysqli类操作数据库有很多优点,本人想尝试用mysqli的方法操作数据库,经过从网上查资料、看手册,浏览、删除都能正常实现,唯独插入功能总是提示错误:Fatal error: Call to a member function prepare() on null in D:\xampps\htdocs\txl\addbook.php on line 20 。
快愁死我了,难道这个问题解决不了我要放弃Mysqli吗?请高手指点我的代码错在哪里?还是服务器的问题?(服务器我用的是Xampps1.9.7集成环境)
if($_POST['contacts'] == "true")
{
$stmt = $mysqli->prepare("INSERT INTO contactsuser(bookUname, bookDep, bookDuty,bookphone,bookTel,bookEmail,bookGid) VALUES (?, ?, ?, ?, ?, ?, ?)");
$stmt->bind_param('sssd', $bookUname, $bookDep, $bookDuty, $bookphone, $bookTel, $bookEmail, $bookGid);
$bookUname = $_POST['bookUname'];
$bookDep = $_POST['bookDep'];
$bookDuty = $_POST['bookDuty'];
$bookphone = $_POST['bookphone'];
$bookTel = $_POST['bookTel'];
$bookEmail = $_POST['bookEmail'];
$bookGid = $_POST['bookGid'];
/* execute prepared statement */
$stmt->execute();
printf("%d Row inserted.\n", $stmt->affected_rows);
/* close statement and connection */
$stmt->close();
exit;
}
回复讨论(解决方案)
$mysqli 不是 mysqli 对象
试试面向过程风格的方法:
$stmt = mysqli_prepare($link, "INSERT INTO contactsuser(bookUname, bookDep, bookDuty,bookphone,bookTel,bookEmail,bookGid) VALUES (?, ?, ?, ?, ?, ?, ?)")
我刚才的程序确实疏忽忘了包含数据库链接文件了,但包含之后,包括改成面向过程风格后还是有错误:
Warning: mysqli_stmt_bind_param(): Number of elements in type definition string doesn't match number of bind variables in D:\xampps\htdocs\txl\addbook.php on line 24
程序如下:
$link = mysqli_connect('localhost','root','root','addressbook') or die('Unale to connect');
$stmt = mysqli_prepare($link, "INSERT INTO contactsuser(bookUname, bookDep, bookDuty,bookphone,bookTel,bookEmail,bookGid) VALUES (?, ?, ?, ?, ?, ?, ?)");
mysqli_stmt_bind_param($stmt,'sssd', $bookUname, $bookDep, $bookDuty, $bookphone, $bookTel, $bookEmail, $bookGid);
$bookUname = $_POST['bookUname'];
$bookDep = $_POST['bookDep'];
$bookDuty = $_POST['bookDuty'];
$bookphone = $_POST['bookphone'];
$bookTel = $_POST['bookTel'];
$bookEmail = $_POST['bookEmail'];
$bookGid = 1;
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
数据库的字段类型我也检查了,除了主键bookid是自动增加的int型,bookGid是int型,其他都是varchar类型
VALUES (?, ?, ?, ?, ?, ?, ?)
$stmt,'sssd', $bookUname, $bookDep, $bookDuty, $bookphone, $bookTel, $bookEmail, $bookGid
七个问号对应着八个参数 。。。。。加一个问号再试试
mysqli_stmt_bind_param($stmt,'ssssssd', $bookUname, $bookDep, $bookDuty, $bookphone, $bookTel, $bookEmail, $bookGid);
http://php.net/manual/zh/mysqli-stmt.bind-param.php
The number of variables and length of string types must match the parameters in the statement.
楼上说的对,应该是ssssssd
太好了!感谢各位高手帮忙!特别是saint_leer和misakaqunianx...说的“ssssssd”的问题说到点子上了,一直没搞懂这传字符串啥意思!

ThesecrettokeepingaPHP-poweredwebsiterunningsmoothlyunderheavyloadinvolvesseveralkeystrategies:1)ImplementopcodecachingwithOPcachetoreducescriptexecutiontime,2)UsedatabasequerycachingwithRedistolessendatabaseload,3)LeverageCDNslikeCloudflareforservin

You should care about DependencyInjection(DI) because it makes your code clearer and easier to maintain. 1) DI makes it more modular by decoupling classes, 2) improves the convenience of testing and code flexibility, 3) Use DI containers to manage complex dependencies, but pay attention to performance impact and circular dependencies, 4) The best practice is to rely on abstract interfaces to achieve loose coupling.

Yes,optimizingaPHPapplicationispossibleandessential.1)ImplementcachingusingAPCutoreducedatabaseload.2)Optimizedatabaseswithindexing,efficientqueries,andconnectionpooling.3)Enhancecodewithbuilt-infunctions,avoidingglobalvariables,andusingopcodecaching

ThekeystrategiestosignificantlyboostPHPapplicationperformanceare:1)UseopcodecachinglikeOPcachetoreduceexecutiontime,2)Optimizedatabaseinteractionswithpreparedstatementsandproperindexing,3)ConfigurewebserverslikeNginxwithPHP-FPMforbetterperformance,4)

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl


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

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.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

Dreamweaver Mac version
Visual web development tools

Atom editor mac version download
The most popular open source editor

WebStorm Mac version
Useful JavaScript development tools
