PHP - The Times Are Achanging: Storing Date/times With Php

Hi everyone,
I'm trying to add up the current time with a specified amount of seconds and insert it in a database afterwards.
When I add say: 500 seconds to the current time it adds a whole lot more and I get a number few thousands higher than I want. Can anyone help me???.
Gr Ryflex

Hello All,

I have tried to find a solution for this issue for days. The script was working fine until yesterday when all of a sudden I get this warning.

Quote

Warning: imagecreatefrompng(http://domain.com/images/broadcast1.png) [function.imagecreatefrompng]: failed to open stream: Connection timed out in /home/domain/public_html/logo/logo1.php on line 8


line 8 is:
$image_1 = imagecreatefrompng($file_1);
Where
$file_1 = "http://domain.com/images/broadcast1.png";

The exact code is working perfectly fine in a different server I have, both servers are running Centos with PHP5 + GD fully enabled. The image http://domain.com/images/broadcast1.png (~5Kb) is loading very fast when open through a browser.

Please please help me resolve this, I have tried many different things and even uninstall and install GD again but n luck. Thank you so much for your help.

Hi all

I am trying to edit a piece of code to change possible times for a booking system.

This is the code I have:

$count=0;
               for($b=$startTime;$b<$endTime;$b++){
                  if($count==$tempVar2){ $availability .= "</td><td align='left' valign='top'>"; }   
                  if(in_array($b,$reservedArray)){
                     $availability .= $b.":00 ".($b<12?"am":"pm")." - ".($b+1).":00 ".($b+1<12?"am":"pm")." - Booked.<br>";
                  } else {
                  $availability .=$b.":00 ".($b<12?"am":"pm")." - ".($b+1).":15 ".($b+1<13?"am":"pm")."- <input type=\"checkbox\" value=\"".$b."\" name=\"time[]\" ><br>";
                  }
                  $count++;
               }

It gives me the following times:

09:00 am - 10:15 am
10:00 am - 11:15 am
11:00 am - 12:15 am
12:00 pm - 13:15 pm
13:00 pm - 14:15 pm
14:00 pm - 15:15 pm
15:00 pm - 16:15 pm
16:00 pm - 17:15 pm

How can I change it so I can have the following times available:

10:00 am - 10:30 am
10:45 am - 11:15 am
11:30 am - 12:00 pm
12:15 pm - 12:30 pm
etc...

Many thanks for you help
Pete.

I need help with a query.   I've got a table that stores references to calls that come in to our office. It has a datetime field, and for the purposes of the query, it's the only thing in this table that is important.   I've got another table that stores appointment information. The appointment start time is also a datetime field. For this query, this start time is the only thing in this table that is important.   I need to know how many times in the last year there was a day when we had at least 150 calls come in and made at least 1 appointment.

SELECT COUNT(*)
FROM appointments a
LEFT JOIN (
  SELECT DATE(time)
  FROM calls
  WHERE <there are at least 150 calls on a day>
) c 
ON DATE(a.start_time) = c.time
WHERE a.start_time >= CURDATE() - INTERVAL 1 YEAR 

To make things difficult, I guess the time would have to be converted to a day, because I'm looking for all days where there was an appointment, and the datetime field is too specific.   I've been looking online for 30 mins or so, and was hoping somebody here could point me in the right direction. I'm not making much progress by myself.
Edited by sKunKbad, 06 October 2014 - 01:17 PM.

hello, i have an event reservation system. i need to make sure that every time someone is booking a new time, it's not overlap another reservation.   for example lets say i have an event reserved starting at X and ending at Y

X = Wed Sep 10 2014 07:30:00 GMT+0000
Y = Wed Sep 10 2014 08:00:00 GMT+0000

and now im reserving a new event

start = Wed Sep 10 2014 09:30:00 GMT+0000
end = Wed Sep 10 2014 09:30:00 GMT+0000

how can i check if they are not crushing? lets say the first event starts at 12:00 and end 14:00, i need to make sure that the new event is not held between these hours. it need to be started and end before 12:00 or after 14:00.   thanks in advance!

Hi There,

I am trying to use PHP to create a calendar that only show's working days - which are monday to friday.

Is there any way that PHP can return a list of the next 5 working day's dates? For example, if today is Thursday 15th Sept - could it return the numbers 15,16,19,20 and 21?

Thanks
Matt

Hello PHP Freaks,

I am using a basic payment frame system, and it requires me to pass in a GMT time in this format, in a hidden form.

"YYYYMMDDHHMMSS"

I have found a lot of examples in PHP on how to format the above tag, but what would be the easiest way to generate it as is?
To make things a little more complicated, there are different users in different GMT times, and based on the state they select it needs to + or - hours from the current time to get the GMT time.

The formulas to calculate the results are as follows, just after the best approach in PHP to calculate:

State #1:   CURRENT_TIME + 10 HOURS = GMT TIME (echo as YYYYMMDDHHMMSS) and assign to $GMT_TIMESTAMP
State #2:    CURRENT TIME + 9.5 HOURS = GMT TIME  (echo as YYYYMMDDHHMMSS) and assign to $GMT_TIMESTAMP



What would be the best way to tackle this ? At the moment I have select boxes where the user can pick the state, then click SUBMIT.

Thankyou in advance,

D

I only see one "mysql_query($memberquery);"  Yet the record is inserted 4 times when I check the db.  Anyone see why?

Thank you for your time!

Code: [Select]
<?php 
$link_register = 1;
session_start(user);
include("header.php"); 



$firstname      = $_SESSION['firstname'];
$middleinitial  = $_SESSION['middleinitial'];
$lastname      = $_SESSION['lastname'];
$phone      = $_SESSION['phone'];
$email      = $_SESSION['email'];
$street      = $_SESSION['street'];
$city      = $_SESSION['city'];
$state      = $_SESSION['state'];
$categoryArray  = $_SESSION['categoryArray'];
$gender      = $_SESSION['gender'];


$con = mysql_connect("localhost", "root", "");

if (!$con)
{
die("Could not connect: ". mysql_error());
}

//The database is selected with the mysql_select_db() function.
mysql_select_db("hobbyclub", $con);

//put the data insert into a varaible so it can be checked later
$memberquery = "INSERT INTO member (firstname, middleinitial, lastname, phone, email, street, city, state, gender) 
VALUES ('$firstname', '$middleinitial', '$lastname', '$phone', '$email', '$street', '$city', '$state', '$gender')";

// if ($categoryArray){
 // foreach ($categoryArray as $category){
// $categoryString .= "'$".$category."',";
// }
// }
// $categoryquery = "INSERT INTO category (categoryname) VALUES('$categoryString')";
// $categoryquery = "INSERT INTO category (categoryname) VALUES(".$categoryString.")";
 

//insert the data
mysql_query($memberquery);


?>
The commented out block of code is just me trying to figure out how to insert an array into the db.

I have an array of appointment start times throughout a day. All appointments last 30 mins.

I also have a list of times that staff are available to meet these appointment times (can be in any format, array etc.)

I need to ensure the appointment times are fully covered by members of staff.

E.g.
Code: [Select]

$appointmentStart[] = "09:30";
$appointmentStart[] = "10:00";
$appointmentStart[] = "11:00";
$appointmentStart[] = "12:30";
$appointmentStart[] = "13:30";
$appointmentStart[] = "15:00";
$appointmentStart[] = "17:00";

$staffMembers[] = "09:00*12:00";
$staffMembers[] = "13:00*16:00";
$staffMembers[] = "15:00*18:00";

In the above case, no, there are not enough staff members to cover this as nobody works from 12:00 to 13:00. I only really need a yes or no. Don't worry about staff breaks, they never work more than 3 hours each at a time.

Thanks in advance for any help.

I have a form created that seems to work across most devices/connection.. but for some reason some phones, Androids specifically so far, seem to time out when the form is submitted using the mobile network. This has happened on multiple android phones. Doesn't seem to have an issue with iPhones. I also had a problem with a Surface tablet when connected to an android wireless signal.. tethering, the same phone that had the issue.   So what happens is once the form is submitted, it hangs for a while and then it'll say "No data received - Unable to load the webpage because the server sent no data. Reload this webpage Press the reload button to resubmit the data needed to load the page. Error code: ERR_EMPTY_RESPONSE" and then after i refresh, it submits and goes through without a problem. Sometimes it refreshsed by itself after flashing this error and goes through.    Another time, using the Surface Pro, wifi and IE, I got the error "Forbidden" you don't have permission to access /new-window-2.php on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.   You can see an example of one of the forms here - connecttopros(dot)com/windows.php   And some of the code is attached below. I'm lost. I've tried using a different server completely, twice, and it didn't fix the issue, so it must be the way the php is put together? Thanks for your help!     Attached Files  Php Freaks.zip   12.25KB   1 downloads

Hello,

I am having a heck of a time trying to get time right on my website lol  When a user logs in, they select what timezone they are in (UTC -1,-2,-3,-4,-5,-6....)  Now this is great an all, but with daylight savings time my times are off by one hour in either direction.  How do sites like this get times to work for users so easily?

Thanks!
weee

Hi guys, i got the following code i wrote which displays a small pop up on screen if the user has mail, and display a little icon. The problem is it displays a new icon for each new mail message. How can i make it so it only display 1 icon no matter how many unread mail the user has. Or even better if not too complicated display a number next too the image?

Code: [Select]
<?
require'xxxxxxxxxxxxxxxxx.php';
mysql_select_db("membership") or die( "Unable to select database");
$sql=("SELECT * FROM user_alerts WHERE user_id = '".($_SESSION['user_id'])."'") or die (mysql_error());
if ($query=@mysql_query($sql)) {
if (mysql_num_rows($query) > 0) {
while ($req=mysql_fetch_array($query)) {

if ($req['messageRead'] == 'NO')
{
?>
<div>
<img src="xxxxxxxxxxxxxx.png" width="32" height="32" alt="unread mail" /> <a href="http://www.xxxxxxxxxxxx/account=account">You have Mail!</a>
<div id="boxes">
<div style="top: 199.5px; left: 551.5px; display: none;" id="dialog" class="window">
<h2>You have new mail!</h2>
<br />
<p>Visit your account page to read it.</p>
<br>
<a href="#" class="close">Close Window</a>
</div>
<!-- Mask to cover the whole screen -->
<div style="width: 1478px; height: 602px; display: none; opacity: 0.8;" id="mask"></div>
</div>
</div>
<?
}
}
}
}
You can ignore most of the div stuff but that's pretty much it. It should check my database for any entries with the users session id in the column called 'user_id'. and only show the image if it then finds an entry with 'NO' in the 'messageRead' column. It currently shows the images for each entry it finds.

Thanks for any help

I've simply set some sessions....

$_SESSION['LoggedIn'] = 1;
$_SESSION['UserID'] = $row["UserID"];

They don't seem to last very long, usually when I close my browser and go back on later, they'll expire. I want them to last permanently unless the user logs out.

How do I do this?

Thanks in advance.

Well I'm hoping someone will have some fun with this.
My database has a list of times for a given date, and a schedule for each time. I'm trying to change the input backgrounds for rows between 2 different times. Like this:

8:00   enter some data
8:10   enter some data
8:20   enter some data
etc.
What I want is to change the background color of any input field between say 9:00 and 10:00, but leave everything else white.
I can change the color, just can't figure out how to compare the times.

Here's part of the code:
Code: [Select]
while($row = mysql_fetch_array( $result ))
{


$opentimeID = date("g:i",strtotime(1530)); //not sure if these statements are correct.
$closetimeID = date("g:i",strtotime(1730));
if (strtotime($row['Time']) //...not sure how to finish this statement to compare the time in the database row to $opentime and $closetime.


{
echo "<tr><td>";
echo date("g:i ", strtotime($row[Time]));
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player1]' name='player1[$i]'
style ='background-color: #FFFF66;'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player2]' name='player2[$i]'
style ='background-color: #FFFF66;'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player3]' name='player3[$i]'
style ='background-color: #FFFF66;'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player4]' name='player4[$i]'
style ='background-color: #FFFF66;'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player5]' name='player5[$i]'
style ='background-color: #FFFF66;'>";
}
else
{
echo "<tr>";
echo "<td>";
echo date("g:i ", strtotime($row[Time]));
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player1]' name='player1[$i]'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player2]' name='player2[$i]'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player3]' name='player3[$i]'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player4]' name='player4[$i]'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player5]' name='player5[$i]'>";
}

Thanks for any advice!

Is there a way to put the value of every 15mins into an array starting and finishing at 2 var times

$time1=10.00am
$time2=1.30pm

$timearray=array($time1, and every 15min interval up to but not including $time2)
        eg  $timearray=array(10.00am,10.15am,10.30am..........1.15pm)