Inserting data into mysql database using PHP gets an error

Question

0.00/5 (No votes)

See more:

I am trying to insert data from a HTML form and PHP script to a MySQL Database.

I am able to connect to the MySQL server from the script but I cannot connect to the Database and table. So that I cannot insert data.

The error that triggers from the PHP script. The error is : Database is not selected !. But I have declared the name correctly.

Here I have uploaded the full solution .

Below I have added the HTML form and the PHP Script.

Could you please try to solve the issue if possible.

What I have tried:

HTML Form

<html>
<head>
    <title>Registration Form</title>
</head>
<body>
    <br>
    <h2 align="center">Register a new customer</h2>
    <h3 align="center">Fill all fields</h3>
    <form action="insertdata.php" method="post">
        <table align="center">
            <tbody><tr>
                <td>First Name:</td>
                <td><input type="text" id="fname" name="fname" /></td>
            </tr>
            <tr>
                <td>Middle Name:</td>
                <td><input type="text" id="mname" name="mname" /></td>
            </tr>
            <tr>
                <td>Last Name:</td>
                <td><input type="text" id="lname" name="lname" /></td>
            </tr>
            <tr>
                <td>NIC / Driving License No:</td>
                <td><input type="text" id="NICNo" name="nicno" /></td>
            </tr>
            <tr>
                <td>Permanent Address Name:</td>
                <td><input type="text" id="paddress" name="paddress" /></td>
            </tr>
                <tr>
                <td>E-Mail Address:</td>
                <td><input type="text" id="email" name="email" /></td>
            </tr>
                <tr>
                <td>Telephone:</td>
                <td><input type="text" id="telno" name="telno" /></td>
            </tr>
            <tr>
                <td>Mobile No:</td>
                <td><input type="text" id="mobileno" name="mobileno" /></td>
            </tr>
                <tr>
                <td>Date of Registration:</td>
                <td><input type="text" id="regdate" name="regdate" /></td>
            </tr>
                <tr><td></td></tr>
                <tr><td></td></tr>
                <tr><td></td></tr>
                <tr><td></td></tr>
                <tr><td></td></tr>
                <tr><td></td></tr>
            <tr>
            <td align="center"><input type="submit" />     <input type="reset" /></td>

            </tr>
        </tbody></table>
    </form>

  </body>

InsertData.php

PHP

<?php

$dbserver = 'localhost';
$username = 'root';
$password = '';

$dbname = 'car_rental';

$con = mysqli_connect($dbserver, $username, $password);

if(!$con)
{
    echo "Not connected to server !";
   
    
}else{
    echo "Server connected !";
 
}

if(!mysqli_select_db($con, $dbname));
{
    echo "Database not selected !";
   
}

$fname = $_POST["fname"];
$mname = $_POST["mname"];
$lname = $_POST["lname"];
$nicno = $_POST["nicno"];
$paddress = $_POST["paddress"];
$email = $_POST["email"];
$telno = $_POST["telno"];
$mobileno = $_POST["mobileno"];
$regdate = $_POST["regdate"];

$sql = "INSERT INTO new_customers (FirstName, MiddleName, LastName, NICNo, PermanentAddress, EmailAddress, Telephone, Mobile, RegDate) VALUES ('$fname','$mname','$lname','$nicno','$paddress','$email','$telno','$mobileno','$regdate')";

if (!mysqli_query($con,$sql))
{
    echo "Data not inserted !";
   
}
else
{
    echo "Data inserted !";
}

header("refresh:300; url=form.php");

?>

Thanks!

Posted 4-Nov-16 23:44pm

Chiranthaka Sampath

Updated 5-Nov-16 1:27am

v3

Add a Solution

Comments

Mohibur Rashid 5-Nov-16 5:46am

try calling the function mysqli_select_db

Chiranthaka Sampath 5-Nov-16 6:00am

Hi Rashid,

Thanks for the tip but I have already declared mysqli_select_db() function. Please refer the 'InsertData.php'

Peter Leow 5-Nov-16 7:39am

Have your verified that this 'car_rental' database does exist?

Mohibur Rashid 5-Nov-16 9:31am

instead of echo "database not selected !" call mysqli_error as CPallini suggested. Also, your message is not correct. But my guess will be same as Peter Leow, your database does not exists, or at least your database name spelling is wrong

Mohibur Rashid 9-Nov-16 0:40am

if it still does not work, just run this
mysqli_query($con, "USE $dbname"); and then use mysqli_error

same thing though.

also, let us know, how you have fixed them

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Answer 1 · 2016-11-05T01:27:00

Solution 1

I would call mysqli_error($con)) in order to get additional info.

Posted 5-Nov-16 1:27am

CPallini