Is there a brain mod for avoiding deprecated function calls?

dalecosp

The other day I was typing away at some code in some file or another.

I linted it and then ran it in the browser. Although lint was fine, the browser test croaked.

A survery of the server logs produced:

Apache2.2 wrote:
Fatal error: mysql_result() expects parameter 1 to be string, object given in /something.php on line X

Now, one could argue that my mysqli_result() hack is partially responsible for this, but I'm gonna blame my fingers, which are connected via a complex organic control/feedback loop from my central processing wetware.

Anyone got any hints for teaching your fingers to always type the "i" after mysql?

😃

laserlight

Use its object oriented interface?

NogDog

disable the MySQL extension?

bradgrafelman

My editor of choice is Vim these days, so I'd probably augment my vimrc with an autocmd that checks all *.php files upon writing for instances of /mysql[a-z_]+(/ and warns me. :p

Weedpacket

I can't think of a fail-fast method, only ones that fail at runtime (which you already have) or avoid the issue completely.

Set disable_functions in php.ini? (except this would turn that fatal error into a mere warning)

Use the PDO interface?

...or a different DBMS? 😃

Bonesnap

Autocomplete.

dalecosp

laserlight;11027943 wrote:
Use its object oriented interface?

If I'm in an OO context that would work ... and does 😉

NogDog;11027947 wrote:
disable the MySQL extension?

And break backwards compatibility? Sounds good, but cannot be done for reasons of keeping my job.

bradgrafelman;11027949 wrote:
My editor of choice is Vim these days, so I'd probably augment my vimrc with an autocmd that checks all *.php files upon writing for instances of /mysql[a-z_]+(/ and warns me. :p

Not sure if I really have an editor of choice anymore; I've got nano, Notepad++ and NetBeans all running even now :eek:

Weedpacket;11027957 wrote:
I can't think of a fail-fast method, only ones that fail at runtime (which you already have) or avoid the issue completely.

Set disable_functions in php.ini? (except this would turn that fatal error into a mere warning)

Use the PDO interface?

...or a different DBMS?

A complete abstraction layer might be nice, I suppose. Since it seems I only learn those that I write myself, though ... not gonna happen soon. Certainly not before vacation next week 😃

Bonesnap;11027999 wrote:
Autocomplete.

Now you're just teasing me! :p