解决方案 »
- 小弟最近对php有很大的兴趣了。
- 【新手求助】插表问题
- 100分 求 php 下拉框二级联动
- 分享IIS下安装php533的体验
- PHP中怎么查看oracle的版本信息
- 求救 oralce 的荐储过程如何写?unix 下
- 請大家幫忙看看.為什么這段代碼不能下載多個文件?
- 问题五:php4的几个问题:
- My SQL中 Inner Join 怎么用,为什么我的老是出错,而Left Join就可以。
- 问问darkwing老兄,在php里如何重定向url
- 请问PHP怎么下载远程服务器上的文件到本地服务器上?
- 程序写在本机上,数据库在公司里的另外一台电脑上(sqlserver2008),本机上不装任何数据库软件的话,程序能不能连接上数据库
<div class="portlet-title">土地数据添加</div>
<div class="portlet-body">
<form action="tudi_add.php" method="post">
<div class="control-group">
<label class="control-label">地块编号</label>
<div class="controls">
<input type="text" name="tudi_id" class="add-in" value="" />例子:DAEJ2014054
</div>
</div>
<div class="control-group">
<label class="control-label">区域</label>
<div class="controls">
<select name="city" class="select-city">
<?php
$q = "SELECT city_id, city_name FROM f_city ORDER BY city_id ASC";
$r = mysqli_query ($conn, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($conn));
if (@mysqli_num_rows($r) > 0) {
while ($row = mysqli_fetch_array ($r, MYSQLI_NUM)) {
echo "<option value=\"$row[0]\"";
if (isset($trimmed['city']) && ($trimmed['city'] == $row[0]) ) echo ' selected="selected"';
echo ">$row[1]</option>\n";
}
mysqli_free_result ($r);
} else {
echo '<option>暂无区域,请添加一个新地区</option>';
}
mysqli_close($conn);
?>
</select>
</div>
</div>
<div class="control-group">
<label class="control-label">地块位置</label>
<div class="controls">
<input type="text" name="weizhi" class="add-in w600" value="" />
</div>
</div>
<div class="control-group">
<label class="control-label">土地用途</label>
<div class="controls">
<input type="text" name="yongtu" class="add-in" value="" />例子:商业、商务、娱乐康体、居住用地
</div>
</div>
<div class="control-group">
<label class="control-label">容积率(FAR)</label>
<div class="controls">
<input type="text" name="rongjilv" class="add-in" value="" />例子:1.0<FAR≤2.273
</div>
</div>
<div class="control-group">
<label class="control-label">建筑密度(D)</label>
<div class="controls">
<input type="text" name="midu" class="add-in" value="" />例子:D≤30.46%
</div>
</div>
<div class="control-group">
<label class="control-label">绿地率(GAR)</label>
<div class="controls">
<input type="text" name="lvdi" class="add-in" value="" />例子:GAR≥30%
</div>
</div>
<div class="control-group">
<label class="control-label">发布日期</label>
<div class="controls">
<input type="text" name="fabu_time" class="add-in" onClick="WdatePicker()" value="" />时间格式例如:2014-12-12
</div>
</div>
<div class="control-group">
<label class="control-label">成交日期</label>
<div class="controls">
<input type="text" name="chengjiao_time" class="add-in" onClick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})" value="" />时间格式例如:2014-12-12 10:00:00
</div>
</div>
<div class="control-group">
<label class="control-label">保证金截止时间</label>
<div class="controls">
<input type="text" name="jiezhi_time" class="add-in" onClick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})" value="" />时间格式例如:2014-12-12 15:00:00
</div>
</div>
<div class="control-group">
<label class="control-label">竞买保证金(万元)</label>
<div class="controls">
<input type="text" name="baozhengjin" class="add-in" value="" />直接填写数字,不要带上单位
</div>
</div>
<div class="control-group">
<label class="control-label">占地面积(亩)</label>
<div class="controls">
<input type="text" name="mianji_m" class="add-in" value="" />直接填写数字,不要带上单位
</div>
</div>
<div class="control-group">
<label class="control-label">占地面积(㎡)</label>
<div class="controls">
<input type="text" name="mianji_p" class="add-in" value="" />直接填写数字,不要带上单位
</div>
</div>
<div class="control-group">
<label class="control-label">规划建筑面积(㎡)</label>
<div class="controls">
<input type="text" name="guihua_p" class="add-in" value="" />直接填写数字,不要带上单位
</div>
</div>
<div class="control-group">
<label class="control-label">起拍价(万/亩)</label>
<div class="controls">
<input type="text" name="qipaijia" class="add-in" value="" />直接填写数字,不要带上单位
</div>
</div>
<div class="control-group">
<label class="control-label">成交单价(万/亩)</label>
<div class="controls">
<input type="text" name="chengjiaodanjia" class="add-in" value="" />直接填写数字,不要带上单位
</div>
</div>
<div class="control-group">
<label class="control-label">成交总地价(万元)</label>
<div class="controls">
<input type="text" name="chengjiazongjia" class="add-in" value="" />直接填写数字,不要带上单位
</div>
</div>
<div class="control-group">
<label class="control-label">楼面地价</label>
<div class="controls">
<input type="text" name="loumiandijia" class="add-in" value="" />直接填写数字,不要带上单位
</div>
</div>
<div class="control-group">
<label class="control-label">溢价率</label>
<div class="controls">
<input type="text" name="yijialv" class="add-in" value="" />百分比数字
</div>
</div>
<div class="control-group">
<label class="control-label">竞得人</label>
<div class="controls">
<input type="text" name="jingderen" class="add-in w600" value="" />
</div>
</div>
<div class="control-group">
<label class="control-label">起始价(万元)</label>
<div class="controls">
<input type="text" name="churang_p" class="add-in" value="" />直接填写数字,不要带上单位
</div>
</div>
<div class="control-group">
<label class="control-label">地图位置</label>
<div class="controls">
<input type="text" name="dituweizhi" id="dituweizhi" readonly="readonly" class="add-in w600" /> <a href="javascript:;" id="up">上传</a>
</div>
</div>
<div class="control-group">
<label class="control-label">出让须知</label>
<div class="controls">
<textarea name="xuzhi" cols="150" rows="10" class="add-in"></textarea>
</div>
</div>
<div class="control-group">
<label class="control-label">交易是否成功</label>
<div class="controls">
<select name="is_cheng" class="select-city">
<option value="0">暂未交易</option>
<option value="1">成功交易</option>
<option value="2">流拍</option>
</select>
</div>
</div>
<div class="form-actions">
<button class="btn" name="submit" type="submit">提交</button>
</div>
</form>
</div>
</div>
$loumiandijia = (!empty($trimmed['loumiandijia'])) ? mysqli_real_escape_string ($conn, (float) $trimmed['loumiandijia']) : NULL;改为
$loumiandijia = (!empty($trimmed['loumiandijia'])) ? mysqli_real_escape_string ($conn, (float) $trimmed['loumiandijia']) : ‘’;
试试
你看下表但是我换了一个写法就可以写入数据库,这是怎么回事?
if (empty($errors)) {
$q = "INSERT INTO f_tudi (tudi_id, city_id, weizhi, yongtu, rongjilv, midu, lvdi, fabu_time, chengjiao_time, jiezhi_time, baozhengjin, mianji_m, mianji_p, guihua_p, qipaijia, chengjiaodanjia, chengjiazongjia, loumiandijia, yijialv, jingderen, churang_p, dituweizhi, xuzhi, is_cheng) VALUES ('$tudi_id', '$city', '$weizhi', '$yongtu', '$rongjilv', '$midu', '$lvdi', '$fabu_time', '$chengjiao_time', '$jiezhi_time', '$baozhengjin', '$mianji_m', '$mianji_p', '$guihua_p', '$qipaijia', '$chengjiaodanjia', '$chengjiazongjia', '$loumiandijia', '$yijialv', '$jingderen', '$churang_p', '$dituweizhi', '$xuzhi', '$is_cheng')";
$r = mysqli_query ($conn, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($conn));
if (mysqli_affected_rows($conn) == 1) {
echo '这条数据已经添加成功';
$_POST = array();
} else {
echo '<p style="font-weight: bold; color: #C00">程序发生错误,请重新添加</p>';
}
}还有一个问题是我写入数据库后为空的值不少NULL而是里面是什么都没有,空的,这个和我看教程的不一样,教程里面空的值就是一个NULL,这是怎么回事?