Re: Ajax

On 2/19/2013 12:16 PM, Ethan Rosenberg, PhD wrote:

Dear List - With the INFINITE THANKS to Jim Giner who provided me with the help to get me out of the forest. The customer db is +----------+----------------------+------+-----+---------+-------+

| Field    | Type                 | Null | Key | Default | Extra |

+----------+----------------------+------+-----+---------+-------+

| Cust_Num | smallint(5) unsigned | NO   | PRI | NULL    |       |
| Fname    | varchar(25)          | NO   |     | NULL    |       |
| Lname    | varchar(25)          | NO   |     | NULL    |       |
| Street   | varchar(25)          | NO   |     | NULL    |       |
| City     | varchar(25)          | NO   |     | NULL    |       |
| State    | varchar(2)           | NO   |     | NULL    |       |
| Zip      | mediumint(9)         | NO   |     | NULL    |       |
| Phone    | int(10)              | NO   |     | NULL    |       |
| Date     | date                 | NO   |     | NULL    |       |
| Notes    | text                 | YES  |     | NULL    |       |
| P1       | int(3)               | YES  |     | NULL    |       |
| P2       | int(3)               | YES  |     | NULL    |       |
| P3       | int(4)               | YES  |     | NULL    |       |

+----------+----------------------+------+-----+---------+-------+ The credit db is: +----------+----------------------+------+-----+---------+-------+

| Field    | Type                 | Null | Key | Default | Extra |

+----------+----------------------+------+-----+---------+-------+

| Cust_Num | smallint(5) unsigned | NO   | PRI | NULL    |       |
| Fname    | varchar(25)          | NO   |     | NULL    |       |
| Lname    | varchar(25)          | NO   |     | NULL    |       |
| Street   | varchar(25)          | NO   |     | NULL    |       |
| City     | varchar(25)          | NO   |     | NULL    |       |
| State    | varchar(2)           | NO   |     | NULL    |       |
| Zip      | mediumint(9)         | NO   |     | NULL    |       |
| Phone    | int(10)              | NO   |     | NULL    |       |
| Date     | date                 | NO   |     | NULL    |       |
| Notes    | text                 | YES  |     | NULL    |       |
| P1       | int(3)               | YES  |     | NULL    |       |
| P2       | int(3)               | YES  |     | NULL    |       |
| P3       | int(4)               | YES  |     | NULL    |       |

+----------+----------------------+------+-----+---------+-------+ What the customer wants - pardon, but I cannot display a table Jones Tom 123 Street Leah; David, Malka Jones, Sam 341 Street Sarah; Shira, Mordechai Last Name, First Name, Address, Spouse; Persons authorized to charge. He wishes to select which "Jones" to use, and then click on "Jones". This will extract the Cust_Num, as cno which [hopefully] I can do constant $Cust_Num = $cno; He will then be shown the credit history of the customer and asked if he wishes to continue. If yes, he will be give the option of credit or payment. $Cust_Num will be used in all the following calculations. The program gives an error in the callback function: |Notice: Undefined variable: cno in /var/www/testClickcallback.php on line 9 || ||Call Stack:

||     0.0006     130112   1. {main}() /var/www/testClickcallback.php:0

|| || ||Variables in local scope (#1): || $cno = *uninitialized* || $json = array ('cnum' => NULL) || ||{"cnum":null}| The Error Console shows no errors. Do you know any way I can cleanup my Ajax and make it work? Here are the scripts I am using: testclick5.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <div id="main"> <?php

     // make up some data in arrays here
     $names =

array("Jim","Joe","Stu","Ethan","Adam","Linda","Mary","Alice","Ann","Jeanne");

     $nums = array(1,5,4,99,23,45,64,84,91,25);
     global $cnum;
     $results = "<table border=4 cellpadding=5 cellspacing=55  rules=all

frame=box style='table-layout:fixed;'>";

     $results .= "<tr><th>Name</th><th>Number</th></tr>";
     // generate a table here
     for($i=0; $i<10; $i++)
     {
         $k = $i ;
         $results .= "<tr><td id='name$i' >$names[$k] </td><td

id='cust$k' id='nums$k'>$nums[$k]</td></tr>";

     }
     $results .= "</table>";
     $results;
     DisplayPage();
     MakeCustIndx();

?> </div> <?php

     function MakeCustIndx()
     {
         global $cnum,$cno;

?> <link type="text/css" href="jquery-ui-1.8.9.custom.css" rel="stylesheet" /> <script type="text/javascript" src="jquery-1.6.2.min.js"></script> <script type="text/javascript" src="jquery-ui-1.8.10.custom.min.js"></script> hello <script type="text/javascript">

     var cusn;
     $(document).ready(function(){
         $("#main").click(function() {
             cusn = $(this).attr('id');
         });
     });

     $(document).ready(function(){
             $("#main").dblclick(function(e) {
                  $.post("testClickcallback.php",
                    {"custnum":cusn},  "html")

                 });
             });

</script> <?php

     }

?> <div id=m2> </div> <?php

     exit();

//****************************************** function DisplayPage() {

     global $results;
     $code=<<<heredocs

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"

      "http://www.w3.org/TR/html4/strict.dtd">

<html> <head> <title>Get Customer Number</title> <script type="text/javascript">

     var cno;
     var cnm;
     function getCustNo(id)
     {
         cno = 'cust'+id;
         cnm = "name"+id;
         cname = document.getElementById(cnm).innerHTML;
         cnum = document.getElementById(cno).innerHTML;
     alert("For customer "+cname+" the number is "+cnum);
         return;
     }

</script>

     $results

</body></html> heredocs;

     echo $code;

} testClickcallback.php <?php $json = Array(); $json['custnum'] = $_POST['cusn']; echo json_encode($json); ?> Thanks for everything. Ethan Ethan - this can't possibly the code you are running. Your 'page' is a bunch of badly formatted html. YOu have a <head> tag but no end tag. YOu have an end body tag, but no start body tag. You have the html 'doctype' line being output twice. And on and on.

People don't need to see table layouts. People don't need to see examples of code that are clearly flawed on the outside. You need to trust in php error messages. The error message (if it is EXACTLY what you say it is) tells you that at that specific point the var is unknown. Where is line 9?? Just as a guess, are you doing a .= to add some data to it, and it hasn't already been declared?