php-windows Digest 4 Feb 2007 11:15:20 -0000 Issue 3130 Topics (messages 27441 through 27448):
Re: New user having problems :(
27441 by: Niel Archer
27442 by: Future Computers and Internet Services
27443 by: Niel Archer
27444 by: Aaron Kenney
Re: Search results
27445 by: Armando
Printer Functions - print a file
27446 by: Chuck Anderson
Calling Illustrator from PHP
27447 by: Max Beutel
27448 by: Max Beutel
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---Hi That build is out of date. Get the latest (2nd Nov 2006) from the web site. Niel
--- End Message ---
--- Begin Message --- Cheers for the reply, I have downloaded the newest one and now when I try the page tries to load and just sits there, some times it times out with page can not be found. normal html pages work fineRob Niel Archer wrote:Hi That build is out of date. Get the latest (2nd Nov 2006) from the web site. Niel
--- End Message ---
--- Begin Message ---Hi Can you get a phpinfo page? Niel
--- End Message ---
--- Begin Message ---Please make sure that the document root in httpd.conf matches that in the php.ini file. Also make sure that all php files that you are using have the .php file extension. Make sure that every php file starts with <?PHP, not <? As this is unsupported by default in the new php. Test your installation with phpinfo(); and also test using the echo function. If you are using a windows server, make sure that the SYSTEM user has full control security priviledges to your docroot and your php folder. Make sure that the php folder is part of your path in windows. On 2/3/07, Niel Archer <[EMAIL PROTECTED]> wrote:Hi Can you get a phpinfo page? Niel -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message --- I see what you mean now, even 400 results would take a long time doing like matching on this many text fields without fulltext indexing. In this case, you want to investigate the use of PHP's serialize() and unserialize() functions. Check out this article on Zend Developer Zone for information:http://devzone.zend.com/node/view/id/1258If your requirement is user-specific then you'll need to determine how you want to accomplish that but that shouldn't be too difficult. The above page uses MySQL as it's example but since you're doing the caching via PHP then it shouldn't be an issue. HTH. Cheers.Armando . Harpreet wrote:SQL looks as below: select top 400 * from na_item_view_new where ((story_name like '%Midlothian%' ) or (title like '%Midlothian%' ) or (script like '%Midlothian%' ) or (item_text like '%Midlothian%' ) or (keyword like '%Midlothian%' ) or (notes like '%Midlothian%' ) or (description like '%Midlothian%' ) or (clipname like '%Midlothian%' ) or (creator like '%Midlothian%' )) and Convert(datetime,rundown_date) >= '05/02/2006' and Convert(datetime,rundown_date) <= '02/02/2007' and type=1 and content_status=1 order by convert(datetime, rundown_date) asc View is as below: CREATE view na_item_view_new as select s.story_id, u.title as title, s.title as story_name, u.state, [rundown_date]=convert(char(10),u.air_date,101), '' as video, '' as cg_text, SUBSTRING(s.text, 1, 500) AS script, SUBSTRING(i.text, 1, 500) as item_text , i.type, i.content_status, k.keyword, i.editorial_description as description , d.description as notes, s.editor as creator, i.original_material_id as clipname, i.ar_material_id as material_idfrom (select null as state,null as type, rundown_id, ncs_rundown_id, edit_duration, title, [air_date]=convert(char(10),air_date, 101), edit_start_time=substring(convert(varchar(10), edit_start_time, 114),1,8) from na_rundown_tbl where rundown_id not in(select ref1 from req_state_tbl where type=(select type_id from req_type_tbl where type='NA_ST_RUNDOWN')) union select state, type, rundown_id, ncs_rundown_id, edit_duration, title,[air_date]=convert(char(10),air_date, 101), edit_start_time=substring(convert(varchar(10), edit_start_time, 114),1,8) from na_rundown_tbl r left outer joinreq_state_tbl s on r.rundown_id=s.ref1 where (state=5 AND type=(select type_id from req_type_tbl where type='NA_ST_RUNDOWN'))) uinner join na_story_tbl s on s.rundown_id=u.rundown_id left outer join na_item_tbl i on s.story_id=i.story_idleft outer join na_itemkeyword_tbl k on i.item_id=k.item_id left outer join na_itemdesc_tbl d on i.item_id=d.item_id Regards, Harpreet KaurCrispin Corporation (919) 367-7911(919) 791-9886 (Cell) -----Original Message-----From: Gustav Wiberg [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 1:47 AMTo: Harpreet; 'php windows' Subject: RE: [PHP-WIN] Search results Hi! I agree to Armando about the optimasation about the search-query. If you show some bit of code (it may be useful only with the actual query used to search), we maybe can help you! Best regards /Gustav Wiberg HMN Konsult (Sweden) http://www.hmn.se/-----Original Message-----From: Harpreet [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 10:22 PMTo: php windows Subject: [PHP-WIN] Search results I have a search page on my web application that searches a database with 1000's of rows. The search results are returned in like 45-50 seconds. If the user goes to another page and then returns to the same page again it takes the same amount of time. Is there a way to use session variables to remember the search results and if user comes back to the page with the same criteria it shows the static results and not take as long. Help is needed urgent. Thanks Regards, Harpreet Kaur -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message --- I've scoured the php.net online manual and other notes about Printer functions and do not see how I simply send a file to the printer using the Printer functions.Can anyone help?(I can open my printer and print text to a page, but I do not see how to simply print an existing file - a gif image file, in this case.)Thanks in advance for any help. -- ***************************** Chuck Anderson • Boulder, CO http://www.CycleTourist.com *****************************
--- End Message ---
--- Begin Message ---Hello there, On a windows server, I want to call Adobe Illustrator, make it open a javascript file and execute it. All controlled via PHP. I use com to call illustrator, which already works nice, but I cant make it yet to open the script file. Does anyone know where to find information about this? The documentation I found was not very helpful. Mainly there was no documentation at all. This is all I got so far : $WshShell = new COM("WScript.Shell"); $illustrator = $WshShell->Run("Illustrator.exe", 3, true); Thanks in advance!
--- End Message ---
--- Begin Message ---Hi there, what I want to do on my Windows server: open Illustrator, make it open a JavaScript file and execute it (manually you would go to File -> Scripts), all controlled via PHP. Unfortunately I got no idea on how to do this. I only got some codesnippet, that opens Illustrator. Not that much, I´d say: $WshShell = new COM("WScript.Shell"); $illustrator = $WshShell->Run("Illustrator.exe", 3, true); I googled quite a lot on this, but found actually nothing... I have no idea where to look at to find something on Illustrators Object hierarchy. Has anyone done something before like this with Illustrator? Any documentation you could point me to? Help would be greatly appreciated!
--- End Message ---
