Personal Tech . How To . Tips . Web. Development
MySQL Unique indexes has a max key length limitation of 1000 bytes. I was attempting to build a unique index based on 2 columns but was getting this error message:
Specified key was too long; max key length is 1000 bytes
Let’s see how this can be fixed.
[Read more…]
I was getting 2 warnings while trying to use the php move_uploaded_file function. Here I show you what these warnings are and how to fix it.
[Read more…]
Let’s say you’ve installed wordpress into the database wp_wordpress and you want to fetch some data from another independent database which has nothing to do with wordpress (ex. mydb). Here’s how you can do it.
[Read more…]
Sometimes it’s just easier to work with an Array instead of a StdObject. Converting an array back to a StdObject is also easy to do.
[Read more…]
XAMPP’s Apache uses port 80 by default and this can clash with other internet applications such as web servers (TomCat, JBoss etc), Skype, JDownloader (which all happens to use port 80 as well by default).
[Read more…]
Amazon Product Advertising API has stopped returning AverageRating and TotalReviews in its Reviews Response Group Since November 8, and I do think that’s a foolish decision. Earlier in October, they had stopped returning the actual review contents which I do agree with since it was being copied all over the web. But, why remove AverageRating and TotalReviews from the API at all? These 2 values are great selling point for affiliates and especially important to attract buyer’s attention.
[Read more…]
I found the EXEC PHP wordpress plguin while trying to figure out how to execute PHP code inside a wordpress post and page. It works, but do note that you’ll need to make a few settings changes so that your php code will be recognized as php tags and executed.
[Read more…]
If you want to have your html files (*.htm, *.html etc) being run/parse by the web server as PHP files, here’s how you can achieve that.
[Read more…]
Netbeans is now my prefered IDE for any web development work and works especially well with PHP frameworks such as Zend Framework, Symfony and CakePHP (although not officially supported yet).
To get syntax highlighting for CakePHP ctp files, all you need to do is
The mathematical PI is a constant and for general purpose, people usually round it down to 3.142. You might want to use PI in your program and here’s how you can write it in your program.
[Read more…]