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...
--
Peter Ford phone: 01580 893333
Developer fax: 01580 893399
Justcroft International Ltd., Staplehurst, Kent
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
