php - help with mysql AES_ENCRYPT -

-

I have created a query but throwing errors is my query here: 

 < Code> $ query = "Include encryption_test values ​​(values) (AES_NCRPP ('pass', 'password'));   
 I have successfully connected to the server and chose the database. Here is the  mysql_error () :  
 
 There is an error in your SQL syntax;   
   
 anyone can do it) I am not looking at anything? Thank you for your help and ask if you have any questions.   
 
 
  value  is a MySQL reserved word you need to avoid such a backtick Enter:  
  $ query = "Encryption_estests` (` value ') Enter values ​​(AES_NCRPT (' pass', 'password')) ";   
 Although my personal preference is to write a question like this, I find it very easy to read:  
  Enter encryption_test SET `values `= AES_ENCRYPT ('pass', 'password')

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

ruby on rails - Convert a Activerecord result with has_one associations into a single hash per record -

-
If I have any results from the Active Records, then I have an array of hashes, if I have a reliable load, then every Each organization hash in record hash has a nested hash of its associated records My question is, is there a quick rail system that allows you to merge these nested hashes into a hash per record? An analogy will be changing the records table rows Another resemblance will be converted into a hash at one level of nested hashes. approach 1: select them in the section Include class user has_one: profile end is for square profile: user # street 1, street 2, city etc. end profile = profile.junks (user :). Selection ("User. *, Profile. *") All profiles. First.login Approach 2: Use delegation for class profiles : User # Street 1, Road 2, City etc. Representative: Name ,: name =,: email,: email = ,: from = to & gt; : End of user
Read more

javascript - Read complete data from stream from onMessage -

-
How to read event.data from a web site entirely using javascript ? On Message: Function (Event) {var msg = event.data; Warning (msg); } In the above code, variable msg shows only partial data How to obtain complete data from websicet server? event.data contains complete information; It depends only on your output how much you will see. A warning box only contains a special number of characters, because more characters do not fit in the warning box only. Warning ing is not a good practice to display large data. A more convenient way to save the length and to check that, for example: On Message: Function (Event) {var msg = event.data; Warning (msg.length); } The length should be just the right length, that is the length of the characters you sent.
Read more