Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <?php
- include ('db.php');
- /*
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "loginform";
- $conn = new mysqli($servername, $username, $password, $dbname);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- if(isset($_POST['login'])){
- $username = $_POST['name'];
- $pass = $_POST['password'];
- $sql = "SELECT * FROM users WHERE name ='$username' AND password ='$pass' ";
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- session_start();
- include('connection.php');
- $firstname=$_POST['firstname'];
- $lastname=$_POST['lastname'];
- $adress=$_POST['adress'];
- $username=$_POST['username'];
- $password=$_POST['password'];
- $tel=$_POST['tel'];
- mysqli_query ("INSERT INTO member (firstname, lastname, adress, username,"
- . " password, tel) VALUES ('$firstname', '$lastname', '$adress', "
- . "'$username', '$password', '$tel')");
- header ("location: index.php");
- mysqli_close($conn);
- }
- */
- if(isset($_POST['submit'])){
- $lastname = $_POST['lastname'];
- $firstname = $_POST['firstname'];
- $adress=$_POST['adress'];
- $tel=$_POST['tel'];
- $username=$_POST['username'];
- $password=$_POST['password'];
- $email=$_POST['email'];
- $columns='';
- $values='';
- foreach ($_POST as $key=>$value){
- $columns.=$key.',';
- $columns = trim(',',$columns);
- }
- $sql = "INSERT INTO register ($columns) VALUES ($values)";
- if ($conn->query($sql) === TRUE) {
- echo "New record created successfully";
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- }
- ?>
- <html>
- <head>
- <link rel="stylesheet" type="text/css" href="style.css">
- <meta charset="UTF-8">
- <title></title>
- </head>
- <body>
- <div class="container">
- <form method="POST" action="">
- <label for="fname"> First Name: </label> <br/>
- <input type="text" id="fname" name="firstname"> <br/>
- <label for="lname"> Last Name: </label> <br/>
- <input type="text" id="lname" name="lastname"> <br/>
- <label for="adress"> Adress: </label><br/>
- <input type="text" id="adress" name="adress"> <br/>
- <label for="username"> Username: </label><br/>
- <input type="text" id="username" name="username"> <br/>
- <label for="pass"> Password: </label> <br/>
- <input type="password" id="pass" name="password"> <br/>
- <label for="tel"> Tel: </label><br/>
- <input type="tel" id="tel" name="tel"> <br/>
- <label for="email"> Email: </label><br/>
- <input type="email" id="email" name="email"> <br/>
- <input type="submit" name="submit" value="Submit">
- </form>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement