Mengatasi Masalah eth0 tidak terdeteksi di Ubuntu 10.04

Pertama cek dulu

# ifconfig -a

dan ternyata eth0 nya ga ada, saudara Eris sedih dan Galau.. :(

Solusinya :

Gunakan Komputer atau Laptop yang terkoneksi INTERNET, kemudian buka link berikut

http://linuxwireless.org/download/compat-wireless-2.6/

dan download file compat-wireless misal download compat-wireless-2012-12-18

Kemudian lakukan perintah-perintah berikut :

Masuk ke direktori file tersebut contoh di Desktop

# cd Desktop/

# tar-xjvf compat-wireless-2012-12-18.tar.bz2

# cd compat-wireless-2012-12-18/

# scripts/driver-select atl1c

# make

# make install

# make unload

# make wlunload

# make btunload

# sudo modprobe atl1c

Selesai... kemudia restart ..

# reboot

  Hasilnya  :

Sub Query Sederhana untuk membuat Laporan MySQL

mysql> select * from pegawai;
+------+--------+
| nik  | nama   |
+------+--------+
| PEG1 | Pampam |
| PEG2 | Agnes  |
| PEG3 | Catur  |
+------+--------+

mysql> select * from produksi;
+-------------+------+---------+--------+
| id_produksi | nik  | barang  | jumlah |
+-------------+------+---------+--------+
|           1 | PEG1 | barang1 |      4 |
|           2 | PEG1 | barang1 |      7 |
|           3 | PEG1 | barang1 |      1 |
|           4 | PEG2 | barang1 |      3 |
|           5 | PEG2 | barang1 |      1 |
|           6 | PEG3 | barang1 |      9 |
|           7 | PEG3 | barang2 |      9 |
|           8 | PEG2 | barang2 |      1 |
|           9 | PEG1 | barang2 |      5 |
+-------------+------+---------+--------+
9 rows in set (0.00 sec)

Query berdasarkan nik pegawai: 

mysql> select nik as nik_pegawai,nama,(select sum(jumlah)  from produksi where nik=nik_pegawai) as jumlah_produksi from produksi inner join pegawai using (nik) group by nik;
+-------------+--------+-----------------+
| nik_pegawai | nama   | jumlah_produksi |
+-------------+--------+-----------------+
| PEG1        | Pampam |              17 |
| PEG2        | Agnes  |               5 |
| PEG3        | Catur  |              18 |
+-------------+--------+-----------------+
3 rows in set (0.01 sec)

Query berdasarkan nik dan barang: 

mysql> select nik as nik_pegawai,nama,barang as barang_produksi,(select sum(jumlah)  from produksi where nik=nik_pegawai and barang=barang_produksi) as jumlah_produksi from produksi inner join pegawai using (nik) group by nik,barang;
+-------------+--------+-----------------+-----------------+
| nik_pegawai | nama   | barang_produksi | jumlah_produksi |
+-------------+--------+-----------------+-----------------+
| PEG1        | Pampam | barang1         |              12 |
| PEG1        | Pampam | barang2         |               5 |
| PEG2        | Agnes  | barang1         |               4 |
| PEG2        | Agnes  | barang2         |               1 |
| PEG3        | Catur  | barang1         |               9 |
| PEG3        | Catur  | barang2         |               9 |
+-------------+--------+-----------------+-----------------+
6 rows in set (0.00 sec)

Tampilkan dalam bentuk file PHP :

<?php
$con=mysql_connect('localhost','abby','abby');
if(!mysql_select_db('abby',$con))
    {die("database salah");}

$nik='xxx';
echo"<table align='center' border='1'>
<tr>
<th>NIK</th>
<th>Nama Pegawai</th>
<th>Nama Barang</th>
<th>Jumlah Produksi</th>
</tr>";
$q=mysql_query("select nik as nik_pegawai,nama,barang as barang_produksi,(select sum(jumlah)  from produksi where nik=nik_pegawai and barang=barang_produksi) as jumlah_produksi from produksi inner join pegawai using (nik) group by nik,barang");
while($d=mysql_fetch_array($q))
{
if($nik!=$d[nik_pegawai])
{
$nik=$d['nik_pegawai'];
$nama=$d['nama'];
}
else
{
$nik='';
$nama='';
}

echo "<tr>
<td>$nik</td>
<td>$nama</td>
<td>$d[barang_produksi]</td>
<td>$d[jumlah_produksi]</td>
</tr>";

$nik=$d['nik_pegawai'];
$nama=$d['nama'];

}
echo"</table>";
?>

Hasil :

Mengatasi Permission Denied to Create Database postgreSQL

# ALTER USER namauser CREATEDB;

Monthpicker dengan jQuery

Download monthpicker Disini
Download jQuery UI Disini

Pengunaan :

CSS dan JS


 <link rel="stylesheet" href="js/jquery-ui.css" />
<script src="js/jquery-1.9.1.js"></script>
<script src="js/jquery-ui.js"></script>
<script src="js/jquery.mtz.monthpicker.js"></script>
<script>

$(function(){

 options = {
    pattern:'/01'+'yyyy/mm',   
    startYear: 2012, 
    monthNames: ['Januari', 'Februari', 'Maret', 'Aprl', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember']
};

   $('#bulan').monthpicker(options);


});
</script>

HTML

Pilih Bulan : <input data-start-year="2012" id="bulan" name="bulan" type="text" />





Demo : http://jsfiddle.net/abbyacakadud/TfSzM/1/
Detail : http://lucianocosta.info/jquery.mtz.monthpicker/

Keranjang Belanja Sederhana jQuery

HTML


<h3>Pilih Barang </h3>
<table border="1">
    <tr>
        <th>No.</th>
        <th>Nama Barang</th>
        <th>Harga</th>
        <th>Beli</th>
    </tr>
<tr>
    <td>1.</td>
    <td>Monitor</td>
    <td>Rp.500.000</td>
    <td><button id="beli" nama="Monitor" harga="500000">Beli</button></td>
</tr>
    <tr>
    <td>2.</td>
    <td>Printer</td>
    <td>Rp.800.000</td>
    <td><button id="beli" nama="Printer" harga="800000">Beli</button></td>
</tr>
    <tr>
        <td>3.</td>
        <td>Sandal</td>
        <td>Rp.10.000</td>
        <td><button id="beli" nama="Sandal" harga="100000">Beli</button></td>
    </tr>
</table>

<h3>Keranjang Belanja</h3>
    <div class="keranjang">
</div>

JS.

var i=0;

$("#beli").live("click", function(){

    var nama=$(this).attr('nama');

    var harga=$(this).attr('harga');

    var total=harga+harga;

    i++;

   $('.keranjang').append('<p>'+i+' | ' +nama+ ' | ' +harga +'<button class="rm">Batal</button></p>');

    

   return false;

});

$(".rm").live("click", function(){

    $(this).parents('p').remove();i--;

});

Demo : http://jsfiddle.net/abbyacakadud/bEvqJ/10//