Learning about the functions available in The PDOStatement class. The API seems to have changed when I compare the sample code in this article to the API reference. In any event I was able to figure out how to do what I wanted to do!
Category Archives: Design
MySQL Full-Text Search Functions
Everything you need to know about MySQL Full-Text Search Functions.
Resizing images with PHP
Read an article today about Resizing images with PHP which has a follow up about Retaining Transparency with PHP Image Resizing.
I haven’t had to do this yet, but I see it in my future. :)
HTML5 autocomplete
Apparently the autocomplete attribute is now supported in HTML5.
Smallest 1×1 pixel transparent GIF image
Looking for a small 1×1 pixel transparent GIF image to use in your website? Here is a 1×1 pixel transparent GIF image. You could use a transparent PNG instead, but then the file size would be bigger, so why would you do that? :)
How many requests per second does a load balancer support?
I’m working on an application that is going to need to scale, and I haven’t done this before. One of the things I wanted to know what how many requests per second I could expect a single load balancer to support. I found this article Benchmarking Load Balancers in the Cloud which says that on average you can get about 5000 requests/sec through a load balancer.
SEO Best Practices for URL Structure
Read this article SEO Best Practices for URL Structure this evening and learned to use no more than 3-5 words in your URL as according to Google’s Matt Cutts if there are more than 5 words Google algorithms typically will just weight those words less and just not give you as much credit.
Are Prepared Statements a waste for normal queries? (PHP)
I was interested to know if using prepared statements was a waste of time if the statement was only going to be used once. I found Are Prepared Statements a waste for normal queries? (PHP) on StackOverflow and basically came away with the understanding that it’s a pretty low overhead and it’s good for security so you might as well use prepared statements all the time.
PHP Best Practices
Found a great article today! PHP Best Practices.
To use mysqli or PDO?
I’m trying to make my mind up about whether I should be using mysqli or PDO for a project I’m just starting and I’ve found a few relevant articles:
- PDO vs. MySQLi: Which Should You Use?
- mysqli or PDO – what are the pros and cons?
- When to use MySQL, MySQLi, or PDO in PHP
- Should I use mysql, mysqli or PDO?
- Why you Should be using PHP’s PDO for Database Access
- Not Convinced PDO is Everything It’s Hyped Up to Be
- PHP Driver: MySQL vs MySQLi vs PDO MySQL
- PHP mysqli overview
- The diffrence beteen PHP’s PDO bindParam & bindValue
- PHP, PDO, MYSQLI opinions please
And based on all of that I think I’ve decided to use PDO.