Databases
StackOverflow2013
Postsdbo
POCreate a random token, check for a duplicate
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreate a random token, check for a duplicate
    primarykey
    data
    text
    <p>I have a php script that makes a random token (A-Z, a-z, 0-9):</p> <pre><code> function token($length) { $characters = array( "A","B","C","D","E","F","G","H","J","K","L","M", "N","P","Q","R","S","T","U","V","W","X","Y","Z", "a","b","c","d","e","f","g","h","i","j","k","m", "n","o","p","q","r","s","t","u","v","w","x","y","z", "1","2","3","4","5","6","7","8","9"); //make an "empty container" or array for our keys $keys = array(); //first count of $keys is empty so "1", remaining count is 1-6 = total 7 times while(count($keys) &lt; $length) { //"0" because we use this to FIND ARRAY KEYS which has a 0 value //"-1" because were only concerned of number of keys which is 32 not 33 //count($characters) = 33 $x = mt_rand(0, count($characters)-1); if(!in_array($x, $keys)) { $keys[] = $x; } } foreach($keys as $key){ $random .= $characters[$key]; } return $random; </code></pre> <p>} </p> <p>Works perfect, but I want to be able to check a certain database to make sure the same token has never been used before. And if it has it will instantly recreate a fresh token before outputing it.</p> <p>I know I can use this script to check for a duplicate:</p> <pre><code>$check = mysqli_query($mysqli, "SELECT ".$table.".token FROM ".$table." WHERE ".$table.".token = '".$random."'"); if(mysqli_num_rows($check) &gt; 0){ //ERROR: DUPLICATE TOKEN, CREATE A NEW TOKEN NOW... } </code></pre> <p>I just need help to add it all together, so that if a duplicate is found in the database, it will loop back and try again.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USfloatleft
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreate a random token, check for a duplicate
      1. USRatzo
      1. VTFavorite
    1. COYou'd better make that `token` column UNIQUE.
      singulars
      1. POCreate a random token, check for a duplicate
      1. USkennytm
    2. COcheck out uniqid http://php.net/manual/en/function.uniqid.php
      singulars
      1. POCreate a random token, check for a duplicate
      1. USGalen
    3. COuniqid isn't suitable in most cases since uniqid just uses the timestamp as seed, and not a random generator.
      singulars
      1. POCreate a random token, check for a duplicate
      1. USthomasmalt
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload