StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
173764
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2008-10-06T10:02:40.170
FavoriteCount
0
LastActivityDate
2012-04-06T11:50:29.570
LastEditDate
2012-04-06T11:50:29.570
LastEditorUserId
17404
OwnerUserId
17404
ParentId
173727
PostTypeId
2
Score
9
ViewCount
0
LastEditorDisplayName
text
Body
<p>We use mcrypt in our projects to achieve encryption. Below is a code sample based on content found on the internet:</p> <pre><code><?php class MyProjCrypt { private $td; private $iv; private $ks; private $salt; private $encStr; private $decStr; /** * The constructor initializes the cryptography library * @param $salt string The encryption key * @return void */ function __construct($salt) { $this->td = mcrypt_module_open('rijndael-256', '', 'ofb', ''); // algorithm $this->ks = mcrypt_enc_get_key_size($this->td); // key size needed for the algorithm $this->salt = substr(md5($salt), 0, $this->ks); } /** * Generates a hex string of $src * @param $src string String to be encrypted * @return void */ function encrypt($src) { srand(( double) microtime() * 1000000); //for sake of MCRYPT_RAND $this->iv = mcrypt_create_iv($this->ks, MCRYPT_RAND); mcrypt_generic_init($this->td, $this->salt, $this->iv); $tmpStr = mcrypt_generic($this->td, $src); mcrypt_generic_deinit($this->td); mcrypt_module_close($this->td); //convert the encrypted binary string to hex //$this->iv is needed to decrypt the string later. It has a fixed length and can easily //be seperated out from the encrypted String $this->encStr = bin2hex($this->iv.$tmpStr); } /** * Decrypts a hex string * @param $src string String to be decrypted * @return void */ function decrypt($src) { //convert the hex string to binary $corrected = preg_replace("[^0-9a-fA-F]", "", $src); $binenc = pack("H".strlen($corrected), $corrected); //retrieve the iv from the encrypted string $this->iv = substr($binenc, 0, $this->ks); //retrieve the encrypted string alone(minus iv) $binstr = substr($binenc, $this->ks); /* Initialize encryption module for decryption */ mcrypt_generic_init($this->td, $this->salt, $this->iv); /* Decrypt encrypted string */ $decrypted = mdecrypt_generic($this->td, $binstr); /* Terminate decryption handle and close module */ mcrypt_generic_deinit($this->td); mcrypt_module_close($this->td); $this->decStr = trim($decrypted); } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to save encrypted data in cookie (using php)?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USShoan
UserOwnerUserId
1. USShoan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to save encrypted data in cookie (using php)?
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
CommentsPostId
1. COThe IV (Initialization Vector) is a random chunk to be used at the front of the stream to encrypt. This is to prevent known-plaintext attacks. You don't need to know the IV for decryption, only its size. Usually this size is standard.
  singulars
  PostPostId
  PO
  UserUserId
  USalecco
2. COI haven't been able to find a way for `mcrypt_generic_init` without the IV.
  singulars
  PostPostId
  PO
  UserUserId
  USShoan

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.