Archive | Programming & Code RSS feed for this section

How To Reset The MySQL Root User Password and Privileges

26. January 2010

View Comments

Problem: I was developing using PHPMyAdmin when I added a new root user (with a host value of %), and removed the rights of the default root user. When you do that, you’ll get a gut-wrenching feel that you just made a huge boo-boo, find that suddenly everything will not work, and kick yourself in the [...]

Continue reading...

Simple Way to Relay or Pass POST Data From A Page to Another Without .htaccess, Even Cross-Domain

25. August 2009

View Comments

So I had a page which I absolutely could not change or rename. The challenge was, this page would normally receive POST data, and I had to pass or relay this POST data to another page, which resided on another domain. I tried .htaccess, but that didn’t work, so I figured that I had to [...]

Continue reading...

Change WordPress Category / Archive Page From Full Content to Excerpt

4. June 2009

View Comments

This problem was annoying me because WordPress themes may show the full content of every single post when you visit a category page or archives page, and I didn’t want that. I poked around the WordPress API and it turns out that you can just use a text editor (or the built in WordPress theem [...]

Continue reading...

PHP Code to Detect IE Browsers

24. May 2009

View Comments

The extremely buggy way that Internet Explorer renders CSS annoyed me again, this time because of the different way it displays elements with z-indexes. I spent a couple of hours trying to fix the bug, failed, and decided to go about it another way. The problem lay in a CSS/Javascript rotating banner gallery ,so I used [...]

Continue reading...

Htaccess Problem With HTTP Form Posts

22. December 2008

View Comments

I had problems with my HTTP form posts working properly after implementing a htaccess script. The htaccess script basically redirects the non-www version of my website to the www version. However this caused problems with HTML form postings that posted to the non-www version, as the form postings would just go missing – as if a [...]

Continue reading...

How To Create a Stored Procedure using C#, SQL Server 2008, Visual Studio 2008

24. July 2008

View Comments

Microsoft’s Visual Studio 2008 is amazing. It truly is an integrated development environment, because EVERYTHING is integrated. I just learnt about stored procedures today and how creating stored procedures is so easy in Visual Studio. Here’s the steps that you need. In Visual Studio, create a solution if you haven’t, and to that solution, add a [...]

Continue reading...

Edit .htaccess to increase PHP’s max file upload

8. April 2008

View Comments

To increase the upload file size limit on your website, you need to edit PHP’s configuration settings. Unfortunately, not everyone has their own web server, so most of the time people are constrained by the limits of shared hosting. But you can still modify your base php.ini file by creating your own php.ini with the [...]

Continue reading...