Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(0);
- //jlh data di produk
- function Cek_CountData($mysqli)
- {
- $query_string = "SELECT count(k1) as jlh FROM produk";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $jlh = $row['jlh'];
- return $jlh;
- }
- //function insert data ke Produk
- function Insert_Produk($mysqli, $name, $harga, $resolusi1, $resolusi2, $sensor1, $sensor2, $iso, $speed, $tgl, $SSM, $deskripsi, $kategori, $gambar){
- $query_string = "INSERT INTO `produk`( `nama_produk`, `harga_produk`, `r1`, `r2`, `s1`, `s2`, `iso`, `ssm`, `valueSSM`, `tgl_release`, `deskripsi`, `kategori`, `gambar`) VALUES ('$name','$harga','$resolusi1','$resolusi2','$sensor1','$sensor2','$iso','$speed','$SSM', '$tgl', '$deskripsi','$kategori','$gambar')";
- $result = $mysqli->query($query_string);
- return $result;
- }
- //Tampilkan Semua Nilai r1*r2
- function Cek_NilaiResolusi($mysqli, $hrg_Terbesar)
- {
- $query_string = "select `id_produk`, `nama_produk`, (r1*r2), ( select find_in_set((r1*r2), ( select group_concat(distinct (r1*r2) order by (r1*r2) DESC separator ',') from produk)) ) as rangking from produk where harga_produk between 0 and '$hrg_Terbesar'";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Tampilkan Semua Nilai s1*s2
- function Cek_NilaiSensor($mysqli, $hrg_Terbesar)
- {
- $query_string = "select `id_produk`, `nama_produk`, (s1*s2), ( select find_in_set((s1*s2), ( select group_concat(distinct (s1*s2) order by (s1*s2) DESC separator ',') from produk)) ) as rangking from produk where harga_produk between 0 and '$hrg_Terbesar'";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Tampilkan Semua Nilai ISO
- function Cek_NilaiISO($mysqli, $hrg_Terbesar)
- {
- $query_string = "select `id_produk`, `nama_produk`, iso, ( select find_in_set(iso, ( select group_concat(distinct (iso) order by (iso) DESC separator ',') from produk)) ) as rangking from produk where harga_produk between 0 and '$hrg_Terbesar'";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Tampilkan Semua Nilai ISO
- function Cek_NilaiSSM($mysqli, $hrg_Terbesar)
- {
- $query_string = "select `id_produk`, `nama_produk`, valueSSM, ( select find_in_set((valueSSM), ( select group_concat(distinct (valueSSM) order by (valueSSM) ASC separator ',') from produk)) ) as rangking from produk where harga_produk between 0 and '$hrg_Terbesar'";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Cek Nilai terbesar pada kolom K1
- function Cek_MaxK1($mysqli, $harga)
- {
- $query_string = "SELECT max(r1*r2) as jlh FROM `produk` where `harga_produk` between '0' and '$harga' ";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $terbesarK1 = $row['jlh'];
- return $terbesarK1;
- }
- //Cek Nilai terbesar pada kolom K2
- function Cek_MaxK2($mysqli, $harga)
- {
- $query_string = "SELECT DISTINCT max(s1*s2) as terbesark2 FROM `produk` where `harga_produk` between '0' and '$harga'";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $terbesark2 = $row['terbesark2'];
- return $terbesark2;
- }
- //Cek Nilai terbesar pada kolom K3
- function Cek_MaxK3($mysqli, $harga)
- {
- $query_string = "SELECT DISTINCT max(iso) as terbesarK3 FROM produk where `harga_produk` between '0' and '$harga'";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $terbesarK3 = $row['terbesarK3'];
- return $terbesarK3;
- }
- //Cek Nilai terbesar pada kolom K4
- function Cek_MinK4($mysqli, $harga)
- {
- $query_string = "SELECT DISTINCT min(valueSSM) as terbesarK4 FROM produk where `harga_produk` between '0' and '$harga'";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $terbesarK4 = $row['terbesarK4'];
- return $terbesarK4;
- }
- //cek harga terbesar
- function Hrg_Terbesar($mysqli)
- {
- $query_string = "SELECT DISTINCT max(harga_produk) as big FROM produk";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $big = $row['big'];
- return $big;
- }
- //cek harga berdasarkan pilihan user
- function Cek_HrgUser($mysqli, $hrg)
- {
- $query_string = "SELECT * FROM `produk` WHERE `harga_produk` between '0' and '$hrg'";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- function Tampil_HasilRekomendasi($mysqli, $hrg)
- {
- $query_string = "SELECT * FROM `produk` WHERE `harga_produk` between '0' and '$hrg' LIMIT 0, 20";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Tampil Produk
- function Tampil_Produk($mysqli){
- $query_string = "SELECT * from produk";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- function Tampil_Produk8($mysqli){
- $query_string = "SELECT * FROM `produk` order by id_produk DESC LIMIT 0,8";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- function Tampil_ProdukMore($mysqli, $more){
- $query_string = "SELECT * FROM produk WHERE id_produk < $more ORDER BY id_produk DESC LIMIT 0,8";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- function TampilProdukById($mysqli,$id){
- $query_string = "SELECT * from produk where id_produk='$id'";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $nama_produk = $row['nama_produk'];
- return $nama_produk;
- }
- //Tampil Edit Produk
- function Tampil_EditProduk($mysqli, $id){
- $query_string = "SELECT * from produk where id_produk='$id'";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Ambil Gambar
- function Tampil_GambarSlide1($mysqli){
- $query_string = "SELECT * from produk order by `id_produk` DESC LIMIT 1";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $nama_produk = $row['gambar'];
- return $nama_produk;
- }
- function Tampil_GambarSlide2($mysqli){
- $query_string = "SELECT * from produk order by `id_produk` DESC LIMIT 1,1";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $nama_produk = $row['gambar'];
- return $nama_produk;
- }
- function Tampil_GambarSlide3($mysqli){
- $query_string = "SELECT * from produk order by `id_produk` DESC LIMIT 2,1";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $nama_produk = $row['gambar'];
- return $nama_produk;
- }
- //Update Produk
- function Update_Produk($mysqli, $nama, $harga, $r1, $r2, $s1, $s2, $iso, $speed, $SSM, $tgl, $kategori, $deskripsi, $id){
- $query_string = "UPDATE `produk` SET `nama_produk`='$nama',`harga_produk`='$harga',`r1`='$r1',`r2`='$r2',`s1`='$s1',`s2`='$s2',`iso`='$iso',`ssm`='$speed', `valueSSM`='$SSM', `tgl_release`='$tgl',`deskripsi`='$deskripsi',`kategori`='$kategori' WHERE id_produk='$id'";
- $result = $mysqli->query($query_string);
- return $result;
- }
- function Update_ProdukWithGambar($mysqli, $nama, $harga, $r1, $r2, $s1, $s2, $iso, $speed, $SSM, $tgl, $kategori, $deskripsi, $id, $gambar){
- $query_string = "UPDATE `produk` SET `nama_produk`='$nama',`harga_produk`='$harga',`r1`='$r1',`r2`='$r2',`s1`='$s1',`s2`='$s2',`iso`='$iso',`ssm`='$speed', `valueSSM`='$SSM', `tgl_release`='$tgl',`deskripsi`='$deskripsi',`kategori`='$kategori', `gambar`='$gambar' WHERE id_produk='$id'";
- $result = $mysqli->query($query_string);
- return $result;
- }
- //Tampil Produk hasil rekomendais
- function Tampil_ProdukRekomendasi($mysqli, $nama){
- $query_string = "SELECT * from produk where nama_produk='$nama'";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Tampil Kategori Sony
- function Tampil_ProdukSony($mysqli){
- $query_string = "SELECT * from produk where kategori='3' order by tgl_release desc";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Tampil Kategori Canon
- function Tampil_ProdukCanon($mysqli){
- $query_string = "SELECT * from produk where kategori = '4' order by tgl_release desc";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Tampi Kategori Nikon
- function Tampil_ProdukNikon($mysqli){
- $query_string = "SELECT * from produk where kategori='2' order by tgl_release desc";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Tampi Produk Lainya
- function Tampil_ProdukLain($mysqli, $id){
- $query_string = "SELECT * from produk WHERE `id_produk` <> '$id'";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Nama Kategori
- function Nama_Kategori($mysqli){
- //$id_view =mysqli_real_escape_string($mysqli,$id_view);
- $query_string = "SELECT * FROM kategori";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Tampil Profil
- function Profil($mysqli, $user){
- $query_string = "SELECT * FROM admin where username='$user'";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- //Update Profil
- function UpdateProfil($mysqli,$nama,$username,$alamat,$email,$user){
- $query_string = "UPDATE `admin` SET `username`='$username', `email`='$email',`nama_lengkap`='$nama',`alamat`='$alamat' WHERE username='$user'";
- $result = $mysqli->query($query_string);
- return $result;
- }
- function CekPassword($mysqli, $user){
- $user =mysqli_real_escape_string($mysqli,$user);
- $query_string = "SELECT * FROM admin WHERE username='$user'";
- $result = $mysqli->query($query_string);
- $row = $result->fetch_assoc();
- $password = $row['password'];
- return $password;
- }
- function UpdatePassword($mysqli, $password, $user){
- $query_string = "UPDATE `admin` SET password='$password' WHERE username='$user'";
- $result = $mysqli->query($query_string);
- return $result;
- }
- //Delete produk
- function DeleteProduk($mysqli, $id){
- $query_string = "delete from produk WHERE id_produk='$id'";
- $result = $mysqli->query($query_string);
- return $result;
- }
- //Simpan Hasil MAE
- function SimpanMae($mysqli, $mae, $akurasi){
- $query_string = "INSERT INTO `hasil_pengujian`( `mae`, `akurasi`) VALUES ('$mae','$akurasi')";
- $result = $mysqli->query($query_string);
- return $result;
- }
- //Ambil Semua data hasil pengujian
- function GetHasilPengujian($mysqli){
- $query_string = "SELECT * from hasil_pengujian";
- $result = $mysqli->query($query_string);
- while($row = mysqli_fetch_array($result))
- $data[]= $row;
- return $data;
- }
- function generateRandomString($length = 6) {
- return substr(str_shuffle("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"), 0, $length);
- }
- //mendapatkan data yang dipilih user
- function GetDataKriteria($data){
- if($data == 0){
- $Tampil = 'Data Belum Dipilih';
- }elseif($data == 1){
- $Tampil = 'Kurang Penting';
- }elseif($data == 3){
- $Tampil = 'Sedikit Penting';
- }elseif($data==5){
- $Tampil='Cukup Penting';
- }elseif($data==7){
- $Tampil='Lebih Penting';
- }elseif($data==9){
- $Tampil='Mutlak Lebih Penting';
- }else{
- $Tampil = 'Belum Dipilih';
- }
- return $Tampil;
- }
- function ubahTgl($tanggal){
- $pisah = explode('/',$tanggal);
- $larik = array($pisah[2],$pisah[0],$pisah[1]);
- $satukan = implode($larik);
- return $satukan;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement