Friday, February 10, 2017
Public Training Magento E-Commerce Advanced Level
Inhouse Training Excel VBA Macro - Batam
Inhouse Training Quantum GIS (QGIS) - Kalimantan Selatan
Inhouse Training Project Management Methodology with MS. Project - jakarta
Inhouse Training Mobile Applications Development with phonegap - Maluku
Public Training Python Advanced Programming - Jakarta
Public Training IT Project Management based On PMBOK 5th - Jakarta
Inhouse Training MS. Excel Basic to Intermediate
Inhouse Training Excel VBA Macro - Cikarang
Inhouse Training MS. Excel PowerPivot and PowerView - Padang
Public Training Cobit 5.0 Foundation - Bandung
Public Training Primavera P6 - Bandung
Inhouse Training Microsoft Project Basic to Advanced - Jakarta
HERY PURNAMA
Inhouse Training Autocad 2D/3D - Jakarta
Inhouse Training Catia 3D V.5 - Jakarta
Inhouse Training MS Project di Medan
Public Training Android Phonegap - Bandung
Inhouse Training Excel VBA macro - Samarinda
Public Training ISTQB - Bandung
Inhouse Training Web Applications Development with PHP Codeigniter and SQL Server - Cibitung
Inhouse Training Android Applications Development - Balikpapan Kaltim
Inhouse Trainining Project Management Methodology with MS Project - Bekasi
Public Training Mobile Applications Development with Phonegap
Hery Purnama
for inquiry please call/text/WA +62-8122-3344-506
inhousetrainer@yahoo.com
Monday, January 30, 2017
Simple PHP Mysql Search for Each Word like Search engine
<?php
$host = "localhost";
$user = "root";
$password = "";
$dbname = "dbcoba";
$koneksi = mysqli_connect($host,$user,$password);
$dbkonek = mysqli_select_db($koneksi,$dbname) or die("error euy ");
if(isset($_GET['txtnama'])) {
$search = str_replace(" ","|",$_GET['txtnama']);
$sql= " SELECT * FROM tbpegawai WHERE nama REGEXP '$search' ";
$run = mysqli_query($koneksi,$sql) or die(mysqli_error($koneksi));
$row = mysqli_fetch_assoc($run);
$total = mysqli_num_rows($run);
}
?>
<body>
<form action="cari.php" method="GET">
<input type="text" name="txtnama" id="txtnama" placeholder="Cari" value="<?php echo $_GET['txtnama']; ?>">
<button type="submit" value="Cari" > Cari</button>
</form>
<?php if($total>0) { ?>
<table border="1" width="500">
<thead>
<tr>
<th> <strong>Hasil Cari <?php echo $total ; ?></strong> </th>
</tr>
</thead>
<tbody>
<?php do{ ?>
<tr>
<td><?php echo $row['nama']; ?> </td>
</tr>
<?php } while($row=mysqli_fetch_assoc($run)) ;?>
</tbody>
</table>
<?php } ?>
</body>
Regards,
HERY PURNAMA
Friday, January 27, 2017
Magento 2.1 training di Jakarta
Terima kasih kepada PT. softbless solution Jakarta atas undangan mengajar Magento 2.1.0 Fundamental bersama peserta dari PT PJB semoga bermanfaat
Salam,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Download Mozilla Firefox Offline Installer
Regards,
HERY PURNAMA
Tuesday, January 24, 2017
Magento 2 , SMTP Setting using gmail in localhost (solved)
GmailSmtpApp
c:\xampp\php\php -f c:/xampp/htdocs/{webMagentoAnda}/bin/magento setup:upgrade
Regards,
HERY PURNAMA
Magento 2 how to make price more than 100 million
Solusi untuk issue tersebut di magento release 1 bisa dilakukan dengan menggunakan extension atau merubah code program namun di release 2 solusi tersebut agak sulit dilakukan dikarenakan code program yang dibuat pada release 2 cenderung di enkripsi dan juga untuk saat ini ketersedian extension release 2 di magento connect belum ada
alter table catalog_product_index_price modify price decimal(24,4);
alter table catalog_product_index_price modify final_price decimal(24,4);
alter table catalog_product_index_price modify min_price decimal(24,4);
alter table catalog_product_index_price modify max_price decimal(24,4);
alter table catalog_product_index_price modify tier_price decimal(24,4);
alter table catalog_product_index_price_tmp modify price decimal(24,4);
alter table catalog_product_index_price_tmp modify final_price decimal(24,4);
alter table catalog_product_index_price_tmp modify min_price decimal(24,4);
alter table catalog_product_index_price_tmp modify max_price decimal(24,4);
alter table catalog_product_index_price_tmp modify tier_price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify orig_price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify min_price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify max_price decimal(24,4);
alter table catalog_product_index_price_final_tmp modify tier_price decimal(24,4);
alter table catalog_product_entity_tier_price modify qty decimal(24,4);
alter table catalog_product_entity_tier_price modify value decimal(24,4);
alter table catalog_product_index_price_final_idx modify orig_price decimal(24,4);
alter table catalog_product_index_price_final_idx modify price decimal(24,4);
alter table catalog_product_index_price_final_idx modify min_price decimal(24,4);
alter table catalog_product_index_price_final_idx modify max_price decimal(24,4);
alter table catalog_product_index_price_final_idx modify tier_price decimal(24,4);
alter table catalog_product_index_price_final_idx modify base_tier decimal(24,4);
alter table catalog_product_index_price_idx modify price decimal(24,4);
alter table catalog_product_index_price_idx modify final_price decimal(24,4);
alter table catalog_product_index_price_idx modify min_price decimal(24,4);
alter table catalog_product_index_price_idx modify max_price decimal(24,4);
alter table catalog_product_index_price_idx modify tier_price decimal(24,4);
alter table catalog_product_index_tier_price modify min_price decimal(24,4);
alter table catalog_product_index_eav_decimal modify value decimal(24,4);
alter table catalog_product_index_eav_decimal_idx modify value decimal(24,4);
alter table catalog_product_index_eav_decimal_tmp modify value decimal(24,4);
Salam,
081223344506
Magento 2 image and menu not loading after installation (solved)
<item name="view_preprocessed" xsi:type="object">Magento\Framework\App\View\Asset\MaterializationStrategy\Symlink</item>
<item name="view_preprocessed" xsi:type="object">Magento\Framework\App\View\Asset\MaterializationStrategy\Copy</item>
Friday, December 30, 2016
Trainer Google Map Api for Android and IOS jakarta bandung
Hery Purnama 081-223344-506, is a trainer of google map api for android and ios training, the training will discuss how to make online transportation mobile application
I am an mobile application developer and also have experiences to deliver android training and google map api v.3 for more than 5 years
I also already developed android application for online transportation as similiar with gojek, uber or grab
If you are interested to get my professional service in training or want to buy my application , please call/text/WA me
Regards,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Friday, December 23, 2016
Excel VBA Macro Training in Sampoerna Pandaan
Selamat Natal 2016 dan Tahun Baru 2017
Salam,
Hery Purnama
Certified IT Trainer
Freelance-Trainer-Jakarta-Bandung
•SKILLS/KOMPETENSI
Best Practice (IT/ Management Public Framework) :
• ITIL v.3/2011 Foundation (IT Infrastructure Library)
• COBIT 5.0 (Control Objectives for Information and Related Technology)
• TOGAF (The Open Group Architecture Framework)
• PMBOK (PMP/ CAPM) (Project Management Body of Knowledge)
• CRISC (Certified in Risk and Information System Control)
• PMO (Project Management Office)
• ISTQB (International Software Testing Qualification Board)
• Prince2 (Projects IN Controlled Environments)
• CISA (Certified Information Systems Auditor)
• RDBMS Concept
• DATA MANAGEMENT (DMBOK)
• SAD UML (System Analysis Design with UML)
• SEO & Internet Marketing (Ecommerce / Blog)
Project Tools
• Microsoft Project / Project Web Server
• Primavera P6
GIS
• QGIS
• ArcGIS
Database
• Oracle DBA
• SQL Server DBA
• Microsoft Access 2013/2016 Fundamental & VBA Programing
• MySQL DBA
• PostGreSQL
• SQLite
• DynamoDB
• MariaDB
Programming
• ASP.Net
• VB. Net
• PHP MySQL
• Web Service (JSON, XML, SOAP, RestFull)
• Java Web Programming
• Erlang Programming
• Python & Django Programming
PHP Framework
• Codeigniter
• Yii
• Laravel
• Zend
• Cakephp
UML Tools
• Enterprise Architect
CMS / E-Commerce
• Wordpress
• Joomla
• Magento E-Commerce
• Prestashop
Javascript Framework
• Sencha ExtJS
• Angular Js
• Backbone Js
• Ember Js
• Ajax JQuery
Mobile Apps. Development
• Android Studio
• Phonegap / Cordova
• HTML 5 , CSS 3
• Jquery Mobile & Phonegap
• Sencha Touch
EndUser , Graphics, Web Design
• Word, Excel, PowerPoint
• Corel Draw , Photoshop
• Web Design with Dreamweaver & Fireworks
• Adobe Premiere
Excel Advanced
• Excel for Business & Accounting
• Excel VBA Macro
• Excel PowerPivot & PowerView
CAD Software
• Autocad 2D/3D
• Catia 3D
• Google Sketchup 3D
• 3D Max Studio
• 3D Maya
Game/ Animation Development Tools
• Unity 5 , 3D Game Development
• Blender , 3D DAZ
Developer Toolbox
• Google Developer Toolbox
• Google Map API V.3
• SMS Gateway
• Facebook API Graph
TRAINING CLIENT REFFERENCES :
PT. INFINEON TECHNOLOGIES - Batam
ASKRINDO – Kemayoran Jakarta
SCTV – Jakarta
EMTEC – Jakarta
O-Shop - Jakarta
BANK FAMA INTERNATIONAL - Bandung
PT. NINDYA KARYA – Cawang Jakarta
MASTERSYSTEM – Sudirman Jakarta
ADARO – Tanjung Kalimantan Selatan
PT. INFOTECH – Rasuna Said Jakarta
PT. EDI INDONESIA – Yos Sudarso Jakarta
MELODIA MUSIK - Jakarta
ENESIS Group – Pulogadung Jakarta
PT. HM. SAMPOERNA Tbk. – Pandaan & Probolinggo
8COMMERCE - LINC GROUP – Jakarta
PUSDIKLAT GEOLOGI - Bandung
PEGADAIAN PUSAT - Jakarta
PAMA Coal – Tanjung, Kalimantan Selatan
KNCV Tuberculousis Foundation Jakarta
PT. HUTAMA KARYA – PLTGU GRATI Pasuruan
PEMKOT SERANG
KEMENINFO – JAKARTA
BANK NAGARI - PADANG
PT. HM. SAMPOERNA, Tbk. , Karawang Factory
PT. PJB SERVICE – Surabaya
PT. LANCARJAYA MANDIRI (ELMA GROUP) – MELAK – KUTAI BARAT
PT. LINTAS BORNEO - BANJARMASIN
BANK SURYA YUDHA - BANJARNEGARA
PT. SEMEN PADANG - PADANG
PT. HUTAMA KARYA – Kemayoran JAKARTA
KAYAN PUTRA UTAMA COAL (KPUC) - SAMARINDA
PT. DUNGO REKSA - MEDAN
PT. JOB-PPEJ - TUBAN
PT. WAVIN DUTA JAYA – CIBITUNG BEKASI
PT. KOMATSU REMANUFACTURING ASIA - BALIKPAPAN
PT. SAMPOERNA TBK – BANDUNG
PT. ASURANSI AXA INDONESIA – JAKARTA
UNIVERSITAS TELKOM - BANDUNG
ICON PLUS (ICON PLN – JAKARTA)
BANK EKONOMI – JAKARTA
PT PLN (PERSERO) PUSHARLIS UWP III
PT. KARENINDO CITRA UTAMA –JAKARTA
ITENAS – BANDUNG
UNIVERSITAS BINA NUSANTARA (BINUS – JAKARTA)
BANK JABAR BANTEN (BJB)
AMDOCS – JAKARTA
PT. ELNUSA, TBK.
PT. SARANA MULTIGRIYA FINANSIAL / SMF (PERSERO)
PT. PERTAMINA GEOTHERMAL ENERGY (THAMRIN – JAKARTA)
PT. INDONESIA ASAHAN ALUMUNIUM (INALUM- MEDAN)
UIN SUSKA – RIAU
RUMAH SAKIT AWALBROS BEKASI
UNIVERSITAS ANDALAS
POLITEKNIK ACEH
PUSINFOWAS BPKP – JAKARTA
ASURANSI TAKAFUL – JAKARTA
PT. FREEPORT , TBK – TEMBAGAPURA PAPUA
PT. GERBANG SINERGI PRIMA – BANDUNG
PT PLN (PERSERO) UIP TRANSMISI ISJ – JAKARTA
PT. CG POWER SYSTEM INDONESIA – BOGOR
PT. PERTAMINA (PERSERO) – JAKARTA
BANK CIMB NIAGA – JAKARTA
IKATAN MAHASISWA TEKNIK METALURGI ITB – BANDUNG
PT. PUPUK KIJANG – CIKAMPEK
PT. PERTAMINA (PERSERO – JAKARTA) BAKRIE TELECOM JAKARTA
SMKN 2 GARUT
PT BES KELAPA GADING JAKARTA
PT. TELKOMSEL – JAKARTA
PT. HUTAMA KARYA PERSERO (BANDUNG)
PT. SEASCAPE SURVEY INDONESIA
PT. PUPUK KALTIM
DANA PENSIUN PUPUK KALTIM
PT. SARINAH (PERSERO)
PT. WEDA BAY NICKEL (HALMAHERA)
TAQ-TAQ OPERATING COMPANY LTD (KURDHISTAN – IRAK)
EMP MALACCA STRAIT SA – JAKARTA
BANK BTPN JAKARTA
PT. SARANA MULTI INFRASTRUKTUR (PERSERO)
PT. MEDCO ENERGI – JAKARTA
PT. ANTAM, TBK.
UNVERSITAS ISLAM INDONESIA (TEKNIK INFORMATIKA)
INSTITUT TEKNOLOGI TELKOM BANDUNG
POLITEKNIK NEGERI MALANG
PT. KPEI
DPPKAD KABUPATEN GRESIK
PT PJB UPHB
PT. KRAKATAU STEEL
Thursday, December 22, 2016
Tuesday, December 20, 2016
Trainer Magento E-Commerce 2.1 /Advanced Level Jakarta
Hery Purnama 081-223344-506, trainer for training Magento 2 fundamental, advanced level in Bali, Jakarta, Bandung, Medan
For Inquiry, please contact :
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Training Excel Advanced for Management, Accounting & Business
Training Excel Advanced di Sampoerna Pandaan, Pasuruan Jawa Timur
Hormat Saya,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Saturday, December 17, 2016
Training Excel VBA Macro Batam
Terima kasih kepada Infineon Technologies dan Smartpro Batam atas undangan mengajar programming Excel with Vba Macro , semoga bermanfaat
Regards,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Thursday, December 8, 2016
Training PHP codeigniter Bandung
Training PHP codeigniter bersama peserta dari PERURI Jakarta. Semoga bermanfaat
Salam,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Friday, November 18, 2016
Training Project Management based on PMBOK 5th
Terima kasih kepada peserta dari PT Askrindo Jakarta yang telah mengikuti training Project Management based On PMBOK 5th Edition semoga bermanfaat.
Hormat Saya,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Saturday, November 12, 2016
Training Excel VBA Macro Sampoerna
Terima kasih kepada peserta dan manajemen PT HM Sampoerna Pandaan atas undangan mengajar Training Excel VBA Macro semoga bermanfaat.
Salam,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Thursday, November 3, 2016
Catia 3D trainer Jakarta Bandung Surabaya Kalimantan
Hery Purnama 081-223344-506 is Catia 3D Trainer in Jakarta Bandung Surabaya
So.. What is Catia ?
As Dassault's pioneer brand, CATIA goes far beyond traditional 3D CAD software tools, offering a lifelike design experience that allows stakeholders and designers to visualize and experiment with products throughout its development. CATIA is the world's leading solution for product design and innovation. Companies of all sizes use CATIA to ensure their products' real success. Increasing the power of innovation for designers, engineers, product and systems architects, and systems engineers is the ultimate mission of Dassault's leading brand.
Related topics : autocad 2D/3D , google sketchup 3D , Unity 3D , 3D Daz
For inquiry please contact :
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Magento Advanced Level 2016
Trainer Magento Jakarta, Bandung - Hery Purnama 081.223344.506
Magento Advance Training Class Oct- Nov 2016 Menara Palma Jakarta Selatan
Regards,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Wednesday, November 2, 2016
Training Magento E-Commerce Advanced Level Jakarta
Terima kasih kepada Peserta O-Shop dan Infotech yang telah mengikuti pelatihan / training Magento Advanced Level, semoga bermanfaat
Salam,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com
Tuesday, November 1, 2016
Trainer DAMABOK Jakarta Bandung surabaya
Hery Purnama 081-223344-506 is freelance trainer for training DAMABOK.
the DAMA Guide to the Data Management Body of Knowledge (DAMA-DMBOK) is the most impressive compilation of data management principals and best practices, ever assembled. It provides data management and IT professionals, executives
Other related topics ITIL, COBIT, CISA, PMBOK, ISTQB, CRISC, TOGAF
Regards,
HERY PURNAMA
Certified IT Trainer
http://www.inhousetrainer.net
inhousetrainer@yahoo.com ,hery.purnama@gmail.com
Call/ SMS/WA : 081.223344.506 | PinBB : 7DC633AA
Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com













































