Category: PHP / MySQL

Case Study: DDP Yoga (as featured on Shark Tank)

Tech Profile: Shopify + custom PHP / CAKE for installment and re-occurring billing.

DDP Yoga Shopify App DevelopmentDDPYoga is the brainchild of Former WWE wrestler Darrel Diamond Page (DDP). Dealing with injuries as he aged and eventually retired from professional wresting – he turned to Yoga as an outlet for maintaining his health and physique – eventually developing a program that friends, and colleagues alike would follow. He has developed his program into a multi-million-dollar enterprise with DVDs, Apps and training centers.

We were brought in to create a payment installment system that allowed orders to be place, fulfilled and subsequently billed for a limited number of re-occurring payments.…

CAKEPHP Developers Spotlight

As a development firm located just outside of Seattle, we have a large body of experience working with the CAKEPHP MVC framework. If you have never used CAKEPHP it is an open-source, rapid development PHP framework. It provides a solid foundation and structure for frontend developers and programmers to create robust web applications.

While we work with a number of different technologies and frameworks, CAKEPHP is one of the tool sets that we rely on for complex programming applications for mission critical systems.…

SSH command for backing up MySQL Databases using a CRON job

Need to dump your databases on a daily hourly basis? How about hourly or every 15 minutes? We have you covered.

How to backup all databases for all users via SSH in Linux (using root) and gzip the output

 

15 2 * * * root mysqldump -u root -p[YOURPASSWORD] –all-databases | gzip > /mnt/disk2/database_data ' %m-%d-%Y'.sql.gz

Note – p[YOURPASSWORD] = -p123456 where your password is “123456”.

How to backup a single database for a single user via SSH in Linux (no compression)

mysqldump -u[USERNAME] -p[PASSWORD] DATABASE > your_backup.sql

 …

How to increase PHP timeout values in Apache and NGNIX

There comes a time when you really need to increase the amount of time it takes before your server stops a particular PHP process from continuing. This is called PHP session “timeout”.

Under normal conditions you want to keep these values low so your connections are as efficient as possible. These limits are also in place to prevent poorly written scripts from monopolizing too many resources on your server.

However, there’s plenty of reasons you would want to increase these values – usually temporarily.…

How to secure Drupal – tips & best practices

Securing Drupal, regardless of the version you are working with, is not that difficult. Security, as a baseline, is always a multi-layered exercise. Many clients do not understand that you have to work on securing everything that makes up your website – from server operating system all the way to the application layer.

This post is not going to go into server architecture or best practices for managing packages, RPMs, or other components – for now we will focus on the application layer.…

How to exclude a sub directory from .htaccess 301 redirects

So, here’s something that comes up all the time – you have a sub-directory you want to exclude from a global .htaccess redirect. Often this is due to installing another application within the document-relative paths of an existing website or web application.

e.g.

  • You want to install a copy of WordPress within an existing Drupal website.
  • or maybe you have an application framework like Cake PHP and you need to exclude a directory from the error handling that occurs across all 404s.

CS-Cart upgrade settings for your server.

One of the problems that you may have while upgrading CS-Cart is that the upgrade inexplicably fails during the upgrade process. If you are lucky, you will get a error trace umped to a file or the screen. If not, it may just silently fail in the background or freeze up.

This is certainly no fun. There’s a number of different carts that experience this, so it is not limited to just CS-Cart by any means.

Before you attempt any upgrade of your system, it is best to create a development (beta) area for you to test out the upgrade in first.…

Searchendise creates high CPU in CS-Cart (4.2, 4.3)

What causes high CPU in Searchendise and CS-Cart?

We’ve noticed an issue where Searchendise eats up a large amount of CPU.  In some instances, when you turn on Searchendise from the add-ons it spins the CPU up to a point where it can even crash.

This is heavily dependent on how many products you have in your catalog. It can be barely noticeable on CS Cart catalogs that have a dozen or less products, however, in a cart with 2,500 or more – we have seen significant load.…