PHP - Moved: Microsoft-webdav-miniredir/6.0.6001

Hi,

I'm designing a website for an online radio station. One show a week they have a DJ who has his own top 40 show with HIS top 40 listed on his own site

At the moment, the only solution I have to getting the top 40 onto my clients site is an iframe (not good I know!)
However, what's worse is that this top 40 list has horrendous colours that completely break the theme of my clients site and worse still, is Excel generated HTML! The author of this list is not a client of mine, and so, I can't do anything to persuade him to change. I've attached a copy of the offending file so you can see what I'm working with, changed the extension from html to txt for the forum post.
Just for clarification, the excel generated HTML file is not hosted on my server (although I could set up a cron job to get it if required)

I've done some  digging and found a useful bit of code

However, it displays the table 4 or 5 times
In addition to this, is there a way to manipulate the width of the columns with this code?

Code: [Select]
<?php 
$oldSetting = libxml_use_internal_errors( true ); 
libxml_clear_errors(); 

$html = new DOMDocument(); 
$html->loadHtmlFile('Chart%20Table2.htm'); 

$xpath = new DOMXPath( $html ); 
$elements = $xpath->query( "//table" ); 

foreach ( $elements as $item ) {
  $newDom = new DOMDocument;
  $newDom->appendChild($newDom->importNode($item,true));

  $xpath = new DOMXPath( $newDom ); 

  foreach ($item->attributes as $attribute) { 

    for ($node = $item->firstChild; $node !== NULL; 
         $node = $node->nextSibling) {
      if (($attribute->nodeName =='valign') && ($attribute->nodeValue=='top'))
      {
        print($node->nodeValue); 
      }
      else
      {
        print("<br>".$node->nodeValue);
      }
    }
    print("<br>");
  } 
}

libxml_clear_errors(); 
libxml_use_internal_errors( $oldSetting );



?>

Basically, I just want the table,
I'm not bothered about the first column that contains some pictures as I think that's a separate table

Ideally, I'd like to apply my own formatting to the table too (padding etc) if that is possible (eg from line 897 <td class=xl28 x:num>1</td>) down to line 1433

The trouble is, there is a lot of custom widths and styles inbetween which I don't want
I'd like all the tr and td's without all the associated guff from the original export from Excel

Geez I wish there was an easy way to get this guy just to export as CSV but unfortunately that's not an option!

Many thanks in advance!

Other than downloading the file, editing it on the local PC, saving it, and uploading it back to the server using some applicable script, any ideas?

The information on the php.net documentation seems to be out of date.   http://php.net/manua...databases.mssql   as the link to the necessary libraries for Linux is broken.    Can you tell me, or point me to what is needed to connect to MSSQL with PHP 5.3.3/Apache  on Red Hat Linux   If there is more than one option, we would like to know what they are and the installation details.   Thanks

Hello,
i am currently getting an Microsoft Excel formatted text file whose save type is .Txt from a URL.I used to open it and will change the save type  as excel file. Please suggest whether we can do this with php code.

currently my code is like this,
<? php
copy("http://www.faa.gov/airports/airport_safety/airportdata_5010/menu/emergencyplanexport.cfm?Region=&District=&State=&County=&City=LAS%20VEGAS&Use=&Certification=","./contactsexport.xls");
?>

where as the contactsexport.xls type is .Txt which i need it in .xls

Thanks in Advance.

Background:
I'm comparing 2 styles of Ajax:
1.) "jquery style"
2.) "ActiveXObject Microsoft.XMLHTTP style"

Question:
Is one better (faster, more cross-browser compliant) than the other?

My experience:
Both seem equally fast. The Microsoft style is a bit longer, but I don't have to load jquery.js to my page!

Code Examples:

Jquery style on my PHP page:

function getInfo(ProductNumber){
$.ajax({
url:'Ajax-PHP-Page.php?ProductNumber='+ProductNumber,
success: function(html) {
document.getElementById("my_div").value = '';
document.getElementById("my_div").value = html;
}
});
}

Microsoft style on my PHP page:

function getInfo(ProductNumber) {
        if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (this.readyState == 4 && this.status == 200) {
                document.getElementById("my_div").value = this.responseText;
            }
        };
    xmlhttp.open("GET","Ajax-PHP-Page.php?ProductNumber="+ProductNumber,true);
  xmlhttp.send();
}

Thank you!!

Edited May 5, 2020 by StevenOliver