Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7

Thread: ajax mysql php

  1. #1
    New to the CF scene
    Join Date
    Oct 2007
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ajax mysql php

    Hi, im pretty new to this. basically, i have two database tables in mysql, one called items(id of the book, cookieid, quantity) and the other books(id, name, desc, price). my php returns xml(name, price, quantity and total amount). my code returns the name and price but i can't get it to return the quantity or total.

    can anyone see any errors in my code? i think the problem is with the quantity which is the variable newCell2. I keep getting the error "object expected" with that part in IE.


    if (request.readyState==4) {
    if(request.status==200) {

    var response =request.responseXML;
    for(var i=0; i<=response.getElementsByTagName('store').length; i++)
    {
    var newRow = document.getElementById('table').insertRow(-1); // Insert the third row
    var newCell1 = newRow.insertCell(0); // Insert the first cell
    newCell1.innerHTML = response.getElementsByTagName('book')[i].childNodes[1].childNodes[0].nodeValue; // First cell's innerHTML
    var newCell3 = newRow.insertCell(2); // Insert the second cell
    newCell3.innerHTML = response.getElementsByTagName('book')[i].childNodes[3].childNodes[0].nodeValue;
    var newCell2 = newRow.insertCell(1); // Insert the second cell
    newCell2.innerHTML = response.getElementsByTagName('book')[i].childNodes[4].childNodes[0].nodeValue; // Second cell's innerHTML
    var newCell4 = newRow.insertCell(3); // Insert the second cell
    newCell4.innerHTML = response.getElementsByTagName('book')[i].childNodes[5].childNodes[0].nodeValue;
    }


    thanks in advance.

  • #2
    bdl
    bdl is offline
    Regular Coder
    Join Date
    Apr 2007
    Location
    Camarillo, CA US
    Posts
    590
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Would you please post a valid XML example (that this script expects)? Please use the CODE tags when posting.

    Also, consider using JSON for this, as its lightweight and much easier to handle than XML.

  • #3
    New to the CF scene
    Join Date
    Oct 2007
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thanks for the reply. the xml is embedded in the php, but i know that the php and sql db are correct.

    Code:
    echo '<?xml version="1.0" encoding="ISO-8859-1"?><store>';
    	while($row = mysql_fetch_array($result1))
      	{
    
    	echo "<book>";
    	echo "<id>".$row['id']."</id>";
    	echo "<name>".$row['name']."</name>";
    	echo "<description>".$row['description']."</description>";
    	echo "<quantity>".$count."</quantity>";
    	echo "<price>".$row['price']."</price>";
    	echo "<sum>".$count*$row['price']."</sum>";
    	echo "</book>";
    
    	}
        }
    
      }
    
    }
    echo "</store>";
    any ideas?

  • #4
    bdl
    bdl is offline
    Regular Coder
    Join Date
    Apr 2007
    Location
    Camarillo, CA US
    Posts
    590
    Thanks
    4
    Thanked 83 Times in 82 Posts
    No, I was looking for the actual XML. Pull up that PHP script in your browser and post the XML with content. You need to start troubleshooting with the actual data the Ajax request sees.

  • #5
    Senior Coder rnd me's Avatar
    Join Date
    Jun 2007
    Location
    Urbana
    Posts
    4,296
    Thanks
    10
    Thanked 583 Times in 564 Posts
    in general, it's more reliable to use getElementsByTagName('XXX') than childNodes, which can change between files and browsers.
    my site (updated 13/9/26)
    BROWSER STATS [% share] (2014/5/28) IE7:0.1, IE8:5.3, IE11:8.4, IE9:3.2, IE10:3.2, FF:18.2, CH:46, SF:7.9, NON-MOUSE:32%

  • #6
    New to the CF scene
    Join Date
    Oct 2007
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thank you for your reply.
    i can get the name decription and price to show but the quantity and sum won't show. ill keep trying.

  • #7
    Senior Coder A1ien51's Avatar
    Join Date
    Jun 2002
    Location
    Between DC and Baltimore In a Cave
    Posts
    2,717
    Thanks
    1
    Thanked 94 Times in 88 Posts
    You probably have a whitespace node issue.

    Eric
    Tech Author [Ajax In Action, JavaScript: Visual Blueprint]


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •