Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(!defined('S')) {
- header("Location: dash.php");
- }
- ?>
- <?php
- if (isset($_GET['id'])) {
- $id=$_GET['id'];
- // $sql = $conn->query("SELECT * FROM penyakits WHERE kode_penyakit='$id'");
- $sql = $conn->query("SELECT r.kode_pengetahuan, r.kode_gejala, p.kode_penyakit, g.nama_gejala, p.nama_penyakit, p.deskripsi, p.pengobatan, p.pencegahan, p.catatan, p.gambar FROM pengetahuans r INNER JOIN penyakits p ON p.kode_penyakit=r.kode_penyakit INNER JOIN gejalas g ON g.kode_gejala=r.kode_gejala WHERE r.kode_penyakit='$id'");
- $array = array();
- $row = $sql->fetch_assoc();
- if ($row['kode_penyakit'] == null) {
- echo "<script>window.location='?halaman=404';</script>";
- } else {
- ?>
- <div class="main_container">
- <div class="row page-titles mx-0">
- <div class="col-sm-6 p-md-0">
- <div class="welcome-text">
- <h4 class="text-primary">Data Penyakit</h4>
- </div>
- </div>
- <div class="col-sm-6 p-md-0 justify-content-sm-end mt-2 mt-sm-0 d-flex">
- <ol class="breadcrumb">
- <li class="breadcrumb-item"><a href="javascipt:void(0);">Beranda</a></li>
- <li class="breadcrumb-item active"><a href="javascipt:void(0);">Data Penyakit</a></li>
- </ol>
- </div>
- </div>
- <div class="row">
- <div class="col-lg-12">
- <div class="card">
- <div class="card-body">
- <div class="d-flex justify-content-between doctor-info-details">
- <div class="d-flex left-content">
- <div class="media align-self-start">
- <img alt="image" class="rounded-circle shadow" width="90" src="assets/images/penyakits/<?php echo $row['gambar']; ?>">
- </div>
- <div class="media-body">
- <h2 class="mb-2"><?= $row['nama_penyakit']; ?></h2>
- <?php
- // $GEJALA = array();
- // $PENYAKIT = array();
- // foreach($array as $row){
- // $GEJALA[$row->kode_gejala] = $row->nama_gejala;
- // $PENYAKIT[$row->kode_penyakit] = $row;
- // }
- // $array[] = $row;
- $penyakit_array = array();
- while($row = mysqli_fetch_array($sql)){ // cycle through each record returned
- $penyakit_array[] = "\"".$row['nama_penyakit']."\""; // get the username field and add to the array above with surrounding quotes
- }
- $penyakit_string = implode(",", $penyakit_array);
- // foreach ($array as $key => $item) {
- // $arr[$item['kode_penyakit']][$key] = $item;
- // }
- ?>
- <!-- <p class="mb-md-2 mb-sm-4 mb-2">Endocrinologist</p> -->
- <p class="mb-md-2 mb-sm-4 mb-2"><?= print_r($penyakit_string); ?></p>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- <div class="row">
- <div class="col-lg-12">
- <div class="doctor-info-content">
- <ul class="nav nav-tabs" id="myTab" role="tablist">
- <li class="nav-item col-md-4" role="presentation">
- <button class="nav-link active" id="home-tab" data-bs-toggle="tab" data-bs-target="#home" type="button" role="tab" aria-controls="home" aria-selected="true">
- Deskripsi
- </button>
- </li>
- <li class="nav-item col-md-4" role="presentation">
- <button class="nav-link" id="profile-tab" data-bs-toggle="tab" data-bs-target="#profile" type="button" role="tab" aria-controls="profile" aria-selected="false">
- Pengobatan dan Pencegahan
- </button>
- </li>
- <li class="nav-item col-md-4" role="presentation">
- <button class="nav-link" id="contact-tab" data-bs-toggle="tab" data-bs-target="#contact" type="button" role="tab" aria-controls="contact" aria-selected="false">Catatan</button>
- </li>
- </ul>
- <div class="tab-content" id="myTabContent">
- <div class="tab-pane active" id="home" role="tabpanel" aria-labelledby="home-tab">
- <div class="card m-t-30">
- <div class="card-body">
- <?= $row['deskripsi']; ?>
- </div>
- </div>
- </div>
- <div class="tab-pane fade" id="profile" role="tabpanel" aria-labelledby="profile-tab">
- <div class="row m-t-30 m-l-0 m-r-0">
- <div class="card">
- <div class="card-header">
- <h4 class="card-title">Pengobatan</h4>
- </div>
- <div class="card-body">
- <div class="basic-form">
- <p><?= $row['pengobatan']; ?></p>
- </div>
- </div>
- </div>
- <div class="card">
- <div class="card-header">
- <h4 class="card-title">Pencegahan</h4>
- </div>
- <div class="card-body">
- <div class="basic-form">
- <p><?= $row['pencegahan']; ?></p>
- </div>
- </div>
- </div>
- </div>
- </div>
- <div class="tab-pane fade" id="contact" role="tabpanel" aria-labelledby="contact-tab">
- <div class="card m-t-30">
- <div class="card-body">
- <p><?= $row['catatan']; ?></p>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- <?php
- }
- }
- ?>
Add Comment
Please, Sign In to add comment