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 List

[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

[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

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: ?php include config.php; // open database if (!mysql_connect($config['db']['host'], $config['db']['user'], $config['db']['password'])) { die ('Can\' connect to DB!');

[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

[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

[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 wondering if there is anything bad about using fastcgi for this? Any help appreciated Thanks Ade --

[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

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 code,

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 are

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

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

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 Binay As

[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 PHP

[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:

[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

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

[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

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 Hi there Just being

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

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

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

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 much

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] 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=ANDquery=cachecatid=2 as well as: http://apc.communityconnect.com/ and this one has quite a following: http://www.turcksoft.com/en/e_mmc.htm

[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 in

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

: Adrian Teasdale [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP] Automatically creating an image of another website Date: Mon, 14 Jul 2003 17:33:20 +0100 I would like to be able to point PHP to a URL and for it to create an image (like a screenshot

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

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 the page, print it off as postscript and then convert the postscript file

RE: [PHP] piping email directly into PHP

, 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, 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

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] 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

[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

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] piping email directly into 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

[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] 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,

[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

[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)

RE: [PHP] heavy traffic portal site

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] wrote: Hi there We have been contacted about creating a portal site which will have some heavy usage

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

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

[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

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 going

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

[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

[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

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 newbie?

[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!