Blog
- Details
- Category: Blog
- Published on Sunday, Mar 20th 2011 8:42pm
Getting started with Android app development on windows with HTML 5 and JQuery
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.
- Details
- Category: PHP/MySQL Hacks and Tutorials
- Published on Saturday, Mar 26th 2011 9:33pm
Store money into MySQL
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
Subcategories
-
PHP/MySQL Hacks and Tutorials
Most of my experience comes from working with PHP/MySQL.
