I want to validate phone number its not workning.Please help!!
This is php code.
<?php error_reporting(E_ERROR|E_WARNING);
session_start();
$dblink = mysql_connect("localhost", "root", "") or die('Not able to connect to server : ' . mysql_error());
mysql_select_db("apperal",$dblink) or die('Not able to select Database : ' . mysql_error()); //hama ekakatama poduwe hadapu connection eka
if(isset($_POST['add'])){
$no=mysql_real_escape_string($_POST['txtno']);
$refer=mysql_real_escape_string($_POST['txtrefer']);
$amount=mysql_real_escape_string($_POST['txtamount']);
if(!preg_match("/^[0-9]{3}-[0-9]{3}-[0-9]{4}$/s", $state)) {
$errmsg = 'Please enter your valid phone number';
}
else
$state=mysql_real_escape_string($_POST['txtstate']);
$sql = "SELECT COUNT(*) AS Count FROM addnewbuyer WHERE styleno LIKE '".$no."'";
$result = mysql_fetch_array(mysql_query($sql));
if ($result['Count'] > 0) {
die('alredy exist');
}
else
{
$sql1="INSERT INTO `addnewbuyer` (`id`, `styleno`, `buyername`, `buyeraddress`, `phoneno`) VALUES (NULL, '$no', '$refer', '$amount', '$state');"; // database eke hr walata hadapu table eke query walata execute karala
$write=(mysql_query($sql1,$dblink));
if($write){
echo "<font color='blue'>Data Added Successfully";
//$_SESSION['msg']=$msg;
}
else{
$msg="<font color='red'>Data Adding Failed";
$_SESSION['msg']=$msg;
}
}
}
This is HTML form
<form id="form_322883" class="appnitro" method="post" action="chkbyr.php">
<div class="form_description">
<h2> Add New Buyer</h2>
</div>
<table width="102%">
<tr>
<td height="34"><label class="description" for="txtid" value="">BuyerID</label></td>
<td> <input id="txtid" name="txtid" class="hidden" type="BuyerID " value="" /></td></tr>
<tr>
<td height="40"><label class="description" for="txtno">Styleno </label></td>
<td><input id="txtno" name="txtno" type="styleno " value=""/></td></tr>
<tr>
<td height="40"><label class="description" for="txtrefer">BuyerName </label></td>
<td><input id="txtrefer" name="txtrefer" type="BuyerName " value=""/></td></tr>
<tr>
<td height="36"><label class="description" for="txtamount">BuyerAddress </label></td>
<td><input id="txtamount" name="txtamount" type="BuyerAddress" maxlength="" value=""/></td></tr>
<tr>
<td height="42">
<label class="description" for="txtstate">PhoneNo</label></td>
<td><input id="txtstate" name="txtstate" type="PhoneNo" value=""
/>
</td>
</tr>
<li class="buttons">
<tr>
<td> </td>
<td><input id="saveForm" class="button_text" type="submit" name="add" value="Add" /> <input type="submit"class="button_text" name="update" value="Update" />
<a href="http://localhost/Apperal/vieww.php">view</button></a>
<!-- <input type="submit" class="button_text" name="search" value="Search" />-->
<input type="submit" class="button_text" name="delete" value="Delete" />
</td>
<td> </td>
<td> </td>
<td> </td>
</table>
</form>
vindyauwu 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.