Breaking News: Grepper is joining You.com. Read the official announcement!

insert date of birth on the database using php

Prickly Plover answered on March 16, 2022 Popularity 8/10 Helpfulness 5/10

answer insert date of birth on the database using php

related how to insert date in mysql using php

insert date of birth on the database using php

Comment

<!DOCTYPE html>
<html>
<head>
   <title></title>
</head>
<body>
<form method="POST" action="">
<select name="Year">
  <option value="">Select year</option>
  <?php for ($i = 1980; $i < date('Y'); $i++) : ?>
  <option value="<?php echo $i; ?>"><?php echo $i; ?></option>
  <?php endfor; ?>
</select>
<select name="Month">
  <option value="">Select month</option>
  <?php for ($i = 1; $i <= 12; $i++) : ?>
  <option value="<?php echo ($i < 10) ? '0'.$i : $i; ?>"><?php echo $i; ?></option>
  <?php endfor; ?>
</select>
<select name="Date">
  <option value="">Select date</option>
  <?php for ($i = 1; $i <= 31; $i++) : ?>
  <option value="<?php echo ($i < 10) ? '0'.$i : $i; ?>"><?php echo $i; ?></option>
  <?php endfor; ?>
</select>
   <input type="submit" name="sub">
</form>
</body>
</html>
<?php
$conn = mysqli_connect("localhost","root","","getdob");
if(isset($_POST['sub']))
{
$Year = $_POST['Year'];
$Month = $_POST['Month'];
$Date = $_POST['Date'];
if ($Year != '' && $Month != '' && $Date != '') 
   {
   $date = $Year.'-'.$Month.'-'.$Date;
   $sql="INSERT INTO dob VALUES  (Null,'$date')";
   if (mysqli_query($conn,$sql))
   {
      echo "Record added!";
   }
   else
   {
      echo "Error!!!";
   }
   }
else
   {
      echo "Please Select Day, Month and Year!!!";
   }   
}
?>

Popularity 8/10 Helpfulness 5/10 Language php

Source: t4tutorials.com

Tags: database date insert php using

Link to this answer
Share Copy Link

Contributed on Mar 16 2022

Prickly Plover

0 Answers Avg Quality 2/10

Closely Related Answers

how to insert date in mysql using php

Comment

$sample1 = "insert into table (id,date) value(1,'".date("Y-m-d H:i:s")."')";

$sample2 = "insert into user (name,date,created_by) value('perasuah negara', now(), 1)"

Popularity 9/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: date

Link to this answer
Share Copy Link

Contributed on Sep 21 2022

malaya pening sila

0 Answers Avg Quality 2/10

insert date of birth on the database using php

Contents

More Related Answers

insert date of birth on the database using php

Closely Related Answers

how to insert date in mysql using php

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.