PHP - How Can I Compare Time In Format Hh:mm?

I'm trying to make $time be a variable with the current time and I want it to have the same format as mysql.  I can't figure out what I am doing wrong here

Wrror: Warning: date_format() expects parameter 1 to be DateTime, integer given

Code: [Select]
$time = date_format(time(),'Y-m-d H:i:s');

How can I format my time value (initially created by using time()) to ISO 8601 so it can be used in the format described he

http://timeago.yarp.com/

Thanks

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,

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

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.

 

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.

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 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..

Can php be used to get two blog entries and compare them side by side, with a choice one which one to use.

A bit like wikipedia has ?

Hi,
I want to compare the tables from 2 mysql databases in a table.
This is what I have:
for($i=0;$i<$maxCount;$i++)
{
echo "<tr>"; // start row
//fist data square
if ($i < count($db1))
echo "<td>{$db1[$i]}</td>";
else
echo "<td></td>";

echo "<td></td>"; // middle 


//last
if ($i < count($db2))
echo "<td>{$db2[$i]}</td>";
else
echo "<td></td>";

echo "</tr>"; // end row
}

that will put make a nice table for me to see. What I'd like to do next is have all identical sql tables lined up.
So for e.g I have 2 arrays of table names that will look like this:

Databse 1 Database 2 table1 table1 table2 table3 table4 table4
does that make sense?
Also is there a more elegant way of scripting what I have?

PHP date and time function is not showing correct time on my local system

I have the following php code

date_default_timezone_set("Africa/Lagos");

$date = date('d-m-y h:i:s');

echo "Server Time ".$date ."<br>";

echo "The time is " . date("h:i:sa")."<br>";

$current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa')));

echo "Current time1: ".$current_datetime . "<br>";

 

Output

Server Time 21-05-21 09:55:39
The time is 09:55:39am
Current time1: 2021-05-21 09:55:39

 

Expected Output

Server Time 21-05-21 10:55:39
The time is 10:55:39am
Current time1: 2021-05-21 10:55:3

 

Any help would be appreciated.

 

Edited May 21 by Ponel

Hi everyone!
I've been looking for a solution, but i just can't find it anywhere...

Ok, so the problem is:
i have a database which looks something like this:

user_id product_id score
14 . 235 . 79
23 . 235 . 32
53 . 665 . 21
14 . 235 . 90
5 . 675 . 45


This is step-by-step of what i need to do:

1. Select user - user_id =343

2. For user_id =343 select all products that he gave score to:
product_id = 43 - score = 99
product_id = 12 - score = 56
product_id = 68 - score = 32
product_id = 124 - score = 67

3. Find all users that voted for the same products e.g.:
for product_id = 43:
user_id = 125 voted 93 points,
user_id = 23 voted 56 points.


4. Calculate the difference between the score of user, so:
for product_id = 43:
user_id = 125 voted 93 points (99 - 93 =6 points of diff.)
user_id = 23 voted 56 points (99 - 56 =43 points of diff.)
return the results....


That's basically what i need to do. I still don't know the number of the users, or product, but it doesn't really matter - i just need to make it work.
Ok, hope someone can help!

Not sure if there is a better way to do this, but I want to check whether the value in a Sticky Field is the same as what is in the Database.

If what is in the Sticky Field is *exactly* what is in the Database, then the User didn't update that field, and so I would NOT do an UPDATE.

Seem reasonable?

Here is where I grab the value out of the Form...
Code: [Select]
// ****************************
// Process Each Form Field. *
// ****************************
foreach($_POST['answerArray'] as $questionID => $response){
// Copy trimmed Form array to PHP array.
$answerArray[$questionID] = trim($response);


And here is where I grab the existing value in the Database...
Code: [Select]
// ********************
// Check for Answer. *
// ********************

// Build query.
$q1 = "SELECT response
FROM bio_answer
WHERE member_id=? AND question_id=?";

// Prepare statement.
$stmt1 = mysqli_prepare($dbc, $q1);

// Bind variable to query.
mysqli_stmt_bind_param($stmt1, 'ii', $memberID, $questionID);

// Execute query.
mysqli_stmt_execute($stmt1);

// Store results.
mysqli_stmt_store_result($stmt1);

// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt1)==1){
// Answer Found.

// Bind result-set to variable.
mysqli_stmt_bind_result($stmt1, $currResponse);

// Fetch record.
mysqli_stmt_fetch($stmt1);


So I guess I want to compare $answerArray[$questionID] against $currResponse and see if there are any differences?!

What is the best way to do that?

Any better ideas of how to check to see if the User made any changes to a field so I only do an UPDATE if there was actually a change?

Thanks,


Debbie

I run an article directory. I was wondering how I could check an article that is currently pending review against published articles in our database. What I am looking to do is to place the content of the body in the pending article into a variable. That much is easy and I know how to do that. Then I would like to use that variable to compare against other content in our database and have it output a percentage of how close it is to any other article already published in our database. Any direction our guidance with this would be so greatly appreciated.   


Thanks!