Results 1 to 2 of 2

Thread: xml parsing error

  1. #1
    Join Date
    Jul 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Angry xml parsing error

    This page contains the following errors:

    error on line 20 at column 508: Encoding error
    Below is a rendering of the page up to the first error.



    I was uploading this code url in two servers One it is working correctly but in magento based site it is not working....

    All suggesions are welcome...
    Thanks in advance...


    PHP Code:
    <?php
    $con 
    mysql_connect("localhost","casdfhefhsad","!1hfhfhfhfhk");
    if (!
    $con)
    {
    die(
    'Could not connect: ' mysql_error());
    }



      
    mysql_select_db("carhhehd",$con);
      
      
      
    $result=mysql_query"SELECT `main_table`.`entity_id`,`main_table`.`level`, `main_table`.`path`, `main_table`.`position`,
     `main_table`.`is_active`, `main_table`.`is_anchor`,
     `main_table`.`name` FROM
     `catalog_category_flat_store_1` AS `main_table`
       
     WHERE (path LIKE '1/2/%') AND (main_table.store_id = '1') AND
    (is_active = '1') AND (include_in_menu = '1') ORDER BY name ASC"
    );  
      
      
    header("Content-type: text/xml");   
    echo 
    '<?xml version="1.0" ?>';

    echo 
    '<data>';
      
      
       
    $i=0;
    while(
    $row=mysql_fetch_array($result)) 
    {
        
    $m=$i+1;
          echo 
    '<'.$row['name'].'>';
        
         echo 
    '<entity_id>' $row['entity_id'] .'</entity_id>';
        
        echo 
    '<store_id>' '1'.'</store_id>' ;
          
         echo 
    '<name>' $row['name'].'</name>' ;
          
          
        
    $b=$row['name'];     

        
    $result1=mysql_query("SELECT distinct 
            
             p.entity_id AS 'product_entity_id',
             
                cvn.name AS 'cname',
            cvn.entity_id AS 'centityid', 
            


               pvn1.entity_id AS 'entity_id',
               pvn1.name AS 'product_name',
               pvn1.price AS 'price',
            
               pvn1.special_price AS 'special_price',
               pvn1.weight AS 'weight',
               pvn1.small_image AS 'small_image',
               pvn1.short_description AS 'short_description',
               pvn1.url_key AS 'url_key'


    FROM 
    catalog_product_entity p 
    JOIN(
          SELECT DISTINCT entity_id, attribute_id,value
          FROM 
       catalog_product_entity_varchar )  pvn 
    ON p.entity_id = pvn.entity_id 
      JOIN (
          SELECT DISTINCT entity_id, name, price,special_price,weight,small_image,short_description,url_key
          FROM    catalog_product_flat_1 ) pvn1
            ON pvn.entity_id=pvn1.entity_id
    JOIN (
          SELECT DISTINCT product_id,category_id
          FROM   catalog_category_product_index ) r 
    ON r.product_id = p.entity_id 
    JOIN (
          SELECT  entity_id 
          FROM

    catalog_category_entity) c 
    ON r.category_id = c.entity_id 
    JOIN (
          SELECT `cvn`.`entity_id`,`cvn`.`level`, `cvn`.`path`, `cvn`.`position`,
     `cvn`.`is_active`, `cvn`.`is_anchor`,
     `cvn`.`name` FROM
     `catalog_category_flat_store_1` AS `cvn`
       
     WHERE (path LIKE '1/2/%') AND (cvn.store_id = '1') AND
    (is_active = '1') AND (include_in_menu = '1') ORDER BY name ASC ) cvn 
    ON c.entity_id = cvn.entity_id 
    WHERE 
    cvn.name = '
    $b

    ORDER BY pvn.value;"
    ); 



    if(
    $result1)
    {


        while(
    $row1=mysql_fetch_array($result1)) 
    {
          
            
            
            
            
           echo 
    '<products>';

         
           echo 
    '<centity_id>' $row1['centityid'] .'</centity_id>';
           
              echo 
    '<cname>' $row1['cname'].'</cname>' ;
        
        echo 
    '<pentity_id>' $row1['entity_id'] .'</pentity_id>';
        
        echo 
    '<sku>' $row1['sku'].'</sku>' ;
          
         echo 
    '<name>' $row1['product_name'].'</name>' ;
           
          echo 
    '<price>' .$row1['price'].'</price>' ;
              

           echo 
    '<special_price>' .$row1['special_price'].'</special_price>' ;
           
            
           echo 
    '<weight>' .$row1['weight'].'</weight>' ;
           
           

            echo 
    '<image>http://infocomsoftware.com/foodcart/media/catalog/product/cache/1/small_image/170x/9df78eab33525d08d6e5fb8d27136e95' $row1['small_image'] . '</image>';
               

            
           echo
    '<short_description>' $row1['short_description'] . '</short_description>' ;
             
                
              echo
    '<url_key>' $row1['url_key'].'</url_key>' ;
              
                
          
            echo 
    '</products>';  
       
    }
    }
      echo 
    '</' $row['name'].'>';   
    }

    echo
    '</data>';


    ?>
    Last edited by jscheuer1; 07-06-2013 at 03:52 PM. Reason: Formatting

  2. #2
    Join Date
    Mar 2005
    Location
    SE PA USA
    Posts
    29,138
    Thanks
    44
    Thanked 3,231 Times in 3,192 Posts
    Blog Entries
    12

    Default

    Since you say all suggestions welcome, I would suggest that the error is not in the PHP code, but in the xml code it produces. Which is a difference in how the PHP code is interpreted. When you have the page in the browser, hit 'View Source'. Do this on the page where everything is working, and also on the page where you are getting the error. Try to see what is different. That might give you a clue as to how to fix it.



    Oh, and when posting code in the forums:

    Please use the forum's bbcode tags to indent your code and make it more readable:

    for php code............[php] <?php /* code goes here */ ?> [/php]
    for html...............[html] <!-- markup goes here -->.....[/html]
    for js/css/other.......[code] code goes here................[/code]


    The simple editor has a button for the [code][/code] tag, you may use that:

    #

    Not the #i one, which is really just for highlighting.

    The advanced editor (activated by using the 'Go Advanced' button from the simple editor) has buttons for PHP and HTML code braces as well.

    I and another moderator already edited your post to fix this, this time because you are new. In the future, please try to use the bbcode tags for any code that you want to put in your posts.
    - John
    ________________________

    Show Additional Thanks: International Rescue Committee - Donate or: The Ocean Conservancy - Donate or: PayPal - Donate

Similar Threads

  1. BBCode Parsing Error
    By Ozzypig in forum PHP
    Replies: 0
    Last Post: 02-20-2010, 11:41 PM
  2. Parsing XML with PHP
    By teajay99 in forum PHP
    Replies: 5
    Last Post: 09-06-2009, 08:11 AM
  3. Resolved XML parsing error (per W3C validator site)
    By catwoman2970 in forum Other
    Replies: 5
    Last Post: 05-08-2009, 05:25 PM
  4. IE error parsing xml from Basic Ajax Routine
    By kevin_dalby in forum Dynamic Drive scripts help
    Replies: 0
    Last Post: 01-24-2008, 12:20 PM
  5. XML Parsing Error - Advanced RSS Ticker
    By tombr in forum Dynamic Drive scripts help
    Replies: 2
    Last Post: 03-09-2006, 06:58 PM

Bookmarks

Posting Permissions

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