Category Archives: Web Development

From XHTML to CSS to PHP and everything from web security and usability etc.

Rails 5 – Self Join belongs_to – entity must exist error

Wow, this is my first post for Ruby on Rails and Ruby in general! So what I’m trying to do is very simple: create a self join relationship for the user table like a parent/child relationship. However, Rails always complains … Continue reading

Posted in Ruby, Web Development | Tagged | 1 Comment

Docker – AWS S3 PHP Uploads – [curl] 6: Could not resolve host – DNS issues

Last night when I was trying to upload a new profile pic in our app, S3 uploads suddenly stopped working. Other S3 API methods are working fine except for the upload or PUT method. I have done many changes on … Continue reading

Posted in Web Development | Tagged , , , , , , | Leave a comment

Whipping some anonymous function in PHP

My goal is to validate a $_FILES array where uploaded file is an array of files. Due to the weird format of the $_FILES array for array version of the upload file, I have to validate each fields so that … Continue reading

Posted in php, Web Development | Tagged , , , | Leave a comment

Application running on Docker container – Part 2 – Database

This is a continuation of our previous post regarding a simple application running inside a Docker container. This post focuses on the database part of the application stack. Yes, we run the database in a separate container! MariaDB I’m using … Continue reading

Posted in Database, Linux, Web Development | Tagged , , | Leave a comment

Liquibase – Source control for your database

Many PHP, Python and Ruby frameworks already have their database source control feature either built-in or supported as a plugin. In our case, we didn’t use (PHP) CodeIgniter’s built-in database migration tool nor use any migration tool at all until … Continue reading

Posted in Database, MySQL, Web Development | Tagged , , , , | Leave a comment

MySQL – Locking reads using transaction

Here is a quick post before I hit work on a Sunday afternoon. I was trying to create some sort of locking mechanism designed to trigger the same tasks from multiple clients but only one should be executed/run. I tried … Continue reading

Posted in Database, MySQL, Web Development | Tagged , | Leave a comment

Using Symfony Validators outside the Symfony Framework

While we are quite doing fine with our current framework, we are stuck in terms of data validation especially when validation is done deep inside several layers of model classes. I’ve been thinking of either using Zend Validate classes (ZF2) … Continue reading

Posted in Web Development | Tagged , , , , | Leave a comment

Using Assetic to manage CSS and JS

We’ve been using Assetic for some time and we’re quite happy with the results. Assetic can be used to consolidate your CSS and JS files into fewer files with options to minify (compress) them to minimize the file size and … Continue reading

Posted in CSS, JavaScript, Site Optimization, Web Development | Tagged , , , | Leave a comment

Importing Third Party Fonts like Google Fonts – put them on top

We were using a theme for quite some time which uses Google fonts. There are no issues encountered until the number of CSS files increases too much that we need to consolidate them into 1 or 2 CSS files. This … Continue reading

Posted in CSS, Web Development | Tagged , , , | 3 Comments

jQuery DataTables – sort by date using timestamp data attribute

DataTables is an awesome “do-it-all” table plugin for jQuery. I was trying to display a locally formatted date but should still be sorted correctly. Current plugins may not work since it the date format uses long date format like “20 … Continue reading

Posted in JavaScript, Web Development | Tagged , , | Leave a comment