Sencha ExtJS 5.0 MVVM free Tutorial

Get Sencha ExtJS Complete Tutorial at  http://sencha-extjs-tutorial.blogspot.com/2015/04/tutorial-1-sencha-cmd-build-your-first.html

Tutorial by :
http://freelance-it-trainer.blogspot.com

Hery Purnama 081.223344.506 , IT trainer , Excel / access VBA Macro, MS Project, Primavera,

PHP Ajax Jquery, Google Map API, Google Sketchup3D, Ubuntu, Sencha ExtJS, YII, Code Igniter,

Oracle, SQL Server,

Bandung, Jakarta, Bali, Medan, Surabaya, Yogya, Indonesia

Connecting PHP CodeIgniter to SQL Server 2008/2012

7 Steps to make SQL Server and Codeigniter Works

Who are tried to connect Codeigniter with SQL Servers knows the suffering and the time invested to achieve this goal (or at least for me). Here is the steps that I follow, I hope that works for you!

1. Download and execute the Microsoft Drivers 3.0 for PHP for SQL Server (http://www.microsoft.com/en-us/download/details.aspx?id=20098). These is not a installer, just a EXE utility to uncompress the drivers for PHP.
2. Download and install the SQL Client for SQL Server 2012 (for 64 bits here: http://go.microsoft.com/fwlink/?LinkID=239648, for 32 bits here: http://go.microsoft.com/fwlink/?LinkID=239647)
3. Verify what is your version of PHP (Thread Safe or Non – Thread Safe). How to do that? Create a new PHP file with the following content:

   1 2	<?php phpinfo();

   Execute the script and verify the row with the name Thread Safety. If says "enabled" your PHP Installation is Thread Safe (TS), if have other value is Non Thread Safe (NTS).
   

4. Go to the folder where uncompress the Drivers 3.0, and select the version corresponding to. In my case, is PHP 5.4 Thread Safe TS, but this choice varies according to your PHP version.
   
   Copy these file and put on the folder of the extensions of PHP (generally is in PHP_INSTALLATION_FOLDER/ext)
5. Modify the php.ini file (generally located in PHP_INSTALLATION_FOLDER), and find the following word: extension=. Here you will find all the extensions enabled by default in PHP, and you only need to add the namefile of the extension you previously put on ext folder.
   
   Close and save changes, and restart the Apache / PHP service.

6. Enable the SQL Server to listen on specific ports. Go to the machine where SQL Server is installed, press keys Win + R, and typing the following: SQLServerManager10.msc (this could change, if you have SQL Server 2012 type "SQLServerManager11.msc"). These command open the SQL Configuration Manager. Go to SQL Server Network Configuration option, Protocols for 'instance name', and double click on TCP/IP option.

   On the Protocol tab, row Enabled, select yes option, and in IP Address tab go to IPALL option, and in the row TCP Dynamic Ports make it blank and in the row TCP Port inputs whenever port you like (the standard is 1433)

   

   Click on Ok, and restart the SQL Server service.

7. Go to Codeigniter, and in the database.php file do the following:

   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

   <?php /* EXTRACT OF database.php */ $db['default']['hostname'] = "127.0.0.1"; // or put the IP of your SQL Server Instance $db['default']['port'] = 1433; // or the port you configured on step 6 $db['default']['username'] = 'test2'; $db['default']['password'] = 'test2'; $db['default']['database'] = 'contactos'; $db['default']['dbdriver'] = 'sqlsrv'; $db['default']['dbprefix'] = ''; $db['default']['pconnect'] = FALSE; // Pay attention to this, codeigniter makes true for default $db['default']['db_debug'] = TRUE; $db['default']['cache_on'] = FALSE; $db['default']['cachedir'] = ''; $db['default']['char_set'] = 'utf8'; $db['default']['dbcollat'] = 'utf8_general_ci'; $db['default']['swap_pre'] = ''; $db['default']['autoinit'] = TRUE; $db['default']['stricton'] = FALSE;

8. Congratulations! Now you can make any models and querys, and it should work

Source from : https://futbolsalas15.wordpress.com/2014/02/23/7-steps-to-make-sql-server-and-codeigniter-works/

Creata Android Notification with HTML , CSS, javascript

How to create android notification with html5, css, javascript

http://stackoverflow.com/questions/17723164/show-an-android-style-toast-notification-using-html-css-javascript

Classic google map mode

f you've switched to the new Google Maps desktop interface, you can quickly go back to the classic interface by clicking the "Help" icon at the bottom of the page and picking "Return to classic Google Maps". You'll see a message that asks you if you want to permanently go back to the old interface or temporarily switch.

Another option is to bookmark this URL: Classic Google Maps (https://www.google.com/maps?output=classic). It will always send you to the standard Maps interface and you won't have to open the new interface first.

Why would you switch to the old interface? Maybe you need to use the more advanced directions that let you add more than 2 destinations, maybe you like the terrain/photos/webcam layers or Maps Labs features like the distance measurement tools or the LatLng tooltip, maybe you miss the Pegman icon you could drag and drop to switch to Street View or you want to customize the printing format for directions.

You've probably noticed that the new maps style (with new colors, icons, labels, tooltips) is now also available in the classic Google Maps. If you hide the sidebar, you can make it look more like the new Google Maps.

by

Hery Purnama

Freelance IT Trainer

Bandung 081.223344.506