20 Replies Latest reply on Aug 7, 2014 7:40 AM by kglad

    Problem passing a variable from a dynamic text field to php  (Flash 8)

    BigLewie

      I am currently working on a flash file where a person enters
      their score into an input text box with an instance name of score and then it
      converts it to a percentage and grade. 
      The swf file displays the grade and percentage in two dynamic text boxes
      with instance names of percent and score. 
      That part gives me no trouble.
      The main objective is to pass the percent and score to a php file called
      grade.php and then store both variables in MySQL. 

       

       

      After uploading the files to a server, I run the swf file and
      it seems like everything works.  But when
      I check the MySQL file, I notice that a row has been inserted, but no score or
      grade is entered.   I can not figure out
      what the problem is.  Can anyone assist
      me with this?

       

       

      Here the Actionscript 2.0 code and the php file:

       

       

       

      function findPercent() {

       

      percent.text = (score.text * 100) / 100;

       

      if (percent.text >= 90) {

      grade.text = "A";

           }  else if (percent.text < 90 &&  percent.text >= 80){

      grade.text = "B";

           else
      if (percent.text < 80 && percent.text >= 70){

      grade.text = "C";

           }  else if (percent.text < 70 && percent.text >= 60){

      grade.text = "D";

           }   else if (percent.text < 60){

      grade.text = "F";

      }

      }

       

       

       

      submit_button.onRelease = function(){

      submitURL = "grade.php";

       

      // create a LoadVars object instance and populate it.

       

      send_lv = new LoadVars();

      send_lv.score = "percent.text";    //  (Note: when I used the input text box as .score.text, it displayed  in MySQL)

      send_lv.grade = "grade.text";

      send_lv.send(submitURL, "POST");

       

      };

       

      (grade.php)

      <html>

      <head>

      <title>Grades: Add Your Grade and Score</title>

      </head>

      <body>

      <h2>Grade Display</h2>

      <?php

      require_once('connectvars.php');

      // Connect to the database

      $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

      // Grab the score data from the POST

      $score = $_POST['score'];

      $grade = $_POST['grade'];

      // Write the data to the database

      $query = "INSERT INTO transcript (score, grade) VALUES ('$score', '$grade')";

      mysqli_query($dbc,$query);

      mysqli_close($dbc);

      ?>

      <hr />

      </body>

      </html>