Home Backend Development PHP Tutorial mysqli_stmt_bind_param不能处理时间类型吗?解决思路

mysqli_stmt_bind_param不能处理时间类型吗?解决思路

Jun 13, 2016 pm 12:06 PM
class gt lt mysqli nbsp

mysqli_stmt_bind_param不能处理时间类型吗?
 报错的这条语句

mysqli_stmt_bind_param($stmt, 'idii', $c, $a, $t, $w);
Copy after login


完整代码
<?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 />?>
Copy after login



报错提示

出错文件是 'D:\wamp\www\zhuzhai_add.php' 出错行号是 36: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given<div class="clear">
                 
              
              
        
            </div>
Copy after login
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 Article

Hot Article

Hot Article Tags

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)

Solution: Your organization requires you to change your PIN Solution: Your organization requires you to change your PIN Oct 04, 2023 pm 05:45 PM

Solution: Your organization requires you to change your PIN

How to adjust window border settings on Windows 11: Change color and size How to adjust window border settings on Windows 11: Change color and size Sep 22, 2023 am 11:37 AM

How to adjust window border settings on Windows 11: Change color and size

How to enable or disable taskbar thumbnail previews on Windows 11 How to enable or disable taskbar thumbnail previews on Windows 11 Sep 15, 2023 pm 03:57 PM

How to enable or disable taskbar thumbnail previews on Windows 11

How to change title bar color on Windows 11? How to change title bar color on Windows 11? Sep 14, 2023 pm 03:33 PM

How to change title bar color on Windows 11?

OOBELANGUAGE Error Problems in Windows 11/10 Repair OOBELANGUAGE Error Problems in Windows 11/10 Repair Jul 16, 2023 pm 03:29 PM

OOBELANGUAGE Error Problems in Windows 11/10 Repair

What are the differences between Huawei GT3 Pro and GT4? What are the differences between Huawei GT3 Pro and GT4? Dec 29, 2023 pm 02:27 PM

What are the differences between Huawei GT3 Pro and GT4?

Display scaling guide on Windows 11 Display scaling guide on Windows 11 Sep 19, 2023 pm 06:45 PM

Display scaling guide on Windows 11

10 Ways to Adjust Brightness on Windows 11 10 Ways to Adjust Brightness on Windows 11 Dec 18, 2023 pm 02:21 PM

10 Ways to Adjust Brightness on Windows 11

See all articles