Click here to Skip to main content
14,574,310 members
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 3:10
cofounderChris Maunder16-Jul-09 3:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 16:30
cofounderChris Maunder10-Nov-05 16:30 
QuestionSql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu29-Jun-20 21:18
Memberkali siddhu29-Jun-20 21:18 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan29-Jun-20 21:54
mveRichard MacCutchan29-Jun-20 21:54 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu30-Jun-20 23:29
Memberkali siddhu30-Jun-20 23:29 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan30-Jun-20 23:31
mveRichard MacCutchan30-Jun-20 23:31 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
David Mujica1-Jul-20 5:36
MemberDavid Mujica1-Jul-20 5:36 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
ZurdoDev1-Jul-20 7:03
mveZurdoDev1-Jul-20 7:03 
QuestionHttp 500 error with register page Pin
and180y29-Jun-20 4:31
Memberand180y29-Jun-20 4:31 
AnswerRe: Http 500 error with register page Pin
ZurdoDev29-Jun-20 4:33
mveZurdoDev29-Jun-20 4:33 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 4:45
Memberand180y29-Jun-20 4:45 
GeneralRe: Http 500 error with register page Pin
ZurdoDev29-Jun-20 4:49
mveZurdoDev29-Jun-20 4:49 
AnswerRe: Http 500 error with register page Pin
Richard Deeming29-Jun-20 5:15
mveRichard Deeming29-Jun-20 5:15 
and180y wrote:
$sql = "INSERT INTO users (email, username, password) VALUES (?, ?)";
...
mysqli_stmt_bind_param($stmt, "ss", $param_email, $param_username $param_password);
Two obvious problems:

You're inserting into three columns, but you've only specified two values:
$sql = "INSERT INTO users (email, username, password) VALUES (?, ?, ?)";
You've only specified types for two parameters, and you're missing a comma between the last two parameters:
mysqli_stmt_bind_param($stmt, "sss", $param_email, $param_username, $param_password);




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 5:21
Memberand180y29-Jun-20 5:21 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 7:40
Memberand180y29-Jun-20 7:40 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan29-Jun-20 9:36
mveRichard MacCutchan29-Jun-20 9:36 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 12:37
Memberand180y29-Jun-20 12:37 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan29-Jun-20 21:44
mveRichard MacCutchan29-Jun-20 21:44 
GeneralRe: Http 500 error with register page Pin
and180y1-Jul-20 8:03
Memberand180y1-Jul-20 8:03 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan1-Jul-20 9:10
mveRichard MacCutchan1-Jul-20 9:10 
GeneralRe: Http 500 error with register page Pin
and180y1-Jul-20 9:42
Memberand180y1-Jul-20 9:42 
GeneralRe: Http 500 error with register page Pin
and180y1-Jul-20 13:11
Memberand180y1-Jul-20 13:11 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan1-Jul-20 22:37
mveRichard MacCutchan1-Jul-20 22:37 
GeneralRe: Http 500 error with register page Pin
and180y20hrs 19mins ago
Memberand180y20hrs 19mins ago 
QuestionReporting data Pin
Joan M19-Jun-20 10:03
professionalJoan M19-Jun-20 10:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.