php 搜索记录如何实现

<code class="sql">CREATE TABLE search_history (
  id INT NOT NULL AUTO_INCREMENT,
  user_id INT NOT NULL,
  query VARCHAR(255) NOT NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
);</code>

<code class="php">$userId = 1; // Replace with the actual user ID
$stmt = $pdo->prepare("SELECT query, created_at FROM search_history WHERE user_id = ? ORDER BY created_at DESC");
$stmt->execute([$userId]);
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);</code>

<code class="php">$userId = 1; // Replace with the actual user ID
$query = 'PHP search records'; // Replace with the actual search query
$stmt = $pdo->prepare("INSERT INTO search_history (user_id, query) VALUES (?, ?)");
$stmt->execute([$userId, $query]);</code>

<code class="html"><ul id="search-history">
{% for result in results %}
  <li><a href="{{ result.query }}">{{ result.query }}</a><span class="timestamp">{{ result.created_at }}</span></li>
{% endfor %}
</ul></code>

<code class="javascript">// Get the search history element
const historyElement = document.getElementById('search-history');

// Iterate through the results and create list items
for (let i = 0; i < results.length; i++) {
  const result = results[i];

  // Create the list item
  const li = document.createElement('li');

  // Create the anchor tag
  const a = document.createElement('a');
  a.href = result.query;
  a.textContent = result.query;

  // Create the timestamp span
  const span = document.createElement('span');
  span.classList.add('timestamp');
  span.textContent = result.created_at;

  // Append the anchor tag and timestamp span to the list item
  li.appendChild(a);
  li.appendChild(span);

  // Append the list item to the search history element
  historyElement.appendChild(li);
}</code>