PHP Forms not inserting data in MySQL

Question

I'm having trouble with data not saving to a table, I've got the following code in a file called Register.php, I have enabled error_reporting to see any errors, but none are showing. My database is called Registration and the table is called users and is being hosted on GoDaddy

<?php
require 'Connections/Connections.php';
?>

<?php
if(isset($_Post['Register'])) {

    session_start();
    $FName = $_POST['First_Name'];
    $LName = $_POST['Last_Name'];
    $Username = $_POST['Username'];
    $Email = $_POST['Email'];
    $PW = $_POST['Password'];

    $sql = $con->query("INSERT INTO users (Fname, Lname, Username, Email, Password)Values('{$Fname}', '{$LName}', '{$Username}', '{$Email}', '{$PW}')");

}
?>

<!doctype html>
<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8'/>
<link href="Style/Master.css" rel="stylesheet" type="text/css" />
<title>Register</title>
</head>
<body>
<form action="" method="post" name="RegisterForm" id="RegisterForm">

    <div class="FormElement">
        <input name="First_Name" type="text" required="required"    class="TField" id="First_Name" placeholder="First Name">
    </div>

    <div class="FormElement">
        <input name="Last_Name" type="text" required="required" class="TField" id="Last_Name" placeholder="Last Name">
    </div>

    <div class="FormElement">
        <input name="Username" type="text" required="required" class="TField" id="Username" placeholder="Username">
    </div>

    <div class="FormElement">
        <input name="Email" type="text" required="required" class="TField"   id="Email" placeholder="Email">
    </div>

    <div class="FormElement">
        <input name="Password" type="text" required="required" class="TField" id="Password" placeholder="Password">
    </div>

    <div class="FormElement">
        <input name="Register" type="submit" class="button" id="Register"        placeholder="Register">
    </div>
</body>
</html>

This is the code in the Connections.php just without my real username and password

<?php

$con = mysql_connect("localhost", "USERNAME", "PASSWORD", "Registration");

?>

Any help would be very much appreciated!

update -- "INSERT INTO users (Fname, Lname, Username, Email, Password)Values('$Fname', '$LName', '$Username', '$Email', '$PW')" — CodeLove
– CodeLove, Commented Nov 6, 2015 at 12:20
you are using procedural style and object oriented style..... !!!!!!! — CodeLove
– CodeLove, Commented Nov 6, 2015 at 12:22
PHP is case sensitive. $_POST needs to be in capitals. You have if(isset($_Post['Register'])) — ImClarky
– ImClarky, Commented Nov 6, 2015 at 12:24

Abdul Razak · Accepted Answer · 2015-11-06 12:28:28Z

0

You need to edit the Connection.php

mysql_connect("localhost", "USERNAME", "PASSWORD"); 
mysql_select_db("Registration");  //your data base name

And also you have to edit

 mysql_query("INSERT INTO users (Fname, Lname, Username, Email, Password)Values('$Fname', '$LName', '$Username', '$Email', '$PW')") or die(mysql_error());

answered Nov 6, 2015 at 12:28

Abdul Razak

2,7992 gold badges20 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Matthew Ralston Over a year ago

Working now, Thank you very much!

RiggsFolly Over a year ago

Please dont use the mysql_ database extension, it is deprecated (gone for ever in PHP7) Specially if you are just learning PHP, spend your energies learning the PDO database extensions. Start here its really pretty easy

Arvind Jaiswal · Accepted Answer · 2015-11-06 12:21:23Z

0

Try this

mysql_query("INSERT INTO users (Fname, Lname, Username, Email, Password)Values('$Fname', '$LName', '$Username', '$Email', '$PW')") or die(mysql_error());

answered Nov 6, 2015 at 12:21

Arvind Jaiswal

4425 silver badges14 bronze badges

1 Comment

RiggsFolly Over a year ago

Please dont use the mysql_ database extension, it is deprecated (gone for ever in PHP7) Specially if you are just learning PHP, spend your energies learning the PDO database extensions. Start here its really pretty easy

Collectives™ on Stack Overflow

PHP Forms not inserting data in MySQL

2 Answers 2

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Linked

Related