I am sending data to my server which I want to ,AES_ENCRYPT ... I tried to insert it like below but nothing shows up in the Database ... doesn't throw and err just does not record the data ... to check I retrieve the data and the Columns are empty ... what am I doing wrong ?
$key = ($_POST['Key']);
$Incident = mysql_real_escape_string($_POST['Incident']);
$ First_Name = mysql_real_escape_string($_POST[' First_Name']);
$Last_Name = mysql_real_escape_string($_POST['Last_Name']);
$sql="INSERT INTO $tbl_name(Incident, Last_Name, First_Name)VALUES('$Incident', '$Ic_number', AES_ENCRYPT('$Last_Name','$key') ,AES_ENCRYPT('$First_Name','$key'))";
and while I'm asking what is the syntax for updating a record
SET Last_Name='".$Last_Name."', First_Name='".$First_Name."',