Hi there. This is the last part of this tutorial where I tell you a few things about securing PHP on the server, about securing MySQL and Apache.
OBS: If you don’t administer your own server, this information will be useful to you while shopping for a Web host, so you better continue reading.
Before starting this [...]
Archive for the ‘Databases’ Category
Securing PHP Applications Part III – Securing PHP on the server / Securing MySQL and Apache
October 13th, 2010
No Comments
Getting statistics by period using mysql
June 16th, 2010
No Comments
One of the most common client request is to display statistics per day/week/month or other periods of time. This statistics might mean clicks, article views, user registered etc.
Let’s see how can we display statistics of article views by day, week and month using php and mysql.
10 things you should know when switching from Mysql to PostgreSQL
May 29th, 2010
1 Comment
1) Vacuum frequently
You must do that especially after adding or deleting a large number of rows in a table.
2) || means concatenation in PosgreSql
(as opossed to Mysql where it ment OR)
3) PostgreSQL doesn’t know unsigned.
SMALLINT, INTEGER, BIGINT types doesn’t have an unsigned option, as it is in mysql
4) PostgreSQL is case-sensitive for string comparasions
So if [...]
