<?php
session_start();
require_once 'conn.php';
if(isset($_POST['submit'])){
$path = 'files/';
$extention = pathinfo($_FILES['files']['name'],PATHINFO_EXTENSION);
$file_name = $_POST['fname'].'_'.date('YmdHis').','.$extention;
$files = (file_exists($_FILES['files']['tmp_name'])) ? $file_name : null;
$insert_data = [
'fname' => $_POST['fname'],
'lname' => $_POST['lname'],
'email' => $_POST['email'],
'password' => $_POST['password'],
'number' => $_POST['number'],
'gender' => $_POST['gender'],
'adderss' => $_POST['address'],
'state' => $_POST['state'],
'profile' => $files,
'hobbies' => implode(',',$_POST['hobbies'])
];
$conl = implode(',', array_keys($insert_data));
$values = implode("','", array_values($insert_data));
$sql = 'INSERT INTO form ($conl) VALUES ($values)';
$insert = $con->query($sql);
if ($insert) {
if (!is_null($files)) {
move_uploaded_file($_FILES['files']['tmp_name'],$path.$file_name);
};
echo "<div class='alert alert-success' role='alert'>
Data insert successfuly!</div>";
}else{
echo "<div class='alert alert-success' role='alert'>
Data insert failed!</div>";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Registration from</title>
<style type="text/css">
*{
margin: 0;
padding: 0;
}
nav{
width: 100%;
height: 5rem;
background: cyan;
}
.button a,button{
width: 7rem;
height: 2rem;
position: absolute;
top: 1rem;
right: 1rem;
font-size: 18px;
border: none;
}
nav div h1{
padding: 1rem;
font-size: 2rem;
font-family: 'poppins' sans-serif;
}
form{
margin-top: 2rem;
margin-left: 20rem;
padding: 3rem;
border: 1px solid green;
border-radius: 5px ;
width: 30rem;
}
.ff{
padding: 0;
}
form input{
padding-left: 1rem;
margin-top: 1rem;
}
.submit{
padding-top: 0px;
margin-top: 0px;
width: 9rem;
height: 2rem;
font-size: 18px;
background: skyblue;
border: none;
}
body{
background: lightgray;
}
</style>
</head>
<body>
<nav>
<div>
<h1>KANTA</h1>
<span class="button"><a href="Login.php"><button>LOGIN</button></a></span>
</div>
</nav>
<form action="Registration.php" method="POST" enctype="multipart/form-data">
<div class="ff">
<h1>Registration</h1>
<hr></div>
<label>First name : </label>
<input type="text" name="fname" required><br><br>
<label>Last name : </label>
<input type="text" name="lname"><br><br>
<label>E-mail</label>
<input type="email" name="email" required><br><br>
<label>Password</label>
<input type="password" name="password" required><br><br>
<label>Contact number</label>
<input type="tel" name="number" required><br><br>
<label>Gender:</label>
<input type="radio" name="gender" value="male" checked>Male
<input type="radio" name="gender" value="female">Female<br><br>
<label>Address</label><br>
<textarea name="address" cols="40" rows="5" placeholder="enter you address"></textarea><br><br>
<label>State</label>
<select required name="state">
<option>Andhra Pradesh</option>
<option>Arunachal Pradesh</option>
<option>Assam</option>
<option>Bihar</option>
<option>Chhattisgarh</option>
<option>Delhi</option>
<option>Goa</option>
<option>Gujarat</option>
<option>Haryana</option>
<option>Himachal Pradesh</option>
<option>Jharkhand</option>
<option>Karnataka</option>
<option>Kerala</option>
<option>Madhya Pradesh</option>
</select><br><br>
<label>Profile : </label>
<input type="file" name="files" required><br><br>
<label>Hobbies:</label><br>
Dance<input type="checkbox" name="hobbies[]"><br>
Coding<input type="checkbox" name="hobbies[]"><br>
Music<input type="checkbox" name="hobbies[]"><br><br>
<div class="left submit">
<input type="submit" name="submit" value="submit" class="submit">
</div>
</form>
</body>
</html>
you have to upload conn.php cou’z this file having the connecction of database the errror is in conn.php thats why database connection failed