This question already has an answer here:
I have searched on here for this same question being asked and found many answers that did not fix my error at all and usually just created more :P Here is the full error
Warning: mysqli_error() expects exactly 1 parameter, 0 given in F:\Jacob's Project rehashegister.php on line 54.
and here is the entire PHP page that it inhabits:
<!DOCTYPE html> <html> <head> <title>Membership Confirmation</title> <script type='text/javascript' src='gen_validatorv31.js'></script> </head> <body> <h1></h1> <p>Thank for your membership support!</p> <br> <?php //assign connection details to PHP variables $servername="localhost"; $username="root"; $password=""; $database="bryanbook"; //connect to the database server and select Bryanbook database $link=mysqli_connect($servername,$username,$password,$database); //check for successful connection if (mysqli_connect_error()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } //assign values submitted by HTML form to PHP variables $email = $_POST['email']; $firstname = $_POST['firstname']; $surname = $_POST['surname']; $addressline1 = $_POST['addressline1']; $password = $_POST['password']; $towncity = $_POST['towncity']; $postcode = $_POST['postcode']; $favouritecolour = $_POST['favouritecolour']; $likes = $_POST['likes']; $dislikes = $_POST['dislikes']; //create query to add member details to database $query = "INSERT INTO users (email,password,firstname,surname,`address line 1`,town/city,postcode,`fave colour`,likes,dislikes) VALUES ('$email','$password','$firstname','$surname','$addressline1','$towncity','$postcode','$favouritecolour','$likes','$dislikes')"; //execute SQL query to add details to the member table $data = mysqli_query($link, $query)or die(mysqli_error()); <------- Line 54 //check that query has been successful if($data) { //display message to notify user that details have been added echo "Your registration has been successful"; } //close server connection mysqli_close($link); //exit PHP ?> <br> <p><a href="Home Page.html">Click here to return to the Home Page</a></p> </body> </html>
</div>
