Date Format From YYYY-MM-DD To DD-MM-YYYY

**rhodarose** · 05-03-2011, 09:14 AM

Good day!

I want to know if what should I do to change the format of Date FROM YYYY-MM-DD to DD-MM-YYYY using php and also what should i put in the database as date format.

Here is my code:

PHP Code:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Machine 1 Problem</title>

</head>

<body>

<form method="post" action="machine_1.php" name="machine1">

<?php

$db_host = 'localhost';

$db_user = 'root';

$db_name = 'db_machine1';



$query = mysql_connect("$db_host", "$db_user")or die (mysql_error());

$db = mysql_select_db("$db_name")or die (mysql_error());



$query = "SELECT * FROM tbl_machine1 ORDER BY Emp_ID ASC";

$result = mysql_query($query) or die(mysql_error());



echo "<table border='1'><tr>";

for($i = 0; $i < mysql_num_fields($result); $i++){

    //echo "<th>".mysql_field_name($result, $i)."</th>";

    echo "<th><a>.mysql_field_name($result, $i).""</a></th>";

}

echo "<th>Options</th>";

echo "</tr>";

while($row = mysql_fetch_array($result)){

    echo "<tr>";

    for($i = 0; $i < mysql_num_fields($result); $i++){

        echo "<td>". $row[$i] ."</td>";

    }

    echo "<td><a href = 'edit.php'>Edit</a> <a href = 'delete.php'>Delete</a></td>";

    echo "</tr>";

}



echo "</table>";

echo "<input type = 'button' name= 'add' value='ADD'>";



?>

</form>

</body>

</html>

Thank you

**bluewalrus** · 05-03-2011, 09:39 PM

This should work

PHP Code:


$date = "2011-05-03";

$date = substr($date, 8, 2) . '-' . substr($date, 5, 2) . '-' . substr($date, 0, 4);

There probably is a convert function in your SQL you can use as well. You can do this a number of other ways also...

**fastsol1** · 05-03-2011, 11:40 PM

Well you don't give us any date info to look at in your code but this will work, you just need to change the $sp_end to your var from the db. You can just use the normal date format in the db to store the date.

PHP Code:


$enddate = date_create("$sp_end");
        $the_end = date_format($enddate, 'm-d-Y');

**rhodarose** · 05-04-2011, 04:57 AM

Originally Posted by fastsol1

Well you don't give us any date info to look at in your code but this will work, you just need to change the $sp_end to your var from the db. You can just use the normal date format in the db to store the date.

PHP Code:


$enddate = date_create("$sp_end");
        $the_end = date_format($enddate, 'm-d-Y');

How can I insert that code in my php code I only want to use this on my bday field.

Here is my new code:

PHP Code:


<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Untitled Document</title>
<script type="text/JavaScript">
function confirmDelete(){
    var agree = confirm("Are you sure you want to delete this file?");
    if(agree){
        // direct browser to delete.php
        window.location = "./delete.php";
    } else {
        // do nothing and return false
        return false ;
    }
}
</script>
</head>
 <body>
 <form name="machine1" action="page3.php" method="post">
 <table border="1">
 <tr>
 <td>Emp ID</td>
 <td>Last Name</td>
 <td>First Name</td>
 <td>Birthday</td>
 <td>Option</td>
 </tr>
 
 <?php 
mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("db_machine1") or die(mysql_error()); 
 
 $data_p = mysql_query("SELECT * FROM tbl_machine1") or die(mysql_error());
while($info = mysql_fetch_array( $data_p ))
{
    $emp_id = $info['Emp_ID'];
    $lname = $info['Last_Name'];
    $fname = $info['First_Name'];
    $bday = $info['Birthday'];
    ?>
    <tr>
    <td><?php echo $emp_id;?> </td>
    <td><?php echo $lname;?> </td>
    <td><?php echo $fname;?> </td>
    <td><?php echo $bday;?> </td>
       <td><a href = 'edit.php'>Edit</a> <a href='delete.php?id=$emp_id' onClick='confirmDelete();'>Delete</a></td>
    </tr>
<?php
}
?>
</table>
<input type = 'button' name= 'add' value='ADD'>
 </body>
 </html>

Thank you

**fastsol1** · 05-04-2011, 11:55 AM

PHP Code:


<?php
$emp_id = $info['Emp_ID'];
    $lname = $info['Last_Name'];
    $fname = $info['First_Name'];
    $bday = $info['Birthday'];
$birth = date_create("$bday");
        $birthday = date_format($birth, 'm-d-Y');
?><tr>
    <td><?php echo $emp_id;?> </td>
    <td><?php echo $lname;?> </td>
    <td><?php echo $fname;?> </td>
    <td><?php echo $birthday;?> </td>

**rhodarose** · 05-04-2011, 01:10 PM

I tried this code:

PHP Code:


<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<script language="JavaScript">
    function CloseChildWindow()
    {
        window.opener.location.href="page3.php";
        self.close();
    }
</script>
</head>

<body>
<form method="post" action="add.php" name="add">
Last Name:&nbsp;<input type="text" name="Last_Name" id="Last_Name"><br/><br/>
First Name:&nbsp;<input type="text" name="First_Name" id="First_Name"><br/><br/>
Birthday:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="Birthday" id="Birthday"><br/><br/>
<input type="submit" name="save" value="SAVE" onClick="CloseChildWindow();">
<?php
//error_reporting(0);
$Lname = "";
$Fname= "";
$bday = ""; 


mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("db_machine1") or die(mysql_error()); 

if(isset($_POST['save'])){
$Lname=$_POST['Last_Name'];
$Fname=$_POST['First_Name'];
$bday=$_POST['Birthday'];



$date = date('Y-m-d', strtotime($bday));
//$query = "INSERT INTO tbl_machine1 (Last_Name, First_Name, Birthday) VALUES ('$Lname','$Fname','$bday')";
//$result=mysql_query($query);

$sql = mysql_query("INSERT INTO tbl_machine1 (Last_Name, First_Name, Birthday) 
VALUES('".$Lname."', '".$Fname."', '".$date."')");

}

?>
</form>
</body>
</html>

And when I insert 1990-05-25 as birthday it did not convert to 25-05-1990

Thank you

**Beverleyh** · 05-04-2011, 01:22 PM

Look slike you havent reformatted the date here;

PHP Code:


$date = date('Y-m-d', strtotime($bday));

**rhodarose** · 05-05-2011, 04:57 AM

How can I reformat it?I need to know it now maam..

Thank you so much

**Beverleyh** · 05-05-2011, 10:00 AM

You should just need to reverse the 'Y-m-d' part.

Other date format options can be found here: http://php.net/manual/en/function.time.php

**rhodarose** · 05-05-2011, 01:06 PM

Thank you

Thread: Date Format From YYYY-MM-DD To DD-MM-YYYY

Thread Tools

Search Thread

Date Format From YYYY-MM-DD To DD-MM-YYYY

Bookmarks

Bookmarks

Posting Permissions