Trainer Web Java ajax with xml and json

Hery Purnama , 081.223344.505 , freelance Trainer for training web java , ajax, xml or json

Inhouse trainer for location Jakarta, bandung, surabaya, balikpapan, makasar, menado and other city in Indonesia, singapore, malaysia

For inquiry please contact
+62.81223344506
PinBB 7dc633aa

inhousetrainer@yahoo.com
inhousetrainer.net

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Sencha ExtJS 5 , using Sencha Cmd in Wamp directory

Sencha ExtJS 5 is very powerfull javascript framework , you can start to build your first application by using scafolding feature.  what you need to do is download sencha cmd 5 for windows.

In this case i am using Wamp Server , so the folder should be generated in wampwww after i run the command

1. Download sencha extjs 5.0.1 gpl

2. Extract the zip file in any location for example i will extract it in D:

3. Install the Sencha Cmd 5 , by default it will be installed in C:usersadministratorbinsencha

4. Go to start –> Cmd (to open your windows command prompt)

5. use this command bellowed

C:UsersAdministrator>sencha -sdk d:ext-5 generate app Aplikasiku d:wampwwwext5-aplikasiku

aplikasiku is your scaffolding application name , ext5-applikasiku is your web application folder

the process will be looked like this …

Sencha Cmd v5.1.2.52
[INF] Processing Build Descriptor : default
[INF] Loading app json manifest…
[INF] Appending content to d:wampwww
ext5-aplikasiku/bootstrap.js
[INF] Writing content to d:wampwww
ext5-aplikasiku/bootstrap.json

That's it, your startup application is ready to access by using your localhost path address
Thanks

Regards,

Hery Purnama
Freelance IT Trainer
Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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).
    thread-safe

  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.
    select-sqlsrv-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.
    configure_php_ini
    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)

    habilitar-puerto

    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/

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Jquery Ajax clear form after submit

How to clear your form after submission using Jquery

The easiest way is using

$('#formId').trigger("reset")

Example

$(document).ready(function(e) {
    $("#btntambah").click(function(){
        var nama = $("#txtnama").val(); // cara jquery mangambil value dari object html dengan id txtnamaprd
        var kota = $("#txtkota").val();
        var detail = $("#txtdetail").val();
       

    $.ajax({ // ajax jqeury untuk mengirim value dengan methode post
            type: "POST",
            url: urlService+'proses.php?mode=add', // proses.php berisi php dengan script sql insert
            data:"txtnama="+nama+'&txtkota='+kota+'&txtdetail='+detail,
            success: function(data){
                $("#result").html(data); // callback respon ajax apabila proses.php berhasil, hasil dikembalikan ke halaman html di tag dengan id #result
            }
    });
   
$('#frmnasabah').trigger("reset") // form field di reset
   

    })
});

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

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

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT