我想验证并且用户只在文本字段中输入浮点数,例如 libraryForm .php p>
p>
savelibscores.php p>
3.4 代码>。 在这种情况下,我需要使用
php code>检查
$ value1 code>和
$ value2 code>。 p>
< form action =“savelibscores.php”method =“POST”>
S3:< input class =“inputfield”type =“text”name =“s3”size =“5”> < br />< br />
S4:< input class =“inputfield”type =“text”name =“s4”size =“5”> < br />< br />
< b>年:< b />
< select name =“year”>
< option value =“选择”>请选择..< / option>
< option value =“2005”> 2005< / option>
< option value =“2006”> 2006< / option>
< option value =“2007”> 2007< / option>
< option value =“2008”> 2008< / option>
< ; option value =“2010”> 2010< / option>
< option value =“2011”> 2011< / option>
< option value =“2012”> 2012< / option>< / select&gt ;< br />< br />
< br />
< input type =“submit”value =“保存”name =“submit”>
< input type =“ 重置“name =”reset“value =”清除“>< br />< br />
< / form>
code> pre>
<?php
define('DB_NAME','');
define('DB_USER','');
define('DB_PASSWORD','');
define('DB_HOST','localhost');
$ connect = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if(!$ connect){
die('无法连接:'。mysql_error());
}
$ db_selected = mysql_select_db(DB_NAME,$ connect);
if if(!$ db_selected){
die(' 不能使用'.DB_NAME。':'。mysql_error());
}
if(isset($ _ POST ['submit'])){
$ value1 = $ _ POST ['s3' ];
$ value2 = $ _ POST ['s4'];
$ value3 = $ _ POST ['year'];
if(!empty($ value1)&& !empty($ value2)&& !empty($ value3)){
$ sql = mysql_query(“INSERT INTO` library`(s3,s4,year)VALUES('”。$ value1。“','”。$ value2。“','” 。$ value3。“')”)或死(mysql_error());
}
其他{
echo“请填写所有字段。”;
}
}
?>
< / code> pre>
div>
I want to validate and that the user only enters float number in the text field such as 3.4
. I need to check only the $value1
and $value2
in this case using php
.
libraryForm.php
<form action="savelibscores.php" method="POST">
S3: <input class="inputfield" type="text" name="s3" size="5"> <br /><br/>
S4: <input class="inputfield" type="text" name="s4" size="5"> <br /><br/>
<b>Year:<b/>
<select name="year">
<option value="Choose">Please select..</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option></select><br/><br/>
<br/>
<input type="submit" value="Save" name="submit">
<input type="reset" name="reset" value="Clear"><br /><br/>
</form>
savelibscores.php
<?php
define('DB_NAME','');
define('DB_USER','');
define('DB_PASSWORD','');
define('DB_HOST','localhost');
$connect = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if(!$connect){
die('Could not connect:'.mysql_error());
}
$db_selected=mysql_select_db(DB_NAME,$connect);
if(!$db_selected){
die('Can\'t use'.DB_NAME.':'.mysql_error());
}
if(isset($_POST['submit'])){
$value1=$_POST['s3'];
$value2=$_POST['s4'];
$value3=$_POST['year'];
if(!empty($value1) && !empty($value2) && !empty($value3)){
$sql=mysql_query("INSERT INTO `library`(s3,s4,year) VALUES ('".$value1."','".$value2."','".$value3."')")or die(mysql_error());
}
else{
echo "Please fill all the fields.";
}
}
?>