April 16 2018

CSS and Jquery Android click Ripple effect look like

Tagged Under : , ,

css3
Below are showing example Android click Ripple effect with CSS3 and Jquery.
Below was 2 example:
Example 1
Example 2

April 16 2018

MySQL week() function not correct display

Tagged Under :

MySQL
I am try gather some statistics from a database and it need group by week numbers. and the results return unexpected.
SELECT create_date, WEEK(create_date) as week FROM `ttable` 
+---------------------+-------------+
| craete_date         | week        |
+---------------------+-------------+
| 2018-01-02 00:00:00 |           0 | 
| 2018-04-10 00:00:00 |          14 | 
| 2018-03-13 00:00:00 |          10 | 
| 2018-03-30 00:00:00 |          12 | 
+---------------------+-------------+
From the above you will found that the week number was wrong. and MySQL counts the first days of the year that do not belong week 1 as week 0.

This is because MySQL default week() function caused the issue. because in MySQL the first day of week is Sunday and it range was 0 to 53 weeks. And you need change the MySQL mode with the below table.

January 14 2018

IONIC 3 display config.xml version number on APP

Tagged Under :

ionic
To use config.xml version number on APP. you need install APP VERSION with npm.

To display the version number on APP.
this.platform.ready().then(() => {
	this.appVersion.getVersionNumber().then((value) => {
		var value = value.replace(/"/g, '');
		this.version = 'v'+value;
	})
});
and then put {{version}} where you want to display in html page.

and the output will be like this v1.0.1

January 14 2018

IONIC 3 dynamic loading control content or text

Tagged Under :

ionic
In IONIC 3 LoadingController you can set the content or text in starting. But if the loading is for getting information from many place and you want to display how many percent was completed or the process until which step.
this.loading = this.loadingCtrl.create({content: 'Please wait...'});