Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can kinda fudge it, but I would totally recommend adding another column. Here's how I'd do it with PHP.</p> <pre><code>// do your insert // Retrieve last insert id $orderId = mysql_insert_id(); // get the current timestamp $time = time(); // Intersperse the $orderId into the $time to get a new "hash" $orderId = explode("", (string)$orderId); $time = explode("", (string)$time); $orderIdLength = sizeof($orderId); $newOrderId = ""; for ($i = 0; $i &lt; $orderIdLength; ++$i) { $newOrderId .= $orderId[$i] . $time[$i]; } $newOrderId = (int)$newOrderId; </code></pre> <p>So, if your actual order id is 489, and the current timestamp is 1300778794, you end up getting an order id that looks like 418390. If your customer then uses that order id for anything, you simply have to break it back down:</p> <pre><code>$newOrderId = explode("", (string)$newOrderId); $length = sizeof($newOrderId); $oldOrderId = ""; for ($i = 0; $i &lt; $length; $i = $i + 2) { $oldOrderId .= $newOrderId[$i]; } $oldOrderId = (int)$oldOrderId; </code></pre> <p>This isn't a very sophisticated approach and isn't 100% fool-proof. But for the sake of gently obfuscating your order ids, I think it does the job sufficiently.</p> <p><em>Edit:</em> just as a quick aside, you can use some other method of generating some semi-random number for padding the id other than <code>time()</code>. For example, you could do <code>rand(pow(10, log10($orderId)), pow(10, log10($orderId)+1))</code>, which would always return some random number that's the same length as the orderId.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to generate Unique Order Id (just to show touser) with actual Order Id?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMichael McTiernan
    1. USMichael McTiernan
    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. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThis solution isn't really user friendly, since the outputted order id will be different every time the value of time() changes. While computationally it's possible to reverse the obfuscation, it will confuse the user, if the order id keeps changing all the time.
      singulars
      1. PO
      1. USRiimu
    2. CO@Rinuwise: then use UNIX_TIMESTAMP(`created_date`). For some reason, I imagined he was generating an order id for a printed invoice that would only be delivered once. I have no idea why I thought this. :)
      singulars
      1. PO
      1. USMichael McTiernan
 

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