Details
-
Type:
New Feature
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 2.0.4
-
Fix Version/s: None
-
Component/s: ORM
-
Security Level: All
-
Labels:None
-
Environment:Win XP, MySql5, Php5.3, ZendFramework 1.11.4
Description
Hi there,
I'm trying to insert an encrypted data:
Because '"INSERT statements are not allowed in DQL, ...." i processed like this:
<?php
...
// controller
$membre = new \Entity\TMembre();
$membre->setPassword($password);
$em->persist($membre);
$em->flush();
...
?>
//entity
<?php
namespace Entity;
/**
- TMembre
* - @Table(name="t_membre")
- @Entity(repositoryClass="Repository\TMembreRepository")
*/
class TMembre
{
/** - Set password *
- @param string $password */
public function setPassword($password) { $this->email = "AES_ENCRYPT('".$email."','"._MYSQL_CRYPT."')"; => insert this entire string without executing encryption $this->email = new \Doctrine\ORM\Query\Expr\Func("AES_ENCRYPT",array("'".$email."'","'"._MYSQL_CRYPT."'")); => does not work }}
?>
How can i do ?
Add this method to Doctrine\ORM\Query\Expr class ?
/**
public function aesEncrypt($value)
Best regards
David
Activity
Benjamin Eberlei
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Workflow | jira [ 12626 ] | jira-feedback [ 13924 ] |
Benjamin Eberlei
made changes -
| Workflow | jira-feedback [ 13924 ] | jira-feedback2 [ 15788 ] |
Benjamin Eberlei
made changes -
| Workflow | jira-feedback2 [ 15788 ] | jira-feedback3 [ 18045 ] |