I'm new to PHP ...... so I want to make a program in which my HTML form inputs are stored in the database. I followed a youtube tutorial to do this this and here is the code I have written for the php file `<?php
$firstname = $_POST ['firstname'] ;
$email = $_POST ['email'];
$admin = $_POST ['admin'];
$school = $_POST ['school'];
$gender = $_POST ['gender'] ;
//DATABASE CONECTION
$conn = new mysqli('localhost', 'root', '', 'register');
if ($conn-> connect_error){
die ('connection error : ' . $conn-> connect_error);
}else{
$stmt = $conn->prepare("INSERT INTO register(firstname, email, admin, gender)
values(?, ?, ?, ?, ?)");
$stmt-> bind_param("ssiss", $firstname, $email, $admin, $gender);
$stmt-> execute();
echo"Registration succesfull";
$stmt-> close();
$conn-> close();
}`
and here is my database
and my html code
<html>
<head>
<title>form</title>
</head>
<body>
<h1>
<div> <center>Trial form</center>
</h1>
<form action="connect.php" method="post">
<center> <label for="name"><b>enter name</b> </label> <br>
<input type="text" name="first name" id="firstname"> <br>
<br>
<label for="email"><b>email</b></label><br>
<input type="email" name="email" id="email"> <br>
<br>
<label for="admin no."><b> enter admin no. </b></label><br>
<input type="number" name="admin" id="admin"> <br>
<label for="school"><b>enter school name</b></label> <br>
<input type="text" name="school" id="school"> <br>
<label for="school"><b>Gender</b></label> <br>
<label for="male"> <input type="radio" name="gender" id="male" value="m"><b>male</b></label> <br>
<label for="female"><input type="radio" name="gender" id="female" value="f"><b>female</b></label><br>
<input type="submit" value="submit"><br>
</form> <center>
</div>
<body bgcolor="#fcba03">
<body text="#000000"
</body>
</html>
When I run it, the HTML form runs fine but the PHP program is just displayed on the screen without any output. pls help me thanks. to fix this i have tried rewriting the php code. i tried debugging the php code but this the error it gave me Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in C:\Users\Dell\connect.php on line 10 connection error : Access denied for user 'root'@'localhost' (using password: YES) (i used my mysql password to connect it) this is my html code while running enter image description here and this is my php code enter image description here i also keep getting this error
Fatal error: Uncaught Error: Call to a member function prepare() on bool in C:\Users\Dell\connect.php:14
Stack trace:
#0 {main}
thrown in C:\Users\Dell\connect.php on line 14
source https://stackoverflow.com/questions/70410564/php-code-not-connecting-html-to-mysql-database
Comments
Post a Comment