Getting started with Android app development on windows with HTML 5 and JQuery

contact@dylanbishop.net (Super User) — Sun, 20 Mar 2011 20:42:03 +0000

I had a great idea for a mobile app and decided to pick up Android. Interesting enough, web developers can apply their current knowledge in making websites and make Android apps. I'm already very familiar with JQuery and HTML 5 so this sounded good to me.

Store money into MySQL

contact@dylanbishop.net (Super User) — Sat, 26 Mar 2011 21:33:06 +0000

On many occasions developing E-Commerce applications, I've needed to recall the proper DB table column declarations for storing currency/money. I always forget, but I figured writing a blog post would make it easier for me to remember and for others to find on the web.

In order to store money/currency into MySQL, you will need to create a new table column and name it whatever you like...In this case we'll call it 'total_amount'. Set the data type (type) to FLOAT and the length/value properties to 10,2. This column's value will never be empty so we set Null to not null.

Let me take a moment and explain the FLOAT datatype. MySQL represents approximate numeric data values with the FLOAT or DOUBLE datatypes. Below is an explaination from MySQL's online documentation

Blog

Getting started with Android app development on windows with HTML 5 and JQuery

Store money into MySQL