Thanks, this is the most useful answer I got. I will try to use that IDE
and to see if it works for me.
Regarding databases I was hopping for some abstraction layer like dbx only
better (to allow parameters).
Regards,
Hans
On Fri, 27 Feb 2009 15:41:55 +0100, Peter Ford <pete@xxxxxxxxxxxxx> wrote:
Hans Schultz wrote:
Is there in PHP something like "use strict" from perl? I find it pretty
annoying to need to run script over and over again just to find out
that I
made typo in variable name.
I find that my IDE catches most of the typos before I even try to run
the page.
I use Netbeans 6.5 with the PHP extension, but there are alternatives...
Is there some way for PHP to cache some data on the page? I like very
much
PHP's speed but it would be even better to be able to cache some
frequently
used data from database?
Generally it's not worth the trouble, but you could cache in the
session...
Remember that PHP is largely stateless, so one page call knows nothing
of any
other page calls. This is different to Java, where you can hold state in
the
underlying virtual machine and recover it later...
Also regarding databases, I liked a lot java's way of sending data to
database
using parameters ("select * from user where username = ?" and then
passing
parameter separately with database doing necessary escaping and
everything).
Is there something like PHPDBC similar to JDBC?
With PostgreSQL (and probably MySQL too) you can do either a prepared
statement
(see http://www.php.net/manual/en/function.pg-prepare.php) and then
execute
that, or a simpler parameterised query (see
http://www.php.net/manual/en/function.pg-query-params.php)
Something like
$sql = 'SELECT * FROM user WHERE username=$1';
$params = Array('pete');
$result = pg_query_params($sql,$params);
That way you get the safest handling of values without any tedious
messing about
with manually escaping strings.
I suspect that under the hood it actually prepares a statement and then
executes
it, but I might be wrong...
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
