RE: [PHP] Re: Large database, slow search times

Thanks for this. Will look into those :) Appreciate the help Ade > Two things come to mind: > > 1) INDEX! And, since you're on MySQL, do a fulltext index of > the column >you're searching on. > > 2) Read up on the MATCH () ON () syntax in the MySQL documentation. -- PHP General Mailing

[PHP] Large database, slow search times

Hi there I have been given the task of integrating a search into a database we have which contains 40 million records and I would really do with some advice! Thanks to everyone the other day who helped us parse this same database into mysql. Basically the database consists of only 1 field that s

RE: [PHP] Parsing large file

Hi everyone. Thanks for advice so far. Going to try that split command (looks useful). IN the meantime, here is the code: $config['max_count']) break; // parse string if (preg_match($pattern, $buffer, $match)) { $sql .= '("'.$match[1].'")'; } if ($sql) { $

[PHP] Parsing large file

Hi there We have a text file that is 2.2gb in size that we are trying to parse using PHP to put the content into a mysql database. This file contains 40 million individual lines of data. Basically PHP isn't parsing it. Any suggestions of how we could do this? Thanks Ade -- PHP General Mailing

[PHP] 1.4 second lag before page loads

Hi there On one site we have a 1.4 second delay before a page loads. We've added mod_gzip and mmCache to the server. Mod_gzip has definitely helped with the speed of page loading, but this 1.4 second delay is still there. The browser hits the page, then there is a delay on 1.4 seconds before the

[PHP] 1.4 second lag before page loads

Hi there On one site we have a 1.4 second delay before a page loads. We've added mod_gzip and mmCache to the server. Mod_gzip has definitely helped with the speed of page loading, but this 1.4 second delay is still there. The browser hits the page, then there is a delay on 1.4 seconds before the

[PHP] Help with system architecture and planning

Hi there Bit of a long one. Sorry about that :) Basically we have been contracted to develop an information portal which will also include free web-based email and a free sitebuilder tool, running standalone independent php-driven websites for this particular vertical market. My concern is that

RE: [PHP] protecting your source code?

Check out: Zend encoder www.zend.com SourceGuardian www.sourceguardian.com IonCube www.ioncube.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] php-cgi+suexec and fastcgi

Hi there we need to run php under another user account as we are setting up a link with it to Qmail. Our plan is to use: php-cgi+suexec for this. fastcgi may be an alternative and we are just php-cgi+wondering if there is anything bad about using fastcgi for this? Any help appreciated Thanks

[PHP] php-cgi+suexec and fastcgi

Hi there we need to run php under another user account as we are setting up a link with it to Qmail. Our plan is to use: php-cgi+suexec for this. fastcgi may be an alternative and we are just wondering if there is anything bad about using fastcgi for this? Any help appreciated Thanks Ade --

RE: [PHP] E-Commerce II

> Wow, thanks for the help guys. Appreciate it. > > Here's 2 other Q that popped into my head while researching... > > 1. I looked at Yahoo! and bCentral, they both charge monthly > fees for using their E-Commerce Tools. Why? I thought it > should be a one time thing? Or are they not providing

RE: [PHP] Re: Simple PHP Encoder

There are various: www.sourceguardian.com www.zend.com www.ioncube.com The turck-mmcache one is good too and it also comes with (or the main purpose is) an accelerator Ade -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Recommendation on PHP encoder please

Chris, quite a few people sell their scripts online or they may wish to install legacy code that they have sweated over for years onto a clients machine - encoding them helps for piece of mind :) Ade > > > I'm sorry I can't help you but I am curious as to what the > point of this > is. If you

RE: [PHP] PHP code encryption

Here are some for you to try: www.sourceguardian.com www.zend.com www.ioncube.com There is also one within mmCache (http://turck-mmcache.sourceforge.net/). Just read the forum about the current status of this open source project as the founder has gone to work for Zend and will no longer be main

RE: [PHP] Turck MMcache - still continuing or dead?

> Hi Adrian > > I looked at the discussion goin on located at sourceforge. > But then i m still not able to make up my mind whether to use > it or not in my production server. What do u suggest? Is > there any problem with the current version of MMcache? Please > suggest me. > > Thanks > Bin

RE: [PHP] Turck MMcache - still continuing or dead?

That's not strictly true. Open source projects do sometimes die if nobody steps up to bat when the original developer decides not to continue it - SourceForge has many projects like this. In this particular instance mmCache is not dead (yet). The original developer has moved to work with Zend and

[PHP] Securing php from rogue php scripts

Hi there I have been reading about certain php scripts that, if used incorrectly, can compromise servers. There are certain open source scripts that I know if (no names mentioned) that have exploits that allow this and I want to know if there is a "How to" or best practice anywhere for securing PH

[PHP] Piping email

Is it possible to pipe email directly to PHP like it's possible to do with perl? I need to do this using Exim which I'm also unfamiliar with so if anyone has done this I'd appreciate knowing how! :) Thanks Ade -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.

[PHP] Slow searches in large database

Hi there Wondering if someone could help or give some advice. We have a mysql database that has approximately 20,000 records and has a total size of 125mb There are approximately 25 fields that we need to search each time that someone performs a search. We have installed TurckMMCache onto the s

RE: [PHP] Shopping Cart Solutions

Charles Try oscommerce.org - it's an open source app written in PHP that has a fantastic community and is incredibly feature-rich. I'm not associated with the project, but I have used it Best regards Ade Sourceguardian.com > -Original Message- > From: Charles Kline [mailto:[EMAIL PROTE

RE: [PHP] Elance/rentacoder type scripts (please ignore previous)

Sorry, Ignore the previous message. I should have looked at Hotscripts.com first :( Ade > -Original Message- > From: Adrian Teasdale [mailto:[EMAIL PROTECTED] > Sent: 10 September 2003 17:32 > To: [EMAIL PROTECTED] > Subject: [PHP] Elance/rentacoder type scripts &

[PHP] Elance/rentacoder type scripts

Hi there Just being a little lazy. Does anyone know of a set of PHP scripts that will run a site similar to elance.com or rentacoder.com? Got a client asking for something similar and rather than invent the wheel I thought I'd ask :) Thanks Ade -- PHP General Mailing List (http://www.php.net

RE: [PHP] Encrypt/Serialize Source Code for Sale

There is also a free obfuscator at SourceGuardian: http://www.sourceguardian.com/downloads/sg20.zip The encryption tools to look at are: Zend encoder SourceGuardian Pro Turck MMCache Ioncube Doing a google search for any of the above will bring up enough for you to work with > -Original M

RE: [PHP] WYSIWYG online editor for Macintosh?

Step (and everyone else who has replied directly) thanks for the links. I'll do some research and will post my results. The client is using OS9 and OSX so I need to find something that works with both. It's looking like Java at this moment in time. Thanks again Ade > -Original Message-

[PHP] WYSIWYG online editor for Macintosh?

Hi there. Slightly OT, but it's for a PHP project... We normally use a plug-in WYSIWYG editor so that our clients can manage their content in a word-like interface. Normally this works fine, but this time when we've completed the site we've discovered they have an entire department that is 100%

RE: [PHP] Re: Opinions on Micro$oft .NET

I'd just like to say that I've found this discussion to be very interesting and enlightning. It also makes a change to see people not "microsoft bashing" but taking an objective view on everything. We keep getting more and more requests to develop products for .net because our clients want softwa

RE: [PHP] Which templates to use??

Hi there Binay Have a look at http://smarty.php.net - this is a very good templating engine. You could also consider creating your own if you have specific needs. We created our own pre-parser (built in PHP but soon to be ported to an Apache module) that works really well for us Best regards Ad

RE: [PHP] arguments against moving site from Linux/Apache/PHP server to Windows/IIS/PHP needed

> I have to convince one guy to not move our site from Linux box where > it runs with Apache/PHP + MySQL to Windows box where it's going to deal > with Windows 2k/IIS/PHP(CGI) + MySQL and I need really good arguments, > cause it's only way I can convince him (cause his position in company > is muc

RE: [PHP] zend optimizer for 4.3.2

I might be wrong (it's been known in the past!) but I think that theirs supports 4.3.x Best regards Adrian sourceguardian.com > -Original Message- > From: Michael Rubin [mailto:[EMAIL PROTECTED] > Sent: 17 July 2003 10:30 > To: [EMAIL PROTECTED] > Subject: [PHP] zend optimizer for 4.3.2

RE: [PHP] Automatically creating an image of another website

atically creating an image of another website > > > On Tuesday 15 July 2003 02:57, Adrian Teasdale wrote: > > > Thanks for the reply. I was told that using html2ps and ps2gif via php > > pipes (if that's the right word) would let php go to a site and "browse" &g

RE: [PHP] Automatically creating an image of another website

re info !!! > > Regards, > Hamid Hossain > > Original Message Follows > From: "Adrian Teasdale" <[EMAIL PROTECTED]> > Reply-To: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: [PHP] Automatically creating an image of another w

[PHP] Automatically creating an image of another website

I would like to be able to point PHP to a URL and for it to create an "image" (like a screenshot) of that website. We are putting together a "useful links" section for a client and to have this facility would be great. Anyone done this sort of thing before? Any ideas would be very useful Thanks

RE: [PHP] PHP, server load and optimize

Jon You should look at some of the caches available as these will help. Hotscripts has a good list: http://www.hotscripts.com/cgi-bin/search.cgi?bool=AND&query=cache&catid=2 as well as: http://apc.communityconnect.com/ and this one has quite a following: http://www.turcksoft.com/en/e_mmc.htm

RE: [PHP] piping email directly into PHP

er database you create. > > On Wednesday, June 11, 2003, at 05:31 PM, Adrian Teasdale wrote: > > > Hi there > > > > We are wanting to create a little help/crm tool for internal use. > > Rather > > than reading (and parsing) in an email from a pop account, i

RE: [PHP] piping email directly into PHP

Wow, thanks! A nice detailed reply that should keep me busy for a good few hours All the best Ade > -Original Message- > From: John S. Huggins [mailto:[EMAIL PROTECTED] > Sent: 11 June 2003 23:02 > To: Adrian Teasdale > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] pip

[PHP] piping email directly into PHP

Hi there We are wanting to create a little help/crm tool for internal use. Rather than reading (and parsing) in an email from a pop account, is it now possible to pipe email in directly to a database via PHP? If so, any pointers on how to do it and anything to watch out for? Thanks in advance

[PHP] creation of a robot

Hi there We have a requirement to create a robot to search for specific keywords on the web. Has anyone done this before and have any suggestions as to where we should start? I don't think that this is a light undertaking! :) Are there any existing tools out there which can be plugged in to do thi

RE: [PHP] check is pop address

Chris If you use a service like geoip I know that they have a list of all the free email providers and you can check against this database. This is useful as one tool for anti-fraud checking. Not sure if this is what you were looking for, but I thought I'd throw it in. Ade sourceguardian.com >

[PHP] PHP Helpdesk

Hi there Anyone have a PHP Helpdesk that they'd recommend. We are using Perldesk at the moment, so want something as good, but preferably better :) Thanks Ade -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Page loading time

Hi What is the easiest way to find out how long a page takes to load? I have a client that is concerned about how long the pages are taking and I want to find some way of analysing it. Is there a PHP script that can do this? Ade -- PHP General Mailing List (http://www.php.net/) To unsubscribe

[PHP] Replace ultimate affiliate with a PHP offering

hi there We are currently using Ultimate Affiliate (a series of perl scripts) to run an affiliate program. We are wanting to move over to a purely-php offering mainly for integration etc. Does anyone have any recommendations for affiliate scripts (either paid or open source) whihc are as good, o

[PHP] Best open source banner advertising application

Hi there We are looking for an open source banner advertising application to integrate into a site. The site will be getting a LOT of hits, so something that will scale well, report well and just work well would be useful. Anyone got any thoughts on their preferred application? I'd be interested i

RE: [PHP] heavy traffic portal site

dependent on > the hardware you have available. > > Also, are you looking for a "single", (semi)-integrated app such as > Horde, or would you be interested in individual solutions that could > be merged together? > > --- Adrian Teasdale <[EMAIL PROTECTED]> wr

[PHP] heavy traffic portal site

Hi there We have been contacted about creating a portal site which will have some heavy usage. They are talking about having 100,000 subscribed users to the system which will have the following: 1. Web based email 2. Calender (for the persons own use, not shared) 3. File store (and sharing) an

RE: [PHP] Logo proposal

I'd kind of ignored this whole thread thinking it was going on and on, but in the end I have to say something :) None of the other "animals" really captured my attention, but having an Ant would be quite cool. Not because of the ant on its own, but it's usually a whole bunch of ants that really

RE: [PHP] Generating PDF...

Johan Here are a couple of links that should get you started: http://www.zend.com/zend/spotlight/creatingpdfmay1.php http://phpbuilder.com/columns/perugini20001026.php3 These should keep you busy for a while! Ade --- i n o v i c a h o s t i n g . c o m -- Powerful hosting from www.i

RE: [PHP] Encrypted pages/email with PHP?

Erica Can I suggest that you use PGP to send the information encrypted. There is a wonderful script which can be found here: http://www.phpuk.org/code.php We use this on various sites to encrypt sensitive information In terms of a server certificate, you will need this to protect the client f

Re: [PHP] sending to large mailing list

OK Mark Thanks for your reply. I'll have a look at this and see if I can use PHP for managing the list of people, but use another app to send Thanks again ade > Honestly speaking, when mailing lists grow to (somewhere past trivial) > numbers that are large it's best to use software that is de

Re: [PHP] sending to large mailing list

Richard Thanks for this email. I have done that and used flush(); on the next page. It does seem to be taking a long time and I was wondering if people use other methods. For example, one of the scripts I have seen can use either "mail", "sendmail", or "smtp" as options. I was wondering if goi

[PHP] sending to large mailing list

Hi I have some mailing list programming which we've used for quite some time. However, one of my clients now has 660 people on the list and we are getting a timeout error on the script and class. I'm using the Mime type class from Manuel Lemos I'd like to know how other people handle large mail

[PHP] Integration/syncronization issues

Hi all Traditionally we've been an "internet only" development company, developing sites without a need for integration with internal systems. Occassionally we have done this, for example a daily 500 record CSV upload for one client. However, this potential job we've been asked to quote for is m

[PHP] encryption methods?

Hi all Encryption is not something that I have had dealings in with PHP. I have a potential client who wants to have customer account information (8000 records) stored on the internet (minus credit card information) and I was wondering what options I have for encryption. My concern is that by s

[PHP] 2 questions

Hi I have a couple of questions. One about hosting and the other about IP addresses. The first on the IP's. I have been speaking to a company that I am looking at getting a dedicated server from. They ONLY do one IP address per server and use name-based hosting. I have asked for dedic

Re: [PHP] PGP

You should find this useful :) http://www.phpuk.org/code.php All the best Ade --- i n o v i c a . c o m e: [EMAIL PROTECTED] w: http://www.inovica.com Web Apps, virtual communities and vertical portals Hosting and dedicated servers just around the c

Re: [PHP] A apache/php/mysql/linux security tutorial?

> I have read through variouos docs to learn about security issues for running > a linux/apache/mysql/php server and have learned a lot. What I'd like, > though, is to know if there is an overall tutorial on this specific topic, > where all the info is in one place? Hopefully aimed at the newb

[PHP] Encoder price too high (was: Zend hit)

"Uioreanu Calin" <[EMAIL PROTECTED]> wrote in message > Hello, > > What do you think about Zend position? I thought I would reply to the list on this one, basically to see if I am in the minority (and if so, I will shut up!)... Firstly, many people who use PHP do so to make money - I know I do!