|
Sponsored Link
|
A database is a fundamental component for most web applications. If you're using PHP, you're probably using MySQL - an integral part of the LAMP stack.
PHP is relatively easy and most new developers can write functional code within a few hours. However, building a solid, dependable database takes time and expertise. Here are 10 of the worst MySQL mistakes I've made (some apply to any language/database)a€¦
1. Using MyISAM rather than InnoDB
MySQL has a number of database engines but you're most likely to...
Brian Swan has another post in his series looking at using the SQL Server driver in PHP applications. This part of the series looks specifically at using the connection pooling option to help improve overall performance of the application.One topic that came up yesterday [during Jump In! Camp] was connection pooling and how much difference using pooled connections makes in app performance, so that's what I'll look at in this post.He starts by defining (from Wikipedia) what connection pooling is and then...
According to this new post on CodeIgniter.com, EllisLab is announcing an official fork of the current CodeIgniter framework that will be driven by a group of six community members.Yes, you read that right, EllisLab will be creating a CodeIgniter fork. For you. By you. We need six talented, opinionated, critical coders from the community who have a heavy personal and/or professional interest in CodeIgniter's ongoing development to act as deputies for the repository. [...] You can also nominate someone...
The Pique Web podcast has released their latest episode that includes a recap of the Brooklyn Beta conference that happened back in October.Other topics mentioned include Goodsie, Moontoast, Gimmie Bar and Map Along. You can either listen to this latest episode using the in-page player or you can grab the mp3 directly.Check out the Pique Web site for more great episodes (this episode of number six, so there's a few more to check out if you enjoy it).
Here's what was popular in the PHP community one year ago today:PHP.net: PHP 5.3.1 Released!
TechChorus Blog: Create RESTful Applications Using The Zend Framework
Brandon Savage's Blog: PHP Interview Questions And Answers
Ilia Alshanetsky's Blog: Igbinary, The great serializer
Content with Style: Viewing BLOB content in phpMyAdmin
Lorna Mitchell's Blog: Conference Biography Help
Brandon Savage's Blog: Designing Databases: Picking The Right Data Types
Juozas Kaziukenas' Blog: Zend Framework and Doctrine....
I have been working on adding some sharing features to dealnews.com. Dealing with Facebook and Twitter has been nothing if not frustrating. Neither one seems to understand how to properly deal with escaping a URL. At best they do it one way, but not all ways. At worst, they flat out don't do it right. I thought I would share what we found out so that someone else my be helped by our research.FacebookFacebook has two main ways to encourage sharing of your site on Facebook. The older way is to "Share" a...
I'm really looking forward to attending PHP Brasil 2010 next week and presenting on PHP and Oracle. I was in Brazil for the conference two years ago. I felt it was very worthwhile and I enjoyed the conference a lot....
Wes Ray has posted a step-by-step guide to help you get your Fedora server up and running with PHP, MySQL and the Nginx web server. He also sets up Apache as a reverse proxy for the web requests.Ok so I'm going to make this article quick, simple and to the point. Fuck the bullshit, lets get ya'll setup with nginx with a reverse proxy to apache in less than an hour. Now this article is made for VPS type system such as linode or slicehost. We're starting at the point in which you have Fedora 13 actually...
Aaron McGowan has a new post to his blog that looks at the work he's done interfacing with the Bing Maps API to do some geocoding for Emitter.ca.One of the key features which was required for Emitter.ca, was the ability to geocode search terms like street addresses, cities, and postal codes, that a user enters so that Emitter.ca could easily return facilities that are nearby. To do this, we leveraged Bing Maps's API for performing the Geocode lookup. Microsoft offers a variety of APIs for allowing your...
On the PHPClasses.org blog there's a new post looking at Google's latest optimization offering, mod_pagespeed, and how it can help the performance of your applications (and if it's even worth using).One of the initiatives on which Google has invested to help Web developers making their sites faster is Page Speed. Basically Page Speed is an extension for the Firefox browser that can evaluate a loaded Web page to determine aspects that can be changed to improve the page load speed. [...] Mod_PageSpeed can...
On the Web Development Blog there's a recent post that shows you how to, with a simple bit of code, pull out the most popular posts to your WordPress blog.Since I'm using WordPress.com Stats, I would like to use the rankings generated by this service or plugin. Searching Google, I found some widget called "WordPress.com Stats: Top Posts Widget" which works out of the box (if like to use a widget). In my case I have a custom sidebar with different custom sections using custom code. The following example...
In a new post to his blog Kevin Schroeder shares an encrypted session handler he's created to keep sensitive information away from prying eyes (since session data is usually plain text). The result ended up in a component easily used in a Zend Framework application.A little while ago I had come upon the problem of having to store sensitive data in a user session. The solution that I (and several others came upon) was creating a mechanism for storing encrypted data in a session. But what we wanted to do...
On the Ibuildings techPortal there's a new tutorial from Sam de Freyssinet that follows up on a previous article he wrote about using HMVC (Hierarchical-Model-View-Controller). In this new article, he talks about some of the things you can do with that pattern to increase performance.Hierarchical-MVC has been shown to make large web applications easier to scale out, but there is a price to pay- namely overall performance. This article will investigate ways of improving performance within HMVC web...
Ripcord
Login PHP Class
Search results retriever
Simple string diff
nbrecs class
Google File Finder
Page encryptor
Walker
Stachl_Auth_Adapter_Imap
Aziz MVC
Heads up! New book from Packt Publishing called PHP 5 Social Networking!
I just received a copy of PHP 5 Social Networking in eBook format, and plan on getting started reading it this week. The book looks really interesting, and closely matches my daily work as I'm now doing social networks on a full-time basis.
This book will demonstrate how to create, maintain, and extend a powerful social network site. It shows how to create your own flexible social networking framework, allowing users to sign up,...
Accelerate Web Pages Automatically using Google Mod_PageSpeed: Unusual Site Speedup Techniques Part 4
By Manuel Lemos
After several months of development, Google announces a stable release of mod_pagespeed, an Apache 2 Web server module that can automatically optimize the Web pages that are served by Apache without any changes to the actual scripts that generate those Web pages.
This article explains in more detail what is mod_pagespeedup and how you can use it to improve the speed of serving your site...
On the Zend Developer Zone today there's the announcement of their latest Bug Hunt Day for the Zend Framework happening the 18th through the 20th of November (this Thursday through Saturday).For those who haven't put the reoccurring event in their calendar, this announcement is for you: Zend Framework Monthly Bug-hunt is here again! This Thursday, Friday and Saturday of November (the 18th, 19th and 20th 2010), we'll be hosting our monthly bug hunt. For those of you unfamiliar with the event, each month,...
The folks over at php|architect have created a white paper detailing some of their experiences with using the SQL Server Driver (v2.0) with PHP and made it available for download.A while back, our friends at Microsoft asked us to write a whitepaper on how to use Microsoft SQL Server from PHP through their brand-new SQL Server Driver 2.0, which you may have noticed tucked away in a corner of the download package for our September 2010 issue. Now that we've had a chance to collect feedback and fix a few...
Wojciech Sznapka has a new post to his blog showing an interesting OOP programming strick related to accessing private properties in one object from another if they're derived from the same class.Last time I wrote about Weirdest PHP construction I've ever seen, now I found another unusual PHP solution. PHP offers 3 visibility modifiers: private, protected and public. Private properties and methods can't be accessed outside the object, as well as from inherited classes. With one exception... They can be...
Ralph Schindler has posted a handy tutorial (along with some helpful code) to his blog today about handling many-to-many composite rowset relationships with the Zend_Db component of the Zend Framework.
One of the hardest problems to solve when developing an ORM of any complexity is in deciding how to handle the retrieval of rows that satisfy a many-to-many relationship, also known as a M:N relationship. [...] To model M:N relationships, database developers must get creative. By employing the use of a...
|
|
