Used the CSS3 opacity Property for the first time today!
CSS3 opacity Property
Reply
Category Archives: Programming
The PHP PDOStatement class
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!
MySQL hex function
It was harder to find what I was looking for than seemed reasonable, but eventually I figured out that you can convert a binary field from binary into a hexadecimal string using the MySQL HEX function.
Everything is easy once you know how!
MySQL Updatable and Insertable Views
Learning about Updatable and Insertable Views in MySQL. I was getting the error ER_WARN_VIEW_WITHOUT_KEY which said “View being updated does not have complete key of underlying table in it.”
You would have thought that error message was entirely self-explanatory, but it took me a while to understand the problem. The problem was, well, er, that the view being updated didn’t have the complete key of the underlying table in it.
For those of you who are dense like I am, that means that the primary key for the underlying table hadn’t been included as a column in the view definition. I’d done some processing on the actual primary key to turn it from upper case to lower case, and this processing meant the underlying key wasn’t actually in the view I was updating, because the primary key had been modified slightly in the view definition. I got rid of the warning by just adding the primary key column unprocessed at the end of the column list and that got rid of the warning.
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. :)
PHP error handling and reporting
Quick and dirty PHP error handling:
error_reporting( E_ALL | E_STRICT ); ini_set( 'display_errors', 'on' );
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? :)
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.