Ggtcf

How does the mv command work with external drives?

How do I go from 300 unfinished/half written blog posts, to published posts?

How do scammers retract money, while you can’t?

Are there any unintended negative consequences to allowing PCs to gain multiple levels at once in a short milestone-XP game?

Can I equip Skullclamp on a creature I am sacrificing?

Why has the US not been more assertive in confronting Russia in recent years?

Preparing Indesign booklet with .psd graphics for print

Is micro rebar a better way to reinforce concrete than rebar?

Can I run my washing machine drain line into a condensate pump so it drains better?

To not tell, not take, and not want

What does convergence in distribution "in the Gromov–Hausdorff" sense mean?

Won the lottery - how do I keep the money?

Is 'diverse range' a pleonastic phrase?

How does the Z80 determine which peripheral sent an interrupt?

Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?

Multiple labels for a single equation

Would this house-rule that treats advantage as a +1 to the roll instead (and disadvantage as -1) and allows them to stack be balanced?

What's the best way to handle refactoring a big file?

Would a completely good Muggle be able to use a wand?

Why do remote companies require working in the US?

How to solve a differential equation with a term to a power?

MessageLevel in QGIS3

Are there any limitations on attacking while grappling?

If the heap is initialized for security, then why is the stack uninitialized?

Check a value with encrypted field in mysql

1

I am using Codeigniter encrypt library for data encryption and store it on db,but now i want to check a value exist or not in this table.

I have 3 fields in table which are encrypted,if I give same value it will store different string in field every time, so how can I check them my value ?

Table

controller code

$result = $this->Home_model->check_mail($this->encrypt->encode($this->input->post('email')));

model code

function check_mail($email)
 $this->db->select('*');
 $this->db->from('enquiry');
 $this->db->where('email',$email); 
 $query = $this->db->get();
 return $query->num_rows();

php mysql

share|improve this question

edited Mar 8 at 14:26

executable

1,9742924

asked Mar 8 at 12:27

diptidipti

548

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  add your code that you have tried and your database
  
  – xmastertje
  Mar 8 at 12:29
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Other then building A.I in the PHP code to geuss the encrypting in the future? You can't most likely you are looking for hashing (SHA256, SHA512 for example) instead of a encryption which gives a different result for each time you execute like MCrypt, Blowfish ? .. But you also might be looking for a password_verify() hard to say without user case, example code and table structure.
  
  – Raymond Nijland
  Mar 8 at 12:35
  

  
  
  
  

add a comment | 

1

I am using Codeigniter encrypt library for data encryption and store it on db,but now i want to check a value exist or not in this table.

I have 3 fields in table which are encrypted,if I give same value it will store different string in field every time, so how can I check them my value ?

Table

controller code

$result = $this->Home_model->check_mail($this->encrypt->encode($this->input->post('email')));

model code

function check_mail($email)
 $this->db->select('*');
 $this->db->from('enquiry');
 $this->db->where('email',$email); 
 $query = $this->db->get();
 return $query->num_rows();

php mysql

share|improve this question

edited Mar 8 at 14:26

executable

1,9742924

asked Mar 8 at 12:27

diptidipti

548

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  add your code that you have tried and your database
  
  – xmastertje
  Mar 8 at 12:29
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Other then building A.I in the PHP code to geuss the encrypting in the future? You can't most likely you are looking for hashing (SHA256, SHA512 for example) instead of a encryption which gives a different result for each time you execute like MCrypt, Blowfish ? .. But you also might be looking for a password_verify() hard to say without user case, example code and table structure.
  
  – Raymond Nijland
  Mar 8 at 12:35
  

  
  
  
  

add a comment | 

I am using Codeigniter encrypt library for data encryption and store it on db,but now i want to check a value exist or not in this table.

I have 3 fields in table which are encrypted,if I give same value it will store different string in field every time, so how can I check them my value ?

Table

controller code

$result = $this->Home_model->check_mail($this->encrypt->encode($this->input->post('email')));

model code

function check_mail($email)
 $this->db->select('*');
 $this->db->from('enquiry');
 $this->db->where('email',$email); 
 $query = $this->db->get();
 return $query->num_rows();

php mysql

share|improve this question

edited Mar 8 at 14:26

executable

1,9742924

asked Mar 8 at 12:27

diptidipti

548

$result = $this->Home_model->check_mail($this->encrypt->encode($this->input->post('email')));

function check_mail($email)
 $this->db->select('*');
 $this->db->from('enquiry');
 $this->db->where('email',$email); 
 $query = $this->db->get();
 return $query->num_rows();

share|improve this question

edited Mar 8 at 14:26

executable

1,9742924

asked Mar 8 at 12:27

diptidipti

548

share|improve this question

edited Mar 8 at 14:26

executable

1,9742924

asked Mar 8 at 12:27

diptidipti

548

edited Mar 8 at 14:26

executable

1,9742924

edited Mar 8 at 14:26

executable

1,9742924

asked Mar 8 at 12:27

diptidipti

548

asked Mar 8 at 12:27

diptidipti

548