plusnplus

Hi.., I use below method to export data to excel. header('Content-type: application/ms-excel'); header('Content-Disposition: attachment; filename=abc.xls'); if I run the script from the server. (http://localhost/export.php) it is work. (pop-up window if i want save or open the file) but if i run the script from the client (http://192.168.1.5/export.php) it is not work. (nothing happen) any idea how to solve this?

Hi.., is there any possible to see what real text after use password()? example: insert into table1 values(password(1234)); if somehow someone can access this table, can they see the real word "1234" ?

hi.., thanks to everyone the problem is solved now. i just replace all the open tag code.

after i put <?php ( before just <? ), it work properly. since so many pages (more then 200) I need to update, any other way beside that update opening tag? i just wonder, why apache+mysql+php in windows server 2008 need this opening tag? my intranet server, using ubuntu 10.04, without that (<?php), the web page work properly.

first, i install apache 2.2 installer 2nd, install mysql installer 3rd, install php installer (during process, select web server and loc of conf file) that's all. any file( *.dll) i should copy to some folder?

hi.., i have pc development, using win xp sp3, apache+mysql+php the code/ webpage work prefect. i have intranet server, using ubuntu 10.04, apache+mysql+php the code/ webpage work prefect. but.., when i copy to live web server, using win server 2008, apache+mysql+php, all php code show in broswer. if there is a html code, it show correctly, but the php code, show just like text in the browser. how to solve this problem? thanks for any help/ info

So it is not possible to order by last x column in mysql query ?

Hi.., Is order by last x column possible in mysql query ? my query is like: select * from table1 order by col_a, col_b, col_c every month I need to change the order like: select * from table1 order by col_b, col_c,col_d because i add another column in the table.

if my way to insert image is not correct, anyone can advice, how is the proper way to insert some images into excel from php. thanks for any reply/ info

anyone can help me?

Hi.., My code is like: <?php $filename ="excelreport.xls"; print "<table border=1>"; print "<tr ><td valign=bottom><img src=http://abc/images/big.png ></img></td> <td valign=bottom><img src=http://abc/images/small.png ></img></td> </tr>"; print "</table>"; header('Content-type: application/ms-excel'); header('Content-Disposition: attachment; filename='.$filename); ?> when I open the excel file, the images alignment is from top to bottom(equal from top of image). what i want is from bottom to top(equal from bottom of image). i did try using valign in td property, but still the images equal from top of image thanks for any reply/ help

is this have related with php version? i using php 4.4.9 should i upgrade to php 5?

i see in phpinfo() is "on" for local and master value.\ so should be OK? but still i can not get result from code i type.

Hi.., I have code: <?php header("content-type: text/xml"); $xmlData = file_get_contents("http://www.google.com/ig/api?weather=new%20york"); echo $xmlData; ?> and get error:XML Parsing Error: no element found. is this kind of error need some setting in php.ini? or what i should look at phpinfo() to make sure the setting is ok. or.. is there any setting in apache? i'm using win XP, apache, php and mysql. if i type direct in browser: http://www.google.com/ig/api?weather=new%20york it give me the xml file withour any error. thanks for any reply/ help

Hi.., I have script like: <script type="text/javascript">setTimeout(window.close, 2000);</script> it is working if run in my test server(windows XP), but not working in my live server(ubuntu 8.04). Any idea what is wrong? thanks for any help/ reply