Generate a unique hash/number for tracking on $wpdb insert

The userid will not exist until the user is inserted, you would need to do a second update for that. You may be better off using PHP’s uniqid(), perhaps with the user’s email as a salt/prefix to avoid a race condition (however unlikely).

Related Posts:

  1. wpdb->insert: do I need to prepare against SQL injection?
  2. How to use $wpdb to delete in a custom table
  3. WPDB prepare – like % – placeholders?
  4. $wpdb->update multiple rows, like IN in normal SQL
  5. Matching database content types to PHP types
  6. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  7. Avoiding “Usage of a direct database call is discouraged”
  8. dbDelta does not create Table, but returns success
  9. Saving custom form data into database
  10. wp-content/db.php : where is this file?
  11. Quotes in table name
  12. $wpdb->get_results() returns good result only in first foreach iteration
  13. $wpdb->insert – inserting multiple rows
  14. $wpdb prepared with search term
  15. WPDB->insert with special characters
  16. How Can I Use $wpdb in PayPal IPN file?
  17. Is there a (better) way to access $wpdb results?
  18. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  19. $wpdb->prepare not working with update table prefix
  20. How to use prepare to query with variables
  21. Use $wpdb in wordpress theme files
  22. $wpdb not returning data
  23. WPDB update row with != in where clause
  24. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  25. Problem in creating table through plugin code
  26. I want to update my postcontent with $wpdb
  27. How to email user after inserting the username in database in WordPress
  28. Create an array with a string key from wpdb->get_results
  29. How to fetch an array in $wpdb?
  30. $wpdb – do you have to use foreach even if there will always only be one result?
  31. Replicating the WP_Query ‘s’ param with $wpdb
  32. Need help writing a $wpdb query
  33. get the number of queries made on a page(inside my plugin)
  34. Doing a loop with multiple DBs simultaneoulsy
  35. $wpdb->insert query changes to SHOW COLUMNS query Output
  36. Fixing wpdb->get_results and wpdb->prepare?
  37. How does the WXR file differ from the WPDB?
  38. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  39. Modify the structure of data returned by $wpdb
  40. WPDB If primary key already exists, add +1 to integer field
  41. How to get an array of user roles with or without a specific capability?
  42. What is wrong with this wpdb update?
  43. Programmatically Creating Page using $wpdb and getting 404 error
  44. Constructing a dynamic WPDB query with multiple LIKEs
  45. Problem in inserting row to custom database table
  46. sanitize_text_field and apostrophe problem
  47. 301 Redirect Code
  48. wpdb updating record in wordpress with json adds extra array elements
  49. Counting posts with argument without retrieving the posts
  50. How to display a specific category using a custom Query?
  51. $wpdb->insert inserting only f character in custom table
  52. Why does wpdb->update delete other meta?
  53. Increment integer field in database when WHERE needs to be dynamic [closed]
  54. Getting variable from Database
  55. Create new database through static page code
  56. Custom $wpdb returns unexpected time based results
  57. WordPress “wpdb->update” – Append Text Value
  58. Need help converting get_user_meta [keys] into own array
  59. Can’t call WPDB inside RSS template
  60. Save sql file after doing insert wpdb
  61. Can I use wpdb to insert query results into a post?
  62. $wpdb->prepare error after WordPress update [duplicate]
  63. $wpdb->get_var next var?
  64. Query and get meta as object(stdClass) on wp postmeta table?
  65. How do I query a table?
  66. check that the data exists before sending it to wpdb
  67. How to pass an input value into wpdb->Prepare
  68. no result returns when using $wpdb->get_results with where clause
  69. SQL queries to another wordpress site
  70. PHP | left join avg query give me Array()
  71. update not working using wpdb
  72. get_posts() SQL Injection
  73. og:image functions.php
  74. wpdb replace returning 1 where delete and insert is expected
  75. wpdb discards duplicate column names?
  76. update_post_meta not working in template_redirect action
  77. How to work with constraints on wordpress user metadata?
  78. $wpdb select returns empty array
  79. Show error messages to a user when database insert fails
  80. Unable to use $wpdb in WordPress
  81. Intermittent problem writing update_user_meta
  82. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  83. Combine posts and postmeta
  84. Get 3 row ID’s via ARRAY_A
  85. Getting record from three wpdb tables
  86. wpdb insert working in one function, but not another
  87. wp_commentdata: error in documentation?
  88. Echo only gives me the first part of string
  89. wpdb select from using array as search parameters
  90. esc_sql inserting weird chars to DB
  91. Retriving array size from serialized data
  92. How to update user profile or inputing any data to the wp db from external site?
  93. Can’t get expected result from a wpdb query
  94. Get comments after specific date
  95. selecting row using wpdb which contain special symbols
  96. Query Problem in Clustom Plugin
  97. How does $wpdb->get_var work with offset?
  98. $wpdb The query does not contain the correct number of placeholders
  99. Get count of rows based if column exists in two different tables
  100. $wpdb:insert, more arguements in $format array than in $data