Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   Sending Query Result to Excel (http://www.go4expert.com/forums/sending-query-result-excel-t5806/)

coool 11Aug2007 20:01

Sending Query Result to Excel
 
Hi guys,

How can I send query result to EXCEL in PHP pages?

is there such a function in PHP ? any code example !

coool 11Aug2007 20:34

Re: Sending Query Result to Excel
 
page.php
Code: html

<?php
$items = "item1,item3";
?>


<a href="form.php?selectedItems=<?=$items?>" >View Form<a/>



form.php
Code: html

<form name="selectionform" method="post" action="">

              <select  size="3" multiple name="selectedItems[]">
                <option value="item1">Item1</option>
                <option value="item2">Item2</option>
                <option value="item3">Item3</option>
              </select>

              <input type="submit" value="View Result">
</form>


What I'm looking for is when user click "View Form" link, they get the for filled with items - i.e some items are alreay selected ---- then if the user want to deselect one of the items or select more items he should able to do that.. !

to check the result: - in form.php
PHP Code:

if($_POST)
    echo 
implode($_POST['selectedItems'],","); 

so what do you think ? having $_GET inside form.php will solve the problem ! .. but I've tried it and it doesn't work.. I didn't know how to handle the array and nothing selected !! .. can you take my sample code and add to it the proper things so it will work ! please

coool 11Aug2007 22:58

Re: Sending Query Result to Excel
 
oh the above reply was posted in the wrong thread..

didn't see an icon to edit it or deleted it .. sorry for that.. :)


All times are GMT +5.5. The time now is 11:58.