PHP - Php Help. Injury: Store Time

This topic has been moved to Application Design.

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

I am having a problem with PHP displaying the correct date and time. It updates as it should, but is fast by 4min and is always displaying a date in 2004. I ran a basic php script to make sure the application im using itself is not wrong. go to lunenburgledger.com/time.php

Anybody had any ideas on where to check? The system time on the Windows Server 2003 is correct. The only thing I can think of is that it was converted to a virtual machine on vmware esxi, but the system time stayed right. Any ideas?

Thanks!

OK So I've got a datepicker that sends a date in d/m/y format. My DB stores the data in Unix Timestamp Which I can convert the date to with strtotime however this does the exact date & time.

All I want is the actual day. I've spent hours trying to convert this with just the day with mixed results...

Thanks.

PHP 5.2.6

We rent PHP server space on a server in California. Several of my pages generated by PHP show the current date and time, so when the page is printed, the user knows when the data was printed. Our users could be anywhere in the US, I am in Michigan. How do I convert the server time (PDT) into local time, regardless of where the user is?

Thanks.

Hello,

I tried to implement some PHP code to enable a web page to show "Dinner" specials versus "Lunch" specials based on the time.

The business is located in the Eastern Time Zone, so I only need to routine to work based on Eastern Time (New York).

What I am noticing is that the server is processing the lines of code so fast that the command to establish the correct time for the remaining code is not always being acknowledged.

This line of code appears to be processing too fast for the remaining lines of code:
date_default_timezone_set ( "America/New_York" );

Is there some additional code I can put in place to make sure the correct time is always ascertained?

I need the $hourmin variable to always return a combination of hour + minute based on 24-hour time and Eastern Time zone.

My code is as follows:


 <?php
   $name8 = file_get_contents("test/special8name.txt");
date_default_timezone_set ( "America/New_York" );
$gethour = date("H");
$getminutes = $gettimedate["minutes"];
$gettimedate = date();
$hourmin = $gethour . $getminutes;
$currentday = date("l", time());
$currentdate = date("M j, Y");
if ($hourmin < 1500 && $currentday <> "Saturday" && $currentday <> "Sunday") {
   echo "<span class=\"namesred\">$name8 </span>";
}
  else if ( $hourmin > 1500 && $hourmin < 2300 && $currentday <> "Saturday" && $currentday <> "Sunday") {
   echo "<span class=\"namesblue\">$name8 </span>";
  }
  else if ( $currentday == "Saturday" or $currentday == "Sunday") {
   echo "<span class=\"namesblue\">$name8 </span>";
  }
?>

Hi,

The hosting provider for my domain confirm me that the server time is in EST (UTC-5). They also sent me a grab supporting that
Code: [Select]
server time is now:
----------------------
Sun Nov 7 02:20:01 EST 2010
-------------------

But when I use the following code, the output I get is has 1 hr difference (UTC-6)
echo date("d M, Y h:i:s A",time());

Output==> 07 Nov, 2010 01:20:01 AM

But it suppose to give the same time as the server, ryt? Can anybody please explain?

Thanks,

I have this:

    $sql = mysqli_query($conn, "SELECT ip
                                     , page
                                     , CASE WHEN referrer = ''
                                            THEN 'N/A'
                                            ELSE referrer
                                       END as referrer     
                                     , DATE_FORMAT(date, '%m/%d/%y') as date
                                     , TIME_FORMAT(time, '%T') as time
                                FROM tblTraffic 
                                ORDER BY date DESC, time DESC");

most of my traffic report contains the correct times, my time, which is CST in the USA.  but some records are off by a lot.  Does the time() function capture the time of the actual location from which the visitor is coming from?  if so, what could I do to return my timezone for any visitor?  w3 schools and php.net don't mention this.

Let's say I am buying a share for $10.

If I sell the share on the same day BEFORE 3:30PM, it will be sold for $10, but if I keep the share past 3:30PM, I want the code to automatically add $1 (Taxes and such) once in the the price of the share in database, after that no matter how many days pass by, the price will remain the same.

 

I've thought about CRON jobs, but I have no idea how to make/use them or set them up.

 

Any direction or help is appreciated.

 

 

I am making a time clock, and I was wondering what is the best way to calculate the number of hours an employee worked?

I have a table called "statuses" it holds names of punch types:
- id = the auto_inc
- status = "in/out/break/lunch" text statuses
- paid = whether or not the punch is paid or not (true/false)

I have another table called "logging" This table holds the information about the punch type:
- id = the auto_inc
- owner = the member id
- ip = members ip
- inout = the punch type from the statuses table
- location = the city/state of where the punch took place
- date = the time the member punched

Maybe I am over thinking this, but what is the best way to calculate the hours a person has worked?

Right now I am getting all the punches for for a particular member between a date range. then loop through the data to display it and passing it to a method in a class called Calc. I want to then add the times from punch in to punch out, then the next punch in to punch out.

Any suggestions?

how do i get a drop down value and store it in a another table
as of now i am getting the value from one table showing it on drop down now once that is selected i need to insert it into another table.

<html>
<?php

mysql_connect('localhost','root','') or die('Could not connect to mysql ' . mysql_error());
        mysql_select_db("dbtest") or die(mysql_error());

if(isset($_POST['submit'])) { //$name=$_POST['val'];
$id = $_POST['select'];
          $id=$row['name'];
?>
<input type="text" name="name2" value="<?php echo $row['name'] ?>"><br />
       <?php
      $query = "INSERT INTO sub (`sub`) values('" . $id . "')";
            $result = mysql_query($query);
                 
if($query) {                       
echo "query executed";         
}

    
    } 
    ?>

<form id="name" action="<?php $_POST['SERVER_SELF'] ?>" method="POST" >
<input type="text" name="name1"><br />
<select name="select" id="select">
<?php
$query = "SELECT name,id FROM main"; 
            $result = mysql_query($query);
            
if($query) {  
                while($row = mysql_fetch_array($result)) {
$options .= '<option value="' . $row['name'] . '">' . $row['name'] . '</option>';
        //  $out .= "<option value=\" . $row['name'] . \" >' . $row['name'] . '</option>";    
}
}

echo $options;
?>

</select>

<input type="submit" name="submit1">
</form>

</html>

Thanks the above seem to work.

Well, I am storing some of images on my server, but I have to type in the name myself which gets a bit boring and I may overwrite an old image by accident, so, I was thinking of having mysql auto increment the image names. But will this be suitable for images, or should it be text.

Hi,

I am writing a advertisement system, where i have two fields
Ad_Start_date
Ad_End_Date


i was always confused, in doing this things regarding date whether to use

datetime or
timestamp in mysql


Thanks,

Hi, I want to maintain users who log in a webpage and each time they leave, I want to record the current time, so this sounds silly but do I just set in my db table in a field that tracks a user's last log in with DEFAULT: CURRENT_TIMESTAMP?

db structu
user_id   lastActivity  lastSession (stores TIMESTAMP of last time user logged in)

Any help much appreciated

Hi,    I am building a website that will contain listings, there will be a categories page which will bring the user to the subcategories for that category then the user can see all listings linked to that subcategory. At the minute I am just linking each page using basic href tags to go to the page name.php and all my pages end up being homepage.com/clickedlink.php.    How do I change my URL's so that if i click on a certain category the url changes to page name.php?category=chosen category?   Thanks

It seems that in the following script I am not able to make $page contain some values as it always acts as it contains 0.
The script will give you more idea about what I wanna do with it.
Code: [Select]
<?php
include('dbinfo.inc');
session_start();
$connect= mysql_connect($host,$dbuser,$password) or die("connect to database fails");
mysql_select_db($dbname, $connect);
//This will set the number of messages we want to display on each page
$rows_per_page = 5;
function show_msg()
{
echo "<tr align='center'>
<td>$row[message]</td>
</tr>
<tr><td><strong>Sent By: $_SESSION[username] ON Date: $row[date]</strong></td></tr>
<tr><td></td></tr>";
}
//This will set the necessay variables required to set the page layout
function page_vars()
{
$sql = "select * from msgs";
$result = mysql_query($sql, $connect);
$numrows = mysql_num_rows($result);
$total_pages = ceil($numrows/$rows_per_page);
//Check whether page is given or not
if(isset($_GET["page"]))
{
$page = $_GET["page"];
}
else
{
$page = 1;
}
if($page < 1):
{
$page = 1;
}
elseif($page > $total_pages):
{
$page = $total_pages;
}
endif;
}
if($_SESSION[loggedin] == TRUE && $_SESSION[actype] == lecturer)
{
echo "<form action='postmsg.php' method='POST'>";
echo "<table width='80%' border='1'><tr align='center'><td><strong>To send a new message type it in the below box and press SUBMIT</strong>
</td></tr>";
echo "<tr align='center'>
<td><textarea name='msgarea' cols='40' row='5'></textarea></td>
</tr>
<tr align='center'>
<td><input type='submit' value='Send Message' /></td>
</tr>
</table>";
$limit .= 'LIMIT '.($page - 1)*$rows_per_page.', '.$rows_per_page;
echo $limit;
$sql = "select * from 'msgs' $limit";
$result = mysql_query($sql);
echo "<table width='80%' border='1'>";
$row = mysql_fetch_assoc($result);
while($row)
{
show_msg();
}
}
else
{
page_vars();
$limit .= 'LIMIT '.($page - 1)*$rows_per_page.', '.$rows_per_page;
$sql = "select * from msgs $limit";
$result = mysql_query($sql,$connect);
echo "<table width='80%' border='1'>";
while($row = mysql_fetch_assoc($result))
{
show_msg();
}
echo "<tr align='center'>
<td>
<a href='$_SERVER[php_self]?page=1'>First Page</a>
<a href='$_SERVER[php_self]?page=($page - 1)'>$page</a>
<a href='$_SERVER[php_self]?page=$page'>$page</a>
<a href='$_SERVER[php_self]?page=($page + 1)'>$page</a>
<a href='$_SERVER[php_self]?page=($total_pages)'>>>>Last Page</a>
</td>
</tr>";
echo "</table>";
}
?>
now when i echo $limit it always shows "-5, 5" , that's not what i want from this script.
Instead I want limit to store "0, 1" with the same concept not direct because it will change according to what $_GET[page] holds.

Hope I will get the solution here....