Click here to Skip to main content
14,605,926 members
   

Database

 
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 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu15-Jul-20 23:44
Memberkali siddhu15-Jul-20 23:44 
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
and180y2-Jul-20 4:57
Memberand180y2-Jul-20 4:57 
QuestionReporting data Pin
Joan M19-Jun-20 10:03
professionalJoan M19-Jun-20 10:03 
AnswerRe: Reporting data Pin
Mycroft Holmes19-Jun-20 12:25
professionalMycroft Holmes19-Jun-20 12:25 
GeneralRe: Reporting data Pin
Joan M20-Jun-20 1:11
professionalJoan M20-Jun-20 1:11 
GeneralRe: Reporting data Pin
David Mujica22-Jun-20 4:27
MemberDavid Mujica22-Jun-20 4:27 
GeneralRe: Reporting data Pin
Joan M22-Jun-20 8:40
professionalJoan M22-Jun-20 8:40 
Questionhow to create relationship between tables based on field Pin
Cenator13-Jun-20 2:12
MemberCenator13-Jun-20 2:12 

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.