Jump to content
jdauthre

using php to retrieve data after updating mysql

Recommended Posts

I have a web site that lists students in a database on a server, and can add a students details. It then relists the students pulling the new list off the database.  All worked well until I transferred everything to a new webhost.   It still works to the point of relisting when I get the old list not the updated one. Checking the database(mysql) directly it has actually put the new student in. and if I log out of the web site and back in the new student's details are there.  how do get this to work? relevent code is below:

html/javascript:

function listStudents(password){

var oReq = new XMLHttpRequest();
    oReq.onload = function() {
        // This is where you handle what to do with the response.
        // The actual data is found on this.responseText
    allTheStudents =  JSON.parse(this.responseText);
    
    if(allTheStudents){
     select = document.getElementById("audioFile");
for(index in allTheStudents) {
    select.options[select.options.length] = new Option(allTheStudents[index], index);
            }    

    }else{
    alert("There are no students");
    }

document.getElementById("fileLabel").innerHTML= "Select Student(s) from the list:";
document.getElementById("fileLabel").style = "display:show;font-family: Calibri; font-size: 16px; font-weight: bold;color:#E3C208;";
   };
    oReq.open("get", "listStudents.php?x=" + username, true);
    oReq.send();
oReq.close;
}

function addStudent(){
 
    document.getElementById("familyNameId").innerHTML="";
 document.getElementById("qInput").style="display:none";

familyName = document.getElementById("familyNameId").value;
givenName = document.getElementById("givenNameId").value;
email = document.getElementById("emailId").value;
studentdetails = familyName+","+ givenName +","+email+","+ username ;
listNewStudent = familyName+" "+ givenName +" "+email;
addaStudent = JSON.stringify(studentdetails);
var oReq = new XMLHttpRequest();
    oReq.onload = function() {
    };
    oReq.open("get", "saddStudent.php?x=" + addaStudent, true);
    oReq.send();
    oReq.close;
    //alert("username "+ username);
    alert("about to list");
    

    select = document.getElementById("audioFile");
    //select.options = new Option(listNewStudent);
    select.options[select.options.length] = new Option(listNewStudent);

listStudents();
}

php:
<?php

$studentdetails = json_decode($_GET["x"],false);

//$var = file_get_contents('php://input');
//$studentArray = json_decode($var);

//$length = count($studentArray);
$servername = xxxxx
$user =  xxxxxx
$pass=xxxxx
$db ='xxxxxx

    // Create connection
    
    $con = new mysqli($servername, $user, $pass, $db) or die("Unable to connect to Database: " . $db);

    if ($con->connect_error) {
      die("Connection failed: " . $con->connect_error);
    }

    
    $studentElements = str_getcsv($studentdetails,",","");
    $fname=$studentElements[0];
    $gname=$studentElements[1];
    $ename=$studentElements[2];
    
    $sqla = "INSERT INTO students (familyName,givenName,email,)
    VALUES ('$fname','$gname','$ename);";

    
if (mysqli_multi_query($con,$sqla) === TRUE) {
  //      echo "New records created successfully";
  } else {

  }

  $con->close();
?>

Thanks in advance

Edited by jdauthre
minor correction

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...