Pages

Sunday, March 31, 2013

Membuat format angka dengan javascript

Berikut ini Script untuk membuat format angka pada inputan Text

Script :


<script type="text/javascript">
function formatangka()
{
a = form1.harga.value;
b = a.replace(/[^\d]/g,"");
c = "";
panjang = b.length;
j = 0;
for (i = panjang; i > 0; i--)
{
j = j + 1;
if (((j % 3) == 1) && (j != 1))
 {
c = b.substr(i-1,1) + "," + c;
} else {
c = b.substr(i-1,1) + c;
}
}
form1.harga.value = c;
}
</script>

<br/>
<p>Format Angka Pada Input Text</p>
<br/>

<form name="form1">
 <input type="text" name="harga" onkeyup="formatangka()">
</form>

Membuat format titik dengan javascript


Berikut ini cara membuat format titik pada input type = "text"

Script :

<script type="text/javascript">
function formatangka_titik()
{
a = form1.harga.value;
b = a.replace(/[^\d]/g,"");
c = "";
panjang = b.length;
j = 0;
for (i = panjang; i > 0; i--)
{
j = j + 1;
if (((j % 3) == 1) && (j != 1))
 {
c = b.substr(i-1,1) + "." + c;
} else {
c = b.substr(i-1,1) + c;
}
}
form1.harga.value = c;
}
</script>


Format Titik Pada Input Text

<form name="form1">
<input name="harga" onkeyup="formatangka_titik()" type="text" />
</form>



Wednesday, March 27, 2013

ibase_num_rows() not pound on php 5.3

Create function ibase_num_rows() on firebird


function ibase_num_rows($res)
    {
            $i = 0;
            while (ibase_fetch_row($res)) {
            $i++;
            }
            return $i;
    }

Tuesday, March 26, 2013

Menyederhanakan script Oprator Perbandingan IF

Script Normal :

if ($value!=0) {
   $value=$value;
}
else{
    $value='';
}

Script sederhana :


$value !=0 ? $value:""

Thursday, March 21, 2013

Sunday, March 17, 2013

Merubah hasil select Banyak Baris menjadi satu baris Record


Code Standar function Select yang menghasilkan data dalam bentuk baris record yang banyak :


select Emplname  from mst_employee  where section='system'


Code  untuk membuat hasil select menjadi  satu record / satu baris :

declare @teks varchar(2000)
   select @teks = coalesce(@teks+',','')+ cast(Emplname as varchar(50))from mst_employee
   where  section='system'
   select @teks Nama_Karyawan

Thursday, March 14, 2013

Cara menghapus semua isi tabel pada SQL Server












Rumus :

DELETE FROM [NAMA_TABLE]

Contoh :

DELETE FROM master_employee


Ket : Menghapus semua data yang ada pada table master_employee

Sunday, March 10, 2013

Upload file with Jquery










Script HTML :



<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8" />
    <title>HTML5 File API</title>
    <link rel="stylesheet" href="style.css" />
</head>
<body>
<div id="main">
<form method="post" enctype="multipart/form-data"  action="">
    <input type="file" name="filename" id="filename" multiple />
    <button type="submit" id="btn">Upload Files!</button>
    </form>

  <div id="response"></div>

</div>

  <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
  <script src="upload.js"></script>
</body>
</html>


Simpan Dengan nama index.php


Script PHP :


<?php

foreach ($_FILES["filename"]["error"] as $key => $error) {
    if ($error == UPLOAD_ERR_OK) {
        $name = $_FILES["filename"]["name"][$key];
        move_uploaded_file( $_FILES["filename"]["tmp_name"][$key], "/var/www/DMSStore/" . $_FILES['filename']['name'][$key]);
    }
}


echo "<h2>Successfully Uploaded Images</h2>";


Simpan Dengan nama upload.php


Script JQuery :


(function () {
var input = document.getElementById("filename"),
            formdata = false;

if (window.FormData) {
            formdata = new FormData();  
}

  input.addEventListener("change", function (evt) {
  document.getElementById("response").innerHTML = "Uploading . . ."
  var i = 0, len = this.files.length, img, reader, file;

file = this.files[i];
if (!!file.type.match(/image.*/) || !!file.type.match(/pdf.*/)) {
if ( window.FileReader ) {
reader = new FileReader();
reader.readAsDataURL(file);
}
if (formdata) {
formdata.append("filename[]", file);
}
}


if (formdata) {
$.ajax({
url: "upload.php",
type: "POST",
data: formdata,
processData: false,
contentType: false,
success: function (res) {
document.getElementById("response").innerHTML = res;
$("#filename").val('');
}
});
}
}, false);
}());



Simpan Dengan nama upload.js

Friday, March 8, 2013

Cara convert String ke integer Pada SQL Server



Dengan menggunakan fungsi CAST or CONVERT

Rumus CAST:

SELECT CAST(Varchar_column AS INT) FROM Nama_table


Rumus CONVERT:


SELECT CONVERT(INT, Varchar_column) FROM Nama_table

Wednesday, March 6, 2013

How to Read multiple Checkboc value using JQuery


html script :

<input  id="ad_Checkbox1" class="ads_Checkbox" type="checkbox" value="1" />
<input  id="ad_Checkbox2" class="ads_Checkbox" type="checkbox" value="2" />
<input  id="ad_Checkbox3" class="ads_Checkbox" type="checkbox" value="3" />
<input  id="ad_Checkbox4" class="ads_Checkbox" type="checkbox" value="4" />
<input type="button" id="save_value" name="save_value" value="Save" />


Jquery script :


 $(function(){
      $('#save_value').click(function(){
        var val = [];
        $(':checkbox:checked').each(function(i){
          val[i] = $(this).val();
        });
      });
    });