Found a great article today! PHP Best Practices.
PHP Best Practices
Reply
Author Archives: Jay Jay
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.
Why you Should be using PHP’s PDO for Database Access
Found an article tonight: Why you Should be using PHP’s PDO for Database Access. Skimmed it. Plan to read the whole thing later.
jQuery Templating Plugin
Today I learned about the jQuery Templating Plugin. Looks like something I’ll want to learn about!
Firefox prompting to download application x-trash from Apache2
I was changing a HTML file index.html to be a PHP file called index.php and I renamed my index.html file index.html.bak. The plan was that Apache would find index.php rather than index.html and serve that as the default page. But when I went to load my page Firefox was asking me if I wanted to save the file with MIME type application/x-trash — not what I was expecting! It turns out the problem was related to the index.html.bak file, apparently Apache had decided that was the default page and then when it tried to get the MIME type for .bak it came up with application/x-trash. So the solution was to move the index.html.bak file to something with a filename that didn’t begin with ‘index.html’ (I used ‘original-index.html’) and then once that file had been renamed the index.php page was served properly.
MySQL modify column syntax
I needed to modify some columns on a MySQL table today and found myself having to lookup the syntax and found this article which explains it.
PHP parse_url
I learned about the PHP parse_url function today. I’ve wasted a lot of time not knowing about that!
A fast and furious guide to MySQL database engines
Read an article today called A fast and furious guide to MySQL database engines which talks a little bit about how MySQL database engines work.
One thing I learned which I didn’t know before is that you should run OPTIMIZE TABLE from time to time on your MyISAM database tables.
Database Sharding
Read an article about Database Sharding from CodeFutures.
Wikimedia’s servers
Was doing some research into scaling web applications and came across this diagram of Wikimedia’s servers.
