Kangkam

MySQL : mysqldump with -w option on Windows XP

2012-01-08T10:59:00.005+07:00

Case : You have a big size of mysql database table on windows xp machine and you want to dump database table with "where" condition Solution : using -w option set_time_limit(0); $username = "root"; $password = "toor"; $hostname = "localhost"; $sConnString = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); $connection = mysql_select_db("Country",$sConnString

Javascript : Reload Target / Parent Window From Second Child Window

2011-11-24T23:44:00.011+07:00

I have problem like this guy on this link. Solution : use window.name, and target it to reload On parent page : window.name = "parent_window"; On the first child page : function open2print(id_cek_in,diskon) { window.open( "cek_print.php?id_cek_in="+id_cek_in+"&cetak=y&diskon="+diskon, "print","status=no,menubar=no,toolbar=no,scrollbars=yes,resizable=yes,width=600,height=800" ) } On the

Bash : Auto Delete Old Backup Files

2011-11-17T18:49:00.005+07:00

Based on my experience on maintenance project. It's about to create auto delete old backup files on Mandriva 2005 (Linux) server. This article is related with this article After create backup file there will be alot of files created in our backup folder. So we need an auto delete old backup files. 1. Create recycle.sh $ mcedit /recycle.sh File content : #! /bin/sh find /backup | grep `date -

Bash : Auto Backup Mysql on Mandriva 2005

2011-11-17T18:20:00.003+07:00

Based on my experience on maintenance project. It's about to create auto backup mysql on Mandriva 2005 (Linux) server. 1. Create file backup.sh, you may using mc or pico $ mcedit /backup.sh File content : #! /bin/sh /usr/bin/mysqldump -u[username] -p[password] [database_name] > /[your_backup_directory]/[filename].sql cd /backup tar --remove-files -czf backup-`date '+%Y-%m-%d' `.tar.gz -R *.

phpMyAdmin : How to Import Large CSV

2011-09-26T09:07:00.003+07:00

Case : You have a big file size csv to import to mysql using phpmyadmin Solution : Use mysql script instead of import form from phpmyadmin (that will save you a lot of time) Script : LOAD DATA LOCAL INFILE 'file_name.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (column1,column2,column3); Note : place your csv file in your phpmyadmin directory Source : http://

Javascript : URL Validation

2011-08-31T18:18:00.001+07:00

Excel : Delete new line

2011-08-18T00:17:00.000+07:00

Case : You have a text : I want to eat in column A1, and you want to replace into single line : I want to eat. This kind of thing gonna be a troublesome if you have 1000 lines to change. Instead of replacing manual one by one, you can do this trick : 1. Press Ctrl + F 2. Switch to "Replace" tab 3. Put active cursor into "Find what" column 4. Press Alt + 010 5. Press "Replace All" button

Excel : Merge Spreadsheets into One Spreadsheet

2011-08-18T00:07:00.002+07:00

Sub CopyFromWorksheets() Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As Worksheet 'Master Worksheet Dim rng As Range 'Range object Dim colCount As Integer 'Column count in tables in the worksheets Set wrk = ActiveWorkbook 'Working in active workbook

PHP : Fungsi Terbilang

2011-07-23T11:16:00.000+07:00

JQuery : Fade Out

2011-07-22T09:12:00.002+07:00

setTimeout(function() { $('#final_msg').fadeOut(); }, 10000)

Ubuntu 11.04 : Perfect Server Ubuntu 11.04 with ISPConfig

2011-07-15T13:26:00.001+07:00

How to install Perfect Server Ubuntu 11.04 with ISPConfig http://www.howtoforge.com/perfect-server-ubuntu-11.04-ispconfig-3 http://www.howtoforge.com/perfect-server-ubuntu-11.04-ispconfig-3-p2 http://www.howtoforge.com/perfect-server-ubuntu-11.04-ispconfig-3-p3 http://www.howtoforge.com/perfect-server-ubuntu-11.04-ispconfig-3-p4 http://www.howtoforge.com/perfect-server-ubuntu-11.04-ispconfig-3-

JQuery : Autocomplete Force Input

2011-07-14T09:48:00.000+07:00

case : you use jquery autocomplete to replace an old style drop down menu and you want to force user to choose at least one of these input option. solution : use a "mustMatch"; $().ready(function() { $("#kategori").autocomplete("../actions/autocomplete.php?p=kategori", { width: 190, max: 2000, selectFirst: false,

JQuery : Star Rating

2011-07-03T13:08:00.002+07:00

PHP MySQL : Output Query Result in Two Columns

2011-06-28T15:08:00.004+07:00

PHP MySQL : Numbering on Paging Tutorial

2011-06-23T13:18:00.001+07:00

PHP MySQL : Paging Tutorial

2011-06-23T13:15:00.003+07:00

Excel : Speed Up Calculation

2011-06-20T09:12:00.002+07:00

Case : You want to delete bulk of rows (more than 50.000 rows) on excel Solution : Use VBA Script : Sub delete_rows_zero() Application.ScreenUpdating = False Dim nMaxRow As Long, nrow As Long nMaxRow = ActiveSheet.UsedRange.Rows.Count For nrow = nMaxRow To 1 Step -1 If Range("A" & nrow).Value = "delete" Then Range("A" & nrow).EntireRow.Delete End If Next nrow

Install Ubuntu Perfect Server

2011-06-08T10:33:00.002+07:00

This tutorial shows how to prepare an Ubuntu 10.04 (Lucid Lynx) server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. http://

Mass User Creation in WordPress

2011-05-18T15:16:00.004+07:00

Case : you want to add mass user in your wordpressScript :require( '/wp-load.php' );wp_create_user('otto', 'password', 'otto@ottodestruct.com');wp_create_user('fake', 'fakepass', 'fake@example.com');...Source : http://wordpress.org/support/topic/mass-user-creation-in-wordpress-30

20 Things You Must Have on Your Blog

2011-04-14T21:54:00.005+07:00

20 things you must have on your blog :SEO DesignPage : HomePage : AboutPage : DisclaimerPage : ContactAddthisSearchboxShoutboxFollowerPopular PostRecent PostBlog ArchiveBlogrollFeedjitTagcloud / Wp-Cumulus likeBacklinkPagingLinkwithinShare Facebook buttonGoogle Adsense Source : http://www.google.com

JQuery : Tooltip and Image Preview

2011-03-29T13:52:00.009+07:00

Case : You want to create cool tooltip or image preview from your thumbnailSolution : JQueryScript :this.imagePreview = function(){/* CONFIG */ xOffset = 10; yOffset = 30; // these 2 variable determine popup's distance from the cursor // you might want to adjust to get the right result/* END CONFIG */$("a.preview").hover(function(e){ this.t = this.title; this.title = ""; var c = (this.t != "") ?

PHP : Auto Resize Image on Upload

2011-03-29T12:14:00.008+07:00

Case : you want to resize image on uploadSolution : PHP imagecopyresampledScript :if ($_SESSION[username_administrasi] != "" && $_POST[submit] == "Simpan") { $cek = cek("select * from ktp where no_ktp = '$no_ktp' and npwp = '$npwp' "); if ($cek > 0) { alert("Data sudah ada !"); loncat("../index.php"); } else { $tmp_filename = $_FILES[file1][tmp_name]; $filename = $_FILES[file1][name]; $file

Blogger : Show hide Guestbook/Shoutbox/Shoutmix

2011-03-25T14:28:00.006+07:00

Script CSS :#gb{position:fixed;top:50px;z-index:+1000;}* html #gb{position:relative;}.gbtab{height:200px;width:30px;float:left;cursor:pointer;background:url("http://purwomartono.googlepages.com/slider_shoutmix.gif") no-repeat;}.gbcontent{float:left;border:5px solid #000000;background:#FFFFFF;padding:5px;}Script Javascript :var _gaq = _gaq || [];_gaq.push(['_setAccount', 'UA-4639370-4']);_gaq.push

JQuery : Autocomplete extraParams

2011-03-21T15:57:00.007+07:00

Case : You want to create an autocomplete that depends on another fieldsSolution : Using JQuery Autocomplete with extraParamsScript :$("#ProvinsiCalonSuami").autocomplete("actions/autocomplete.php?p=provinsi", {max: 100,width: 260,selectFirst: true,});$("#KabupatenCalonSuami").autocomplete("actions/autocomplete.php?p=kabupaten", {max: 100,width: 260,selectFirst: true,extraParams: {provinsi:

JQuery : Autocomplete not working more than 10 rows

2011-03-19T11:39:00.004+07:00

Case : You are using JQuery autocomplete, but the data cannot display more than 10 rowsSolution : using option "Max"Script :$().ready(function() {$("#targetDiv1").autocomplete("actions/autocomplete.php?p=provinsi", { max: 100, width: 260, selectFirst: false,});$("#targetDiv2").autocomplete("actions/autocomplete.php?p=kabkota", { max: 100, width: 260, selectFirst: false,});$("#targetDiv3").