{ Berbagi, Menulis, Dan Mengajar } Ilmu… » 4. Programming / IDE
Konektor ADODB MYSQL
Public Sub Bukadatabase() Set DBKoneksi = New ADODB.Connection DBKoneksi.CursorLocation = adUseClient ‘StrKoneksi = “Provider=Microsoft.Jet.OleDB.4.0; ” _ ‘Â Â Â & ” Data Source=” + App.Path _ ‘Â Â Â + “\DbPenggajian.mdb;Mode=readwrite” StrKoneksi = “provider=msdasql.1;” & _ “persist security info = false; data source = sdmkumham;” & _ “initial catalog = sdmkumham” … Read entire article »
Filed under: Visual Basic 6.0
Script Update
#!/bin/sh WaktuSaatIni=`date +%Y%m%d` mkdir /home/bekap_data/$WaktuSaatIni saat=`date +%H%M` #cd /var/lib #tar cvvf /home/bekap_data/$WaktuSaatIni/mysql.tar /var/lib/mysql cd /home/ #ini situs utama www.ptpn-11.com tar cvvf /home/bekap_data/$WaktuSaatIni/web2010.tar /home/web2010/ #tar cvvf /home/bekap_data/$WaktuSaatIni/mysql.tar /home/database/mysql #ini database-nya tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_arif.tar /home/database/mysql/arif tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_forumDB.tar /home/database/mysql/forumDB tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_kvaweb.tar /home/database/mysql/kvaweb tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_ptpn11_map.tar /home/database/mysql/ptpn11_map tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_ptpn11wp.tar /home/database/mysql/ptpn11wp tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_ptpn2010.tar /home/database/mysql/ptpn2010 tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_rosella.tar /home/database/mysql/rosella tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_sdm_ptpn_xi.tar /home/database/mysql/sdm_ptpn_xi tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_sms.tar /home/database/mysql/sms tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_t89607_eproc.tar /home/database/mysql/t89607_eproc tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_t89607_ptpn.tar /home/database/mysql/t89607_ptpn tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_t89607_sipgut.tar /home/database/mysql/t89607_sipgut tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_webptpn11.tar /home/database/mysql/webptpn11 tar cvvf /home/bekap_data/$WaktuSaatIni/mysql_wonolangan.tar /home/database/mysql/wonolangan … Read entire article »
Filed under: PHP-Script
Inner Join
(3:36:16 PM) dimas_4dityo: boss…INNER JOIN Kie piye ?? (3:36:22 PM) dimas_4dityo: pengertian konsep e (3:37:25 PM) punyadony: nggabungno dua tabel.. penggabungane, berdasar ndek field key yg bersesuaian ndek masing2 tabel (3:37:52 PM) punyadony: tabel A : NIP, Nama, Alamat (3:38:11 PM) punyadony: tabel B : NIP, Gaji, Bonus (3:38:21 PM) punyadony: nah join e (3:39:31 PM) punyadony: select a.nama, a.alamat, b.gaji, b.bonus from A a inner join B b on a.NIP = b.NIP (3:40:01 PM) dimas_4dityo: oo… (3:40:05 PM) dimas_4dityo: oke2x (3:40:29 PM) punyadony: ok2 … Read entire article »
Filed under: 4. Programming / IDE, MYSQL
Tutorial MYSQL
http://www.java2s.com/Tutorial/MySQL/0100__Table-Join/0040__Inner-Join.htm … Read entire article »
Filed under: 4. Programming / IDE, MYSQL
mysqldump Piye Nggawene ?
CONSOL >#$ mysqldump -u root -p –databases noc_db > noc_db.sql … Read entire article »
Filed under: MYSQL
itegno lagi
Ada Yang Butuh Itegno – 3000 Namanya Pak Gunadi No HP : 031-70359992 … Read entire article »
Filed under: 4. Programming / IDE, 8. Data Comm / Inet of Things (IoT), MYSQL
From Excel To Mysql – 2
Excel Ke MySQLCara nie agak panjang sikit berbanding cara lain (mungkin ada yang lebih senang) Tapi memang boleh dipraktikkan. Fail disimpan (Save As) CVS Buka PHPMyAdmin dan buat 1 DATABASE. Kemudian buat 1 TABLE No of field 5 (mengikut kesesuaian rekod dari Excel) IMPORT FAIL Setelah selesai membuat Database dan Table, klik Table, Import, Browse fail CVS Pilih CVS Load Data, Field terminate by , (comma) Klik GO Add New User – jika belum Uji Connection guna Dreamweaver Hasilnya boleh dilihat dalam web browser. (IE) OK. … Read entire article »
Filed under: 4. Programming / IDE, MYSQL
From Excel To Mysql 1
12.2.5. LOAD DATA INFILE Syntax LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE ’file_name’ [REPLACE | IGNORE] INTO TABLE tbl_name [CHARACTER SET charset_name] [FIELDS [TERMINATED BY ’string’] [[OPTIONALLY] ENCLOSED BY ’char’] [ESCAPED BY ’char’] ] [LINES [STARTING BY ’string’] [TERMINATED BY ’string’] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...] The LOAD DATA INFILE statement reads rows from a text file into a table at a very … Read entire article »
Filed under: 4. Programming / IDE, MYSQL
PPP auto Dial
Tambahkan ke Crontab … Kemudian lakukan Checking per 1 menit, jika koneksi putus maka akan dilakukan percobaan dial ke ADSL provider, sampai bener bener konek. <?$pppcheck = exec("ifconfig | grep ppp | grep -v grep | awk ’{ print $1}’");if($pppcheck=="") {exec("/usr/sbin/pppoe-start");}?> GoodLuck … Read entire article »
Filed under: PHP-Script
redirect-web
Bila Menggunakan HTML script,redirect web bisa ditulis : <meta HTTP-EQUIV="REFRESH" content="0; url=http://www.yourdomain.com/index.html"> Bila Menggunakan PHP script, redirect web bisa ditulis : — $URL=http://www.alamat-url-tujuan.com/ header ("Location:$URL"); — .:goodluck:. … Read entire article »
Filed under: PHP-Script