How do I send data from my javascript/php code to mySQL server?

Question

I'm having major problems uploading data to mySQL server, and have no clue how to go about it. I have searched up solutions and this is my current attempt:

function documentReady(){
      $.ajax({
        type: "POST",
        url: "/phpServerContent.php",
        data: {CollegeID: simData.userID, FirstName: "Bob", LastName: "Smith", ClassID: simData.userClassSelected},
        cache: false,
        success: function(html){
        } 
      });
};

and this is my PHP:

 <?php
 mysql_connect("localhost","root");
  mysql_select_db("userdatagravsim");
  $result_set=mysql_query("SELECT*FROM users");
  $num_messages=mysql_num_rows($result_set);


   $CollegeID=$_POST["CollegeID"];
   $FirstName=$_POST["FirstName"];
   $LastName=$_POST["LastName"];
   $ClassID=$_POST["ClassID"];

   $query=mysql_query("INSERT INTO users(CollegeID,FirstName,LastName,ClassID)values('$name','$guessnum','$taskid','$effort')");

   if($query){
      echo "Your comment has been sent";
      }
   else{
      echo "Error in sending your comment";
       }

    ?>

I'm very new to programming, this is for A-level coursework. I am also unsure about how to view the echo flags to indicate if the upload has worked or not.

SELECT*FROM, let it breathe and put some spaces there. And where do you get your javascript variables from? — Qirel
– Qirel, Commented Mar 23, 2017 at 0:27
Where is your form? Do you get any errors on the page itself or in your console log? How do you get the data/variables to be used on your ajax? — Logan Wayne
– Logan Wayne, Commented Mar 23, 2017 at 0:35

toximorph · Accepted Answer · 2017-03-23 01:44:40Z

1

First of all, I recommend you not to use mysql_query as it's depreciated and risky.

I think the best way is to use PDO_MySql extension in order to connect to your database and to make request.

This is what you should do to my mind:

<?php       
    private static $dns = "mysql:host=localhost;dbname=userdatagravsim";
    private static $user ="root";
    private static $password = "";
    static $connexion =new PDO($dns, $user, $password);
?>

This code wil connext you to the database, yo can put it in a specific file (db_connect.php for example) and call it with require_once when you need to do request.

Now for the request:

<?php
    require_once 'path_to_db_connect.php';

    $request = $connect->prepare('INSERT INTO users(CollegeID,FirstName,LastName,ClassID) values(?,?,?,?);');
    //The ? will be replace when query will be execute
    $request->execute(array($name,$guessnum,$taskid,$effort));

    if(!$request){
        echo 'Error with INSERT';
    } 
    else {
        echo 'INSERT success';
    }
?>

Hope it helps !

answered Mar 23, 2017 at 1:44

toximorph

481 silver badge9 bronze badges

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

1 Comment

Ciaran Quigley Over a year ago

Besides a couple small changes, this helped amazingly! Thanks

Collectives™ on Stack Overflow

How do I send data from my javascript/php code to mySQL server?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related