I AM USING AJAX TO SEND JSON TO PHP. BUT I DON'T KNOW IF SENDING JSON FROM AJAX IS DONE CORRECTLY AND IF RECEIVING JSON AT PHP IS ALSO DONE RIGHT. I DOUBT IT IS CORRECT
CAN YOU HELP ME.
<SCRIPT>
$("#REGISTERFRM").bind(submit, function(){
var NAME = $("#NAME").val();
var EMAIL = $("#EMAILADDRESS").val();
var PASSWORD = $("#PASSWORD").val();
var POSTEDDATA = {
"NAME" : NAME,
"EMAIL" : EMAIL,
"PASSWORD" : PASSWORD
}
$.ajax({
type : "POST",
url : "REGISTER.PHP",
data : {MYDATA,POSTEDDATA},
dataType : "json",
success : function(){
}
})
}
</SCRIPT>
<FORM METHOD="POST" ID="REGISTERFRM" ACTION="REGISTER.PHP">
<TR>
<TD><B><FONT FACE="COURIER" SIZE="7" COLOR="RED">NAME</FONT></B></TD>
<TD>
<INPUT TYPE="TEXT" ID="NAME" NAME="NAME" SIZE="6">
</TD>
</TR>
<TR>
<TD><B><FONT FACE="COURIER" SIZE="7" COLOR="RED">EMAIL ADDRESS</FONT></B></TD>
<TD>
<INPUT TYPE="TEXT" ID="EMAILADDRESS" NAME="EMAIL" SIZE="6">
</TD>
</TR>
<TR>
<TD><B><FONT FACE="COURIER" SIZE="7" COLOR="RED">PASSWORD</FONT></B></TD>
<TD>
<INPUT TYPE="PASSWORD" ID="PASSWORD" NAME="PASSWORD" SIZE="6">
</TD>
</TR>
<TR>
<TD>
<INPUT TYPE="SUBMIT" VALUE="REGISTER">
</TD>
</TR>
</FORM>
( PHP )
$DATA = $_POST['MYDATA'];
$REGISTER = json_decode( $DATA );
$NAME = $REGISTER["NAME"];
$EMAIL = $REGISTER["EMAIL"];
$PASSWORD = $REGISTER["PASSWORD"];
$CON =
NEW PDO("localhost","root","", "ORDERDBF" );
$STMT = $CON->prepare (" INSERT INTO CUSTOMER VALUES(?,?,?)");
$STMT->bindParam( 1, $NAME );
$STMT->bindParam( 2, $EMAIL );
$STMT->bindParam( 3, $PASSWORD );
$STMT->execute();