php-windows Digest 3 Feb 2007 17:46:03 -0000 Issue 3129
Topics (messages 27436 through 27440):
Re: Visual Studio and PHP
27436 by: Bill Bolte
27437 by: David Lindstrom
PHPMyAdmin Acting frunky on Windows Vista.
27438 by: Sean Madden
Re: Search results
27439 by: Harpreet
New user having problems :(
27440 by: Future Computers and Internet Services
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 ---
Theres this: http://www.jcxsoftware.com/jcx/vsphp/home
I demo'ed the standalone version and really liked it. But I'm leaning
towards Eclipse right now.
-----Original Message-----
From: Jarrett Meyer [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02, 2007 12:10 PM
To: PHP Windows List
Subject: [PHP-WIN] Visual Studio and PHP
To: PHP Windows List
Is it possible to compose PHP using MS Visual Studio? If so, what
additional tools/installs are required? Can you please point me in the
right direction?
I know that I *could* use Zend Developer Studio, but I'm already a big
fan of VS, and I wouldn't have to pay for and learn new development
software.
Thanks,
Jarrett
No trees were harmed during this transmission; however, several
electrons were terribly inconvenienced.
--
PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Take a look at Phalanger - http://www.codeplex.com/Phalanger, might be of
interest to you (it's free).
--
// DvDmanDT
mail: dvdmandt¤telia.com
msn: dvdmandt¤hotmail.com
"Jarrett Meyer" <[EMAIL PROTECTED]> skrev i meddelandet
news:[EMAIL PROTECTED]
To: PHP Windows List
Is it possible to compose PHP using MS Visual Studio? If so, what additional
tools/installs are required? Can you please point me in the right direction?
I know that I *could* use Zend Developer Studio, but I'm already a big fan
of VS, and I wouldn't have to pay for and learn new development software.
Thanks,
Jarrett
No trees were harmed during this transmission; however, several electrons
were terribly inconvenienced.
--- End Message ---
--- Begin Message ---
Hello all,
Running PHP 5.2.0 on Apache 2.2.4 under Windows Vista (Business,
retail). All of the applications I've written under PHP have made the
migration just fine; with the exception of PHPMyAdmin. Here's a screenshot
of what it's doing =>
http://seanscompy.rh.rit.edu/images/funkyphpmyadmin.jpg
My question is this; On a different partition I'm running Fedora Core
6, Apache 2.2.4, PHP 5.2.0 and it's displayed normally. I've tried rolling
back versions of all three to ones I've known that work (PHP, Apache and
PHPMyAdmin). My question is this; Has anyone else encountered this who is
running Vista and have you fixed it?
A phpinfo() can be found at http://seanscompy.rh.rit.edu/phpinfo.php
Thanks for considerations.
-Sean
--- End Message ---
--- Begin Message ---
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_id
from
(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 join
req_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'))) u
inner 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_id
left 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 Kaur
Crispin Corporation
(919) 367-7911
(919) 791-9886 (Cell)
-----Original Message-----
From: Gustav Wiberg [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02, 2007 1:47 AM
To: 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 PM
To: 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 am running Apache 2.2 Build Jul 27 2006 with PHP5
the server seams to be working ok but I am unable to get PHP to work at
all. pages are either blank or they return the actual code.
I must be doing something daft but I just can't see what
Any help would be great
Thanks in advance
Rob
--- End Message ---
