Posts Tagged ‘code’

Converting hex into a text or normal string

Posted by on 5 November, 2008
7 Comments
This item was filled under [ Code Snippet, PHP ]

Converting hex into a text or normal string using PHP code.
Fungsi mengkonvert dari tulisan bentuk hex kedalam normal string menggunakan PHP.

<?php
function hex2text($hexstr) {
 $hex = explode('%',$hexstr);
 array_shift($hex);
    $str = '';
    foreach($hex as $hexcode) {
     $str .= chr(base_convert($hexcode, 16, 10));
    }
    return $str; 
}
?>

contoh penggunaan:

echo hex2text("%40"); // <-- akan menampilkan @
echo "<br />";
echo hex2text("%2A"); // <-- akan menampilkan *
echo "<br />";
echo hex2text("%40%2A"); // <-- akan menampilkan @*

semoga mambantu :mrgreen:

Update: untuk memudahkan, gunakan Tools konversi javascript encrypt decrypt hex HTML.
Link nya: http://www.nusansifor.com/kasus/hex2string

Selamat mencoba.

1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 5.00 out of 5)
Loading ... Loading ...
Popularity: 5,519 views
Tagged with: [ , , , , , , , ]

CSV2MySQL convert from CSV file into MySQL database

Posted by on 5 November, 2008
13 Comments
This item was filled under [ Code Snippet, Javascript, MySQL, PHP ]

Bagaimana cara convert dari CSV ke dalam database MySQL menggunakan PHP.
Silahkan lihat langkah2 dibawah ini:

How to convert from CSV file into MySQL database using PHP?
Plus how to create a table and fields into database with PHP?
Here it is..
We need 3 files php, and 2 file jpg (the jpg is just for menu).

index.php

<?php
// UPLOAD CSV CUSTOM
// Ver. 1.0
// by Jawaad
// http://www.nusansifor.com
// File: index.php
 
@session_start();
//@ob_start(); 
//@ob_implicit_flush(0); 
 
@error_reporting(E_ALL ^ E_NOTICE);
@ini_set('display_errors', true);
@ini_set('html_errors', false);
@ini_set('error_reporting', E_ALL ^ E_NOTICE);
 
define('jin', true);
 
// CONECT DATABASE
@mysql_connect("localhost", "root", "") OR die ("NOT CONNECT DATABASE");
@mysql_select_db("nama_database") OR die ("CONNECTED, BUT NO DATABASE");
 
 
 
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
  "http://www.w3.org/TR/html4/strict.dtd">
<html xmlns='http://www.w3.org/1999/xhtml' lang='en' xml:lang='en:us'>
  <head>
    <meta http-equiv="Content-type" content="text/html; charset=utf-8">
    <title>UPLOAD CSV CUSTOM</title>
    <style type="text/css" media="screen">
      body {
        background: #fff;
        color: #888;
        font: 100% georgia,times,serif;
      }
      h1 {
        font-weight: normal;
        margin: 0;
        padding: 0 0 .5em 0;
      }
      h2 {
        font-weight: normal;
        margin: 0;
        padding: 0 0 .5em 0;
      }
 
/*- Menu Tabs J--------------------------- */
 
    #tabsJ {
      float:left;
      width:100%;
      background:#fff;
      font-size:93%;
      line-height:normal;
	  border-bottom:1px solid #24618E;
      }
    #tabsJ ul {
	margin:0;
	padding:10px 10px 0 50px;
	list-style:none;
      }
    #tabsJ li {
      display:inline;
      margin:0;
      padding:0;
      }
    #tabsJ a {
      float:left;
      background:url("tableftJ.gif") no-repeat left top;
      margin:0;
      padding:0 0 0 5px;
      text-decoration:none;
      }
    #tabsJ a span {
      float:left;
      display:block;
      background:url("tabrightJ.gif") no-repeat right top;
      padding:5px 15px 4px 6px;
      color:#24618E;
      }
    /* Commented Backslash Hack hides rule from IE5-Mac \*/
    #tabsJ a span {float:none;}
    /* End IE5-Mac hack */
    #tabsJ a:hover span {
      color:#FFF;
      }
    #tabsJ a:hover {
      background-position:0% -42px;
      }
    #tabsJ a:hover span {
      background-position:100% -42px;
      }		
    </style>
    <script type="text/javascript">
function addElement() {
  var ni = document.getElementById('myDiv');
  var numi = document.getElementById('theValue');
  var num = (document.getElementById("theValue").value -1)+ 2;
  numi.value = num;
  var divIdName = "my"+num+"Div";
  var newdiv = document.createElement('div');
  newdiv.setAttribute("id",divIdName); //  + num + 
  newdiv.innerHTML = "<input type=hidden name=\"kode[" + num + "]\" value=\"" + num + "\"><input type=text name=\"field" + num + "\"> <select name=\"tipe" + num + "\"><option>TEXT</option><option>LONG-TEXT</option><option>NUMERIC</option><option>NUMERIC-2-DECIMAL</option><option>DATE</option><option>DATE-TIME</option></select> <a href=\"javascript:;\" onclick=\"removeElement(\'"+divIdName+"\')\">[- del]</a><p>";
  ni.appendChild(newdiv);
}
 
function removeElement(divNum) {
  var d = document.getElementById('myDiv');
  var olddiv = document.getElementById(divNum);
  d.removeChild(olddiv);
}
</script>
</head>
 
<body>
      <h1>UPLOAD CUSTOM CSV INSERT TO MYSQL</h1>
<div id="tabsJ">
  <ul>
    <li><a href="?do=upload_csv" title="Upload CSV"><span>Upload CSV</span></a></li>
    <li><a href="?do=create_table" title="Create New Table"><span>Create New Table</span></a></li>
  </ul>
</div>
<?php
switch($_REQUEST["do"]) {
	case "upload_csv":
		include ("upload_csv.php");
	break;
	case "create_table":
		include ("create_table.php");
	break;
 
	default:
		include ("upload_csv.php");
}
 
?>
 
 
	 </body>
</html>

upload_csv.php

<?php
// UPLOAD CSV CUSTOM
// Ver. 1.0
// by Jawaad
// http://www.nusansifor.com
 
if(!defined('jin')) { die('nice try..'); }
 
if($_POST[upload_csv]=="1") {
	$table_name="`".$_POST[table_name]."`";
	if(!$_FILES["file_csv"]["name"]) {
		echo "<script>alert('Please Browse File.. CSV.');</script>";
	} else if(substr($_FILES["file_csv"]["name"], -3) != "csv") {
		echo "<script>alert('File ".substr($_FILES["file_csv"]["name"],-3)." not support. Please use CSV extension');</script>";
	} else if($_FILES["file_csv"]["size"]>=1672864) {
		echo "<script>alert('File size is too big. File max 1.5 MB');</script>";
	} else {
		// READ FIELD FROM TABEL
		$sql_tabel = mysql_query("SELECT * FROM ".$table_name."");
		$numfields = mysql_num_fields($sql_tabel);
		$field_name = "";
		for ($i=0; $i < $numfields; $i++) {
			$get_field = mysql_field_name($sql_tabel, $i);
			if($i == 1) {
				$field_name .= "`".$get_field."`";
			} elseif($i > 1) {
				$field_name .= ", `".$get_field."`";
			}
		}
		copy($_FILES["file_csv"]["tmp_name"], "tmp/".$_FILES["file_csv"]["name"]);
	  	$ifile = fopen("tmp/".$_FILES["file_csv"]["name"],"r");
	  	$no=1;
		$jum_value = $numfields - 1;
	  	while (($file_list = fgetcsv($ifile, 1000, ",")) !== FALSE) {
			if($no > 1) {
				$field_value = "";
				for ($i=0; $i < $jum_value; $i++) {
						if($i == 0) {
							$field_value .= "'".$file_list[$i]."'";
						} else {
							$field_value .= ", '".$file_list[$i]."'";
						}
				}
					$sql = "INSERT INTO ".$table_name." (".$field_name.") VALUES (".$field_value.")";
					$ex = mysql_query($sql) OR die ("<br>ERROR, DATA TIDAK BISA MASUK...<br>");
					if(!$ex) {
						echo "<script>alert(\"Sorry, Error....\");location.href='?do=upload_csv';</script>";
					} else {
						echo "<script>alert(\"Succesed.\");location.href='?do=upload_csv';</script>";
					}
			}
			$no++;
		}
		fclose($ifile);
		unlink("tmp/".$_FILES["file_csv"]["name"]) OR die ("Cannot DEL file tmp/".$_FILES["file_csv"]["name"]);
	}
}
?>
 
<form method="post" enctype="multipart/form-data">
<br><br>
<h2>Upload CSV</h2>
<table border="0" cellspacing="0" cellpadding="3">
<tr>
	<td valign="top">Table Name</td><td valign="top">: <input name="table_name"></td>
</tr>
<tr>
	<td valign="top">File CSV</td><td valign="top">: <input type="file" name="file_csv" value="1"></td>
</tr>
<tr>
	<td valign="top" colspan="2">
		<input type="hidden" name="upload_csv" value="1">
		<input type="submit" name="submit" value="UPLOAD .CSV">
	</td>
</tr>
</table>
</form>

create_table.php

<?php
// UPLOAD CSV CUSTOM
// Ver. 1.0
// by Jawaad
// http://www.nusansifor.com
// file: create table
 
if(!defined('jin')) { die('nice try..'); }
 
?>
 
<form method="post">
<br><br>
<h2>Create Table</h2>
Table Name: <input name="table_name">
<input type="hidden" value="0" id="theValue" /><a href="javascript:;" onclick="addElement();">+ Add field</a>
<p>
<div id="myDiv"> </div>
 
 
<input type="hidden" name="create_table" value="1">
<input type="submit" name="submit" value="Create Table">
</form>
 
 
<?php
if($_POST[create_table]=="1") {
	//$kode = array($_POST[kode]);
	$table_name = $_POST[table_name];
	echo "Check <b>".$table_name."</b><br>";
	//print_r($_POST[kode]);
	if($table_name != "" && $_POST[kode] != "") {
		foreach ($_POST[kode] as $field_arr) {
			$field =  $_POST["field".$field_arr.""];
			$tipe = $_POST["tipe".$field_arr.""];
				 if($tipe == "TEXT") {$db_tipe = "varchar(255),";}
			elseif($tipe == "NUMERIC") {$db_tipe = "bigint(20),";}
			elseif($tipe == "NUMERIC-2-DECIMAL") {$db_tipe = "float(10,2),";}
			elseif($tipe == "LONG-TEXT") {$db_tipe = "text NOT NULL,";}
			elseif($tipe == "DATE") {$db_tipe = "date NOT NULL,";}
			elseif($tipe == "DATE-TIME") {$db_tipe = "datetime NOT NULL,";}
			$the_fields .= "`" . $field . "` " . $db_tipe . "\n";
		}
		$sql = "
					CREATE TABLE IF NOT EXISTS `".$table_name."` (
						`id` bigint(20) NOT NULL auto_increment,
						".$the_fields."
						PRIMARY KEY  (`id`)
					) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
		";
		$ex = mysql_query($sql);
		if(!$ex) {
			echo "Sorry,... Error...<br>";
		} else {
			echo "Table  <b>".$table_name."</b> created.<br>";
		}
	} else {
		echo "Sorry,... Error... Please fill the table name and the fields...<br>";
	}
}
?>

Image files:

Download file lengkap:

  CSV2MySQL.V.1.0.rar (6.4 KiB, 1,925 hits)

semoga membantu :mrgreen:

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 5.00 out of 5)
Loading ... Loading ...
Popularity: 6,249 views
Tagged with: [ , , , , ]

Membuat alamat link URL menjadi cantik

Posted by on 5 November, 2008
6 Comments
This item was filled under [ Code Snippet, PHP ]

Rewrite URL adalah salah satu dari tenik SEO.
Berikut contoh simple pembuatan URL cantik menggunakan .htaccess

simpan file pada root folder project Anda dengan nama .htaccess

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^(.+) - [PT,L]
 
RewriteRule ^(.*)$ index.php?do=$1 [QSA,L]

lalu pada file index.php Anda, mainkan aturan URL-nya.

contoh isi file index.php:

<?php
$do = explode ("/", $_REQUEST['do']);
$opsi = $do[0];
 
define('PUB_DIR', dirname (__FILE__) . '/' .);
 
switch($opsi) {
	case 'home':
		require_once (PUB_DIR . 'home.php');
	break;
	case 'content':
		require_once (PUB_DIR . 'web_content.php');
	break;
	case 'subcontent':
		require_once (PUB_DIR . 'web_content_sub.php');
	break;
	case 'news':
		require_once (PUB_DIR . 'news.php');
	break;
	case 'news-detail':
		require_once (PUB_DIR . 'news-detail.php');
	break;
	case 'articles':
		require_once (PUB_DIR . 'articles.php');
	break;
	case 'article-detail':
		require_once (PUB_DIR . 'article-detail.php');
	break;
	case 'event':
		require_once (PUB_DIR . 'event.php');
	break;
	case 'event-detail':
		require_once (PUB_DIR . 'event-detail.php');
	break;
	case 'calendar':
		require_once (PUB_DIR . 'calendar.php');
	break;
	case 'testimonial':
		require_once (PUB_DIR . 'testimonial.php');
	break;
	case 'testimonial-sign':
		require_once (PUB_DIR . 'guestbook_sign.php');
	break;
	case 'product':
		require_once (PUB_DIR . 'product.php');
	break;
	case 'product_search':
		require_once (PUB_DIR . 'product_search.php');
	break;
	case 'contact':
		require_once (PUB_DIR . 'contact_us.php');
	break;
 
	case 'search':
		require_once (PUB_DIR . 'search.php');
	break;
 
	case 'download':
		require_once (PUB_DIR . 'download.php');
	break;
 
	case 'faq':
		require_once (PUB_DIR . 'faq.php');
	break;
	case 'sitemap':
		require_once (PUB_DIR . 'sitemap.php');
	break;
 
	default:
		require_once (PUB_DIR . 'home.php');
}

Semoga membantu :mrgreen:

1 Star2 Stars3 Stars4 Stars5 Stars (7 votes, average: 5.00 out of 5)
Loading ... Loading ...
Popularity: 4,772 views
Tagged with: [ , , , , ]

Fungsi angka menjadi tulisan huruf

Posted by on 5 November, 2008
2 Comments
This item was filled under [ Code Snippet, PHP ]

Fungsi merubah angka menjadi huruf.
contoh:
295.350 = dua ratus sembilan puluh lima ribu tiga ratus lima puluh
1.251 = seribu dua ratus lima puluh satu
100 = seratus
dsb….

<?php
// Fungsi untuk merubah Angka menjadi Tulisan Huruf
// Penggunaan:
// jin_num2txt(25500);
// output: dua ratus lima puluh ribu lima ratus
function jin_num2txt($num) {
	$tdiv = array("","","ratus ","ribu ", "ratus ", "juta ", "ratus ","miliar ");
	$divs = array( 0,0,0,0,0,0,0);
	$pos = 0; // index into tdiv;
	// make num a string, and reverse it, because we run through it backwards
	// bikin num ke string dan dibalik, karena kita baca dari arah balik
	$num=strval(strrev(number_format($num,2,'.',''))); 
	$answer = ""; // mulai dari sini
	while (strlen($num)) {
		if ( strlen($num) == 1 || ($pos >2 && $pos % 2 == 1))  {
			$answer = doone(substr($num,0,1)) . $answer;
			$num= substr($num,1);
		} else {
			$answer = dotwo(substr($num,0,2)) . $answer;
			$num= substr($num,2);
			if ($pos < 2)
				$pos++;
		}
		if (substr($num,0,1) == '.') {
			if (! strlen($answer))
				$answer = "";
			$answer = "" . $answer . "";
			$num= substr($num,1);
			// kasih tanda "nol" jika tidak ada
			if (strlen($num) == 1 && $num == '0') {
				$answer = "" . $answer;
				$num= substr($num,1);
			}
		}
	    // add separator
	    if ($pos >= 2 && strlen($num)) {
			if (substr($num,0,1) != 0  || (strlen($num) >1 && substr($num,1,1) != 0
				&& $pos %2 == 1)  ) {
				// check for missed millions and thousands when doing hundreds
				// cek kalau ada yg lepas pada juta, ribu dan ratus
				if ( $pos == 4 || $pos == 6 ) {
					if ($divs[$pos -1] == 0)
						$answer = $tdiv[$pos -1 ] . $answer;
				}
				// standard
				$divs[$pos] = 1;
				$answer = $tdiv[$pos++] . $answer;
			} else {
				$pos++;
			}
		}
    }
    return strtoupper($answer);
}
 
function doone2($onestr) {
    $tsingle = array("","satu ","dua ","tiga ","empat ","lima ",
	"enam ","tujuh ","delapan ","sembilan ");
       return strtoupper($tsingle[$onestr] . $answer);
}	
 
function doone($onestr) {
    $tsingle = array("","se","dua ","tiga ","empat ","lima ", "enam ","tujuh ","delapan ","sembilan ");
       return strtoupper($tsingle[$onestr] . $answer);
}	
 
function dotwo($twostr) {
    $tdouble = array("","puluh ","dua puluh ","tiga puluh ","empat puluh ","lima puluh ", "enam puluh ","tujuh puluh ","delapan puluh ","sembilan puluh ");
    $teen = array("sepuluh ","sebelas ","dua belas ","tiga belas ","empat belas ","lima belas ", "enam belas ","tujuh belas ","delapan belas ","sembilan belas ");
    if ( substr($twostr,1,1) == '0') {
		$ret = doone2(substr($twostr,0,1));
    } else if (substr($twostr,1,1) == '1') {
		$ret = $teen[substr($twostr,0,1)];
    } else {
		$ret = $tdouble[substr($twostr,1,1)] . doone2(substr($twostr,0,1));
    }
    return strtoupper($ret);
}
?>

Keterangan:

Untuk berbasis simpel class, silahkan lihat artikel berikut terbilang-ejaan-angka-kedalam-bentuk-kalimat

1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 5.00 out of 5)
Loading ... Loading ...
Popularity: 3,149 views
Tagged with: [ , ]

Script PHP Waktu eksekusi suatu halaman

Posted by on 4 November, 2008
No comments yet
This item was filled under [ Code Snippet, PHP ]

Pertama-tama ketikkan kode berikut (akhirnya…) pada bagian awal dari skrip PHP anda :
PHP Code:

$awal = microtime(true);

Pertama-tama yang kita lakukan adalah menyimpan nilai microtime() kedalam variabel $waktu. Kemudian kita pecah variabel waktu agar kita dapat menjumlahkan bagian Microsecond dan Second dari $waktu. Setelah itu simpan nilainya dalam variabel $awal.
Mudah kan.. Sekarang ketikkan kode berikut ini pada bagian paling bawah dari skrip PHP anda :
PHP Code:

$akhir = microtime(true);
$totalwaktu = $akhir  - $awal;
echo "Halaman ini di eksekusi dalam waktu " . number_format($totalwaktu, 3, '.', '') . " detik!";

Untuk kode yang ini sama dengan sebelumnya, hanya saja nilainya disimpan dalam variabel $akhir. Kemudian variabel $akhir dikurangi $awal untuk mendapatkan waktunya dan hasilnya disimpan dalam variabel $totalwaktu.

Kesimpulan
Anda dapat menggunakan teknik ini untuk menghitung berbagai macam hal, seperti kecepatan komputer anda. Lakukan saja looping hingga 100000 kali dan hitung seberapa cepat komputer anda melakukannya.

Sumber: http://www.webmaster-tutorial.com/tutorial/Waktu_eksekusi_suatu_halaman/5/2
Edited by me.

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 5.00 out of 5)
Loading ... Loading ...
Popularity: 1,611 views
Tagged with: [ , ]
Page 6 of 6123456

Halaman ini di eksekusi dalam waktu 3.669 detik! (sedeng lah segini mah...)