Pikatucy

Thank you so much!

I'm trying to pass id parameter into this query $insertuserquery = ("INSERT INTO users (id, username, hash, salt, fname, lname, email) VALUES ('".$id."','".$username."', '".$hash."', '".$salt."', '".$fname."', '".$lname."', '".$email."');"); but the problem is i have to increment the id by 1 every time i submit the query and i don't really know how to do it! $id = "SELECT id FROM users"; $id+1;

My primary key is "id" it's defined as primary key

[19-Jun-2022 13:18:58 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate entry '0' for key 'PRIMARY' in /home/stpclima/public_html/vexie/registerer.php:35 Stack trace: #0 /home/stpclima/public_html/vexie/registerer.php(35): mysqli_query(Object(mysqli), 'INSERT INTO use...') #1 {main} thrown in /home/stpclima/public_html/vexie/registerer.php on line 35

As I'm using PHP via my hosting panel "CPanel", I'm unable to use that extension. @mac_gyver 😕 Give me that fish haha I'm unable to learn how to catch it at this moment. Maybe in the future, Ill be learning it seriously Kind regards,

Thank you @Barand, @mac_gyver for your replies and your time The problem has been resolved, there was a logic error in queries. anyway I'm facing a new error and I don't know how to solve it $insertuserquery = "INSERT INTO users (username, hash, salt, fname, lname, email) VALUES ('$username', '$hash', '$salt', '$fname', '$lname', '$email')"; mysqli_query($con, $insertuserquery) or die ("4: Insert player query failed"); Error statement: "4: Insert player query failed" I have other columns inserted into users such as balance, score, etc... but I set the default value for them as 0, should they be defined in the quoted statement above?

Thank you for your time and your replies the first error has been resolved Here's my last code <?php $con = mysqli_connect('localhost','root','root','stpclima_vexie'); if(mysqli_connect_errno()) { echo "1"; exit(); } $username = $_POST["name"]; $fname = $_POST["fname"]; $lname = $_POST["lname"]; $email = $_POST["email"]; $password = $_POST["password"]; $namecheckquery = "SELECT username from users WHERE username '$username' ;"; $emailcheckquery = "SELECT email from users WHERE email '$email' ;"; $namecheck = mysqli_query($con, $namecheckquery) or die("2: Name check query failed"); $emailcheck = mysqli_query($con, $emailcheckquery) or die("2.1: Email check query failed"); if(mysqli_num_rows($namecheck) > 0) { echo "3: Name already exists"; exit(); } if(mysqli_num_rows($emailcheck) > 0) { echo "3.1: email already exists"; exit(); } //adding user to the table $salt = "\$5\$rounds=5000\$" . "steamedhams" . $username . "\$"; $hash = crypt($password, $salt); $insertuserquery = "INSERT INTO users (username, hash, salt, fname, lname, email) VALUES ('$username', '$hash', '$salt', '$fname', '$lname', '$email')"; mysqli_query($con, $insertuserquery) or die ("4: Insert player query failed"); echo("0"); ?> I'm getting an error on this page "2: Name check query failed" https://stp-climatechange.net/vexie/registerer.php @Barand

@Barand

Hello, Thank you for your reply <?php $con = mysqli_connect('localhost','root','root','users'); if(mysqli_connect_errno()) { echo "1"; exit(); } $username = $_POST["name"]; $fname = $_POST["fname"]; $lname = $_POST["lname"]; $email = $_POST["email"]; $password = $_POST["password"]; $namecheckquery = "SELECT username from users WHERE username'" . $username . "';"; $emailcheckquery = "SELECT email from users WHERE email'" . $email . "';"; $namecheck = mysqli_query($con, $namecheckquery) or die("2: Name check query failed"); $emailcheck = mysqli_query($con, $emailcheckquery) or die("2.1: Email check query failed"); if(mysqli_num_rows($namecheck) > 0) { echo "3: Name already exists"; exit(); } if(mysqli_num_rows($emailcheck) > 0) { echo "3.1: email already exists"; exit(); } //adding user to the table $salt = "\$5\$rounds=5000\$" . "steamedhams" . $username . "\$"; $hash = crypt($password, $salt); $insertuserquery = "INSERT INTO users (username, hash, salt, fname, lname, email) VALUES ('".$username"' , '".$hash"' , '".$salt"' , '".$fname"' , '".$lname"' , '".$email"');"; mysqli_query($con, $insertuserquery) or die ("4: Insert player query failed"); echo("0"); ?> still getting an error on $insertuserquery syntax error T_CONSTANT_ENCAPES_STRING can anyone please fix it

<?php $con = mysqli_connect('localhost','root','root','users'); if(mysqli_connect_errno()) { echo "1"; exit(); } $username = $_POST["name"]; $fname = $_POST["fname"]; $lname = $_POST["lname"]; $email = $_POST["email"]; $password = $_POST["password"]; $namecheckquery = "SELECT username from users WHERE username'" . $username . "';"; $emailcheckquery = "SELECT email from users WHERE email'" . $email . "';"; $namecheck = mysqli_query($con, $namecheckquery) or die("2: Name check query failed"); $emailcheck = mysqli_query($con, $emailcheckquery) or die("2.1: Email check query failed"); if(mysqli_num_rows($namecheck) > 0) { echo "3: Name already exists"; exit(); } if(mysqli_num_rows($emailcheck) > 0) { echo "3.1: email already exists"; exit(); } //adding user to the table $salt = "\$5\$rounds=5000\$" . "steamedhams" . $username . "\$"; $hash = crypt($password, $salt); $insertuserquery = "INSERT INTO users (username, hash, salt, fname, lname, email) VALUES ($username, $hash, $salt, $fname, $lname, $email);"; ?> Hello, What's wrong with $insertuserquery... I'm totally new to php Kind regardo