Hi Guys when I click on the submit button on my register page I'm getting the following errors

Notice: Undefined variable: a in C:\xampp\htdocs\submit-form.php on line 3

Warning: mysql_select_db() expects parameter 2 to be resource, null given in C:\xampp\htdocs\submit-form.php on line 3

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\config.php on line 8
DB select failed: Unknown database 'database_name'

This is the code


ini_set('display_errors', true); // change to false when you go live

//Mysql Connect  |   mysql_connect("host= 3306","username","");
//Below example to connect in localhost
if($a == false) {
    die("Connect failed: ".mysql_error());
//select your database
if($b == false) {
    die("DB select failed: ".mysql_error());

This is the submit_form.php code

//select your database

//Database connection

//mysql query to insert value to database
$query=mysql_query("INSERT INTO registration (`firstname`, `lastname`, `username`, `confirmusername`, `password`, `confirmpassword`, `email` ,`confirmemail`) VALUES ('$firstname', '$lastname', '$username', '$password', '$confirmpassword', '$email' , '$confirmemail')");

//if value inserted successyully disply success message

    echo 'Registred successfully..!!</div>';
//error message
    echo '<unable to registred !!</div>';

Hope someone can help me, someone has suggested that i change sql to sqli

Recommended Answers

All 2 Replies

On this link you have example of mysql and mysqli...

Hope someone can help me, someone has suggested that i change sql to sqli

That person gave you very valuable advice. The original MySQL extension, which you're using, has been deprecated as of PHP 5.5. Development on the MySQL extension ended years ago. Even if you disregard the deprecation you should be aware that it is missing features that make it very worthwhile to convert for (chiefly parameterized statements. Your code is extremely vulnerable to SQL injection attacks; parameterized statements are your solution.

As for your problem:


This is your problem. In submit_form.php you haven't declared a value for $a. You have in config.php, though. But you don't bring in config.php for over 10 more lines. Fix this by requiring config.php at the top of your script.

Also, you're declaring $b in config.php. No need to do it in submit_for.php as well.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.