Hello. Can someone help me with this?

Fatal error: Call to undefined function: aes_encrypt() in /home/user/public_html/application3t.htm on line 450

My Query:

// insert into database
$query = "INSERT INTO ".MYSQL_TBL_CLIENTS." SET $query_string, ssn='".aes_encrypt($ssnpost, $aeskey)."', lastupdate=NOW()";

if (!mysql_query($query)) {
die(mysql_error());
}

$result = mysql_query($query);

# echo $query;

Always having trouble with this AES stuff What am I doing wrong?

oops...

Since its throwing back an undefined function error that means that the php engine cannot locate the function you're trying to use.

Make sure that the file containing the function is included before the query is done. Or that the function itself is posted up top.

Or make sure you dont do what I do and misspell something. I do that all the **** time.

Seems pretty clear to me...

Call to undefined function: aes_encrypt()

aes_encrypt is not a PHP function, but a mysql one.
You must not escape it.

Look what I've found as second result in google for "php aes_encrypt"

Help with aes_encrypt/decrypt functions

OK, AES_ENCRYPT is a MySQL function, not PHP. > >>When I look in the table the field pword is a load of garbage so I assume ...
http://www.issociate.de/board/post/1...functions.html - 12k -

Right, ok. I removed all of the "'s, and the query works, but I get the error that column ssn is defined twice.

This is on a form where all the inputs are defined by a for each, then matched & placed in the database.

foreach ($_POST as $key=>$value) { ......

Since ssn would be defined in both the actual query and for each, how do I get it down to one?

Bumping, can anyone help?