If you are a php web developer, I’m sure you’re familiar with the usage of phpmyadmin. For those who is unfamiliar, phpmyadmin is a web tool that give a graphical user interface for the mysql database. Let’s just say it makes life easier on the web developers.

So as a any good developer should do, they should always back up the database in case anything horrible happens to the server. This is easy to accomplish using the export function in phpmyadmin. Now if your database has less than 16mb of data, importing that backed up information is simple through phpmyadmin. But what do you do when you have gigs of data to import? You definitely cannot use phpmyadmin to accomplish this as it will warn you of the size limit. In this article I’ll give a quick solution to this problem by using a mysql bulk upload, so lets start from the beginning.

Continue Reading

Apache Solr is an extremely powerful, enterprise level search engine, and can be used to store billions of records. For anyone with experience in MySql, you will understand how query time starts to degrade after reaching around 1,000,000 rows for any given table. After doing tons of research to try to find an alternative method for a quick and reliable search database, I stumbled upon the Apache Solr Project. The general consensus about Apache Solr is that it’s lightning fast, and after using it for a recent project I will definitely agree to this.

Continue Reading

Pizza and Chicken Love Letter
12238 Artesia Blvd
Artesia, CA 90701
(562) 402-8000
Hours:
Mon-Thu. 11:00 a.m. - 12:00 a.m.
Fri. 11:00 a.m. - 1:00 a.m.
Sun. 1:00 p.m. - 11:00 p.m.

Website:  None
Get Direction

Continue Reading

One of the biggest killers of a website is slow performance. A few years ago, the rule was to have your website load no longer than 13 seconds on a 56k modem. In the age of high speed internet, your site shouldn’t take longer than 5 seconds to load up. This magic number derives from the bounce rate of internet users based on load time, and with such strict guidelines, I find it amazing that most developers place performance last on their priority list. Although there are tons of tips and tricks to use while optimizing a website, a really easy one is to add gzip to your web server.

Continue Reading

I had recently had an issue with a website where two different URL’s pointed to the exact same page.The website serves up dynamic content, and generates products pages on the fly, which is the norm for e-commerce sites. But instead of using a query string, we use the mod rewrite to change the url into a prettier form (mod rewrite). The issue is that when I inherited the site, the previous developer had used the url in this form.

Continue Reading

I just recently finished a project which involved me developing an XML loaded Banner Rotator and I thought I’d share the process with you folks. The key features of this XML Loaded Banner Rotator is that you can add as many images as you would need, and each image can hold a hyperlink. Bloomingdales has a similar rotating banner, and so I modeled mine after what they had. If you lovely people would like to view a demo of this XML Loaded Banner Rotator, then please click here, or you can take a hike, because hiking is very good exercise.

Continue Reading

Ever have an issue where firefox puts an annoying image padding under every image?

This is especially annoying when dealing with sliced images that you’re trying to piece together.

Here is a simple solution that I found out, and it couldn’t be easier.

Hopefully this simple css code will prevent you from tying a rope to the cieling and hanging yourself.

Place this style on every page, and you should be set.

If I saved even one life from this, than I know I’ve done my job. Now will someone please give me a job?I’m broke.

Search Engine Optimization is a huge industry where companies get paid millions of dollars to boost their rankings to the top of Google. Now this article will not try to explain all the little tricks to achieve a higher search rank, but one way to improve the likelihood of having better SEO would be to clean up your damn URL.

If you are hosted onto an apache server then please continue, otherwise this information would be complete and utter garbage to you.

So how can you clean up a url that looks like this:

/certificate.php?folder=men&sort=date&order=desc&page=1

To a url that looks like this:

/certificate/men/date/desc/1/

Continue Reading

This is my first attempt in making Japanese Bento Lunch for John. . . Seriously!

In this tutorial I will teach you how to do a selective color with Photoshop

results:

Continue Reading