CatatanKu

Tuesday, October 8, 2019

logika algo: deret hitung suku ke n

#include <conio.h>

#include <iostream>

#include <stdio>

main(){

int n=6,i,bil;

for(i=1;i<=n;i++)

{

bil=i*2-1;

printf("%d ",bil);

}

getch();

}

hslnya: 1 3 5 7 9 11

=======================================================

#include <conio.h>

#include <iostream>

#include <stdio>

main(){

int n=6,i,bil;

for(i=1;i<=n;i++)

{

bil=(i*i)+1;

printf("%d ",bil);

}

getch();

}

hslnya: 2 5 10 17 26 37

===================================================

#include <conio.h>

#include <iostream>

#include <stdio>

main(){

int b,n=8,i,bil;

for(i=1;i<=n;i++)

{

bil=i;

b=bil%2;

if(b==0)

{printf("%d ",bil);}

else

{printf("%d- ",bil);}

}

getch();

}

hslnya: 1-2 3-4 5-6 7-8

Wednesday, September 25, 2019

contoh bahasa database relasional

11. π ID,NAMA,MANAJER(PEKERJA)

SELECT ID,NAMA,MANAJER FROM PEKERJA

22. π DEPT, MANAJER(DIVISI)

SELECT DEPT,MANAJER FROM DIVISI

5. π ID,NAMA(PEKERJA)

SELECT ID,NAMA FROM PEKERJA

6. π NOBARANG,NAMA(PRODUK)

SELECT NOBARANG,NAMA FROM PRODUK

7. π NOBARANG,banyaknya(σDEPT.=’23’ (TRANSAKSI))

SELECT NOBARANG, banyaknya FROM TRANSAKSI

WHERE DEPT.=’23’

8. π NOBARANG,banyaknya(σ banyaknya > ’50’ (TRANSAKSI))

SELECT NOBARANG, banyaknya FROM TRANSAKSI

WHERE banyaknya > ’50’

Friday, September 20, 2019

google dork

http://gakenakcuy.blogspot.com/2013/02/tutorial-google-dork.html

Tuesday, March 19, 2019

<html>
<!DOCTYPE html>
<head>
<title></title>
</head>
<body>
<style type="text/css">
.table-data{
   width: 100%;
   border-collapse: collapse;
}

.table-data tr th,
.table-data tr td{
   border:1px solid black;
   font-size: 10pt;
}
</style>

<h3>Laporan Data Buku Perputakaan Online</h3>
<br/>
<table class="table-data">
<thead>
   <tr>
    <th>No</th>
    <th>Judul Buku</th>
    <th>Pengarang</th>
    <th>Tahun Terbit</th>
    <th>Penerbit</th>
    <th>ISBN</th>
    <th>Jumlah Buku</th>
    <th>Lokalisasi</th>
   </tr>
</thead>
<tbody>
   <?php
   $no = 1;
   foreach($buku as $b){
   ?>
   <tr>
     <td><?php echo $no++; ?></td>
     <td><?php echo $b->judul_buku; ?></td>
     <td><?php echo $b->pengarang; ?></td>
     <td><?php echo $b->thn_terbit; ?></td>
     <td><?php echo $b->penerbit; ?></td>
     <td><?php echo $b->isbn; ?></td>
     <td><?php echo $b->jumlah_buku; ?></td>
     <td><?php echo $b->lokasi; ?></td>
   </tr>
   <?php
}
?>
</tbody>
</table>
</body>
</html>

laporan_print_buku.php

<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<style type="text/css">
.table-data{
   width: 100%;
   border-collapse: collapse;
}

.table-data tr th,
.table-data tr td{
   border:1px solid black;
   font-size: 10pt;
}
</style>

<h3>Laporan Data Buku Perputakaan Online</h3>
<br/>
<table class="table-data">
<thead>
   <tr>
    <th>No</th>
    <th>Gambar</th>
    <th>Judul Buku</th>
    <th>Pengarang</th>
    <th>Tahun Terbit</th>
    <th>Penerbit</th>
    <th>ISBN</th>
    <th>Jumlah Buku</th>
    <th>Lokasi</th>
   </tr>
</thead>
<tbody>
   <?php
   $no = 1;
   foreach($buku as $b){
   ?>
   <tr>
     <td><?php echo $no++; ?></td>
     <td><img src="<?php echo base_url().'/assets/upload/'.$b->gambar; ?>"
       width="80" height="80" alt="gambar tidak ada"></td>
     <td><?php echo $b->judul_buku; ?></td>
     <td><?php echo $b->pengarang; ?></td>
     <td><?php echo $b->thn_terbit; ?></td>
     <td><?php echo $b->penerbit; ?></td>
     <td><?php echo $b->isbn; ?></td>
     <td><?php echo $b->jumlah_buku; ?></td>
     <td><?php echo $b->lokasi; ?></td>
   </tr>
   <?php
}
?>
</tbody>
</table>

<script type="text/javascript">
window.print();
</script>

</body>
</html>

dari view(header.php) ke controller(admin.php) balik lg ke view(laporan.php)

tambahkan skrip ini di file admin.php seblm tutup kurawal paling bawah.

function cetak_laporan_buku(){
          $data['buku'] = $this->M_perpus->get_data('buku')->result();
          $this->load->view('admin/header');
          $this->load->view('admin/laporan_buku', $data);
          $this->load->view('admin/footer');
        }

        function laporan_print_buku(){
          $data['buku'] = $this->M_perpus->get_data('buku')->result();
          $this->load->view('admin/laporan_print_buku',$data);
        }

        function laporan_pdf_buku(){
          $this->load->library('dompdf_gen');

          $data['buku'] = $this->M_perpus->get_data('buku')->result();

          $this->load->view('admin/laporan_pdf_buku', $data);

         $paper_size = 'A4'; // ukuran kertas
         $orientation = 'landscape'; //tipe format kertas potrait atau landscape
         $html = $this->output->get_output();

         $this->dompdf->set_paper($paper_size, $orientation);
         //Convert to PDF
         $this->dompdf->load_html($html);
         $this->dompdf->render();
         $this->dompdf->stream("laporan_data_buku.pdf", array('Attachment'=>0));
         // nama file pdf yang di hasilkan
        }

        Function cetak_laporan_anggota(){
          $data['anggota'] = $this->M_perpus->get_data('anggota')->result();
          $this->load->view('admin/header');
          $this->load->view('admin/laporan_anggota', $data);
          $this->load->view('admin/footer');
        }

        function laporan_print_anggota(){
          $data['anggota'] = $this->M_perpus->get_data('anggota')->result();
          $this->load->view('admin/laporan_print_anggota',$data);
        }

        function laporan_pdf_anggota(){
          $this->load->library('dompdf_gen');

          $data['anggota'] = $this->M_perpus->get_data('anggota')->result();

          $this->load->view('admin/laporan_pdf_anggota', $data);

         $paper_size = 'A4'; // ukuran kertas
         $orientation = 'landscape'; //tipe format kertas potrait atau landscape
         $html = $this->output->get_output();

         $this->dompdf->set_paper($paper_size, $orientation);
         //Convert to PDF
         $this->dompdf->load_html($html);
         $this->dompdf->render();
         $this->dompdf->stream("laporan_data_anggota.pdf", array('Attachment'=>0));
         // nama file pdf yang di hasilkan
        }

        function laporan_transaksi(){
          $dari = $this->input->post('dari');
          $sampai = $this->input->post('sampai');
          $this->form_validation->set_rules('dari','Dari Tanggal','required');
          $this->form_validation->set_rules('sampai','Sampai Tanggal','required');

          if($this->form_validation->run() != false){

          $data['laporan'] = $this->db->query("select * from peminjaman p,detail_pinjam d,
          buku b,anggota a where d.id_buku=b.id_buku and p.id_anggota=a.id_anggota
          and p.id_pinjam=d.id_pinjam and date(tanggal_input) >= '$dari'")->result();

          $this->load->view('admin/header');
          $this->load->view('admin/laporan_filter_transaksi',$data);
          $this->load->view('admin/footer');
        }else{
          $this->load->view('admin/header');
          $this->load->view('admin/laporan_transaksi');
          $this->load->view('admin/footer');
        }
        }

        function laporan_print_transaksi(){
          $dari = $this->input->get('dari');
          $sampai = $this->input->get('sampai');

          if($dari != "" && $sampai != ""){
            $data['laporan'] = $this->db->query("select * from peminjaman p,detail_pinjam d,buku b,anggota a where d.id_buku=b.id_buku and p.id_anggota=a.id_anggota and p.id_pinjam=d.id_pinjam and date(tanggal_input) >= '$dari'")->result();
            $this->load->view('admin/laporan_print_transaksi',$data);
          }else{
            redirect("admin/laporan_transaksi");
          }
        }

        function laporan_pdf_transaksi(){
          $this->load->library('dompdf_gen');
          $dari = $this->input->get('dari');
          $sampai = $this->input->get('sampai');

          $data['laporan'] = $this->db->query("select * from peminjaman p,detail_pinjam d,buku b,anggota a
          where d.id_buku=b.id_buku and p.id_anggota=a.id_anggota and p.id_pinjam=d.id_pinjam and date(tanggal_input)
          >= '$dari'")->result();

         $this->load->view('admin/laporan_pdf_transaksi', $data);

         $paper_size = 'A4'; // ukuran kertas
         $orientation = 'landscape'; //tipe format kertas potrait atau landscape
         $html = $this->output->get_output();

         $this->dompdf->set_paper($paper_size, $orientation);
         //Convert to PDF
         $this->dompdf->load_html($html);
         $this->dompdf->render();
         $this->dompdf->stream("laporan_data_transaksi.pdf", array('Attachment'=>0));
        }

laporan_buku.php

<div class="page-header">
<h3>Cetak Data Buku</h3>
</div>
<a class="btn btn-default btn-md" href="<?php echo base_url().'admin/laporan_print_buku' ?>">
<span class="glyphicon glyphicon-print"></span>
Print</a>
<a class="btn btn-warning btn-md" href="<?php echo base_url().'admin/laporan_pdf_buku' ?>">
<span class="glyphicon glyphicon-print"></span>
Cetak PDF</a>
<br><br>
<div class="table-responsive">
<table class="table table-bordered table-striped table-hover">
    <thead>
      <tr>
        <th>No</th>

        <th>Judul Buku</th>
        <th>Pengarang</th>
        <th>Penerbit</th>
        <th>Tahun Terbit</th>
        <th>ISBN</th>
        <th>Lokasi</th>
      </tr>
    </thead>
    <tbody>
      <?php
      $no = 1;
      foreach ($buku as $b) {
      ?>
      <tr>
        <td><?php echo $no++; ?></td>

        <td><?php echo $b->judul_buku ?></td>
        <td><?php echo $b->pengarang ?></td>
        <td><?php echo $b->penerbit ?></td>
        <td><?php echo $b->thn_terbit ?></td>
        <td><?php echo $b->isbn ?></td>
        <td><?php echo $b->lokasi ?></td>
      </tr>
    <?php } ?>
</tbody>
</table>
</div>

Monday, March 18, 2019

TAMBAH SUB MENU LAPORAN

file header.php

   <li class="dropdown"><a href="<?php echo base_url().'#'; ?>" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true"   ariaexpanded="false"> <span class="glyphicon glyphicon-list-alt"></span>Laporan<span class="caret"></span></a>

           <ul class="dropdown-menu">
              <li><a href="<?php echo base_url().'admin/cetak_laporan_buku' ?>">
                <i class="glyphicon glyphicon-lock"></i>Laporan Data Buku</a></li>
              <li><a href="<?php echo base_url().'admin/cetak_laporan_anggota' ?>">
                <i class="glyphicon glyphicon-lock"></i>Laporan Data Anggota</a></li>
              <li><a href="<?php echo base_url().'admin/laporan_transaksi' ?>">
                <i class="glyphicon glyphicon-lock"></i>Laporan Data Transaksi</a></li>
            </ul>
         </li>

Monday, March 11, 2019

Codeigniter: METODE MVC

Framework Codeigniter dengan metode MVC(MODEL, VIEW, CONTROLLER)

Tuesday, November 27, 2018

c# db access save,hapus,cari

namespace nilaiPrj

{

public partial class Form1 : Form

{

OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\syamsul\akhir.accdb");

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

con.Open();

string sql = "SELECT * FROM nilai";

OleDbDataAdapter da = new OleDbDataAdapter(sql, con);

DataSet ds = new DataSet();

da.Fill(ds,"nilai");

grid1.DataSource = ds.Tables["nilai"].DefaultView;

}

private void bsimpan_Click(object sender, EventArgs e)

{

string sql = string.Format("insert into nilai values('{0}','{1}','{2}')", textBox1.Text, textBox2.Text, textBox3.Text);

OleDbCommand cmd = new OleDbCommand(sql, con);

cmd.ExecuteNonQuery();

MessageBox.Show("Data berhasil disimpan");

cmd.Dispose();

        string tampil = "SELECT * FROM nilai";
            OleDbDataAdapter da = new OleDbDataAdapter(tampil, con);
            DataSet ds = new DataSet();
            da.Fill(ds, "nilai");
            grid1.DataSource = ds.Tables["nilai"].DefaultView;
            grid1.Refresh();

}

private void bcari_Click(object sender, EventArgs e)

{

OleDbDataReader dt = null;

string sql = string.Format("select * from nilai where nim = '{0}'", textBox1.Text);

OleDbCommand cmd = new OleDbCommand(sql, con);

dt = cmd.ExecuteReader();

if (dt.Read())

{

textBox2.Text = Convert.ToString(dt["nilaiuts"]);

textBox3.Text = Convert.ToString(dt["nilaiuas"]);

}

else

{ MessageBox.Show("dt td ada"); }

}

private void bhapus_Click(object sender, EventArgs e)

{

string sql = string.Format("delete * from nilai where nim='" + textBox1.Text + "'");

OleDbCommand cmd = new OleDbCommand(sql, con);

cmd.ExecuteNonQuery();

con.Close();

MessageBox.Show("Data Telah Dihapus");

}

private void bupdate_Click(object sender, EventArgs e)

{

string sql = string.Format("update nilai set nama=@name where nim=@nim",con);

//con.Open();

OleDbCommand cmd = new OleDbCommand(sql, con);

cmd.Parameters.AddWithValue("@name", textBox2.Text);

cmd.ExecuteNonQuery();

MessageBox.Show("Data berhasil diupdate");

cmd.Dispose();

}

CatatanKu

Tuesday, October 8, 2019

logika algo: deret hitung suku ke n

Percabangan/Branching

Wednesday, September 25, 2019

contoh bahasa database relasional

Friday, September 20, 2019

google dork

Tuesday, March 19, 2019

laporan_pdf_buku.php

laporan_print_buku.php

dari view(header.php) ke controller(admin.php) balik lg ke view(laporan.php)

laporan_buku.php

Monday, March 18, 2019

TAMBAH SUB MENU LAPORAN

Monday, March 11, 2019

Codeigniter: METODE MVC

Tuesday, November 27, 2018

c# db access save,hapus,cari

logika algo: deret hitung suku ke n