Re: Ajax
Jim Giner <[email protected]>
| Newsgroups | gmane.comp.php.database |
|---|---|
| Message-ID | <[email protected]> |
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?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php