共享服务器下如何通过PHP获取表单提交时的客户端本地时间戳并存入SQL？

Got it, let's work through this—since you can't tweak your US-based shared server's time settings, leaning into the client's local time is the perfect workaround. Here are a couple of practical, easy-to-implement approaches:

1. Use JavaScript to Capture Client Time (Recommended) #

This is the most straightforward method. You'll add a hidden field to your form, then use JavaScript to populate it with the client's local time (as a timestamp or ISO string) right before the form submits. The server can then take this value and store it as a TIMESTAMP.

Example Code: #

HTML Form:

<form id="submitForm" action="/your-submit-endpoint" method="POST">
  <!-- Your existing form fields go here -->
  <input type="hidden" name="client_local_time" id="clientTime">
  <button type="submit">Submit Form</button>
</form>

JavaScript:

document.getElementById('submitForm').addEventListener('submit', function(event) {
  // Option 1: Capture Unix timestamp (milliseconds since epoch)
  // This is great because it's timezone-agnostic and easy for servers to parse
  const clientTimestamp = Date.now();
  document.getElementById('clientTime').value = clientTimestamp;

  // Option 2: Capture local time as an ISO string (with timezone info)
  // Use this if you want a human-readable format straight from the client
  // const localISO = new Date().toLocaleString('en-GB', {
  //   year: 'numeric', month: '2-digit', day: '2-digit',
  //   hour: '2-digit', minute: '2-digit', second: '2-digit',
  //   timeZoneName: 'short'
  // });
  // document.getElementById('clientTime').value = localISO;
});

Server-Side Handling (Example with PHP): #

If you're using PHP, you can convert the timestamp to a valid TIMESTAMP format for your database:

// Get the client timestamp from the form submission
$clientTimestamp = $_POST['client_local_time'];
// Convert milliseconds to seconds (MySQL uses Unix timestamps in seconds)
$unixTimestamp = floor($clientTimestamp / 1000);
// Format as a MySQL-compatible DATETIME string
$localDateTime = date("Y-m-d H:i:s", $unixTimestamp);

// Now you can insert $localDateTime into your TIMESTAMP column

Note: #

Keep in mind that client-side clocks can be inaccurate. If you need to enforce time validity, you can add a quick check: compare the client timestamp to your server's current timestamp, and if the difference is extreme (e.g., more than 1 hour), show a warning to the user asking them to check their device's clock.

2. Fallback for JavaScript-Disabled Clients #

If you need to support users who have JavaScript turned off, you can add an optional manual time input field. Hide it by default with CSS, and show it only if JavaScript isn't enabled:

<noscript>
  <div class="js-disabled-warning">
    <p>JavaScript is disabled. Please enter your local time:</p>
    <input type="datetime-local" name="manual_local_time" required>
  </div>
</noscript>

Then on the server, check if the client_local_time field exists—if not, use the manual_local_time value instead.

Why These Work #

Both methods avoid relying on your server's timezone entirely. By capturing the time directly from the client (either automatically via JS or manually), you ensure the TIMESTAMP reflects the user's local time in Ireland, regardless of where your server is hosted.

内容的提问来源于stack exchange，提问作者Sam Lawless