header problems

nikko50

Hello there guys. I have an application at work that is a full screen php/sql web apllication. I have a pop up window that opens a search into excel. The problem is the toolbars are not in excel. Anyway I can get this to pop up in a window with toolbars. Thanks
Tracy🙂

if($radiogo =="excel")
{header("Content-Type: application/vnd.ms-excel");

$query = "SELECT store ,date ,equipmentid ,quantity ,enteredby FROM shiplist WHERE store='$quicksearch' and quantity > '0'
ORDER BY store";

$result = mysql_query($query);
$fieldcounts = mysql_num_fields($result);
for($i = 0; $i < $fieldcounts; $i++) {
$fieldtype = mysql_fetch_field($result, $i);
echo "$fieldtype->name \t";

Mucello

I have data open into an Excel document for some stuff too, but I don't have any problems with the toolbars not being there. The only thing I can see to change may potentially be the header... try this instead and see what happens:

header(Content-type: application/x-msexcel);

The_Chancer

Similar to Word - you can set the default opening style for Excel.

Can't remember what the template is for it now...

However when a document is saved in excel and opened again in a differen PC's version - it will open as it did on the previous version.

This is (of course) assuming that there are no macros or VB script behind it that will affect the way in which it opens.

nikko50

Hi guys. Thanx for the replys. The code works fine if the page loads in a window with toolbars. The problem is the search form is in a window with toolbars set at "no". When a user inputs the search criteria the excel sheet opens in a window with no toolbars also. As I understand correctly the header function must be the first thing written to a page to function corecctly?? Therefore how can I get the excel sheet to open in a normal window??
Tracy

The_Chancer

How about using Javascript to open it - and then specify toolbars=yes...