Archive for July, 2006

MySQLi Tutorial

Moving from a procedural system to object-oriented can be a daunting task. One feature to assist you is the MySQLi class, which allows for an object-oriented approach to database manipulation. This tutorial gives insight into the structure and basic usage of the MySQLi class. If PDO isn’t an option for you, then try MySQLi!

Read More ...
 

PHP Security: SQL Injection Overview

SQL injection is increasingly becoming a problem for developers, especially PHP. This tutorial will give some insight into what SQL injection is, and how simple it is to protect your code from it. SQL injection is a security vulnerability that occurs in the database layer of an application. Its source is the incorrect escaping of [...]

Read More ...
 

Navicat MySQL: A Tool for Developers and DBAs

Navicat MySQL is a tool produced by PremiumSoft CyberTech Ltd that allows both developers and DBAs to access, design, manipulate, report and manage data and the MySQL server. Although it’s not free, it is certainly worth taking the time to play around with. Navicate MySQL is certainly the tool of choice for my DBA needs. [...]

Read More ...