Facebook autocomplate style with jquery

FCBKcomplete allows to generate fancy facebook-like dynamic inputs with auto complete & pre added values.
website
demo
download

Read More

pharmacy relationship design database

The following is one form of examples of inter-relationship database design table for pharmacy

Refference:
http://rankga.wordpress.com
http://blog.its.ac.id

Read More

Make Auto Readmore on Blogspot

1. Edit HTML and find </head>.
2. Copy-paste and put this script bellow in above code script </head>, and continuous "Make Auto Read More Functions".

<script type='text/javascript'>
var thumbnail_mode = "float" ;

summary_noimg = 250;
summary_img = 250;
img_thumb_height = 120;
img_thumb_width = 120;
</script>
<script type='text/javascript'>

//<![CDATA[

function removeHtmlTag(strx,chop){
if(strx.indexOf("<")!=-1)
{
var s = strx.split("<");
for(var i=0;i<s.length;i++){
if(s[i].indexOf(">")!=-1){
s[i] = s[i].substring(s[i].indexOf(">")+1,s[i].length);
}
}
strx = s.join("");
}
chop = (chop < strx.length-1) ? chop : strx.length-2;
while(strx.charAt(chop-1)!=' ' && strx.indexOf(' ',chop)!=-1) chop++;
strx = strx.substring(0,chop-1);
return strx+'...';
}
function createSummaryAndThumb(pID){
var div = document.getElementById(pID);
var imgtag = "";
var img = div.getElementsByTagName("img");
var summ = summary_noimg;
if(img.length>=1) {
imgtag = '<span style="float:left; padding:0px 10px 5px 0px;"><img src="'+img[0].src+'" width="'+img_thumb_width+'px" height="'+img_thumb_height+'px"/></span>';
summ = summary_img;
}
var summary = imgtag + '<div>' + removeHtmlTag(div.innerHTML,summ) + '</div>';
div.innerHTML = summary;
}
//]]>
</script>

3. On EDIT HTML, check "Expand widget template" and found this script code bellow

<data:post.body/>

4. If you have been found <data:post.body>, copy-paste this script code bellow:

<b:if cond='data:blog.pageType != "item"'>
<div expr:id='"summary" + data:post.id'><data:post.body/></div>
<script type='text/javascript'>createSummaryAndThumb("summary<data:post.id/>");</script>
<span class='rmlink' style='float:left'><a expr:href='data:post.url' expr:title='data:post.title'>Read More »»»</a></span>
</b:if>
<b:if cond='data:blog.pageType == &quot;item&quot;'><data:post.body/></b:if>

5. Save your template and see the result.

Read More

Create Authentication Login On Code Igniter With Extends Controller

1. Create MY_Controller.php on /system/apllication/libraries/.

<?php
class MY_Controller extends Controller {

    function  My_Controller() {
        parent::Controller();
        $this->is_logged_in();
    }

    private function is_logged_in() {
        $this->ci =& get_instance();
        $this->ci->load->library('session');
        if(! $this->ci->session->userdata('login')) {
            redirect('login');
        }
    }

}
?>

2. Login Controller login.php

<?

/**
 * Login Class
 *
 *
 */
class Login extends Controller {
 /**
  * Constructor
  */
 function login()
 {
  parent::Controller();
  $this->load->model('Login_model', '', TRUE);
 }

 /**
  * Check User Status, if login status it will appear in main page,
  * If Not it'll redirect in login page
  */
 function index()
 {
  if ($this->session->userdata('login') == TRUE)
  {
   redirect('home');
  }
  else
  {
   $this->load->view('login/login_view');
  }
 }

 /**
  * Login
  */
 function process_login()
 {

  $this->form_validation->set_rules('username', 'Username', 'required');
  $this->form_validation->set_rules('password', 'Password', 'required');

  if ($this->form_validation->run() == TRUE)
  {
   $username = $this->input->post('username');
   $password = $this->input->post('password');

   if ($this->Login_model->check_user($username, $password) == TRUE)
   {
    $row = $this->Login_model->data_user($username);
    $data = array('jbname' => $username, 'login' => TRUE, 'jbnama' => $row['nama'], 'jbid' => $row['id_user']);
    $this->session->set_userdata($data);
    redirect('home/');
   }
   else
   {
    $this->session->set_flashdata('message', 'Sorry, username and password is wrong');
    redirect('login/index');
   }
  }
  else
  {
   $this->load->view('login/login_view');
  }
 }

 /**
  * logout
  */
 function process_logout()
 {
  $this->session->sess_destroy();
  redirect('login', 'refresh');
 }
}

3. Make Model Login_model.php

<?php
/**
 * Login_model Class
 *
 *
 */
class Login_model extends Model {
 /**
  * Constructor
  */
 function Login_model()
 {
  parent::Model();
 }

 // Inisialisation user table name
 var $table = 'user';

 /**
  * Check user table
  */
 function check_user($username, $password)
 {
  $password = md5($password);
  $query = $this->db->get_where($this->table, array('username' => $username, 'pass' => $password, 'aktif' => 1,
  'nm_module' => 'akd'), 1, 0);

  if ($query->num_rows() > 0)
  {
   return TRUE;
  }
  else
  {
   return FALSE;
  }
 }

 function data_user($username){
  $sql = "select id_user, nama from user where username = '$username' and nm_module = 'akd' ";
  $query = $this->db->query($sql);
  $row = $query->row_array();
  return $row;
 }

}
// END Login_model Class

/* End of file login_model.php */
/* Location: ./system/application/model/login_model.php */

Read More

Simple General Helper on Code Igniter

1. Create general_helper.php on /sytem/application/helpers.

<?php

/**
 * change date format from dd/mm/yyyy become yyyy-mm-dd
 * @param <type> $date
 * @return string
 */
function encode_date($date) {
    list($day, $month, $year) = explode('/', $date);
    $new_date = $year . "-" . $month . "-" . $day;
    return $new_date;
}

/**
 * change date format from yyyy-mm-dd become dd/mm/yyyy
 * @param <type> $date
 * @return string
 */
function decode_date($date) {
    list($year, $month, $day) = explode('-', $date);
    $new_date = $day . "/" . $month . "/" . $year;
    return $new_date;
}

/**
 * create money value in Rupiah
 * @param <type> $uang
 * @return <type>
 */
function format_rupiah($uang) {
    return "Rp. ". number_format($uang, 0, ",", ".");
}

function format_dana($uang) {
    return number_format($uang, 0, ".", "");
}
        
function indonesian_month($month) {
    switch ($month) {
        case "01" : $imonth = "Januari"; break;
        case "02" : $imonth = "Februari"; break;
        case "03" : $imonth = "Maret"; break;
        case "04" : $imonth = "April"; break;
        case "05" : $imonth = "Mei"; break;
        case "06" : $imonth = "Juni"; break;
        case "07" : $imonth = "Juli"; break;
        case "08" : $imonth = "Agustus"; break;
        case "09" : $imonth = "September"; break;
        case "10" : $imonth = "Oktober"; break;
        case "11" : $imonth = "November"; break;
        case "12" : $imonth = "Desember"; break;
        default  : $imonth = "-"; break;
    }
    return $imonth;
}

/**
 * change date format to indonesia
 * @param <type> $month
 * @return string
 */
function indonesian_date($date) {
    list($year, $month, $day) = explode('-', $date);
    $new_date = $day ." ". indonesian_month($month) . " ". $year;
    return $new_date;
}

function indonesian_yearmonth($yearmonth) {
    list($month,$year) = explode(' ', $yearmonth);
    $new_yearmonth =  indonesian_month($month) . " ". $year;
    return $new_yearmonth;
}

function bulan_hari($day) {
    $tahun = floor($day/365);
    $bulan=floor(($day - ($tahun * 365))/30);
    $hari=$day - $bulan * 30;
    if($day=="30"){return $bulan." Bulan ";}
    elseif($day >= "30"){return $bulan." Bulan, ".$hari." Hari";}
    else{return $hari." Hari";}

}
?>

2. Controller script

<?php

/**
 * @property CI_DB_active_record $db
 */
class tryhelper extends MY_Controller {

    function cobapdf() {
        parent::MY_Controller();
  $this->load->helper('general_helper');
    }

    function index() {
        echo indonesia_month('01');
    }
}
?>

Read More

Exsport to PDF with dompdf in Code Igniter

1. cDownload dompf from here and exstract the file.
2. Then put to the directory ./system/application/plugins/.
3. After that then create new file on ./system/application/plugins/dompdf_pi.php like this

<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

/**
 * Try increasing memory available, mostly for PDF generation
 */
ini_set("memory_limit", "32M");

function pdf_create($html, $filename, $stream=TRUE, $orientation="portrait") {
    require_once(BASEPATH . "application/plugins/dompdf/dompdf_config.inc.php");

    $dompdf = new DOMPDF();
    $dompdf->set_paper("a4", $orientation);
    $dompdf->load_html($html);
    $dompdf->render();
    if ($stream) { //open only
        $dompdf->stream($filename . ".pdf");
    } else { // save to file only, your going to load the file helper for this one
        write_file("pdf/$filename.pdf", $dompdf->output());
    }
}

?>

4. Create controler mypdf.php

<?php

/**
 * @property CI_DB_active_record $db
 */
class mypdf extends MY_Controller {

    function mypdf() {
        parent::MY_Controller();
  $this->load->plugins('dompdf_pi');
    }

    function index() {
     $html="Hello Word";
  $filename="Mypdf";
        pdf_create($html, $filename, $stream=TRUE, $orientation='portrait');
    }

 }
?>

Read More

Count day, month and year from two date

$tgl1 = "2009-10-01";  // 1 October 2009
$tgl2 = "2009-11-10";  // 10 October 2009

// break dates to get the date, month and year
// from the first date

$pecah1 = explode("-", $tgl1);
$date1 = $pecah1[2];
$month1 = $pecah1[1];
$year1 = $pecah1[0];

// break dates to get the date, month and year
// from the second date

$pecah2 = explode("-", $tgl2);
$date2 = $pecah2[2];
$month2 = $pecah2[1];
$year2 =  $pecah2[0];

// count JDN from each of the dates

$jd1 = GregorianToJD($month1, $date1, $year1);
$jd2 = GregorianToJD($month2, $date2, $year2);

// compute difference the second day date

$selisih = $jd2 - $jd1;
$month=floor(($selisih - ($tahun * 365))/30);
$day=$selisih - $bulan * 30;

echo "difference the both of the day date is ".$month." month ".$day." day";

This Source is originaly from www.ms-room.com

Read More

Simple Script Exsport Excel With PHP

First example

<?
header("Content-Type: application/vnd.ms-excel");
echo "<table border=1>
<tr>
<td>Cell 1</td>
<td>Cell 2</td>
</tr>
</table>";
?>

Implementation

$header = "Header1" . "\t";
$header .= "Header2" . "\t";

//Reading the data thro' POST
$data= $_POST['header1']. "\t";
$data .= $_POST['header2'] . "\t";

header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=xyz.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";

Read More

Recovering Ubuntu GRUB After Installing Windows

There are two method that I often use to fix the grub on ubuntu, on time after installing windows including,
First Method

1. Boot into a LiveCD (recomanded Ubuntu 9.04)
2. Open a terminal
3. Open the GRUB Command-line utility by typing

sudo grub

4. Find where Grub is. If this gives a few different answers then you will need to find the correct one, perhaps by trial-and-error.

find /boot/grub/stage1

5. Tell GRUB which partition to tell the MBR your Grub is on by entering

root (hdA,B)

6. The coordinates A,B are where 'A' is the hard-drive number, starting at 0, and 'B' is the partition number, starting at 0. For example, if Ubuntu was installed on the second partition of the first hard-drive, the command should be

root (hd0,1)

7. Tell GRUB which drive's MBR to fix

setup (hd0)

8. Replace 0 only in the extremely unlikely event that your bios does not use the first hard-drive as the boot device. Typically Ubuntu might be on any drive but the bios will almost always go to the first drive's MBR to find out where to find the boot-loader.
9. Leave the GRUB Command line

quit

10. And reboot.

If that method still dont work, you should try
Second Method

1. Insert the Ubuntu CD (for recomanded Ubuntu 9.04) select live CD
2. Once inside the desktop, open Terminal
3. Check the Linux root partition is where the command

sudo fdisk-l

4. Once the device is known Linux root partition, suppose I have a /dev/sda6 and then type

sudo mount-t ext4 /dev/sda6 /mnt/
sudo mount-t proc proc /mnt/proc/ 
sudo mount-t sysfs sys /mnt/sys/ 
sudo mount-o bind /dev/ /mnt/dev/ 
sudo chroot /mnt/bin/bash

5. Install Grub on MBR command

grub-install /dev/sda

6. Install grub on linux partition

grub-install /dev/sda7

7. after all is finished please restart.

Read More