PHP - Displaying A Date From A Registered Field

Ok, i can't understand whats wrong with the DATE field in MySQL and PHP. I have a form in PHP witch has 3 birth day dropdown menus that looks like this (YYYY-MM-DD). An in my database i have a birth_day colum with DATE as type and i've tried to set the default value to "None" and "0000-00-00" but nothing works. Everytime i try to input something (e.g. 1993-16-05) i get this error:

Incorrect date value: '05' for column 'birth_day' at row 1

I've tried to set the value for the "Day" dropdown in the PHP form to both 5 and 05 but still nothing, what am i doing wrong?

I have such a little code. If I echo $order_date, I receive normal date in YYYY-MM-DD format. But when I use $order_date in mysql query it is not showing me anything. I do not receive any error or warning also.

Please help me.

$query = "SELECT Product,Amount FROM orders WHERE Date='$order_date'";
$result = mysql_query($query) or die(mysql_error());

while($products_list = mysql_fetch_array($result)) {
  echo "<tr>";
    echo "<td>" . $products_list["Product"] . "</td>";
    echo "<td>" . $products_list["Amount"] . "</td>";
  echo "</tr>";
}

I was wondering if someone could help me out with calculating and displaing dates. Below i posted html of my page and also php for it. It has a field called "DATE1" thats where visitors input the date, after that it gets posted to db and i pull it and disply it in a grid on my site. I would also like to have a column that shows time elapsed between the "DATE1" and current date.

I sorta figured how to calculate the dates using the php, but really stuck on how do i actually display it now. from what i been told so far i shouldn't create a new column for that, instead calculate and display the values on the fly, could some step me through this please, or get me started... thanks so much!

my html
Code: [Select]
<form id="signupForm" method="POST" action="processform.php">
  <div>
    <fieldset>
      <legend>Signup Form</legend>
      <label for="Country">*Country:</label>
      <select name="Country">
      <option value="">-----</option>
      <option value="Canada">Canada</option>
      <option value="UK">UK</option>
      <option value="France">France</option></select></div></p>

      <p><label for="Nationality">*Nationality:</label>
      <div><select name="Nationality">
      <option value="">-----</option>
      <option value="Afghanistan">Afghanistan</option>
      <option value="Albania">Albania</option>
      <option value="Algeria">Algeria</option></select></div></p>

      <p><label for="Province">*Province:</label>
      <div><select name="Province">
      <option value="">-----</option>
      <option value="British Columbia">British Columbia</option>
      <option value="Alberta">Alberta</option>
      <option value="Saskatchewan">Saskatchewan</option></select></div></p>
     
      <p><label for="DATE1">*Date:</label>
      <div><select name="day" id="Date1" class="regularfont"><option value="" selected="selected"></option>
      <option value="1">01</option>
      <option value="2">02</option>
      <option value="3">03</option></select>

      <select name="month" id="Date2" class="regularfont"><option value="" selected="selected"></option>
      <option value="1">January</option>
      <option value="2">February</option>
      <option value="3">March</option></select>

      <select name="year" id="Date3" class="regularfont"><option value="" selected="selected"></option>
      <option value="2014">2014</option>
      <option value="2013">2013</option>
      <option value="2012">2012</option></select>
    </fieldset>
  </div>
  <p>
    <div align="center"><input type="submit" name="submit" value="Submit your entry"></div>
  </p>
</form>
<p>

Code: [Select]
<?PHP
$hostname = "localhost";
$db_user = "";
$db_password = "";
$database = "";
$db_table = "";
$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);
//here i use this to calculate the date but really unsure how to further display the results
Code: [Select]
if (isset($_REQUEST['submit'])) {
    // Get current time, or input time like in $date2
    $date1 = time();

    // Get the timestamp of DATE1
    $date2 = mktime(0,0,0,date($_POST['month']),date($_POST['day']),date($_POST['year']));

$dateDiff = $date1 - $date2;
    $TotalTime = floor($dateDiff/(60*60*24));
    echo "$TotalTime";
}

for posting to db
Code: [Select]
  if(isSet($_POST['submit'])) {
    $country     = mysql_real_escape_string($_POST['Country']);
    $nationality = mysql_real_escape_string($_POST['Nationality']);
    $province    = mysql_real_escape_string($_POST['Province']);
    $date        = $_POST['day'].'-'.$_POST['month'].'-'.$_POST['year'];

    $myQuery = "INSERT INTO {$db_table} (`Country`,`Nationality`,`Province`,`DATE1`) VALUES ('{$country}','{$nationality}','{$province}','{$date}')");

    if(mysql_query($myQuery)) {
      echo 'Record inserted.';
    } else {
      echo 'An error has occurred: '.mysql_error();
    }

  }
?>

Hi, im trying to calculate and display a time elapsed from known date in db. however im having trouble displaying it. other values display no problem, just cant calculate and display date on the fly. does anyone see a problem with my query? thank you.

Code: [Select]
<?php
include('config.php');
$uname=$_SESSION['username'];
if($_SESSION['username']){
$sql="SELECT country, nationality, passportDate FROM country WHERE uname='$uname'";
$result = mysql_query($sql) or die(mysql_error());
$passportDate _ts = strtotime($row['passportDate ']);
$passportDate _str = date("M-d-Y", $passportDate _ts);
$TotalTime = floor((time() - $passportDate _ts)/(60*60*24)) . ' days'; 

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

 echo "<table border='0'>
  <tr>
  <th>Nationality</font></th>
  <th>Country</font></th>
  <th>Passport Seent Date</font></th>
  <th>Time Elapsed</font></th>
  </tr>";

  echo "<tr>";
  echo "<td>" . $row['nationality']."</td>";
  echo "<td>" . $row['country'] . "</td>";
  echo "<td>" . $row['passportDate '] . "</td>";
  echo "<td>" . ('$TotalTime') . "</td>"; 
  echo "</tr>";
  }
  echo "</table>"; 
  }
?>

Hi People. 

I am building a logbook application and have a form field where the user will enter a date.

However, I would like to simplify it for the user and give them a button which would add "todays" date into the box for them.

Please could someone tell me the code to do so.  The date format in my DB is YYYY-MM-DD.

The form would also need to take input from the user if they were adding info from a different day instead of today.

Thanks in advance.
Code: [Select]
<input type="text" name="date" id="date" size = "25"/>
    </label>
     <input type="submit" name="today" id="today" value="Add Today" />

I am writing code in the ZEND framework and i need to get the current day in like 2012-02-03:
In the controller:
Code: [Select]
$time=date('YYYY-mm-dd',time());
$this->view->time=$time;In view:

Code: [Select]
<?php echo $this->time; ?>
Output:
2012201220122012-0202-0303

I dont know why it is displaying like that instead of once...there is no loop anywhere.

Hi, everyone. I am trying to put together a WordPress for a client and although I hate asking for help - I am at a total standstill! She wants date tabs on the left of each post (on the main homepage and then each post; NOT pages- obviously, since those aren't 'dated', per say...).

Here is the function.php code I am using:
Code: [Select]

// custom date tab - creates two divs
// first div pulls in a background png image named by date
// and adds year dynamically. Placed via css to left of post as
// a hanging tab.

remove_action('genesis_before_post_content', 'genesis_post_info');
add_action('genesis_before_post_content', 'family_tree_post_info');
function family_tree_post_info() {
    if(is_page()) return; // don't do post-info on pages
echo '<div class="post-date-wrap">';
echo '<div class="post-date post-date-background" style="background:url(';
echo CHILD_URL;;
echo '/images/date';
echo the_time('F');
echo '/';
echo the_time('M');
echo '.png) no-repeat 4px -3px">';
echo the_time('Y');
echo '</div>';
echo '</div>';
echo '<div class="post-info">';
        genesis_post_comments_link(__('Leave a Comment', 'child'), __('1 Comment', 'child'), __('% Comments', 'child'));
        edit_post_link(__('(Edit)', 'child'), '', ''); // if logged in
    echo '</div>';
} 

This shouldn't matter [much] - but here is the style.css for the post-dat:

Code: [Select]

.post-date-wrap {
width: 65px;
height: 73px;
}

.content-sidebar .post-date-wrap {
float: left;
margin-top: -42px;
margin-left: -107px;
background: url(images/dates/bgd-left.png) no-repeat top left;
}

.content-sidebar-sidebar .post-date-wrap {
float: left;
margin-top: -42px;
margin-left: -84px;
background: url(images/dates/bgd-left.png) no-repeat top left;
}

.full-width-content .post-date-wrap {
float: left;
margin-top: -42px;
margin-left: -89px;
background: url(images/dates/bgd-left.png) no-repeat top left;
}

.sidebar-content .post-date-wrap {
width: 65px;
height: 73px;
float: right;
margin-top: -42px;
margin-right: -89px;
background: url(images/dates/bgd-right.png) no-repeat top left;
}

.sidebar-sidebar-content .post-date-wrap {
width: 65px;
height: 73px;
float: right;
margin-top: -42px;
margin-right: -86px;
background: url(images/dates/bgd-right.png) no-repeat top left;
}

.sidebar-content-sidebar .post-date-wrap, .sidebar-content-sidebar .post-date {
visibility: collapse;
height: 0;
width: 0;
}

.post-date {
width: 62px;
height: 17px;
display: inline;
text-align: center;
color: #4e260d;
padding: 50px 0 0 5px;
font-size: 9px;
}

.content-sidebar .post-date, .content-sidebar-sidebar .post-date, .full-width-content .post-date {
float: left;
}

.sidebar-content .post-date, .sidebar-sidebar-content .post-date {
float: right;
}

Here are two pictures:
* I have one of these for every day; for each month - found in images/dates - thereafter organized by months (in written out for October, November; then 1.png; 2.png, etc. for each DAY of the month)



This is how it is coming up right now; only the year (that really small lettering that says 2011):

I need the images with the month & date to appear inside of that box/tab. I have been working on this for too long and cannot get it to go. My 'thing' is design, so I really hope you can all help me! I just can't get PHP down.. I am sure it is something so ridiculous that I cannot see.

Thanks for your help!!

- Nicole

Hi all,   I have a search page where I'd like members to be able to search for races that they and their friends have entered into a database. When entering the data, users put the race date into the race_date field (Which is a DATETIME field) in the table.   I've set up the search and display pages, so users can search by a number of other criteria (first name, last name, race distance, time, etc), but am having trouble with searching by year. On my search form, is a field called race_year.   So, obviously I need some change in the code below, specifically in relation to the line $where .= " AND race_date='$race_year'"; because I want to extract the year part of the race_date column from the table and see if it matches $race_year .   Any advice would be appreciated.   Cheers, Dave  

$race_year = $_POST['race_year'];
if ($race_year != '')
{ // A year is selected
  $where .= " AND race_date='$race_year'";
}

Here is one part of php code. Here I try to show in last 1 month which dates exactly user made orders. When I run the SQL code in command prompt it works. I think problem is in while loop.

Thanks beforhand for contribution.


$query = "SELECT Date FROM orders WHERE User='$username' and DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= Date;";
$result = mysql_query($query,$link_id) or die (mysql_error());

echo "<table border='1'>
        <tr>
          <td>&nbsp;Last 1 month's orders:</td>
        </tr>";
   
      while($order_date = mysql_fetch_row($result)) {
        echo "<tr>";
          echo "<td>" . $order_date[0] . "</td>";
        echo "</tr>";
      }
     
      echo "</table>

Hi, I need to add a function for a date field on a form being submitted to MySQL DB. Something similar to this for a website field, except it shoudl make sure the format is in 01/05/2010 or 2numbers/2 numbers/4 numbers format...


if(!mb_eregi("^[a-zA-Z0-9-#_.+!*'(),/&:;=?@]*$", $website))
$this->setError('website', 'invalid website');
elseif(mb_strlen(trim($website)) > 120)
$this->setError('website', 'too long! 120 characters');


thanks in advance for any assistance.

hi i have a mysql table with upddate and updtime field as follows:
upddate       updtime
2011-02-25  11:03:05
2011-01-28  08:01:09
2011-02-20  07:00:08
2011-02-15  06:10:02
2011-02-05  10:21:04
2011-02-09  10:20:25

the data types for upddate is mysql date and for updtime its mysql time

In my php page i use Code: [Select]
<?php echo $date = date("d M Y",strtotime($row_rs1['upddate'])); ?> to retrieve date and the results displays as 25 Feb 2011. And for time right now im using Code: [Select]
<?php echo $row_rs1['updtime']; ?> which displays time as 11:03:05

I want to display time as HH:MM only, how can i do it?

Hi.  I have wrote a simple login script.  Works perfectly.  Now as my users can only register one email address at the minute if you register two the same you get the default sql error pop up.  I want my own error so at the beginning of my script i wrote the following code. however.  It does not seem to be running.  It does not create an error but still allows duplicate emails in the database.  can anyone see the error of my ways?
<?php session_start();
if(isset($_POST['create'])){    
 //script for checking if the email account already exists
$qCheckEmail = "SELECT * FROM members WHERE email='".$_POST['email']."'";
$rCheckEmail = mysql_query($qCheckEmail);
$Email = mysql_fetch_array($rCheckEmail);
 
 if($_POST['email'] == $Email['email']) 
 {$emailDup = "This email account has already been registered";}
 else
 { 
//Process data for validation    
$forename =  trim($_POST['forename']);    
$surname =  trim($_POST['surname']);    
$email      =  trim($_POST['email']);        
$password   =  trim($_POST['password']);     
$gender     =  trim($_POST['gender']);
$birthday =  $_POST['birthday'];
$creationdate = $_POST['creationdate'];
$validationID = $_POST['validationID'];
$accesslevel =  trim($_POST['accesslevel']);
$accountType =  trim($_POST['accountType']);
// then the rest of the login script here

Hello everybody,

This is my first post here and I am beginner in PHP world in terms of writing the code to serve my own purposes.

Well I am building a web app and basically it's a calendar which pulls information from .js file. Now I have thinking for the past couple of days how can I accomplish that each user that registers on the site manipulates its own .js file because information from .js file will be shown on calendar.

Let me tell you how it's currently set up:

1. JavaScript file with particular static name is called under the script that is placed on index.php and the data is displayed on the page itself.

So I would love to have is set it up like this:

1. Index page contains login form - Each registered/logged in user will have its own session
2. User registers and based on username/email new .js file is created out of a blank template and it is named based on user's username
3. user is then redirected to the calendar index which contains javascript that cals out that appropriate .js file based on the what user is logged in and displays data to the calendar

I am not sure if that is doable with PHP or not but that's my thinking how it can be done if it's doable. I am open for any kind of suggestions how all this can be put together and if you do have better ideas I would love to hear from you.

Hello,

i'm trying to get the number of users that registered today and the number of users that registered yersterday (seperate), i've got this field in mysql: 'registertime' which stores data in this format 2011-11-14 14:53:49 also i have the field 'time' in the same format that updates everytime the user logs in.

Now previously i wanted to find out users online in last 24 hours, the code i used for that is this:

Code: [Select]
$query = "SELECT COUNT(*) as Anzahl FROM customers WHERE country = 'de' AND time BETWEEN DATE_SUB( NOW(), INTERVAL 24 HOUR ) and NOW() ";
$queryerg = mysql_query($query) OR die(mysql_error());
while($row = mysql_fetch_array($queryerg)){
  $customers_on_de_24 = $row[0];
}
How could i edit that to select the count just by date and ignore the time (hours minutes seconds) ?