display error message after submitting a form

Sam

i have a registration form in which i have placed a check on email id and status so that a person cannot signup again with the same email. Both the form and script are on a single page and the page is in .php format. The problem is that although the check works fine but i am not able to display an error message in front of email box. would appreciate if someone could help me

<form role="form" action="" autocomplete="off" method="POST">

    <div class="input-group">
        <span class="input-group-addon"><i class="fa fa-user"></i></span>
            <input type="name" class="form-control" name="name" placeholder="Company Name" required>
    </div>
    <span class="help-block"></span>

    <div class="input-group">
        <span class="input-group-addon"><i class="fa fa-user"></i></span>
            <input type="email" class="form-control" name="email" placeholder="email address" required>
    </div>
    <span><?php echo $errormsg;?></span>

    <div class="input-group">
        <span class="input-group-addon"><i class="fa fa-lock"></i></span>
            <input  type="password" class="form-control" name="password" placeholder="Password" required>
    </div>
    <span class="help-block"></span>

    <div class="input-group">
        <span class="input-group-addon"><i class="fa fa-user"></i></span>
            <input type="tel" id="tel" class="form-control" name="phoneno" pattern="\d{10}" placeholder="Please enter a ten digit phone number" required />
    </div>
    <span class="help-block"></span>
    <input class="form-control" value="" type="hidden" name="status">

    <button class="btn btn-lg btn-primary btn-block" name="submit" type="submit">Sign Up</button>

</form>

<?php
$con=mysqli_connect("localhost","root","","db");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// escape variables for security
$name = mysqli_real_escape_string($con, $_POST['name']);
$email = mysqli_real_escape_string($con, $_POST['email']);
$password = mysqli_real_escape_string($con, $_POST['password']);
$phoneno = mysqli_real_escape_string($con, $_POST['phoneno']);
$status = mysqli_real_escape_string($con, $_POST['status']);

$sql = "SELECT * FROM register WHERE email='".$email."' AND status='1'";
$result = mysqli_query($con, $sql); 
if (mysqli_num_rows($result) > 0)
{
    $errormsg="email already exist";
}
else
{
    $sql="INSERT INTO register (name,email,password,phoneno,status) VALUES ('$name','$email','$password','$phoneno','1')";
    if (!mysqli_query($con,$sql)) 
    {
        die('Error: ' . mysqli_error($con));
    }
    exit;
    mysqli_close($con);
}
?>
Ashique C M

If all code is in single file then you shift the PHP code above the html code, why the error is not showing the html is rendering first before executing the PHP code? i.e:

<?php
$con=mysqli_connect("localhost","root","","db");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// escape variables for security
$name = mysqli_real_escape_string($con, $_POST['name']);
$email = mysqli_real_escape_string($con, $_POST['email']);
$password = mysqli_real_escape_string($con, $_POST['password']);
$phoneno = mysqli_real_escape_string($con, $_POST['phoneno']);
$status = mysqli_real_escape_string($con, $_POST['status']);

$sql = "SELECT * FROM register WHERE email='".$email."' AND status='1'";
$result = mysqli_query($con, $sql); 
if (mysqli_num_rows($result) > 0)
    {
        $errormsg="email already exist";
    }
else{
$sql="INSERT INTO register (name,email,password,phoneno,status) VALUES ('$name','$email','$password','$phoneno','1')";
        if (!mysqli_query($con,$sql)) 
            {
                die('Error: ' . mysqli_error($con));
            }
        exit;
mysqli_close($con);
}
?>
<form role="form" action="" autocomplete="off" method="POST">

    <div class="input-group">
        <span class="input-group-addon"><i class="fa fa-user"></i></span>
            <input type="name" class="form-control" name="name" placeholder="Company Name" required>
    </div>
    <span class="help-block"></span>

    <div class="input-group">
        <span class="input-group-addon"><i class="fa fa-user"></i></span>
            <input type="email" class="form-control" name="email" placeholder="email address" required>
    </div>
    <?php echo $errormsg;?></span>

    <div class="input-group">
        <span class="input-group-addon"><i class="fa fa-lock"></i></span>
            <input  type="password" class="form-control" name="password" placeholder="Password" required>
    </div>
    <span class="help-block"></span>

    <div class="input-group">
        <span class="input-group-addon"><i class="fa fa-user"></i></span>
            <input type="tel" id="tel" class="form-control" name="phoneno" pattern="\d{10}" placeholder="Please enter a ten digit phone number" required />
    </div>
    <span class="help-block"></span>
    <input class="form-control" value="" type="hidden" name="status">

    <button class="btn btn-lg btn-primary btn-block" name="submit" type="submit">Sign Up</button>

</form>

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Display custom message after submitting a Google Form

How to display alert message after submitting form

Not able to display message after submitting form using ajax

Display validation message on submitting the form in Angularjs

React displaying message after submitting the form

localStorage page does not display after submitting form

How do I get errors which are handled serverside in a ajax error message after submitting a form?

"Missing Template" error after submitting a form

Pop-up message after submitting a form with php

How to add message after submitting form? PHP, Wordpress

How to get the sucess message in the same page after submitting the contact form?

After submitting form its showing success message on different page

How to add a success message after submitting Word form?

How to get the success message in the same page after submitting the form?

Display form error message on form page

Append table with jQuery after submitting form does not display

How to display result from two states after submitting a form

html5 validation error message without submitting form

Form clears after submitting

Display Message on page after form submitted

Form not submitting after form validation

how to clear validation errors for mat error after submitting the form

Laravel error after submitting form by hitting the Enter key

"Method Not Allowed" error in Flask after submitting form data

internal server error after submitting a form flask,sqlite3

error with submitting a form in wordpress

How to display an error message within the form

Rails Form_with display inline error message

Display error message after redirecting with header function

TOP Ranking

  1. 1

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  2. 2

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  3. 3

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  4. 4

    pump.io port in URL

  5. 5

    Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

  6. 6

    BigQuery - concatenate ignoring NULL

  7. 7

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  8. 8

    ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

  9. 9

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  10. 10

    How to remove the extra space from right in a webview?

  11. 11

    java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

  12. 12

    Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

  13. 13

    flutter: dropdown item programmatically unselect problem

  14. 14

    How to use merge windows unallocated space into Ubuntu using GParted?

  15. 15

    Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

  16. 16

    Nuget add packages gives access denied errors

  17. 17

    Svchost high CPU from Microsoft.BingWeather app errors

  18. 18

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  19. 19

    12.04.3--- Dconf Editor won't show com>canonical>unity option

  20. 20

    Any way to remove trailing whitespace *FOR EDITED* lines in Eclipse [for Java]?

  21. 21

    maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

HotTag

Archive