AutoHotkey Community

// Commented out the following line because PHP.net says: "As of PHP 4.2.0, there is no need to seed the random number generator with srand() or mt_srand() as this is now done automatically."
//mt_srand ((double) microtime() * 1000000);
$search_id = mt_rand();

$search_id = mt_rand();

$sql = "UPDATE " . SEARCH_TABLE . "
   SET search_id = $search_id, search_time = $current_time, search_array = '" . str_replace("\'", "''", $result_array) . "'
   WHERE session_id = '" . $userdata['session_id'] . "'";
if ( !($result = $db->sql_query($sql)) || !$db->sql_affectedrows() )
{
   $sql = "INSERT INTO " . SEARCH_TABLE . " (search_id, session_id, search_time, search_array)
      VALUES($search_id, '" . $userdata['session_id'] . "', $current_time, '" . str_replace("\'", "''", $result_array) . "')";
   if ( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not insert search results', '', __LINE__, __FILE__, $sql);
   }
}

$max_search_id_retries = 20;
for ($i = 0; $i < $max_search_id_retries; $i++) // Retry on failure to insert.  Limit the number of retries to avoid infinite loop when failure is due to something other than "search_id already exists".
{
   $search_id = mt_rand();
   
   $sql = "UPDATE " . SEARCH_TABLE . "
      SET search_id = $search_id, search_time = $current_time, search_array = '" . str_replace("\'", "''", $result_array) . "'
      WHERE session_id = '" . $userdata['session_id'] . "'";
   if ( !($result = $db->sql_query($sql)) || !$db->sql_affectedrows() )
   {
      $sql = "INSERT INTO " . SEARCH_TABLE . " (search_id, session_id, search_time, search_array)
         VALUES($search_id, '" . $userdata['session_id'] . "', $current_time, '" . str_replace("\'", "''", $result_array) . "')";
      if ( !($result = $db->sql_query($sql)) )
         continue;  // Try again by generating a new search_id.
   }
   break;  // Since above didn't "continue", the update-or-insert succeeded.  No more retries needed.
}
if ($i >= $max_search_id_retries)
   message_die(GENERAL_ERROR, 'Could not insert search results', '', __LINE__, __FILE__, $sql);