好吧,一个接一个地解决一些问题,现在我试图让我的下拉菜单数据提交。我不知道从哪里开始。
这是我的表格..这里有什么问题吗?:
<form action="form.php" method="POST">
<div class="row">
<div class="large-4 columns">
<span id="spryfirstname">
<input name="firstname" type="text" placeholder="First Name"/>
<span class="textfieldRequiredMsg">A value is required.</span></span></div>
<div class="large-4 columns">
<span id="sprylastname">
<input name="lastname" type="text" placeholder="Last Name"/>
<span class="textfieldRequiredMsg">A value is required.</span></span></div>
<div class="large-4 columns">
<div class="row collapse">
<div class="small-9 columns"><span id="spryemail">
<input name="email" type="text" placeholder="[email protected]"/>
<span class="textfieldRequiredMsg">A value is required.</span></span></div>
</div>
</div>
</div>
<div class="row">
<div class="large-12 columns">
<label>Check all Products that you're interested in</label>
<input name="products[]" type="checkbox" value="all">
ALL PRODUCTS/SERVICES
<input name="products[]" type="checkbox" vallue="trade">Trade-in
<input name="products[]" type="checkbox" value="layaway">Layaway products
<input name="products[]" type="checkbox" value="theatre">Home Theatre Systems
<input name="products[]" type="checkbox" value="TV">HD TVs
<input name="products[]" type="checkbox" value="Games">Video Game Consoles<br>
<input name="products[]" type="checkbox" value="laptops"> Laptops
<input name="products[]" type="checkbox" value="monitors"> Monitors
<input name="products[]" type="checkbox" value="phones"> Phones
<input name="products[]" type="checkbox" value="cameras"> Cameras
<input name="products[]" type="checkbox" value="acoustic"> Acoustic Guitars
<input name="products[]" type="checkbox" value="electric"> Electric Guitars
<input name="products[]" type="checkbox" value="drums"> Drums
<input name="products[]" type="checkbox" value="wind"> Wind Instruments <br>
<input name="products[]" type="checkbox" value="pianos"> Pianos
<input name="products[]" type="checkbox" value="violins"> Violins
<input name="products[]" type="checkbox" value="diamonds"> Diamonds
<input name="products[]" type="checkbox" value="neck"> Necklaces
<input name="products[]" type="checkbox" value="rings"> Rings
<input name="products[]" type="checkbox" value="ear"> Ear Rings
<input name="products[]" type="checkbox" value="gold"> Gold Jewelry
<input name="products[]" type="checkbox" value="silver"> Silver Jewelry
<hr>
</div>
</div>
<div class="row">
<div class="large-12 columns">
<label>How often would you like to have product updates? <select>
<option value="daily" name="Updates">Daily</option>
<option value="weekly" name="Updates">Weekly</option>
<option value="monthly" name="Updates">Monthly</option>
</select>
</label>
</div>
</div>
<div class="row">
<div class="large-12 columns">
<label>Tell us a little about yourself <textarea placeholder="Type here">
</textarea>
</label>
</div>
</div>
<div class="row">
<input class="button small large-3" type="submit" name="submit" />
</div>
</form>
这是我与数据库/ php的连接:
<?php
if(isset($_POST['submit'])){
$con = mysqli_connect("localhost","dxh6110","tcqfoz7","dxh6110")
or die("Error " . mysqli_error($con));
$first = stripslashes($_POST['firstname']);
$last = stripslashes($_POST['lastname']);
$email = stripslashes($_POST['email']);
$checkbox = stripslashes($_POST['products']);
$first = mysqli_real_escape_string($con,$_POST['firstname']);
$last = mysqli_real_escape_string($con,$_POST['lastname']);
$email = mysqli_real_escape_string($con,$_POST['email']);
$checkbox = mysqli_real_escape_string($con,$_POST['products']);
$checkbox = implode(',', $_POST['products']);
$sql = "INSERT INTO Register (Firstname,Lastname,Email,Product)
VALUES('".$firstname."','".$lastname."','".$email."','".$checkbox."')";
}
mysqli_query($con,$sql);
mysqli_close($con);
?>
好吧,部分问题是,每次您访问该页面时,它将添加另一行。无论是否提交,都请添加以下内容:
if(isset($_POST['Submit'])){
}
只需将所有php包裹起来,然后转到^。^,所以继续删除它得到的所有空白行,然后重试。这样,您可以对其进行更好的调试。
因此,这说明了您遇到的空白行问题。;)3个中没有什么?
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句