Member Avatar for AntonyRayan 
Index.php
<html>
<head><title>Registration</title>
<script type="text/javascript">
function numbersonly(e,length){
var unicode=e.charCode? e.charCode : e.keyCode
var maxlength=length;
if (unicode!=8){ //if the key isn't the backspace key (which we should allow)
if (unicode<48||unicode>57) //if not a number
return false //disable key press
}
}
</script>
<script type="text/javascript">
function validation()
{
var a = document.form.phone.value;
if(a=="")
{
alert("Please Enter Your Phone Number");
document.form.phone.focus();
return false;
}
}
</script>
<script type="text/javascript">  
      var reg = /^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$/;  
      function PhoneValidation(phone)
      {  
        var OK = reg.exec(phone.value);  
        if (!OK)  
          window.alert("phone number isn't  valid");  
        else  
          window.alert("phone number is  valid");  
      }  
    </script>  
    <script language="javascript">

function checkEmail() {

    var email = document.getElementById('email');
    var filter = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{3})+$/;

    if (!filter.test(email.value)) {
    alert('Please provide a valid email address');
    email.focus;
    return false;
 }
}</script>
</head>
<body>
<div align="center">
<h3> Registration</h3>
<form name="register" action="save.php" enctype="multipart/form-data" onsubmit="return validation()" method="post">
<label>Name</label>
<label>:</label>
<input type="text" name="name" id="name" placeholder="Name" required/><br /><br />
<label>Email</label>
<label>:</label>
<input type="email" name="email" id="email" placeholder="Email" required/><br /><br />
<label>Password</label>
<label>:</label>
<input type="password" name="password" id="password" placeholder="Password" required/><br /><br />
<label>RepeatPassword</label>
<label>:</label>
<input type="password" name="repeatpassword" id="repeatpassword" placeholder="RepeatPassword" required/><br /><br />
<label>Date of Birth</label>
<label>:</label>
<select name="day" required>
<option value="">Day</option>
<?php for ($day = 1; $day <= 31; $day++) { ?>
<option value="<?php echo strlen($day)==1 ? '0'.$day : $day; ?>"><?php echo strlen($day)==1 ? '0'.$day : $day; ?></option>
<?php } ?>
</select>
<select name="month" required>
<option value="">Month</option>
<?php for ($month = 1; $month <= 12; $month++) { ?>
<option value="<?php echo strlen($month)==1 ? '0'.$month : $month; ?>"><?php echo strlen($month)==1 ? '0'.$month : $month; ?></option>
<?php } ?>
</select>
<select name="year" required>
<option value="">Year</option>
<?php for ($year = date('Y'); $year > date('Y')-100; $year--) { ?>
<option value="<?php echo $year; ?>"><?php echo $year; ?></option>
<?php } ?>
</select><br /><br />
<label>Phone</label>
<label>:</label>
<input type="text" name="phone" id="phone" placeholder="Phone No" maxlength="10" onKeyPress="return numbersonly(event)" onchange="PhoneValidation(this);"  required/><br /><br />

<input type="submit" name="submit" value="Register" onClick="return checkEmail()"/>
</form>
</div>
</body>
</html>

save.php:::

<?php
include('connect.php');
$name=$_POST['name'];
$email=$_POST['email'];
$password=$_POST['password'];
$repeatpassword=$_POST['repeatpassword'];
$phone=$_POST['phone'];
$date = $_POST['day'] . '/' . $_POST['month'] . '/' . $_POST['year'];

$sql=mysql_query("insert into  register(name,email,password,repeatpassword,phone,date)values('$name','$email','$password','$repeatpassword','$phone','$date')") or die(mysql_error());
echo "<script type='text/javascript'>alert('Data Inserted Successfully'); window.location.href='index.php';</script>";
?>

my question is, it inserts all the values in the database except date of birth, 
values are storing like :
id  username  email              password         repeatpassword     phone      date
7   akbar   akbarbai@gmail.com  baiakbar    baiakbar    2147483647  0000-00-00.
How to solve this...
I need:
    7  akbar  akbarbai@gmail.com  baiakbar baiakbar 2147483647  20/12/2015
Edited by AntonyRayan because: nil
  • 3 Contributors
  • 3 Replies
  • 231 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by AntonyRayan
Member Avatar for pritaeas

Date format for databases is usually yyyy-mm-dd

Member Avatar for mattster

prit is right about the format, because if MySQL has a "date" field, it wants it in yyyy-mm-dd and will reject anything else.

Also, why on earth are you storing
a) a password with no apparent hashing or encryption??? Major security problem.
b) the repeat password? You won't ever look at it after validation so what's the use in storing the same thing twice?

While I'm on security, you have no escaping, so you are vunerable to "SQL injection" - might be worth looking at that.

Finally to note, mysql_query() was deprecated as of PHP 5.5, so you really ought to at least look at PDO or mysqli.

Member Avatar for AntonyRayan

Thank you to all...

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.