Databases
StackOverflow2013
Postsdbo
POAppoint a unique registration code
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAppoint a unique registration code
    primarykey
    data
    text
    <p>I have a registration form on my site for users to sign up to become members. </p> <p>When they register their details are sent to the mysql database, and their email, name etc is all put in. they also get a unique registration code which is generated by random md5 on submit and this code is entered into the database as well as it being emailed to them. </p> <p>The problem i am getting is each time a new user signs up a new code is generated but it re-writes over the previous code for all the other users in the database. What i want is for each users code to stay unique and for it not to re-write over the others each time a new user signs up, so I'm thinking that i need to edit my code to say </p> <pre><code>UPDATE `ptb_registrations` SET `registration_code` = '%s' WHERE email = (whatever unique email the user enters) </code></pre> <p>any one got any ideas? thanks</p> <pre><code>&lt;?php /** * ShuttleCMS - A basic CMS coded in PHP. * random code - Used for allowing a user to reset password * * @author Dan &lt;dan@danbriant.com&gt; * @version 0.0.1 * @package ShuttleCMS */ define('IN_SCRIPT', true); // Start a session session_start(); /* * Generates registration code and puts it on database */ //Generate a RANDOM MD5 Hash for a code $random_code=md5(uniqid(rand())); //Take the first 8 digits and use them as the code we intend to email the user $emailcode=substr($random_code, 0, 8); //Encrypt $emailcode in MD5 format for the database $registrationcode=($emailcode); // Make a safe query $query = sprintf("UPDATE `ptb_registrations` SET `registration_code` = '%s' ", mysql_real_escape_string($registrationcode)); mysql_query($query)or die('Could not update members: ' . mysql_error()); ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKuf
    1. USDave Smith
    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. This table or related slice is empty.
    1. COAre you missing a `WHERE` clause in your query? This reminds me of the time when my whole movie database consisted of nothing but "Ace Ventura - Pet Detective" :)
      singulars
      1. POAppoint a unique registration code
      1. USJa͢ck
    2. COi think so, i basically need to find a way of setting a WHERE condition so that each time a new code is generated it does it just to the individual email if that makes sense, but because each users email will be different and typed in by the user I'm not sure how to code my WHERE clause?
      singulars
      1. POAppoint a unique registration code
      1. USDave Smith
    3. COyes you have the solution in your answer, you do need to use a `where` cluase in your SQL
      singulars
      1. POAppoint a unique registration code
      1. USEyal Alsheich
 

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