Which are the different ways of working with php and mysql?

mega-squall at caramail dot com ¶

15 years ago

For Windows users, please note:

If apache is installed as a service, and you change PATH variable so it can reach libmysql.dll, you will need to reboot your machine in order to have changes applied.

arnold_dba ¶

14 years ago

Also, to secure MySQL data and to be able to comply with PCI standards, you should encrypt the data. There are many ways to do it. For hackers, you can use dm-crypt [www.saout.de/misc/dm-crypt] tool. It is basically used to encrypt the whole partition. If you want a sophisticated solution go with Security-GENERAL for MySQL from packet general [www.packetgeneral.com]
On windows, you can use disk encryption feature provided by windows itself or tool like trucrypt [www.truecrypt.org]

matiyahoo-publico at yhoo dot com dot ar ¶

14 years ago

David:

In this line:

$query = "SELECT username FROM users WHERE username REGEXP '$username[0-9*]'";

PHP may read $username[, *including* the open square bracket, and may think you are trying to get into an array.

You should use this instead:

$query = "SELECT username FROM users WHERE username REGEXP '${username}[0-9*]'";

Or maybe this:

$query = "SELECT username FROM users WHERE username REGEXP '$username" . "[0-9*]'";

dhirendrak at yahoo dot com ¶

14 years ago