0
    Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion
    Here is my simple code.

    // db.php code
    _______________________

    <?php

    //$con = mysqli_connect("localhost","root","","bakery");
    $db = mysqli_connect('localhost', 'root', '', 'bakery');

    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }

    ?>

-------------------------------------------------------------------------------
**//Sign up form in index.php**

<?php
                require('db.php');
                // If form submitted, insert values into the database.
                if (isset($_REQUEST['firstname'])){
                    $firstname = stripslashes($_REQUEST['firstname']); // removes backslashes
                    $firstname = mysqli_real_escape_string($con,$firstname); //escapes special characters in a string
                    $lastname = stripslashes($_REQUEST['lastname']); // removes backslashes
                    $lastname = mysqli_real_escape_string($con,$lastname); //escapes special characters in a string
                    $username = stripslashes($_REQUEST['username']); // removes backslashes
                    $username = mysqli_real_escape_string($con,$username); //escapes special characters in a string
                    $phonenumber = stripslashes($_REQUEST['phonenumber']); // removes backslashes
                    $phonenumber = mysqli_real_escape_string($con,$phonenumber); //escapes special characters in a string
                    $email = stripslashes($_REQUEST['email']);
                    $email = mysqli_real_escape_string($con,$email);
                    $password = stripslashes($_REQUEST['password']);
                    $password = mysqli_real_escape_string($con,$password);
                    $trn_date = date("Y-m-d H:i:s");

                            $query = "INSERT into `login` (firstname, lastname, username, phonenumber, email, password, trn_date) VALUES ('$firstname', '$lastname', '$username', '$phonenumber', '$email', '".md5($password)."', '$trn_date')";
                    $result = mysqli_query($con,$query);
                    if($result){
                            //echo "<div class='form'><h3>You are registered successfully.</h3><br/>Click here to <a href='login.php'>Login</a></div>";
                        header( 'Location: content.php' );
                    }
                }else{}
                ?>

   ----------------------------------------------------------
          **  // sign in form in index.php**

             <?php
                require('db.php');
                session_start();

                if($_POST['username'] == $username && $_POST['password'] == $password)
                    header( 'Location: content.php' );
                ?> 
2
Contributors
2
Replies
18
Views
9 Months
Discussion Span
Last Post by Ummu_2
0

Help us to help you. What error are you getting or what behavior are you seenig that you don't expect?

0

the button to submit the form seems not working. when i click the button to submit the form, it shows no response.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.