PHP - Displaying Time Format

I have the time time now viewed as 17:11.
The time $Start_Time is 17:00. The time $End_time is 18:00.

Can I use this to check if time is in between starttime and endtime? Or do I have to convert it to other formats before it understand that I'm comparing it as times and not just numbers?

if($Start_Time < $Now_time && End_Time > $Now_time){
}

I want the current date to be displayed in this format:
year-month-day hr:min:sec
Suggest me some functions or codings

Hi,

I'm trying to insert this

$inceptiondate = date("Y-m-d 12:00:00");

to the database, the Y-m-d does make it to database, but the 12:00pm doesn't.
Whenever it reaches the database, it becomes 00:00:00

Where did I got wrong?

Thanks

I am using this php to write to a text file to show me who has logged in and when:
Code: [Select]
<?php
$time = $_SERVER['REQUEST_TIME'];
$myusername = $_POST['myusername'];

$data = "$REQUEST_TIME\n";
$data = "$myusername\n";


//open the file and choose the mode
$fh = fopen("logs/login.txt", "a") ;

fwrite($fh, $data);
fwrite($fh, $time);
fclose($fh);

?>

The result I get in my text file is:

paul
1315919200melody
1315919221tracy&graham
1315919232ed&hannah
1315919251

I would feel more successful if the name of the user were to appear on the next line down but I can live with that but I can't make head nor tale of the date.

I want it to say:
paul
13:59
13/09/2011

next user
14:00
13/09/2011 and so on
I feel I have done very well to even get that far really and wouldn't have been able to yesterday. I am frustrated to have reached the extent of my current understanding.

If anyone can tell me where I'm going wrong, that would be great.

I hope the php isn't too far off, and you can "read between the lines" as it were to see what I'm trying to do.

Paul

MOD EDIT: code tags added.

Hi,

I have noticed on my print order section in my cart that the date/time is in US format ie. there is an entry that calls up "date_purchased" and places this in the following format %Y-%m-%d %H:%M:%S

I have searched all the text in my online shop and I have located the code i believe is responsible under \includes\classes\nusoap.php

This is in the following entry

return strftime('%Y-%m-%d %H:%M:%S', $sec) . '.' . sprintf('%06d', $usec);

My question is can i change this code to either of the following without causing any damage else where in the site? I am not sure if it needs the %H:%M:%S', $sec entry here for anything???

Can i do..

return strftime ('%d-%m-%Y %H:%M:%S', $sec)

or

return strftime ('%d-%m-%Y )

without it causing issues in the code?

Many Thanks,

Hi all,

I am working on my PHP script to set up the date with the time for the autoresponder so I can send out the emails at the specific time. I need some help with set up the correct day date with the time, because on my code when I have two different times `06:00` and `20:00`, as both of them will show the time with the current day date, e.g: 28-11-2019. I find that my code have set up the date as incorrect because the time I have `06:00` which it should have set up with the next day date, e.g 29-11-2019 instead of 28-11-2019 and the time `20:00` should set up with the current day date as my current time is `15:26pm` right now. 

Output for `$autoresponder_date`:

    2019-11-25 06:00
    2019-11-25 20:00

Output for `$get_time`:

    06:00
    20:00

Here is the code:

   

$auto_responders = $link->prepare('SELECT * FROM autoresponder WHERE campaign = ? ORDER BY id ASC');
    $auto_responders->execute([$campaign]);
    $auto_responders->setFetchMode(PDO::FETCH_ASSOC);
    $auto_responders = $auto_responders->fetch(PDO::FETCH_ASSOC);
    $get_time = $auto_responders['send_time'];
    
    if ($get_time >= strtotime('00:00'))
    {
        $autoresponder_date = date('Y-m-d', strtotime($get_time . ' +1 day'));
    }
    else
    {
       $autoresponder_date = date('Y-m-d', strtotime($get_time));
    }
    $send_time = $autoresponder_date . ' '. date('H:i ', strtotime($get_time));

 

Can you please show me an example how I can set up the day date for the time `06:00` and `20:00` as if I have the time is `06:00` then check if the time have passed before I could do anything to send the email and it is the same for the time `20:00:00`? 

Thank you.

 

Hello there,

I was curious about PHP's 'time()', now is there any way to parse that into a human readable version e.g 7:53 PM, because I'm unsure on how to work with the time function since it's returned in the unix format, thanks again in advance for your help guys.

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?

Hi...

I tried to use foreach in displaying my table header, but I encountered problem when I tried to display data on the first row , my query only display the last Sum for the last Comp.

here is my code:

<html>
<head>
<title>Half Shell</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
<?php
  error_reporting(E_ALL ^ E_NOTICE);
  date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);


?>

<body>
<form name="param" action="" method="post" onSubmit="return false">

<div id="fieldset_PS">
<?php
   echo "<table>";
   
   $sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con); 
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Comp[] = $row_comp['Comp'];
   }
   echo "<th>&nbsp;</th>";
   foreach($Comp AS $Comp){
    echo "<th>$Comp</th>";
  }   

   echo "<tr>
   <td>Total Kg/Compound</td>";
      $sql_sec = "SELECT SUM(TotalKg) AS TotalKg FROM sales_order  WHERE Comp = '$Comp' ORDER BY Comp";
   $res_sec = mysql_query($sql_sec, $con);
   
   while($row_sec = mysql_fetch_assoc($res_sec)){
       $TotalKg[] = $row_sec['TotalKg'];

   }
   foreach($TotalKg AS $TotalKg){
    echo "<td>$TotalKg</td>
    </tr>";
  }   

   ?>


I also attach the correct output that should be and the result from my code.

Thank you

I think its a problem connecting with mySQL, because no matter what I put in the "Date" category, it comes up as Dec 31.  Here's the snippet in question for the newArticle.php, and the corresponding snippet for the homepage layout.  If I could somehow put a  "$today = date("F j, Y, g:i a");"   at the top and replace that stuff with $today, please let me know!  The column is called publicationDate, and its a VARCHAR with 30 length.  And I'm 100% I'm connected to the DB itself, because articles will post correctly and they appear on both the webpage and their various rows.  The only one thats not working is publicationDate.
The 'write' part in newArticle.php
 
Code: [Select]
<li>
            <label for="publicationDate">Publication Date</label>
            <input type="date" name="publicationDate" id="publicationDate" placeholder="MM-DD-YYYY, hh:mm" required maxlength="30" value="<?php 
echo $results['article']->publicationDate? date("F-j-Y-g:i a", $results['article']->publicationDate ) : ""  ?>" />
          </li>
The 'read' part in the homepage
Code: [Select]
<td><?php echo date("F j, Y, g:i a", $article->publicationDate)?></td>

When I echo the current time, the hour is what it is plus one:

echo date("h:i:s:A");


Real time is 3:46:33

Would display 4:46:33


What is wrong here?

Hi,

I'm inserting hours and minutes per user into a database where they have their own fields.
(userid, hours, mins)

I've a small issue when displaying the data.

When I run my query I sum the total hours and minutes per user which results in data such as the following

userid1 - 2  hours 15 mins
userid2 - 1 hour 100 mins

The query orders by hours and then mins desc

When I'm displaying the data (as I'm looping through the results array) I perform a calculation to convert the mins to hours so it now reads

userid1 - 2 hours 15 mins
userid2 - 2 hours 40 mins

so the webpage displays userid1 first when i want userid2 to be the first record displayed (Hours desc)

Can anyone recommend a solution to this ?
Will I need to create another table and update it as hours and minutes are being entered and display results from that table instead ?
Can I order the data after I carry out the mins to hours calculation ?

many thanks in advance for any suggestions....

tmfl

Hey everyone. Currently I have a site set up where I manually edit the txt file and the site pulls it from the text file and displays via php. I wanted to automate it by creating one file which contains the sunset times for the whole year, and have php determine todays date and then display the corresponding sunset time.

Can someone please point me in the right direction?

maybe it can be set up in a way where each line in the txt file represents the day of the year. ex: Jan 1 would be line 0, Feb 1's sunset time would be on line 31 etc.

Thanks

Hi all,

I am currently making a website that has e-custom functions and a back end for the client.

I want them to be able to upload images - but they need to be transparent. I do not want to leave this in the hands of the client, so I am looking at ways of using the GD library to make the change

I got no issue with the png/gif type for upload/resize function since this type already transparent background but my major problems is how to deal with jpeg/jpg image type which is their background was not a transparent...so is it possible I can change/ convert to png/gif type upon successful of uploading image...so the new final image will be png/gif type with transparent background...is it doable...I am not even sure it is possible...?

Thanks for any help..

I apologizing for bothering the expert here again, but I've run into another issue.  I am using the following code because I can't change the default timezone on my shared hosting plan:

$time = date("h:i A", strtotime("+19 hours"));

there are few issues with this.  if I just use: date("h:i: A") the time prints as 7 hours earlier than my timezone, and currently it shows 1:09 AM and it appears in the database as "01:09:00".  if I use the code above, the time prints out as "08:09 PM", but it is inserted into the database as "08:09:00".  Shouldn't it read "20:09:00" instead?  and why isn't the time being inserted into the database with the "PM" suffix on it like it appears in the printout?  the "time" field in my database is set to type TIME.

thanks.

Edited October 14, 2019 by ajetrumpet