Member Avatar for DickDeeds

I have version 5.0.27 of MYSQL and when attempting to use AES_ENCRYPT I get the error:
Call to undefined function AES_ENCRYPT()
Here is a copy of a test query:
$sql .=$name[$i] ."='".AES_ENCRYPT($assign[$xx],"36LKFOIREI#");
Can anyone help?
tia
Dick Deeds

  • 2 Contributors
  • 1 Reply
  • 57 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for mwasif

AES_ENCRYPT() is a MySQL function but you are using it in PHP context.

Try something like this

$sql .= $name[$i] ."= AES_ENCRYPT('".$assign[$xx]."','36LKFOIREI#')";
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.