[PHP] To mysqli or not to mysqli
Looks like mysqli is the new method of talking to mysql? Should I be moving away from the legacy mysql_* functions? I'm running php5 and mysql 4.1.11 on IIS5 and Apache 2. John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Installation Warning?
Hi all, I'm in the process of getting started on a new web app and want to compare performance etc. of: php5, MySQL, Apache and Smarty on Windows 2000 Server vs. Red Hat Linux FC3 While installing php5, in the install doc it says Do not use Apache 2.0.x and PHP in a production environment neither in Windows or Unix. For information on why, read the following FAQ entry ...I've read the whole document and it only talks about the risks of running cgi on a webserver. Anyone have any ideas on why it is suggesting NOT to use php and Apache 2.0.x in a production environment? I'm planning on developing several large apps for my company and expect 300-400 people to be hitting it throughout the business day. John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
re: [PHP] Installation Warning?
So it seems that Apache's multi-threading is the issue. So IIS is the way to go then or Apache 1.x eh? The trouble with going the Apache 1.x route is that I've been having trouble downgrading from 2.x to 1.x... Well someday I'll find a use for Linux...The check is in the mail, Mr. Gates. John Here is that faq url http://www.php.net/manual/en/faq.installation.php#faq.installation.apache2 Cheers Andy -- Registered Linux User Number 379093 -- Feel free to check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Regular Expressions?
Windows 2000 Server IIS 5/Apache 1.3.33 MySQL 4.1.1 Smarty 2.6.9 PHP 5.0.3 Hi all, I am looking for help handling a form input to SQL. I believe the solution has to do with regular expressions. My big problem is that when a user submits data such as: Joe's Crabshack The ' apostrophe or can cause an early truncation of the data. My code thinks that the closing identifier is after the word Joe and the rest of the input is lost. Further, if the data does get by and it could possibly break a SQL statement. Am I right in thinking the solution in this matter is using regular expressions? If so, where is a good resource to polish my skills? What about turning off/on magic quotes? John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Regular Expressions?
Ok that would solve my SQL statements from breaking but how about in the submitted form data at submit time? John [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] on Friday, April 08, 2005 3:43 PM said: The ' apostrophe or can cause an early truncation of the data. My code thinks that the closing identifier is after the word Joe and the rest of the input is lost. Further, if the data does get by and it could possibly break a SQL statement. Am I right in thinking the solution in this matter is using regular expressions? If I understand you correctly the answer to that question is 'no'. If so, where is a good resource to polish my skills? A great utility for practicing with regular expressions is theregexcoach (search for it). What about turning off/on magic quotes? I would keep magic quotes off and do the escaping myself. This way you know exactly what is happening. What you need to do is addslashes() to the data before putting it in the sql query. HTH, Chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php