I was testing a PHP script for inserting a new record to my database. However When I ran the script, I only got 500 internal server error.
if( $conn ) { echo "Connection established.<br />"; $Fname=$_POST['FirstName']; $Lname=$_POST['LastName']; $sql = "INSERT INTO testTable (userFirstName, userLastName) VALUES (?, ?)"; $params = array("$Fname", "$Lname"); $stmt = sqlsrv_query( $conn, $sql, $params); if( $stmt === false ) { echo sqlsrv_errors(); } else { echo "Data transmitted successfully.<br />" } }
Try Change “echo sqlsrv_errors();” to “var_dump(sqlsrv_errors);”