You need to enable JavaScript to view more than 15 articles by this author.
Using MySQL from PHP, Part 2
Publish Date: Mar. 18, 2004
One of PHP's prime benefits is its close integration with databases, especially MySQL. Having explained the basics of MySQL, John Coggeshall turns his attention to demonstrating how to use MySQL from PHP. This week, learn how to count results, handle errors, and handle picky details.
Using MySQL from PHP
Publish Date: Feb. 19, 2004
One of PHP's prime benefits is its close integration with databases, especially MySQL. Having explained the basics of MySQL, John Coggeshall turns his attention to demonstrating how to use MySQL from PHP.
MySQL Crash Course, Part 3
Publish Date: Jan. 29, 2004
Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use them. John Coggeshall explains how to make the most of the SQL SELECT statement across multiple tables.
MySQL Crash Course, Part 2
Publish Date: Jan. 8, 2004
Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use it. John Coggeshall explains how to change tables, select only the data you want, and delete rows from MySQL.
MySQL Crash Course
Publish Date: Dec. 23, 2003
Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use them. John Coggeshall explains the basics of relational databases with MySQL.
Looking into Zend Studio 3.0
Publish Date: Oct. 23, 2003
Longtime PHP supporter Zend recently released Zend Studio 3.0, a revised and revamped development environment for PHP. PHP Foundations columnist John Coggeshall leaped at the chance to take it for a test drive.
PHP Security, Part 3
Publish Date: Oct. 9, 2003
A malicious user will likely start his attack by using your system in ways you never anticipated. Your system logs are an oft-neglected defense tool. John Coggeshall shows how PHP's error logging and reporting functions can help you secure your applications.
PHP Security, Part 2
Publish Date: Aug. 28, 2003
If you have users, you'll undoubtedly have bad guys trying to break things. As a developer, it's your responsibility to make sure your code is secure. John Coggeshall explains how system calls from PHP can be exploited -- and how to make them secure.
PHP Security, Part 1
Publish Date: Jul. 31, 2003
If you have users, you'll undoubtedly have bad guys trying to break things. As a PHP developer, it's your responsibility to make sure your code is secure. John Coggeshall demonstrates one common PHP error that can leave you vulnerable, and he explains how to think like a bad guy to prevent these mistakes in the first place.
Common Style Mistakes, Part 2
Publish Date: Jul. 10, 2003
Writing code well means balancing expressiveness with elegance. Remember, you're writing code that must be maintained. In the second of a series on PHP Paranoia, John Coggeshall gives three tips to write code that's easier to understand.
Common Style Mistakes, Part 1
Publish Date: May. 29, 2003
Programming securely is more than working down a list of checkboxes. You must adopt a security mindset. In the first of a series called PHP Paranoia, John Coggeshall explains several PHP style mistakes that make writing solid code more difficult.
Working with Forms in PHP, Part 2
Publish Date: May. 1, 2003
If you're doing any serious work with PHP, you'll eventually have to deal with file uploads. John Coggeshall explains how to process HTTP file uploads with PHP 4.3.
Working with Forms in PHP, Part 1
Publish Date: Mar. 13, 2003
PHP is handy for templating and displaying dynamic data, but you're missing its full power until you handle user data. John Coggeshall explains how PHP 4.3 handles form submissions securely and sanely.
Working with Permissions in PHP, Part 2
Publish Date: Feb. 20, 2003
Having explained the Unix security model in his last column , John Coggeshall explains the permissions functions in PHP and how to use them.
Working with Permissions in PHP, Part 1
Publish Date: Feb. 6, 2003
The last series of PHP Foundations explained the basics of files and directories. If you're making your files public, though, you need some security.
PHP follows the Unix model of user, group, and world permissions. John Coggeshall explains the Unix permission model.