jQuery Forum

I have a PHP program that has a jQuery on a page to run a function and return fields if record is found.

I cheecked to make sure it has the:

 <script type="text/javascript" src="/websmart/v8.9/javascript/jquery.min.js"></script>

 

and the javascript to run the funtion:

<script>

$(document).ready(function()

{

          var select = $("#CCARDNO");

 

          select.blur(valccmsn);

  });

 

  function valccmsn() {

          $.ajax({

                          type: "POST",

                          url: "fmccpmtf.php",

                          data: {

                                  'task'  : 'valccmsn',

                                  'CCARDNO' : jQuery('#CCARDNO').val(),

                                  'EXPDATE' : jQuery('#EXPDATE').val(),

                                  'CVV2CVC' : jQuery('#CVV2CVC').val(),

                                  'CHNAME' : jQuery('#CHNAME').val(),

                                  'SFLAG' : jQuery('#SFLAG').val(),        

},

                          success: function(data){

                                  data = JSON.parse( data );

 

                                  $('#EXPDATE').val(data[0]);

                                  $('#CVV2CVC').val(data[1]);

                                  $('#CHNAME').val(data[2]);

                                   $('#SFLAG').val(data[3);

                           }

                  });

          }

</script>    

 and the proper HTML to receive the data:

          <tr>

            <td>Credit Card Number:</td>

            <td>

              <input id="CCARDNO" type="text" name="CCARDNO" size="25" maxlength="25" value="$CCARDNO" onblur="setStyleBlur(this.id);" onfocus="setStyleFocus(this.id);" />

            </td>

          </tr>

          <tr>

            <td>Expiration  Date:</td>

            <td>

              <input id="EXPDATE" type="text" name="EXPDATE" size="5" maxlength="5" value="$EXPDATE" onblur="setStyleBlur(this.id);" onfocus="setStyleFocus(this.id);" /></td>

          </tr>

          <tr>

            <td>CVV2/CVC Credit Card Security Code:</td>

            <td>

              <input id="CVV2CVC" type="text" name="CVV2CVC" size="5" maxlength="5" value="$CVV2CVC" onblur="setStyleBlur(this.id);" onfocus="setStyleFocus(this.id);" /></td>

          </tr>

          <tr>

            <td>Card Holder Name:</td>

            <td>

              <input id="CHNAME" type="text" name="CHNAME" size="25" maxlength="25" value="$CHNAME" onblur="setStyleBlur(this.id);" onfocus="setStyleFocus(this.id);" /></td>

          </tr>

          <tr>

            <td>Street Address:</td>

            <td>

              <input id="STRADR" type="text" name="STRADR" size="30" maxlength="30" value="$STRADR" onblur="setStyleBlur(this.id);" onfocus="setStyleFocus(this.id);" /></td>

          </tr>

          <tr>

            <td>Zip:</td>

            <td>

              <input id="ZIP" type="text" name="ZIP" size="5" maxlength="5" value="$ZIP" onblur="setStyleBlur(this.id);" onfocus="setStyleFocus(this.id);" /></td>

          </tr>

 

and the function to run the jQuery:

 

function valccmsn()

{

// Validate Transaction Code Return TABCDES from file TABCD

// Make all global variables available here

foreach($GLOBALS as $arraykey=>$arrayvalue)

{

if ($arraykey != "GLOBALS")

{

global $$arraykey;

}

}

 

 

// Get the key field values which identify the record 

$CCARDNO = xl_get_parameter('CCARDNO');

$EXPDATE = xl_get_parameter('EXPDATE');

$CVV2CVC = xl_get_parameter('CVV2CVC');

$CHNAME = xl_get_parameter('CHNAME');

$SFLAG = xl_get_parameter('SFLAG');

 

// Fetch the row for page

$sqlstr = 'SELECT MCCARDNO, MEXPDATE, MCVV2CVC, MCHNAME, MSFLAG FROM JMALIB/CCMSTF

 WHERE ' . ' CCMSTF.MCCARDNO = \'' . xl_encode($CCARDNO, 'db2_search') . "'";

 

if (!$result = db2_exec($db2conn, $sqlstr))

{

// do any add validation here        

 

// Add row to table:

$execsql = 'INSERT INTO JMALIB/CCMSTF (CCMSTF.MCCARDNO , CCMSTF.MEXPDATE, CCMSTF.MCVV2CVC, CCMSTF.MCHNAME, CCMSTF.MSFLAG) VALUES('

. "'" . xl_encode($MCCARDNO, 'db2_search') . "'" . ' , '

. "'" . xl_encode($MEXPDATE, 'db2_search') . "'" . ', '

. "'" . xl_encode($MCVV2CVC, 'db2_search') . "'" . ', '

. "'" . xl_encode($MCHNAME, 'db2_search') . "'" . ', '

. "'" . xl_encode($MSFLAG, 'db2_search') . "'" . ') with NC';

$result = db2_exec($db2conn, $execsql);                                                        

}

else

{

$row = db2_fetch_assoc($result);

 

if ($row)

{

$MEXPDATE = $row['MEXPDATE'];

$MCVV2CVC = $row['MCVV2CVC'];

$MCHNAME = $row['MCHNAME'];

$MSFLAG = $row['MSFLAG'];

$EXPDATE = $MEXPDATE;

$CVV2CVC = $MCVV2CVC;

$CHNAME = $MCHNAME;

$SFLAG = $MSFLAG;

echo("<span style=\"color: red\"><font font-family:\"Arial\" size=\"3\"><B>credit Card on File!</B></span>" . $CCARDNO);

array_push($sReturn, $MEXPDATE);

array_push($sReturn, $MCVV2CVC);

array_push($sReturn, $MCHNAME);

array_push($sReturn, $MSFLAG);

}

else

{

echo("<span style=\"color: red\"><font font-family:\"Arial\" size=\"3\"><B>credit Card Not on File!</B></span>" . $CCARDNO);

}

}                        

echo( json_encode( $sReturn ) );

db2_close($db2conn);

}

 

I can't tell if it is running the function or not.  I have compared it with other programs that work and can't find any errors?

can any  one tell me if you see any erros or what to use to debug this to see if function is running? 

I tried this:

but could not make it work?

James R. Martin
J. Martin Associates

[RESOLVED]  Dropped the: echo json_encode($DIDESC);  

 add:  echo("<span style=\"color: black\"><font font-family:\"Arial\" size=\"4\"><B>" . $DIDESC . "</B></span>");

I have a php program that returns #DIDESC successfully but surrounds it with ["  "].  How can I get rid of the ["  "]?   It has a function valciind() that runs a java script when onblur=:

              <input id="CANCIIND" type="text" name="CANCIIND" size="2" maxlength="2" value="$CANCIIND" onblur="setStyleBlur(this.id);" onfocus="setStyleFocus(this.id);" />