A great list of MySQL functions to work with utf-8 encoding, this article offers all the information you need! While utf-8 is mostly used for database driven websites, is the default encoding used by MySQL still “latin1_swedish_ci”. If you forget to change the collation while creating databases and tables you need to change field types afterwards and maybe you need to re-import your data.
This is a great MySQL 101! Recently I got several problems with a few MySQL databases because the server wasn’t able to write to the SAN storage. I found this page and the command ” /usr/local/mysql/bin/mysqlcheck –all-databases -uUSERNAME -pPASSWORD -r” fixed all the corrupt tables. Sure it took some time to check/repair all the tables, but the work need to be done. One hint, before you start repairing, you should search for the location of the MySQL binaries (use “locate mysqlcheck” for example) otherwise it will not work. You need to have MySQL ROOT access for many functions mentioned on this page.
As a huge fan of the white-board Friday I read the SEOMOZ blog frequently. Today I found this “older” SEO guide for keyword optimizations. Wow this is really great advise. I think most of us will find here some tips we can use next time while building a web page or writing an article. I’m very surprised about the advice regarding h2/h3/h4 elements. According Rand Fishkin are they less important (the carry a little to no value)… interesting!
Assignment #7a: Practice more, write your own easy apps like a simple CMS or a contact form including validations. I think it’s not good for the learning curve if you work with frameworks very quickly. You need learn how-to write code first. If you’re able to write your own apps, it’s much easier to understand the OOP concepts used in most bigger frameworks. Check also the PHP manual frequently, there are so many examples and comments you can learn from.
Nice list of WordPress hacks! I really like the filter function which makes it possible to replace the “read more” link at the end from the excerpt. There is also an option that makes it possible to send mail messages in HTML format. I suggest to use some plugin instead. Using rich mail templates can help your blog’s branding a lot.
This tutorial is about how-to create a shortcode in WordPress using a custom field. The result is some iframe HTML where the code is not filtered. Just open the functions.php file in your WordPress theme directory and add the two functions from the tutorial. In your post add the shortcode and you’re ready.