I’m trying to put this in my input type “-” and example is 123-45 and I will get the error but if I use this 12345 no error showing.
currently using varchar(15) in my database to limit to 15 only ,if possible I don’t want to use longtext or text
if(empty($errors)){
$sql ="INSERT INTO property (full_name,tax_dec,title_lot, property_type, location,block_lot_no, imageType, imageData, status, status1, tax_payer_id)
VALUES (?,?,?,?,?,?,?,?,?,?,?)";
$query = $db->prepare($sql);
$query->bind_param("ssssssssssi",$_SESSION['fullname'],$_POST['tax_dec'],$_POST['title_lot'],$_POST['property_type'], $_POST['location'], $_POST['block_lot_no'], $imageProperties['mime'], $imgData, $status,$status1, $_SESSION['id']);
$query->execute();
$message = "Record Added";
header("refresh: 2; URL=property1.php");
}