mysqli_stmt_bind_param不能处理时间类型吗?
报错的这条语句
mysqli_stmt_bind_param($stmt, 'idii', $c, $a, $t, $w);
完整代码
<?php<br />require ('inc/config.php');<br />$page_title = '住宅数据添加-feige数据中心';<br />include ('inc/header.php');<br />require (MYSQL);<br />if ($_SERVER['REQUEST_METHOD'] == 'POST') { <br /> $trimmed = array_map('trim', $_POST);<br /> $errors = array();<br /> if(empty($trimmed['wdate'])) {<br /> $errors[] = '日期不能为空';<br /> } else {<br /> $w = mysqli_real_escape_string ($conn, $trimmed['wdate']);<br /> }<br /> <br /> if ( isset($trimmed['city']) && filter_var($trimmed['city'], FILTER_VALIDATE_INT, array('city' => 1)) ) {<br /> $c = mysqli_real_escape_string ($conn, $trimmed['city']);;<br /> } else {<br /> $errors[] = '请选择区域';<br /> }<br /> <br /> if (is_numeric($trimmed['taoshu']) && ($trimmed['taoshu'] > 0)) {<br /> $t = mysqli_real_escape_string ($conn, (int) $trimmed['taoshu']);<br /> } else {<br /> $errors[] = '请输入一个正确的套数';<br /> }<br /> if (is_numeric($trimmed['area']) && ($trimmed['area'] > 0)) {<br /> $a = mysqli_real_escape_string ($conn, (float) $trimmed['area']);<br /> } else {<br /> $errors[] = '请输入一个正确的面积';<br /> }<br /> <br /> <br /> if (empty($errors)) {<br /> $q = 'INSERT INTO f_chengjiao (city_id, area, taoshu, fang_time, os_time) VALUES (?, ?, ?, ?, ?, NOW())';<br /> $stmt = mysqli_prepare($conn, $q);<br /> mysqli_stmt_bind_param($stmt, 'idii', $c, $a, $t, $w);<br /> mysqli_stmt_execute($stmt);<br /><br /> if (mysqli_stmt_affected_rows($stmt) == 1) {<br /> echo '<p>这条数据已经被添加</p>';<br /> $_POST = array(); <br /> } else {<br /> echo '<p style="font-weight: bold; color: #C00">程序发生错误,请重新添加</p>'; <br /> } <br /> mysqli_stmt_close($stmt); <br /> } <br />} <br /><br />if ( !empty($errors) && is_array($errors) ) {<br /> echo '<p style="font-weight: bold; color: #C00">发生下列错误:<br />';<br /> foreach ($errors as $msg) {<br /> echo " - $msg<br />\n";<br /> }<br /> echo '请在试一遍</p>';<br />}<br /><br />?><br /><div class="portlet wrap mT50"><br /> <div class="portlet-title">住宅数据添加</div><br /> <div class="portlet-body"><br /> <form action="zhuzhai_add.php" method="post"><br /> <div class="control-group"><br /> <label class="control-label">时间</label><br /> <div class="controls"><br /> <input type="text" name="wdate" class="add-in" onClick="WdatePicker()" value="" />时间格式例如:2014-12-12<br /> </div><br /> </div> <br /> <div class="control-group"><br /> <label class="control-label">区域</label><br /> <div class="controls"><br /> <select name="city" class="select-city"><br /> <?php <br /> $q = "SELECT city_id, city_name FROM f_city ORDER BY city_id ASC"; <br /> $r = mysqli_query ($conn, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($conn));<br /> if (@mysqli_num_rows($r) > 0) {<br /> while ($row = mysqli_fetch_array ($r, MYSQLI_NUM)) {<br /> echo "<option value=\"$row[0]\"";<br /> if (isset($trimmed['city']) && ($trimmed['city'] == $row[0]) ) echo ' selected="selected"';<br /> echo ">$row[1]</option>\n";<br /> }<br /> mysqli_free_result ($r);<br /> } else {<br /> echo '<option>暂无区域,请添加一个新地区</option>';<br /> }<br /> mysqli_close($conn);<br /> ?><br /> </select><br /> </div><br /> </div><br /> <div class="control-group"><br /> <label class="control-label">套数</label><br /> <div class="controls"><br /> <input type="text" name="taoshu" class="add-in" value="" />套<br /> </div><br /> </div> <br /> <div class="control-group"><br /> <label class="control-label">面积</label><br /> <div class="controls"><br /> <input type="text" name="area" class="add-in" value="" />平方<br /> </div><br /> </div> <br /> <div class="form-actions"><br /> <button class="btn" name="submit" type="submit">提交</button><br /> </div> <br /> </form><br /> </div><br /></div><br /><?php<br />include ('inc/footer.php');<br />?>
报错提示
出错文件是 'D:\wamp\www\zhuzhai_add.php' 出错行号是 36: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given<div class="clear"> </div>

TheSecretTokeEpingAphp-PowerEdwebSiterUnningSmoothlyShyunderHeavyLoadInVolvOLVOLVOLDEVERSALKEYSTRATICES:1)emplactopCodeCachingWithOpcachingWithOpCacheToreCescriptexecution Time,2)使用atabasequercachingCachingCachingWithRedataBasEndataBaseLeSendataBaseLoad,3)

你應該關心DependencyInjection(DI),因為它能讓你的代碼更清晰、更易維護。 1)DI通過解耦類,使其更模塊化,2)提高了測試的便捷性和代碼的靈活性,3)使用DI容器可以管理複雜的依賴關係,但要注意性能影響和循環依賴問題,4)最佳實踐是依賴於抽象接口,實現鬆散耦合。

是的,優化papplicationispossibleandessential.1)empartcachingingcachingusedapcutorediucedsatabaseload.2)優化的atabaseswithexing,高效Quereteries,and ConconnectionPooling.3)EnhanceCodeWithBuilt-unctions,避免使用,避免使用ingglobalalairaiables,並避免使用

theKeyStrategiestosigantificallyBoostPhpaPplicationPerformenCeare:1)UseOpCodeCachingLikeLikeLikeLikeLikeCacheToreDuceExecutiontime,2)優化AtabaseInteractionswithPreparedStateTementStatementStatementAndProperIndexing,3)配置

aphpdepentioncontiveContainerIsatoolThatManagesClassDeptions,增強codemodocultion,可驗證性和Maintainability.itactsasaceCentralHubForeatingingIndections,因此reducingTightCightTightCoupOulplingIndeSingantInting。

選擇DependencyInjection(DI)用於大型應用,ServiceLocator適合小型項目或原型。 1)DI通過構造函數注入依賴,提高代碼的測試性和模塊化。 2)ServiceLocator通過中心註冊獲取服務,方便但可能導致代碼耦合度增加。

phpapplicationscanbeoptimizedForsPeedAndeffificeby:1)啟用cacheInphp.ini,2)使用preparedStatatementSwithPdoforDatabasequesies,3)3)替換loopswitharray_filtaray_filteraray_maparray_mapfordataprocrocessing,4)conformentnginxasaseproxy,5)

phpemailvalidation invoLvesthreesteps:1)格式化進行regulareXpressecthemailFormat; 2)dnsvalidationtoshethedomainhasavalidmxrecord; 3)


熱AI工具

Undresser.AI Undress
人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool
免費脫衣圖片

Clothoff.io
AI脫衣器

Video Face Swap
使用我們完全免費的人工智慧換臉工具,輕鬆在任何影片中換臉!

熱門文章

熱工具

禪工作室 13.0.1
強大的PHP整合開發環境

VSCode Windows 64位元 下載
微軟推出的免費、功能強大的一款IDE編輯器

PhpStorm Mac 版本
最新(2018.2.1 )專業的PHP整合開發工具

SAP NetWeaver Server Adapter for Eclipse
將Eclipse與SAP NetWeaver應用伺服器整合。

Safe Exam Browser
Safe Exam Browser是一個安全的瀏覽器環境,安全地進行線上考試。該軟體將任何電腦變成一個安全的工作站。它控制對任何實用工具的訪問,並防止學生使用未經授權的資源。