CODEWITHSUNDEEP
phpmysqlwamp
Pawan
Pawan

Reputation: 55

Having trouble while receiving data in database

I am trying trying to receive data by making a html form and then adding receiving data by $_GET method.Whenever I try to submit my data I get an error saying 'Your file was not found' in my chrome browser,so I tried opening my php page in chrome by typing "localhost/...." in my address bar and there it was displaying 'Database NOT Found'

here is my php code:-

<html>
<?php


$user_name = "root";
$password = "";
$database = "mysql"; //mysql is name of my database
$server = "localhost";

$db_handle = mysql_connect($server , $user_name, $password,"addresbook");      //adressbook is where all the tabels are
$db_found = mysql_select_db($database, $db_handle);


if (!$db_found) {

print "Database Found ";
$x=$_GET['fname'];
$y=$_GET['sname'];
$z=$_GET['address'];

$sql="INSERT INTO addresbook(First_Name,Surname,Address)     VALUES('".$x."','".$y."','".$z."')";
mysql_query($sql,$db_handle);

}
else {

print "Database NOT Found ";

}

?>
</html>

here is mt html code:-

<form action="practic.php"method="get">
Firstname:<input type="text" name="fname"><br>
Lastname:<input type="text" name="sname"><br>
Address:<input type="text" name="address"><br>
<input type="submit">
</form>

btw i am using wamp server.Thanks in advance.

Upvotes: 1

Views: 81

Answers (3)

Junius L
Junius L

Reputation: 16152

Hi change your code to use MysqLi or use PDO

<?php


$user_name = "root";
$password = "";
$database = "mysql"; //mysql is name of my database
$server = "localhost";

$con =   mysqli_connect($server,$user_name,$password,'adresbook');//adresbook is where all the tabels are
// Check connection
if (mysqli_connect_errno())
{
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  exit();
}
// Change database to "adresbook"
$db_found = mysqli_select_db($con,'adresbook');


if ($db_found) {

print "Database Found ";
$x=$_GET['fname'];
$y=$_GET['sname'];
$z=$_GET['address'];

$sql="INSERT INTO addresbook(First_Name,Surname,Address)     VALUES('".$x."','".$y."','".$z."')";
mysqli_query($con, $sql);

}
else {

    print "Database NOT Found ";

}

?>

Your phpMyadmin should look like this with the database addresbook with a single s.

enter image description here

Upvotes: -1

chorn
chorn

Reputation: 150

$db_found will be true on success, so your condition should be

if ($db_found) { // make DB changes etc.

and switch to MySQLi or PDO and use prepared statements as already mentioned, refer to the manual:

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

Upvotes: 3

AbuHuraira Lakdawala
AbuHuraira Lakdawala

Reputation: 786

use mysqli_connect because mysql_connect is now deprecated.

$db_handle = mysqli_connect($server , $user_name, $password,$database);

refer here for connection

http://www.w3schools.com/php/func_mysqli_connect.asp

Upvotes: -1

Related Questions