HTML form not sending data to MySQL using PHP

Question

I have a form in HTML, but it's not setup like normal I guess. I'll post the code form the HTML (PHP) file and the php to send it to the db.

<form action="upload.php" method="POST">
    <!-- Name input-->
    <div class="form-group">
      <label class="control-label" for="name">Name</label>
      <div class="">
        <input id="name" name="name" placeholder="First and Last Name" class="form-control input-md" type="text" required>
      </div>
    </div>
    <div class="form-group">
        <label class=" control-label" for="supportingDoc">Upload Supporting Documentation</label>
        <div class="">
            <input id="supportingDoc" name="supportingDoc" class="input-file" type="file" style="margin-top: .5em; margin-left: 4em;">
        </div>
    </div>
    <hr>
      <!-- Submit -->
      <div class="form-group">
        <label class="control-label" for="submit"></label>
        <div class="">
          <button value="Submit" type="submit" id="submit" name="submit" class="btn btn-danger" style="border-radius: 25px;">Submit</button>
        </div>
      </div>
</form>

Here is my SQL/PHP

<?php
    $servername = "localhost";
    $username = "xxx";
    $password = "xxx";
    $dbname = "xxx";
    // Create connection
    $con = mysqli_connect("localhost","xxx","xxx","xxx");
    // Check connection
    if (mysqli_connect_errno()){
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    if (isset($_REQUEST['name'])){
        // set variables

        $name = mysql_real_escape_string($_POST['name']);
        $supportingDoc = mysql_real_escape_string($_POST['supportingDoc']);

        $sql = "INSERT INTO `tablew` (name,  supportingDoc) VALUES ('$name', '$supportingDoc')";
        $result = mysqli_query($con,$sql);

        if ($con->query($sql) === TRUE) {
            echo "New record created successfully";
            printf("New record created successfully");
        } else {
            echo "Error: " . $sql . "<br>" . $con->error;
            printf("Error: " . $sql . "<br>" . $con->error);
        }

        $con->close();
    }
?>

I've tried all sorts of variations and nothing is showing in phpmyadmin. I've even replicated from a previous site I created and it still didn't work lol.

I see that there are variables for the login info and still put it in the mysqli, but I've been at this one thing for about 8 hours now and am out of juice, so hopefully someone sees what I messed up on.

Thanks in advance for any help everyone.

=========================================================================== UPDATE: I made all the changes mentioned above and now get this:

Warning: mysqli_connect(): (HY000/1049): Unknown database

I can see the database in phpmyadmin and Sequel Pro. I've also made sure to set the password and login to 'root'. My code is as follows for login:

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

and this is my POST:

if (isset($_REQUEST['submit'])){
// set variables
$name = mysqli_real_escape_string($con, $_POST['name']);
$sql = "INSERT INTO `wos` (name) VALUES ('$name')";
$result = mysqli_query($con,$sql);

1. mixing mysql_* with mysqli_* is not correct.2.Since you are using input type="file" so at php end check it through $_FILES. — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Dec 30, 2017 at 4:29
There are like dozen things wrong with this. Use of $_REQUEST, sql injections, outdated api, missing bits in html, strange connection objects, etc. and so on. And all the answers posted here are either incomplete or wrong. — tereško
– tereško, Commented Jan 8, 2018 at 22:28
eduonix.com/blog/web-programming-tutorials/… try this link — AmalJo
– AmalJo, Commented Jan 10, 2018 at 4:52

TBI · Accepted Answer · 2017-12-30 08:41:50Z

9

Following issues can be there:

Uploading error. Use enctype="multipart/form-data" in form tag.
Correct Mysql_connect details i.e. Username, Password, Dbname.
mysql_real_escape_string is depricated. Use mysqli.
Recheck your column names i.e. name, supportingDoc.

answered Dec 30, 2017 at 8:41

TBI

2,8091 gold badge19 silver badges22 bronze badges

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

Comments

Mr Hery · Accepted Answer · 2017-12-30 04:36:37Z

3

Your html code wrong. Whenever you want to use input type file, you need to put <form> tag to <form enctype="multipart/form-data">. If you re not declaring the enctype, then the PHP cannot read the file.

answered Dec 30, 2017 at 4:36

Mr Hery

8802 gold badges9 silver badges25 bronze badges

Comments

Avinash Gupta · Accepted Answer · 2018-01-03 04:54:43Z

2

+25

you have to put

<form enctype="multipart/form-data">

when uploading file . correct your html.

answered Jan 3, 2018 at 4:54

Avinash Gupta

3284 silver badges15 bronze badges

Comments

Naren Verma · Accepted Answer · 2017-12-30 05:22:32Z

1

Try This

The issue is after clicked on submit button it's not hitting the (isset($_REQUEST['name']))

Change it

if (isset($_REQUEST['submit'])){ //code here}

because you button name is submit.

Use SQL injection like

$con->real_escape_string($_POST['name']);

answered Dec 30, 2017 at 5:22

Naren Verma

2,3276 gold badges49 silver badges109 bronze badges

Comments

BjornIronside76 · Accepted Answer · 2018-01-01 20:32:28Z

1

for the unknown database error. I simply went to operations in phpmyadmin and changed the name of the database and it worked. give it a try if you haven't fixed the problem yet.

answered Jan 1, 2018 at 20:32

BjornIronside76

211 bronze badge

1 Comment

TomG103 Over a year ago

Still getting error stating database doesn't exist. I've made random names as well. I'm using Scotchbox, so not sure if that's an issue, but others post their vagrant files, but don't see why this is such an issue.

Diaa Saada · Accepted Answer · 2018-01-05 23:16:41Z

1

in addition to @tbi answer

Check php.ini for max post size it cause the POST request to fail if the size exceeds the size set in php.ini

post_max_size=20M upload_max_filesize=20M

check your SQL connection and your permissions on the DB
use enctype="multipart/form-data" in your form only when you need to upload files (for security reasons)
finally, don't forget to bind your post params to prevent SQL-Injection Params Binding

answered Jan 5, 2018 at 23:16

Diaa Saada

1,0561 gold badge12 silver badges22 bronze badges

Comments

Dee_wab · Accepted Answer · 2018-01-08 12:34:59Z

1

If you are using a default account on a local installation, then your connection code will probably look like this:
```
 <?php $con = mysqli_connect('localhost','root','');
              mysqli_select_db('epboarding', $con); ?>
```

use enctype="multipart/form-data" in form tag when you use file type.

  <form  name="" method="POST" action="" enctype="multipart/form-data">

3.change the following line

    if (isset($_REQUEST['name'])){

to

       if (isset($_REQUEST['submit'])){

correct the syntax when post data like mysql to mysqli.

answered Jan 8, 2018 at 12:34

Dee_wab

1,1631 gold badge10 silver badges23 bronze badges

Comments

Chris Moreton · Accepted Answer · 2018-01-08 16:02:23Z

1

From the PhpMyAdmin screenshot, it looks like the database is running on port 8889, meaning you would need:

$con = mysqli_connect("localhost","xxx","xxx","xxx", 8889);

answered Jan 8, 2018 at 16:02

Chris Moreton

111 bronze badge

1 Comment

tereško Over a year ago

He's not using mysqli ... which someone actually consider as a part of the problem.

gnusey · Accepted Answer · 2018-01-10 08:19:21Z

In addition to what the others have said, I thought I'd provide a tidied script and some (hopefully) useful resource for you other issues.

http://php.net/manual/en/mysqli.construct.php

What's wrong with using $_REQUEST[]?

https://www.w3schools.com/sql/sql_injection.asp

As for your unknown database error this is either your database doesn't exist, is incorrectly named in your PHP script or is unavailable through localhost.

$servername = "localhost";
$username = "xxx";
$password = "xxx";
$dbname = "xxx";

// Create connection
$conn = new mysqli ( $servername, $username, $password, $dbname );

// Check connection
if ( $conn->connect_error ) {
    echo "Failed to connect to MySQL: " . $conn->connect_error;
}

// Check if values are set with post rather than request, as this is deprecated and can output unexpected results
if ( isset( $_POST['name'] ) ) {
    // Set variables
    $name = $_POST['name'];
    $supportingDoc = $_POST['supportingDoc'];

    // Prepare a statement and bind parameters to prevent sql injection
    $stmt = $conn->prepare( "INSERT INTO `tablew` (name,  supportingDoc) VALUES (?, ?)" );
    $stmt->bind_param( 'sb', $name, $supportingDoc );

    if ( $stmt->execute() ) {
        echo "New record created successfully";
        printf( "New record created successfully" );
    } else {
        echo "Error: " . $stmt->error;
        printf( "Error: " . $stmt->error );
    }
    $stmt->close();
    $conn->close();
}

Collectives™ on Stack Overflow

HTML form not sending data to MySQL using PHP

9 Answers 9

Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related