tag:blogger.com,1999:blog-37038877648069938602024-03-05T15:33:58.786+07:00KangkamUnknownnoreply@blogger.comBlogger85125tag:blogger.com,1999:blog-3703887764806993860.post-83141264250295422852012-01-08T10:59:00.005+07:002012-01-08T11:04:57.253+07:00MySQL : mysqldump with -w option on Windows XPCase : 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",$sConnStringKangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-46752782584280483562011-11-24T23:44:00.011+07:002011-11-24T23:56:48.089+07:00Javascript : Reload Target / Parent Window From Second Child WindowI 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 Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-47271764419258164062011-11-17T18:49:00.005+07:002012-01-10T18:24:36.230+07:00Bash : Auto Delete Old Backup FilesBased 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 Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-84077336376748044662011-11-17T18:20:00.003+07:002011-11-17T19:30:29.387+07:00Bash : Auto Backup Mysql on Mandriva 2005Based 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 *.Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-87844346464081882382011-09-26T09:07:00.003+07:002011-09-26T09:09:45.380+07:00phpMyAdmin : How to Import Large CSVCase : 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:Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-18102183440606998572011-08-31T18:18:00.001+07:002011-08-31T18:18:37.751+07:00Javascript : URL Validationfunction urlValidator(elem, helperMsg){
var urlExp = /^http?\:\/\/(www\d?\d?\d?\d?\.)?([A-Za-z0-9-_]+\.)?[A-Za-z0-9-_]+((\.[A-Za-z]{2,6})(\.[A-Za-z]{2})?([0-9-_%&\?\/\.=]*))$/;
if(elem.value.match(urlExp)){
return true;
} else {
alert(helperMsg);
elem.focus();
return false;
}
}
Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-42728822926215347042011-08-18T00:17:00.000+07:002011-08-18T00:17:47.585+07:00Excel : Delete new lineCase : 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" Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-67452287355373493682011-08-18T00:07:00.002+07:002011-08-18T00:08:58.953+07:00Excel : Merge Spreadsheets into One SpreadsheetSub 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
Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-21014897754984033682011-07-23T11:16:00.000+07:002011-07-23T11:16:06.503+07:00PHP : Fungsi Terbilangfunction kekata($x) {
$x = abs($x);
$angka = array("", "satu", "dua", "tiga", "empat", "lima",
"enam", "tujuh", "delapan", "sembilan", "sepuluh", "sebelas");
$temp = "";
if ($x <12) {
$temp = " ". $angka[$x];
} else if ($x <20) {
$temp = kekata($x - 10). " belas";
} else if ($x <100) {
$temp = kekata($x/10)." puluh". kekata($x % 10);
} else if ($x <200) {
$temp = " Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-2814387121556053992011-07-22T09:12:00.002+07:002011-07-22T09:12:59.275+07:00JQuery : Fade Out setTimeout(function() {
$('#final_msg').fadeOut();
}, 10000)
Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-20460931546765949822011-07-15T13:26:00.001+07:002011-07-15T14:58:58.650+07:00Ubuntu 11.04 : Perfect Server Ubuntu 11.04 with ISPConfigHow 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/Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-70262755700396266882011-07-14T09:48:00.000+07:002011-07-14T09:48:32.770+07:00JQuery : Autocomplete Force Inputcase : 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,
Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-21778836176589582072011-07-03T13:08:00.002+07:002011-07-03T13:08:16.836+07:00JQuery : Star RatingKangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-80428429243076764372011-06-28T15:08:00.004+07:002011-06-28T15:12:00.610+07:00PHP MySQL : Output Query Result in Two ColumnsKangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-86653801763989244862011-06-23T13:18:00.001+07:002011-06-23T13:18:45.104+07:00PHP MySQL : Numbering on Paging TutorialKangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-90872074962485533522011-06-23T13:15:00.003+07:002011-06-23T13:19:06.112+07:00PHP MySQL : Paging TutorialKangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-21202408583530951202011-06-20T09:12:00.002+07:002011-06-20T09:15:33.418+07:00Excel : Speed Up CalculationCase : 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
Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-20899380184880170422011-06-08T10:33:00.002+07:002011-06-23T13:19:06.117+07:00Install Ubuntu Perfect ServerThis 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://Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com2tag:blogger.com,1999:blog-3703887764806993860.post-15806945501328547292011-05-18T15:16:00.004+07:002011-05-18T15:22:28.327+07:00Mass User Creation in WordPressCase : 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-30Kangkam Galihhttp://www.blogger.com/profile/12887865474648455082noreply@blogger.com1tag:blogger.com,1999:blog-3703887764806993860.post-46246412480087724242011-04-14T21:54:00.005+07:002011-04-14T22:03:49.949+07:0020 Things You Must Have on Your Blog20 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.comUnknownnoreply@blogger.com5tag:blogger.com,1999:blog-3703887764806993860.post-71822578863378207242011-03-29T13:52:00.009+07:002011-03-29T14:06:56.802+07:00JQuery : Tooltip and Image PreviewCase : 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 != "") ? Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-74703331002680498042011-03-29T12:14:00.008+07:002011-03-29T12:56:09.377+07:00PHP : Auto Resize Image on UploadCase : 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]; $fileUnknownnoreply@blogger.com2tag:blogger.com,1999:blog-3703887764806993860.post-63320376569398603252011-03-25T14:28:00.006+07:002011-03-25T14:40:34.241+07:00Blogger : Show hide Guestbook/Shoutbox/ShoutmixScript 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.pushUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-3703887764806993860.post-77372076853729052011-03-21T15:57:00.007+07:002011-03-21T17:54:52.077+07:00JQuery : Autocomplete extraParamsCase : 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: Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-3703887764806993860.post-37315573356829671222011-03-19T11:39:00.004+07:002011-06-23T13:19:06.122+07:00JQuery : Autocomplete not working more than 10 rowsCase : 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").Unknownnoreply@blogger.com0