Why does not insert these values in database using Ajax

Question

I used tutorialspoint to guide me to insert the values from input text into the db, but unfortunately, it will not insert to the database. Is this correct implementation for AJAX?

Here's my index.php

<html>
<body>

<script language="javascript" type="text/javascript">
<!-- 
//Browser Support Code
function ajaxFunction(){
   var ajaxRequest;  // The variable that makes Ajax possible!
   try{

      // Opera 8.0+, Firefox, Safari
      ajaxRequest = new XMLHttpRequest();
   }catch (e){

      // Internet Explorer Browsers
      try{
         ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
      }catch (e) {

         try{
            ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
         }catch (e){

            // Something went wrong
            alert("Your browser broke!");
            return false;
         }
      }
   }

   // Create a function that will receive data
   // sent from the server and will update
   // div section in the same page.
   ajaxRequest.onreadystatechange = function(){

      if(ajaxRequest.readyState == 4){
         var ajaxDisplay = document.getElementById('ajaxDiv');
         ajaxDisplay.innerHTML = ajaxRequest.responseText;
      }
   }


   // Now get the value from user and pass it to
   // server script.
   var fname = document.getElementById('fname').value;
   var lname = document.getElementById('lname').value;
   var gen = document.getElementById('gen').value;
  // var queryString = "?age=" + age ;

    queryString +=  "&fname=" + fname + "&lname=" + lname+ "&gen=" + gen;
   ajaxRequest.open("GET", "ajax.php" + queryString, true);
   ajaxRequest.send(null); 
}
//-->
</script>

<form name='myForm'>

   First Name: <input type='text' id='fname' /> <br />
   Last Name: <input type='text' id='lname' /> <br />
   Sex: 
   <select id='gen'>
      <option value="m">m</option>
      <option value="f">f</option>
   </select>
   <input type='button' onclick='ajaxFunction()' value='Query MySQL'/>

</form>
<div id='ajaxDiv'>Your result will display here</div>
</body>
</html>

ajax.php

<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "my_db";


$con =  new mysqli($dbhost, $dbuser, $dbpass,$dbname);


$query="INSERT INTO table1 (fname, lname, gender)
VALUES
('$_GET[fname]','$_GET[lname]','$_GET[gen]')";

$qry_result = $con->query($query);


?>

Vishal Wadhawan · Accepted Answer · 2015-02-21 07:39:10Z

1

change your code to the bellow

var queryString;

queryString =  "fname=" + fname + "&lname=" + lname+ "&gen=" + gen;

ajaxRequest.open("GET", "ajax.php?" + queryString, true);

and make sure ajax.php is in the same folder as index.php

edited Feb 21, 2015 at 7:39

answered Feb 21, 2015 at 7:08

Vishal Wadhawan

1,0851 gold badge9 silver badges11 bronze badges

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

10 Comments

Sume-mase Over a year ago

Sir, It says, OBJECT NOT FOUND. :?

Vishal Wadhawan Over a year ago

you have not declared the javascript variable... define it as : var queryString and then attach the values to send it

Sume-mase Over a year ago

Sir, I did, I tried to declare it but same as result

Vishal Wadhawan Over a year ago

are you using jquery ? then I can help you with the jquery ajax answer which would be working 100%

Sume-mase Over a year ago

Thanks. but Jquery and Ajax are not the same right? I try to google the JQuery, it works, but in Ajax, it seemed do not work. But thanks.

|

Andrew LaPrise · Accepted Answer · 2015-09-16 19:58:54Z

1

Try this in ajax.php:

$fname=$_GET['fname'];
$lname=$_GET['lname'];
$gen=$_GET['gen'];

$query="INSERT INTO table1 ('fname', 'lname', 'gender')
        VALUES('$fname','$lname','$gen')";

edited Sep 16, 2015 at 19:58

Andrew LaPrise

3,4334 gold badges34 silver badges51 bronze badges

answered Sep 16, 2015 at 19:30

jon_spades

315 bronze badges

Comments

Murtaza Khursheed Hussain · Accepted Answer · 2015-02-21 07:02:11Z

0

Declare Form method="POST"

and

$query="INSERT INTO table1 (fname, lname, gender) VALUES
('".$_POST['fname']."','".$_POST['lname']."','".$_POST['gen']."')";

edited Feb 21, 2015 at 7:02

Murtaza Khursheed Hussain

15.4k7 gold badges62 silver badges83 bronze badges

answered Feb 21, 2015 at 6:53

Arun

7605 silver badges12 bronze badges

Collectives™ on Stack Overflow

Why does not insert these values in database using Ajax

Here's my index.php

ajax.php

3 Answers 3

10 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Here's my index.php

ajax.php

3 Answers 3

10 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related