PHP - Simple Question: Passing Current Date To Mysql

Well, basically I am making my log in script. This is my first website with php and MySQL... actually, its my first website I have done that isn't for a school project.

Anywho, the problem I am having is I can't seem to verify the password of the account I am trying to log into.

Here is the code snippet I am having trouble with:

$usr = $_REQUEST['Username'];
$pass = $_REQUEST['Password'];
$pass = md5($pass);
if(mysql_query('SELECT Password FROM Accounts WHERE Username = "' .$usr . '"') == $pass)
{
session_start();
$_SESSION['loggedin'] = yes;
$_SESSION['User'] = $usr;
$_POST['info'] = ("You have successfully logged in " . $usr . ".");
} else { $_POST['info'] = "Username and password do not match.";}


The problem is that it doesn't seem to matter if the username and password are correct, it always prints "Username and password do not match.".

So, here is the table layout of 'Accounts':


Did I type the mysql query wrong?

Hi,

I have database stored a field of date. I want to check if the date in the DB field is the same as the current date, how to do it?

Code:

$oracle = mysqli_real_escape_string($con, $_POST['oracle']);
$query 	= mysqli_query($con, "SELECT indate FROM staff WHERE OracleID ='$oracle'");
$row	= mysqli_fetch_array($query);
$num_row = mysqli_num_rows($query);
		
	if ($num_row > 0) 
	{	
		$curdate = date();
		if ($row['indate'] !== $curdate)
		{
			$query1=mysqli_query($con, "update staff set ClockedIn = 0, ClockedOut = 0 where OracleID='$session_id'")or die('Error In Session');
			header('location:home.php');				
		}
	}

 

Hi Guys   I'm just getting back into coding after taking a break from it.  I want to have a text field that can take up to 1000 characters. What is the best field type for the MySQL field for this?  I can't remember if there are any particular special types.   Thanks

Hi,

I m doing some work for my self an because of that i been reading a lot arround about PHP, and theres something that i would like to ask a bit of enlightenment. So my question is as the title says about html form's using php to insert data into mysql, i been reading tutorials arround the interwebs and even made afew successful tests, but pretty much all tutorials use 2 files to accomplish this the html file with the form and an insert.php where the actual code is stored so this made me think is this how usually it's done? in over all you will have 1 file for the form, 1 for the insert, 1 for the edit php code and 1 for delete. How do you guys usually do it?

PS: one of the tests i did was making 1 single file with all these using an switch. My interest in making this question is solo to learn how other people do it to see if i m in the right way.

Thanks in advance.

I am building a site that needs to update member accounts on a weekly basis.  At the moment I have a cron job set for 12:01 am on Monday, that resets five database fields for all of my members. The first field is the current week, the second field is the previous week, the third field is from two weeks ago, the fourth field is from three weeks ago, and the fifth field is from four weeks ago.  Obviously the cron job resets the first field to 0, and the data from this field is moved to field two (last week), and so on and so forth, and the data from the fifth field is just removed altogether.  However, this is really not preferred, because if/when I get 1000+ users, the cron job will take up a crapload of CPU as many mysql queries need to be executed for each account.

So, I am trying to implement a script that checks the last login date for a user, and if they have have not logged in since before the latest Monday, the Monday before that, the Monday before that, or the Monday before that, etc.

I have never really worked with dates, so I don't even know how to begin.

The last user login is stored as a DATA datatype in a mysql database, and is in the following format: YYYY-MM-DD.

Thanks in advance!

What I am trying to do is I am making a Event page and I would like to have it list the events in 2 sections. One being "On" or "Before" current date and the next being "Past" current date so I can list the events in "Upcoming Events" and "Past Events"

the code im showing here is for the listing of my event page
I just need help turning this query into two separate querys with the date function im looking for.

Code: [Select]
<?php 
$result = mysql_query("SELECT * FROM event ORDER by eventdate DESC");
if (!$result) {
   die("query failed: " . msql_error());
}

while ($row = mysql_fetch_array($result)) {
list($id, $eventdate, $header, $description, $image, $location) = $row;
$description = nl2br($description);
$eventdate = date("M j, Y",strtotime("$eventdate"));

print('
<table width="680" border="0" cellpadding="14" cellspacing="0">
 <tr>
 <td>
<div class="myFont"><font size="+1" color="#4e8baf">'.$eventdate.' - </font><font size="+1"><b>'.$header.'</b></font></div>
<font size="+1"><a href="event.php?list=true&eventid='.$id.'">Details</a></font><br />
<hr color="#FFFFFF" width="100" align="left" size="1">
</td>
</tr>
  </table>
');

}
?>

I'm looking to enter the current time and date into a mysql database using php.  My current code looks like this:

Code: [Select]
$now = date("m/d/y",time());
I then insert $now into the table into a datetime column.  This all works but the time when read from the column appears as 0000-00-00 00:00:00.

Any ideas what I'm doing wrong?

Thanks in advance.

Hi,

when i try to insert to table date value it gives me wrong current date.

$joindate = date('m-d-Y');
		
$sql = mysqli_query($con,"INSERT INTO staff (OracleID,StaffName,Des,joindate,username,password,isadmin)
VALUES ('$oracleid','$name','$des','$joindate','$username', '$pass','$isadmin')");

i get this in the main page after making date("d-m-Y",strtotime(date))

30-11--0001

why is that?

Edited April 7, 2020 by ramiwahdan

I'm building an article system, what im trying to do is when a user choose the article to be published tomorrow to able to.  Write today the article but the system will show it from tomorrow

Code: [Select]
        $gettoday = date("Y:m:d");
$query = "SELECT * FROM tblnews WHERE MainArticle = 1 AND NewsDate = '".$gettoday."'  ORDER BY `Id` DESC LIMIT 1";
$result = mysql_query($query);

This is my code, but when i use this and the article is not posted for today is not showing anything.. any suggestions please?

Thank you

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.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342459.0

Hi everyone,

I have a basic calendar that I am trying to change to highlight the current date. I have got the current date highlighted using an if else statement inside a while clause, however, the issue arises when I use the forward/previous links to go to a different month - the same day is highlighted on those months as well.

Here is the code snippet in question (the entire code is below):


while( $day_num <= $days_in_month )
 {
 if(date('d') != $day_num) {
  echo "<td> $day_num </td>";
     $day_num++;
     $day_count++;
  }
// display today's date   
  else {
    echo "<td class=\"today\"> $day_num </td>";
    $day_num++;
$day_count++;
 }


My question is how do I get this calendar to display the current date, just on the current month. I assume there is something I am missing when it comes to handling the date(s) correctly, but what?

Any help is appreciated.

Thanks,

kaiman

Full code:


// gets today's date
$date = time () ;

// puts the day, month, and year in seperate variables
$day = date('d', $date) ;
$month = (int) ($_GET['month'] ? $_GET['month'] : date('m'));
$year = (int) ($_GET['year'] ? $_GET['year'] : date('Y'));

// generate the first day of the month
$first_day = mktime(0,0,0,$month, 1, $year) ;

// get the month name
$current_month = date('F', $first_day) ;

 // determine what day of the week the first day of the month falls on 
 $day_of_week = date('D', $first_day) ; 

 // determine blank days before start of month
 switch($day_of_week){ 

 case "Sun": $blank = 0; break; 

 case "Mon": $blank = 1; break; 

 case "Tue": $blank = 2; break; 

 case "Wed": $blank = 3; break; 

 case "Thu": $blank = 4; break; 

 case "Fri": $blank = 5; break; 

 case "Sat": $blank = 6; break; 

 }

 // determine how many days are in the current month

 $days_in_month = cal_days_in_month(0, $month, $year) ;
 
 // determine next month
 $next_month_link = '<a href="?month='.($month != 12 ? $month + 1 : 1).'&year='.($month != 12 ? $year : $year + 1).'">>></a>';
 
 // determine previous month
 $previous_month_link = '<a href="?month='.($month != 1 ? $month - 1 : 12).'&year='.($month != 1 ? $year : $year - 1).'"><<</a>';

// start building the table

 echo " <table border=0 width=294>\n";
 echo " <tr>\n";
 
// display month and year
 echo " <th> $previous_month_link </th>\n";
 echo " <th colspan=4> $current_month $year </th>\n";
 echo " <th> $next_month_link </th>\n";
 echo " </tr>\n";

// display days of week
 echo " <tr>\n";
 echo " <td width=42>S</td>\n";
 echo " <td width=42>M</td>\n";
 echo " <td width=42>T</td>\n";
 echo " <td width=42>W</td>\n";
 echo " <td width=42>T</td>\n";
 echo " <td width=42>F</td>\n";
 echo " <td width=42>S</td>\n";
 echo " </tr>\n";

 // counts the days in the week

 $day_count = 1;

 echo " <tr>\n";

 // display blank days

 while ( $blank > 0 ) 

 { 

 echo " <td></td>\n"; 

 $blank = $blank-1; 

 $day_count++;

 }
 
// sets the first day of the month to 1 

 $day_num = 1;

// count the days in the month and display them

while( $day_num <= $days_in_month )
 {
 if(date('d') != $day_num) {
  echo "<td> $day_num </td>";
     $day_num++;
     $day_count++;
  }
// display today's date   
  else {
    echo "<td class=\"today\"> $day_num </td>";
    $day_num++;
$day_count++;
 }

 // make sure we start a new row every week

 if ($day_count > 7)

 {

 echo " </tr>\n";
 echo " <tr>\n";

 $day_count = 1;

 }

 } 
 
 // finish calendar

 while ( $day_count >1 && $day_count <=7 ) 

 { 

 echo " <td>\n";
 echo " </td>\n"; 

 $day_count++; 

 } 

 echo " </tr>\n";
 echo " </table>\n";

Hey guys,   Ive been working on this script and I cant seem to figure out how to highlite the current date in lets say a blue color.   Any ideas please?   <!DOCTYPE html>
    <html>
    <head>
    <title>Simple Month Calendar</title>
    <script type="text/javascript">
    // Author: Danny van der ven
    // Created: 12 aug 2014
    // P.S. I'm from The Netherlands, so the names of the weeks and months are in Dutch.
    var Calendar = function(divId) {
    //Store div id
    this.divId = divId;
    // Days of week, starting on Sunday
    this.DaysOfWeek = [
    'Z',
    'M',
    'D',
    'W',
    'D',
    'V',
    'Z'
    ];
    // Months, stating on January
    this.Months = ['januari', 'februari', 'maart', 'april', 'mei', 'juni', 'juli', 'augustus', 'september', 'oktober', 'november', 'december' ];
    // Set the current month, year
    var d = new Date();
    this.CurrentMonth = d.getMonth();
    this.CurrentYear = d.getFullYear();
    };
    // Goes to next month
    Calendar.prototype.nextMonth = function() {
    if ( this.CurrentMonth == 11 ) {
    this.CurrentMonth = 0;
    this.CurrentYear = this.CurrentYear + 1;
    }
    else {
    this.CurrentMonth = this.CurrentMonth + 1;
    }
    this.showCurrent();
    };
    // Goes to previous month
    Calendar.prototype.previousMonth = function() {
    if ( this.CurrentMonth == 0 ) {
    this.CurrentMonth = 11;
    this.CurrentYear = this.CurrentYear - 1;
    }
    else {
    this.CurrentMonth = this.CurrentMonth - 1;
    }
    this.showCurrent();
    };
    // Show current month
    Calendar.prototype.showCurrent = function() {
    this.showMonth(this.CurrentYear, this.CurrentMonth);
    };
    // Show month (year, month)
    Calendar.prototype.showMonth = function(y, m) {
    var d = new Date()
    // First day of the week in the selected month
    , firstDayOfMonth = new Date(y, m, 1).getDay()
    // Last day of the selected month
    , lastDateOfMonth = new Date(y, m+1, 0).getDate()
    // Last day of the previous month
    , lastDayOfLastMonth = m == 0 ? new Date(y-1, 11, 0).getDate() : new Date(y, m, 0).getDate();
    var html = '<table>';
    // Write selected month and year
    html += '<tr><td colspan="7">' + this.Months[m] + ' - ' + y + '</td></tr>';
    // Write the header of the days of the week
    html += '<tr>';
    for(var i=0; i < this.DaysOfWeek.length;i++) {
    html += '<td>' + this.DaysOfWeek[i] + '</td>';
    }
    html += '</tr>';
    // Write the days
    var i=1;
    do {
    var dow = new Date(y, m, i).getDay();
    // If Sunday, start new row
    if ( dow == 0 ) {
    html += '<tr>';
    }
    // If not Sunday but first day of the month
    // it will write the last days from the previous month
    else if ( i == 1 ) {
    html += '<tr>';
    var k = lastDayOfLastMonth - firstDayOfMonth+1;
    for(var j=0; j < firstDayOfMonth; j++) {
    html += '<td class="not-current">' + k + '</td>';
    k++;
    }
    }
    // Write the current day in the loop
    html += '<td>' + i + '</td>';
    // If Saturday, closes the row
    if ( dow == 6 ) {
    html += '</tr>';
    }
    // If not Saturday, but last day of the selected month
    // it will write the next few days from the next month
    else if ( i == lastDateOfMonth ) {
    var k=1;
    for(dow; dow < 6; dow++) {
    html += '<td class="not-current">' + k + '</td>';
    k++;
    }
    }
    i++;
    }while(i <= lastDateOfMonth);
    // Closes table
    html += '</table>';
    // Write HTML to the div
    document.getElementById(this.divId).innerHTML = html;
    };
    // On Load of the window
    window.onload = function() {
    // Start calendar
    var c = new Calendar("divCalendar");    
    c.showCurrent();
    // Bind next and previous button clicks
    getId('btnNext').onclick = function() {
    c.nextMonth();
    };
    getId('btnPrev').onclick = function() {
    c.previousMonth();
    };
    }
    // Get element by id
    function getId(id) {
    return document.getElementById(id);
    }
    </script>
    <style type="text/css">
    td.not-current {
    color: #777;
    }
    </style>
    </head>
    <body>
    <div id="divCalendar">
    </div>
    <button id="btnPrev" type="button">Terug</button>
    <button id="btnNext" type="button">Vooruit</button>
    </body>
    </html>
 

I'm trying to do the following PHP. I have written it in English

if (today's date) => date1 AND <= date2 then {display image1}
elseif (today's date) => date3 AND <= date4 then {display image2}
else {display image 13}

There are 24 fixed dates and 13 fixed images.

I have tried using combinations of strtotime(), replacing the date value with variables, hard coding the dates within the program. I don't seem to be able to get any combination to work properly. I'm sure it's just a syntax error but I can't see it. When I've searched the web all the answers I've found relate to dates within databases but as I only have 24 dates it seems a bit of overkill. I would appreciate any pointers to the correct method I might be able to use. The dates need only a day and month as I would like this to repeat year after year.

<?php
$today = strtotime(date('d-m'));

if (strtotime($today) >= strtotime('28-10') && strtotime($today) <= strtotime('24-11')) {echo "<div>image1</div>";}
elseif (strtotime($today) >= strtotime('25-11') && strtotime($today) <= strtotime('22-12')) {echo "<div>image2</div>" ;}
elseif (strtotime($today) >= strtotime('23-12') && strtotime($today) <= strtotime('24-02')) {echo "<div>image3</div>" ;}
else {echo "<div>image13</div>";}
?>

The result I get from this is image1 appears on the web page but I would expect image3 as today is 22-01

Thank you in advance.

Andrew

I have a field called date_time in the database which is of type datetime.
I have a form which on submit needs to enter the current date and time in the date_time field.
I know I can get the current time using time()
$time=time();
Can do I do some kind of manipulation using strtotime() and store in the database in  datetime format?