Inhouse Trainer – Excel Macro, Android, ITIL, COBIT, Primavera, Google MAP API, Oracle, PM, ExtJS: Freelance Trainer , Excel VBA Macro, Android, Phonegap, Sencha Extjs, ITIL, COBIT, MS Project, Primavera, Oracle, SQL Server

Inhouse Trainer – Excel Macro, Android, ITIL, COBIT, Primavera, Google MAP API, Oracle, PM, ExtJS: Freelance Trainer , Excel VBA Macro, Android, Phonegap, Sencha Extjs, ITIL, COBIT, MS Project, Primavera, Oracle, SQL Server: Hery Purnama 081.223344.506 – Freelance Trainer , Excel VBA Macro, Android, Phonegap, ITIL, COBIT, Google Map API, Sketchup3D , MS Project, Sencha ExtJS, Oracle DBA, SQL Server DBA, MySQL DBA, MS. Access VBA, Primavera P6, MS Project,Jquery, Yii, CodeIgniter. CIW, OCA, ITILF, MCDBA, MOS Certified Trainer For Inquiry : Call/SMS/WA : 081.223344.506 | PinBB : 7DC633AA | Email / YM : inhousetrainer@yahoo.com | FB : inhousetrainer | TW : inhousetrainer

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

Training COBIT5 & ITIL V.3 Foundation di ebiz Surabaya

Terima kasih kepada EBIZ Training Provider surabaya atas undangan mengajar untuk topik training COBIT 5 dan ITIL V.3. Kepada peserta yang telah mengikuti training tersebut semoga bermanfaat

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, ITIL, COBIT, Oracle, SQL Server,

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

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

Freelance Trainer, Instruktur IT

Hery 081.223344.506 – Freelance Certified IT Trainer , Excel VBA Macro , Android Phonegap, ITIL, Google Map API, Google Sketchup3D , MS Project, Sencha ExtJS, Oracle DBA, SQL Server DBA, MySQL DBA, MS. Access VBA, Primavera P6, MS Project,Jquery, Yii, CodeIgniter. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCDBA, MOS , Visit : http://freelance-it-trainer.blogspot.com/2014/12/freelance-certified-it-trainer-bandung.html

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

Indonesia no 1 dalam Cyber attack

Sebagai negara dengan urutan 8 pengguna internet terbanyak dan no 4 potensial online market terbesar ternyata Indonesia juga pemberi kontribusi no 1 terbanyak atas cyber attack diikuti oleh cinan (sumber akamai)

baca lengkapnya di http://freelance-it-trainer.blogspot.com/2015/04/indonesia-is-no-1-source-of-cyber-attack.html

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

Indonesia is the no 1 source of cyber-attack

According to statistics, Indonesia is the 8th largest internet users in the world and 4th largest mobile market in the world. With large numbers of internet and smartphone users, cyber-attack cannot be avoided. In fact according to Akamai, Indonesia is the no 1 source of cyber-attack. and there are 36.6 million cyber-attacks were recorded in Indonesia in the past three years


Quoted from :
SISINDOTEK – IT Training & Solution Provider

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 Trainer

Freelance Inhouse trainer for Sencha ExtJS Training, additional topic : PHP MySQL, AJAX, JSON

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

Hery 081.223344.506 – Freelance Certified IT Trainer , Excel VBA Macro , Android Phonegap, ITIL, Google Map API, Google Sketchup3D , MS Project, Sencha ExtJS, Oracle DBA, SQL Server DBA, MySQL DBA, MS. Access VBA, Primavera P6, MS Project,Jquery, Yii, CodeIgniter. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCDBA, MOS , Visit : http://freelance-it-trainer.blogspot.com/2014/12/freelance-certified-it-trainer-bandung.html

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

Excel Advanced for Accounting, Management, Finance, Business

Inhouse Trainer for Excel Advanced for Accounting, Management, Finance, Business

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

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

Hery Purnama – Freelance, Certified IT Trainer

Hery 081.223344.506 – Freelance Certified IT Trainer , Excel VBA Macro , Android Phonegap, ITIL, Google Map API, Google Sketchup3D , MS Project, Sencha ExtJS, Oracle DBA, SQL Server DBA, MySQL DBA, MS. Access VBA, Primavera P6, MS Project,Jquery, Yii, CodeIgniter. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCDBA, MOS , Visit : http://freelance-it-trainer.blogspot.com/2014/12/freelance-certified-it-trainer-bandung.html

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

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

Training cms wordpress bersama coresolutions indonesia

Terima kasih kepada manajemen dan semua peserta dari pt coresolutions indonesia atas undangan mengajar cms wordpress, semoga bermanfaat

Salam

Hery Purnama
Freelance inhouse 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

How To use custom font in wordpress

How To use custom font in wordpress
http://premium.wpmudev.org/blog/custom-fonts-css/
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

WordPress – Insert image inside the template

How to insert image into the template

1) put your image in wp-content/themes/yourthemes/yourimagefolder/yourfile.jpg

2) use the Img Src tag like this

<img src="<?php bloginfo('template_url'); ?>/images/blog-link.png"/>

Thanks,

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

WordPress change Permalink cause Error 404

Change Permalink cause 404 error on wordpress. This is major issue that normally found if you try to change permalink in wordpress, the solution is

1. From the FTP access your .htaccess file and give it full permission 777 .

2. Now open the .htaccess file in notepad (gedit in linux) and insert the following code

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress

3. Now, reupload the file to the root folder.

4. Now try changing the permalink.

5. Check with your hosts that mod_rewrite is running on your server.(open your httpd.conf at apache) and remove ";"  from LoadModule rewrite_module modules/mod_rewrite.so

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

Inhouse training codeigniter with sql server

Terima kasih kepada manajemen dan staff IT departemen dari PT Wavin Duta Jaya Cibitung bekasi atas undangan mengajar selama 4 hari dengan topik PHP codeigniter yang diintegrasikan dengan SQL Server 2008, semoga bermanfaat

Hery Purnama
Freelance, inhouse , certified IT trainer
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

CodeIgniter SQL Server Pagination – Solved

After few days try and error, finally i found the solution for Pagination in CodeIgniter using SQL Server

My Model <?php

class Mwavin extends CI_Model {

   
        /*
     * sample
     */
   
    function semuadata($no_page){
       
        $perpage = 5; // value $perpage sama dengan yg di $config[‘per_page’]
        if($no_page == 1){
            $first = 1;
            $last  = $perpage;
        }else{
            $first = ($no_page – 1) * $perpage + 1;
            $last  = $first + ($perpage -1);
        }
       
        return $this->db->query(“WITH CTE AS (
                                        SELECT  a.*, b.namadept,
                                                ROW_NUMBER() OVER (ORDER BY a.idpegawai desc) as RowNumber
                                        FROM tbpegawai a left join tbdept b on a.iddept = b.iddept
                                    )
                                SELECT * FROM CTE WHERE RowNumber BETWEEN $first AND $last”)->result_array(); 
    }

function paging($url, $rows = 10, $uri = 3){
 $this->load->library(‘pagination’);
  
 $config[‘per_page’]   = 5;
 $config[‘base_url’]   = site_url($url);
 $config[‘total_rows’]   = $rows;
 $config[‘use_page_numbers’] = TRUE;
 $config[‘uri_segment’]   = $uri;
 $config[‘num_links’]   = 3;
 $config[‘next_link’]   = ‘Berikutnya’;
 $config[‘prev_link’]   = ‘Sebelumnya’;

 $this->pagination->initialize($config);
 return $this->pagination->create_links();
}

function totaldata(){
 $query = $this->db->query(“SELECT count(*) as row FROM tbpegawai left join tbdept on tbpegawai.iddept = tbdept.iddept”)->row_array();
 return $query[‘row’];
}
   

My Controller<?php
if (!defined(‘BASEPATH’))
    exit(‘No direct script access allowed’);

class Wavin extends CI_Controller {

  

    public function __construct() {
        parent::__construct();
        //load helper jika tidak di set di config
       // $this->load->helper(‘url’,’form’,’html’);
    }

function index($no_page = 1){
     $this->load->model(‘mwavin’);
     $data[‘page’] = $this->mwavin->paging(“wavin/index”,$this->mwavin->totaldata(), 3);
     $data[‘baris’] = $this->mwavin->semuadata($no_page);
     $data[‘no_page’] = $no_page;
     $this->load->view(‘home’, $data);     
}
   

   
My VIEW
i’m using additional Jquery plugin JeasyUi for my template
<!DOCTYPE html>

<html>
    <head>
        <title>Sample Sql Server Codeigniter</title>
      
<link rel=”stylesheet” type=”text/css” href=”<?php echo base_url(); ?>jeasyui/themes/default/easyui.css”>
<link rel=”stylesheet” type=”text/css” href=”<?php echo base_url(); ?>jeasyui/themes/icon.css”>
<script type=”text/javascript” src=”<?php echo base_url(); ?>jeasyui/jquery.min.js”></script>
<script type=”text/javascript” src=”<?php echo base_url(); ?>jeasyui/jquery.easyui.min.js”></script>

    </head>
    <body>
      
        <div class=”easyui-panel” title=”DATA PEGAWAI” style=”width: 1300px;height: 700px;padding:10px” >
        <div> <h1>DATA PEGAWAI WAVIN</h1></div>
           
            <a href=”<?php echo base_url(); ?>”>HOME </a>|
            <?php echo anchor(‘wavin/fntambahpeg’,’TAMBAH’); ?> | LOGOUT
            <div >
              
         <?php echo $page; ?>
        </div>
        <div>
          Halaman <?php echo $no_page; ?>
        </div>
        <table class=”easyui-datagrid” title=”PT Wavin”  >
            <thead id=”headtable”>
                <tr>
                    <th data-options=”field:’idpegawai'”>ID PEGAWAI </th>
                    <th data-options=”field:’nama'” sortable=”true”>NAMA </th>
                    <th data-options=”field:’kota'”>KOTA </th>
                    <th data-options=”field:’tgllahir'”>TGL LAHIR </th>
                    <th data-options=”field:’email'”>EMAIL </th>
                    <th data-options=”field:’gaji'”>GAJI </th>
                    <th data-options=”field:’foto'”>FOTO </th>
                    <th data-options=”field:’status'”>STATUS </th>
                    <th data-options=”field:’detail'”>DETAIL PEGAWAI </th>
                    <th data-options=”field:’namadept'”>NAMA DEPARTEMEN </th>
                    <th data-options=”field:’jabatan'”>JABATAN </th>
                    <th data-options=”field:’ ‘” > Admin </th>
                  
                </tr>
            </thead>
          
            <tbody id=”datatable”>
                <?php foreach($baris as $row){ ?>
                <tr style=”vertical-align: top”>
                    <td > <?php echo $row[‘idpegawai’]; ?> </td>
                    <td > <?php echo $row[‘nama’]; ?> </td>
                    <td> <?php echo $row[‘kota’]; ?> </td>
                    <td > <?php echo $row[‘tgllahir’]; ?> </td>
                    <td > <?php echo $row[’email’]; ?> </td>
                    <td > <?php echo $row[‘gaji’]; ?> </td>
                    <td > <?php echo $row[‘foto’]; ?> </td>
                    <td > <?php echo $row[‘status’]; ?> </td>
                    <td > <?php echo $row[‘detail’]; ?> </td>
                    <td > <?php echo $row[‘namadept’]; ?> </td>
                    <td > <?php echo $row[‘jabatan’]; ?> </td>
                    <td> Edit | Del | <?php echo anchor(‘wavin/detail/’.$row[‘idpegawai’],’Detail’,array(‘class’=>’easyui-linkbutton’)); ?> </td>
                </tr>
                <?php } ?>
            </tbody>
        </table>

        </div>
 
      

    </body>
</html>


Hope can help you guys , thanks


By Freelance Inhouse Trainer
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

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

Add SQL Server Jar Driver in Netbeans Service

How add SQL Server 2012 driver to Netbeans 8?

Go to Services window in Netbeans. List Drivers node. If on the list it isn’t SQL JDBC driver you must download it.
u01
Go to http://www.microsoft.com/en-gb/download/details.aspx?id=11774  website.
u02Click the Download button. Then click the exe file.
u03
u04I download this file into jdbc folder.
u05
Then you must any zip program unzip this file. Click the Browser button.
u06
Set path for jdbc files. I set D isc.
u07
Click the Unzip button. You see jdbc4.jar file in sqljdbc_4.0/enu folder.
u08
Close unzip program, clicking the Close button.
u09In this step you may go to Services window. Right click the Drivers node and choose New Driver.
u10You see empty New JDBC Driver. Click the Add button.
u11Select downloading sqljdbc4.jar driver.
u12Click the Open button. In Name field write Microsoft SQL Server 2012 and click the OK button.
u13On the list of drivers you see SQL Server driver.
u14
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

Inhouse Training mobile application development for Android – KRA Balikpapan

Terima kasih kepada staff IT dan Manajemen PT. Komatsu Remanufactoring Asia -Balikpapan Kaltim atas undangan mengajar topik Android Development yang berlangsung selama 4 hari, semoga bermanfaat.

Hery Purnama – Freelance Inhouse Trainer
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

Connect CodeIgniter to SQL Server using sqlsrv driver

Specification
1.       Wamp Server 2.0 with PHP 5.2
2.       CodeIgniter 2.1/2.2
3.       SQL Server 2005/2008
Download First
1.       Download sqlsrv dll driver SQLsrv20.exe (download here)
2.       Download SQL Native Client 2008 (Native Client 10) which is compatible for SQL Server 2005/2008 (download here)
How to connect CodeIgniter to SQL Server 2005 using SQLsrv driver
1.       Install / Upgrade your SQL Native Client to 2008 SP3 (Native Client 10), then restart your computer
2.       Stop your Wamp Server to copy dll file
3.       Install or extract  sqlsrv dll files , you don’t have to copy all of the files , choose the files that have same version with your installed PHP version, in this case I will copy
php_pdo_sqlsrv_52_ts_vc6.dll
php _sqlsrv_52_ts_vc6.dll

Then I’ll copy the files into  :
…wampbinphpphp5.2.5ext
4.       Next , I will edit php.ini , the location of the file is in ..wampbinapacheapache2.2.8binand adding these lines in extension configuration section :
extension=php_pdo_sqlsrv_52_ts_vc6.dll
extension=php_sqlsrv_52_ts_vc6.dll
5.       Start the wamp service
6.       Create test.php(not codeigniter file) the file will be used to test the connection (it’s common native PHP Script )
Adjust with your own host/database/user/password setting in SQL Server
<?php
$serverName = “SISINDOTEKPRIMAVERA”; //serverNameinstanceName
$connectionInfo = array( “Database”=>”cisqldb”, “UID”=>”sa”, “PWD”=>”sa”);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
     echo “Connection established.<br />”;
}else{
     echo “Connection could not be established.<br />”;
     die( print_r( sqlsrv_errors(), true));
}
?>
7.  If the Connection established.  You may try to setup your codeigniter database configuration file (database.php) in 
…wampwwwyourWebfolderapplicationconfig
8.       Change the configuration such as mention bellowed (Use your own configuration !)
9.       Don’t forget to change the value of  $db[‘default’][‘pconnect’] = FALSE;
$active_group = ‘default’;
$active_record = TRUE;
$db[‘default’][‘hostname’] = ‘SISINDOTEKPRIMAVERA’;
$db[‘default’][‘username’] = ‘sa’;
$db[‘default’][‘password’] = ‘sa’;
$db[‘default’][‘database’] = ‘cisqldb’;
$db[‘default’][‘dbdriver’] = ‘sqlsrv’;
$db[‘default’][‘dbprefix’] = ”;
$db[‘default’][‘pconnect’] = FALSE;
$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;
Save the file and now you may try to run your codeigniter web that connected to SQL Server by using sqlsrv dll driver
I Hope that can help you guys !, (http://freelance-it-trainer.blogspot.com)
By :
Freelance Inhouse 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

Codeigniter code snippets for netbeans IDE 8.0 php

Cara menampilkan code snipets Code Igniter 2.0 di Netbeans IDE for PHP

1. Buat file baru dan letakkan di luar folder project web anda , sebagai contoh anda bisa meletakkan di folder D:master ci2_autocomplete.php (Nama file bisa bebas)

2. Copy paste script php berikut ke dalam file tersebut

<? Php
    / **
    *property CI_DB_active_record $ db
    *property CI_DB_forge $ dbForge
    *property CI_Benchmark $ benchmarks
    *property CI_Calendar $ calendar
    *property CI_Cart $ cart
    *property CI_Config $ config
    *property CI_Controller $ controller
    *property CI_Email $ email
    *property CI_Encrypt $ encrypt
    *property CI_Exceptions $ exceptions
    *property CI_Form_validation $ form_validation
    *property CI_Ftp $ ftp
    *property CI_Hooks $ hooks
    *property CI_Image_lib $ image_lib
    *property CI_Input $ input
    *property CI_Language $ language
    *property CI_Loader $ load
    *property CI_Log $ log
    *property CI_Model $ models
    *property CI_Output $ output
    *property CI_Pagination $ pagination
    *property CI_Parser $ parser
    *property CI_Profiler $ profiler
    *property CI_Router $ router
    *property CI_Session $ session
    *property CI_Sha1 $ sha1
    *property CI_Table $ table
    *property CI_Trackback $ trackback
    *property CI_Typography $ typography
    *property CI_Unit_test $ unit_test
    *property CI_Upload $ uploaded
    *property CI_URI $ uri
    *property CI_User_agent $ User_Agent
    *property CI_Validation $ validation
    *property CI_Xmlrpc $ XMLRPC
    *property CI_Xmlrpcs $ xmlrpcs
    *property CI_Zip $ zip
    * /

    CI_Controller class {};

    / **
    *property CI_DB_active_record $ db
    *property CI_DB_forge $ dbForge
    *property CI_Config $ config
    *property CI_Loader $ load
    *property CI_Session $ session
    * /

    CI_Model class {};

    ?>

3.  Buka software Netbeans PHP , masuk ke menu TOOLS -> OPTIONS ->PHP -> GLOBAL INCLUDE PATH -> Browse file ci2_autocomplete.php yang telah anda buat

4. Tutup Netbeans PHP Anda

5. Buka kembali netbeans dan selanjutnya project Code Igniter anda sudah memiliki code snippets lengkap saat anda mengetikkan kode program Anda

Terima kasih

Oleh :
Freelance Inhouse Trainer
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, Android Phonegap, Sencha ExtJS Trainer

English TranslationHow to display code snipets Code Igniter 2.0 in NetBeans IDE for PHP
1. Create a new file and place it outside the folder of your web project, for example, you can put in the folder D: master ci2_autocomplete.php (you may use any name for the file)

2. Copy and paste the following php script into the file

<? Php
    / **
    *property CI_DB_active_record $ db
    *property CI_DB_forge $ dbForge
    *property CI_Benchmark $ benchmarks
    *property CI_Calendar $ calendar
    *property CI_Cart $ cart
    *property CI_Config $ config
    *property CI_Controller $ controller
    *property CI_Email $ email
    *property CI_Encrypt $ encrypt
    *property CI_Exceptions $ exceptions
    *property CI_Form_validation $ form_validation
    *property CI_Ftp $ ftp
    *property CI_Hooks $ hooks
    *property CI_Image_lib $ image_lib
    *property CI_Input $ input
    *property CI_Language $ language
    *property CI_Loader $ load
    *property CI_Log $ log
    *property CI_Model $ models
    *property CI_Output $ output
    *property CI_Pagination $ pagination
    *property CI_Parser $ parser
    *property CI_Profiler $ profiler
    *property CI_Router $ router
    *property CI_Session $ session
    *property CI_Sha1 $ sha1
    *property CI_Table $ table
    *property CI_Trackback $ trackback
    *property CI_Typography $ typography
    *property CI_Unit_test $ unit_test
    *property CI_Upload $ uploaded
    *property CI_URI $ uri
    *property CI_User_agent $ User_Agent
    *property CI_Validation $ validation
    *property CI_Xmlrpc $ XMLRPC
    *property CI_Xmlrpcs $ xmlrpcs
    *property CI_Zip $ zip
    * /

    CI_Controller class {};

    / **
    *property CI_DB_active_record $ db
    *property CI_DB_forge $ dbForge
    *property CI_Config $ config
    *property CI_Loader $ load
    *property CI_Session $ session
    * /

    CI_Model class {};

    ?>

3. Open the Netbeans PHP software, go to the menu TOOLS -> OPTIONS -> PHP -> GLOBAL PATH INCLUDE -> Browse > ci2_autocomplete.php , the file that you created

4. Close your PHP Netbeans software

5. Open the software and now your code snippets will show up everytime you write your CI class methode code

Thank you,

By Freelance Inhouse Trainer
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

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

Trainer Excel VBA Macro, MS Project, Android, ExtJS, Primavera P6, Oracle, Sketchup, Google Map API

Hery 081.223344.506 – Freelance Certified IT Trainer , Excel VBA Macro , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Primavera, MS Project, Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCDBA, MOS , Visit : http://freelance-it-trainer.blogspot.com


Call/ SMS/ Whatsapp : 081.223344.506

pinBB 7DC633AA


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

Freelance Trainer , Pengajar Komputer 081.223344.506 , Certified Trainer

Hery 081.223344.506 – Freelance Certified IT Trainer , Excel VBA Macro , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Primavera, MS Project, Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCDBA, MOS , Visit : http://freelance-it-trainer.blogspot.com

Freelance Inhouse Trainer, Professional Trainer, Certified Trainer

Bandung, Jakarta, Bali , Yogya, Subang, Kalimantan, Sulawesi

Hery Purnama (081.223344.506)

Application Programming :
Excel VBA macro , MS. Access VBA Programming, Visual Foxpro , VB/ ASP.Net

Project Management and Methodology with :

– Microsoft Project 2010/2013

– Primavera P6

Graphical :
Google Sketchup 3D with Vray Effect, Photoshop/Fireworks ,Director, CorelDraw, Swimax/ Flash

Web Development :
PHP – Google Map API V.3

PHP – Sencha ExtJS

PHP – Ajax Jquery

PHP CodeIgniter Framework with MySQL/ SQL Server
PHP Yii Framework
Cake PHP

Database :
Oracle DBA (10/11g)
SQL Server DBA (2008/2012)
MySQL DBA

Networking :
UBUNTU Server (Admin & Configuration)

Windows Server 2008  (Admin & Configuration)

For inquiry Contact / Call

Hery 081.223344.506 – Freelance Certified IT Trainer , Excel VBA Macro , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Primavera, MS Project, Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCDBA, MOS , Visit : http://freelance-it-trainer.blogspot.com

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