html代码:
<span>球场餐饮:<em>*</em></span>
<select class="form-select-sim" id="J_review-s1" name="t1" value="catering">
<option value="-1" >请选择</option>
<option value="0" >差(0)</option>
<option value="1" >一般(1)</option>
<option value="2" >好(2)</option>
<option value="3" >很好(3)</option>
<option value="4" >非常好(4)</option>
</select>
<span class="label label_required">球场环境:<em>*</em></span>
<select class="form-select-sim" id="J_review-s2" name="t2">
<option value="-1" >请选择</option>
<option value="0" >差(0)</option>
<option value="1" >一般(1)</option>
<option value="2" >好(2)</option>
<option value="3" >很好(3)</option>
<option value="4" >非常好(4)</option>
</select>
<span>球场服务:<em>*</em></span>
<select name="t3">
<option value="-1" >请选择</option>
<option value="0" >差(0)</option>
<option value="1" >一般(1)</option>
<option value="2" >好(2)</option>
<option value="3" >很好(3)</option>
<option value="4" >非常好(4)</option>
</select>
数据库sp
数据库表名:pre_portal_comment
对应字段:
catering:餐饮
environment:环境
serve:服务
<span>球场餐饮:<em>*</em></span>
<select class="form-select-sim" id="J_review-s1" name="t1" value="catering">
<option value="-1" >请选择</option>
<option value="0" >差(0)</option>
<option value="1" >一般(1)</option>
<option value="2" >好(2)</option>
<option value="3" >很好(3)</option>
<option value="4" >非常好(4)</option>
</select>
<span class="label label_required">球场环境:<em>*</em></span>
<select class="form-select-sim" id="J_review-s2" name="t2">
<option value="-1" >请选择</option>
<option value="0" >差(0)</option>
<option value="1" >一般(1)</option>
<option value="2" >好(2)</option>
<option value="3" >很好(3)</option>
<option value="4" >非常好(4)</option>
</select>
<span>球场服务:<em>*</em></span>
<select name="t3">
<option value="-1" >请选择</option>
<option value="0" >差(0)</option>
<option value="1" >一般(1)</option>
<option value="2" >好(2)</option>
<option value="3" >很好(3)</option>
<option value="4" >非常好(4)</option>
</select>
数据库sp
数据库表名:pre_portal_comment
对应字段:
catering:餐饮
environment:环境
serve:服务
$environment=daddslashes($_POST["t2"]);
$serve=daddslashes($_POST["t3"]);
得到数据后 再插入数据库就好了
INSERT INTO `sp`.`pre_portal_comment` (`catering` ,`environment`,`serve`)VALUES ('$catering','$environment','$serve');