Skip to main content

PHP code not connecting HTML to MYsql database [closed]

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

enter image description here

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

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

How to show number of registered users in Laravel based on usertype?

i'm trying to display data from the database in the admin dashboard i used this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count(); echo $users; ?> and i have successfully get the correct data from the database but what if i want to display a specific data for example in this user table there is "usertype" that specify if the user is normal user or admin i want to user the same code above but to display a specific usertype i tried this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count()->WHERE usertype =admin; echo $users; ?> but it didn't work, what am i doing wrong? source https://stackoverflow.com/questions/68199726/how-to-show-number-of-registered-users-in-laravel-based-on-usertype
Post a Comment
Read more

Why is my reports service not connecting?

I am trying to pull some data from a Postgres database using Node.js and node-postures but I can't figure out why my service isn't connecting. my routes/index.js file: const express = require('express'); const router = express.Router(); const ordersCountController = require('../controllers/ordersCountController'); const ordersController = require('../controllers/ordersController'); const weeklyReportsController = require('../controllers/weeklyReportsController'); router.get('/orders_count', ordersCountController); router.get('/orders', ordersController); router.get('/weekly_reports', weeklyReportsController); module.exports = router; My controllers/weeklyReportsController.js file: const weeklyReportsService = require('../services/weeklyReportsService'); const weeklyReportsController = async (req, res) => { try { const data = await weeklyReportsService; res.json({data}) console...
Post a Comment
Read more

Confusion between commands.Bot and discord.Client | Which one should I use?

Whenever you look at YouTube tutorials or code from this website there is a real variation. Some developers use client = discord.Client(intents=intents) while the others use bot = commands.Bot(command_prefix="something", intents=intents) . Now I know slightly about the difference but I get errors from different places from my code when I use either of them and its confusing. Especially since there has a few changes over the years in discord.py it is hard to find the real difference. I tried sticking to discord.Client then I found that there are more features in commands.Bot . Then I found errors when using commands.Bot . An example of this is: When I try to use commands.Bot client = commands.Bot(command_prefix=">",intents=intents) async def load(): for filename in os.listdir("./Cogs"): if filename.endswith(".py"): client.load_extension(f"Cogs.{filename[:-3]}") The above doesnt giveany response from my Cogs ...
Post a Comment
Read more