this php file insert data database.
need validate if entered pmob_number less 10 digits, before storing database.
<?php $servername = "localhost"; $username = "root"; $password = ""; $conn = mysqli_connect ($servername , $username , $password) or die("unable connect host"); $sql = mysqli_select_db ($conn,'vcet') or die("unable connect database"); //code insert db... $user_name=$_post['user_name']; $roll_number=$_post['roll_number']; $user_batch=$_post['user_batch']; $user_from=$_post['user_from']; $user_year=$_post['user_year']; $user_level=$_post['user_level']; $f_name=$_post['f_name']; $m_name=$_post['m_name']; $g_name=$_post['g_name']; $mob_number=$_post['mob_number']; $addressline1=$_post['addressline1']; $addressline2=$_post['addressline2']; $city=$_post['city']; $pmob_number=$_post['pmob_number']; $msg=""; $number_valid=$_post['pmob_number']; if(strlen($number_valid)!=10){ $msg='<span class="error">the number enteres not 10 digit long</span>'; }else { echo"valid"; } $land_number=$_post['land_number']; $cutoff=$_post['cutoff']; $dept=$_post['dept']; $medium = $_post['medium']; $locality=$_post['locality']; $intrest=$_post['intrest']; $scholar=$_post['scholar']; $income=$_post['income']; $user_caste=$_post['user_caste']; $user_admit=$_post['user_admit']; $user_stay=$_post['user_stay']; $user_info = "insert studentinfo"." (user_name,roll_number,user_batch,user_from,user_year,user_level,f_name,m_name,g _name,mob_number,addressline1,addressline2,city,pmob_number,land_number,cutoff,d ept,medium,locality,intrest,scholar,income,user_caste,user_admit, user_stay)". "values ('$user_name', '$roll_number','$user_batch','$user_from','$user_year','$user_level','$f_name','$m_name','$g_name','$mob_number','$addressline1','$addressline2','$city','$pmob_number','$land_number','$cutoff','$dept','$medium','$locality','$intrest','$scholar','$income','$user_caste','$user_admit','$user_stay')"; if (!mysqli_query($conn,$user_info)) { die('error: ' . mysqli_error($conn)); } echo "your information added database."; mysqli_close($conn); ?>
you can use strlen() server-side validation
edit: must trick
$num_length = strlen((string)$pmob_number); if($num_length == 10) { $user_info = "insert studentinfo"." (user_name,roll_number,user_batch,user_from,user_year,user_level,f_name,m_name,g _name,mob_number,addressline1,addressline2,city,pmob_number,land_number,cutoff,d ept,medium,locality,intrest,scholar,income,user_caste,user_admit, user_stay)". "values ('$user_name', '$roll_number','$user_batch','$user_from','$user_year','$user_level','$f_name','$m_name','$g_name','$mob_number','$addressline1','$addressline2','$city','$pmob_number','$land_number','$cutoff','$dept','$medium','$locality','$intrest','$scholar','$income','$user_caste','$user_admit','$user_stay')"; if (!mysqli_query($conn,$user_info)) { die('error: ' . mysqli_error($conn)); } echo "your information added database."; mysqli_close($conn); } else { $msg='<span class="error">the number enteres not 10 digit long</span>'; } 
Comments
Post a Comment