PHP - Insert Time

Code: [Select]
$date = date('m-d-y');
$ip = $_SERVER['REMOTE_ADDR'];

mysql_query("INSERT INTO users VALUES ($username, $password, 0, $ip, $date)") or die(mysql_error());

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.60.116, 03-06-11)' at line 1


I'm not sure why I get this error. :/

I'm not looking for code, mostly just some direction, but I'm sure I'll be back as I try to shape the code.  Also, I know very little about coding jQuery, Ajax, etc.  Here is what I'm looking for:

Basketball coach enters a Page that only he (or admin) can see.  (I have that part figured out.)
Once there, he has a form to fill out with a player's name and other information.

I'd rather there not be 12 rows of empty cells.  (Coaches will view that as work)
I'd rather not have the Page reload on each "Add", but that would be the lesser of two evils.

Is there a way to keep a persistent connection so when a coach hits Add, the player gets added to the database, a new empty form shows up, and the player's information shows up below on a roster?

I'm missing something here. I have a form, and when the submit is pressed, the relevant post data inserts into table one, then I want the last insert id to insert along with other form data into a second table. The first table's still inserting fine, but I can't get that second one to do anything. It leapfrogs over the query and doesn't give an error. EDIT: I forgot to add an error: I get: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usage, why VALUES ('14', '', '123', '','1234', '', '')' at line 1

query:INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company) VALUES ('test 14', 'asdfa', 'asdf', 'adf','asdf', '', '', '', '123', '', '')


Code: [Select]
if (empty($errors)) {

require_once ('dbconnectionfile.php');

$query = "INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company)
 VALUES ('$description12', '$sn', '$description4', '$cne','$description5', '$description6', '$description7', '$description8',
'$description9', '$description10', '$description11')";

$result = @mysql_query ($query);


if ($result) {

$who_donated=mysql_insert_id();

$query2 = "INSERT INTO tbl_donation (donor_id, donor_expyear, donor_cvv, donor_cardtype, donor_authorization, amount, usage, why)
 VALUES ('$who_donated', '$donate2', '$donate3', '$donate4','$donate5', '$donate6', '$donate7')";
$result2 = @mysql_query ($query2);

if ($result2) {echo "Info was added to both tables! yay!";}

echo "table one filled. Table two was not.";
echo $who_donated;

//header ("Location: http://www.twigzy.com/add_plant.php?var1=$plant_id");

exit();
} else {
echo 'system error. No donation added';

Can anyone tell me why this is not INSERTing? My array data is coming out just fine.. I've tried everything I can think of and cannot get anything to insert.. Ahhhh!

<?php
  $query = "SELECT RegionID, City FROM geo_cities WHERE RegionID='135'";
  $results = mysqli_query($cxn, $query);
  $row_cnt = mysqli_num_rows($results);
  echo $row_cnt . " Total Records in Query.<br /><br />";
  if (mysqli_num_rows($results)) {
      while ($row = mysqli_fetch_array($results)) {
          $insert_city_query = "INSERT INTO all_illinois SET state_id=$row[RegionID], city_name=$row[City] WHERE id = null" or mysqli_error();
          $insert = mysqli_query($cxn, $insert_city_query);
          if (!$insert) {
              echo "INSERT is NOT working!";
              exit();
          }
          
          echo $row['City'] . "<br />";
          
          echo "<pre>";
          echo print_r($row);
          echo "</pre>";
      }
      //while ($rows = mysqli_fetch_array($results))
      
      } //if (mysqli_num_rows($results))
      
      else {
          echo "No results to get!";
      }
?>

Here is my all_illinois INSERT table structu

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is my source table geo_cities structu

CREATE TABLE IF NOT EXISTS `1` (
  `CityId` varchar(255) NOT NULL,
  `CountryID` varchar(255) NOT NULL,
  `RegionID` varchar(255) NOT NULL,
  `City` varchar(255) NOT NULL,
  `Latitude` varchar(255) NOT NULL,
  `Longitude` varchar(255) NOT NULL,
  `TimeZone` varchar(255) NOT NULL,
  `DmaId` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

Basically I have recently been playing around with parsing a csv file. What I am looking to do at this point is simply take the date/timestamp (part of the csv file), which is in the following format:DD/MM HH:MM:SS.100th/s
For the sake of argument, lets say I have this in an array string called $csv[0] and the file has several lines that span the course of a couple hours. I wouldn't mind having to use explode() to breakup/remove the date or 100th/s IF that would make things a lot simpler.

So where would I start in trying to achieve this?. The result I am looking for will simply return "X Seconds". Storing this in a string variable would be a bonus, as I plan to use this to divide a separate piece of information.

Any examples or ideas would be great. Thank you.

ps:
Here is an example time from the csv file itself:
Code: [Select]
11/19 22:23:18.143

I am trying to simulate an ad expiration and carry out an action if the ad is expired. And I cannot get the if/else to work properly... I've tried many variations and I cannot see what I am doing wrong here. Any tips please 3 hours and counting of no solution!

$ad_start = time()-14 . "<br />"; // 14 days from today in the past (negative)
echo $ad_start;

$current_time = time() . "<br />"; // current epoch time
echo $current_time;

$days_past = $ad_start - $current_time; // days past

echo "<br />$days_past days have past since the ad started!<br />";

if($days_past <= 14)
{
echo "<br />Ad is less than 14 days.  Not expired.";
}
else
{
echo "<br />Ad is over 14 days. Expired.";
}

This topic has been moved to Application Design.

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

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>";
  }
?>

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.

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.

What are the differences and implications of UTC time and Zulu time?
  

<?php
function getArr(string $time):array
{
    $dateTime = new \DateTime($time);
    return [
        'time'=>$time,
        'timestamp'=> $dateTime->getTimestamp(),
        'dateTime' => $dateTime
    ];
}
$arr = getArr('2020-08-05');  
$arr_z = getArr('2020-08-05T00:00:00Z');  

print_r($arr);
print_r($arr_z);

echo('equal timestamps: '.($arr['timestamp'] === $arr['timestamp']?'true':'false'));

 

Array
(
    [time] => 2020-08-05
    [timestamp] => 1596585600
    [dateTime] => DateTime Object
        (
            [date] => 2020-08-05 00:00:00.000000
            [timezone_type] => 3
            [timezone] => UTC
        )

)
Array
(
    [time] => 2020-08-05T00:00:00Z
    [timestamp] => 1596585600
    [dateTime] => DateTime Object
        (
            [date] => 2020-08-05 00:00:00.000000
            [timezone_type] => 2
            [timezone] => Z
        )

)
equal timestamps: true

 

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!

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?

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.