so i'm trying in PHP
to insert new members into a sql database with sqlsrv
. we had a facebook login working BUT that now also doesn't work anymore as the query reaches the database, executes it and returns
"Must declare the scalar variable "@P1"
$NewMemberRegisterSQL = "INSERT INTO dbo.members (MemberName, MemberPassword, MemberEmail) VALUES(?,?,?)";
$paramsNewMember = array($_POST['register-username'], $hashedPass, $_POST['register-email']);
$InsertResult = sqlsrv_query( $conn, $NewMemberRegisterSQL, $paramsNewMember);
The Database exists of MemberID
which is an auto increment, FacebookID
which is allowed to be null
,MemberName
which is just the username
,MemberPassword
well guess what this one is, and Memberemail
. FacebookID
,Memberpassword
and memberemail
are allowed to be NULL
.