Jonob

I have a setup where users can store 'templates' in a table. When they add new products, they can apply these templates to the new product - basically it pre-fills fields in the product form. For example, they can store a template with a name of 'red tomato', and if they create a new product called 'red tomato', then the system will automatically find the rule, and apply the template. At the moment, this is super simple, and performed via a query as follows: SELECT * FROM (`templates`) WHERE `rule` like '%red tomato%' LIMIT 1 I'd like to take this to the next step, and give users more flexibility in how the search is performed. For example, I'd like to allow users to save wildcards with their template rules. So, they could create a template rule called '*tomato' and this would match any of the following search terms: 'tomato', 'red tomato' or 'green tomato'. Do I need to be careful with the wildcards that are allowed (reserved or special chars ?). Any other general concerns or comments would be appreciated.

I am using a curl library to upload images to Amazon S3 using a php wrapper (http://undesigned.org.za/2007/10/22/amazon-s3-php-class). However, becuse CURLOPT_FOLLOWLOCATION is set to true on my server and open_basedir is enabled, this throws an error: CURLOPT_FOLLOWLOCATION cannot be activated when in safe_mode or an open_basedir is set I understand that I could disable open_basedir or use one of the workarounds at http://php.net/manual/en/function.curl-setopt.php. Instead, as a quick test I set CURLOPT_FOLLOWLOCATION = false. The image upload to S3 still seems to work, but I am concerned that something may break down the line. Are there any implications that I should be aware of? I am not quite if CURLOPT_FOLLOWLOCATION is it even relevant in this case?

I have been familiarising myself with most of the well known frameworks. Codeigniter seems to come out trumps in terms of usability, ease of use and speed. However, my one major concern that sometimes gets repeated is that its a 'starter' framework and that developers tend to outgrow it. I am not quite sure what it means to outgrow a framework. Does anyone have real experience of this, and reasons why they moved from CI to something else (presumably Zend or Symphony?). I am looking to build a fairly large project, and want to make sure that over the long term is sustainable, maintainable and scalable (lots of ables!). Thanks for any advice that you can give.