<?php
include "../database/connection.php";
$my_connection = new connection();
$my_connection->connectdb('wisma', 'wisma');
$stmt = "UPDATE KAMAR SET KELAS='" . $_POST["kelas"] . "', HARGA=" . $_POST['harga'] . ", KAPASITAS=" . $_POST['kapasitas'] . " WHERE NO='" . $_POST['no_kamar'] . "'";
$test = $my_connection->select($stmt);
header("Location: ../tambah_kamar.php");
?>
/**
* Exemplos de uso para class connection
* @author Antonio Santos
* @version 0.1
*/
$db = new connection();
/**
* Exemplo de insert
*/
$fields_insert = array('field1' => 'first inserted field', 'field2' => 'second inserted field', 'field3' => 'third inserted field');
$result = $db->insert('table_name', $fields_insert, 'id');
/**
* Exemplo de select
*/
$result = $db->select('table_name', array('*'), array('id' => 1));
/**
* Exemplo de update
*/
$fields_update = array('field1' => 'first updated field', 'field2' => 'second updated field', 'field3' => 'third updated field');
$conditions = array('user' => 'tester');
$result = $db->update('table_name', $fields_update, $conditions, 'id');
/**
* Exemplo de delete
*/
$conditions = array('id' => 1);
$result = $db->delete('table_name', $conditions);
/**
* Exemplo de outras queries
*/
$result = $db->results_object('SELECT e.first_name, e.last_name, u.user_type, u.username FROM table_name AS e INNER JOIN second_table_name AS u ON e.id = u.employee_id');
<?php
include_once 'connection.php';
$conn = new connection();
$result = $conn->select();
?>
<html>
<head>
<title>CRUD</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.9/css/dataTables.bootstrap.min.css">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-12">
<div>
<p>This is for trial</p>
<a href="create.php" class="btn btn-info pull-right" role="button">Create new user</a>
</div>
<div>
<table class="table table-striped table-bordered" align="center">
<thead>
<tr>
<td>First Name</td>
<td>Last Name</td>
<td>Addres</td>
<td>Phone</td>
</div>
<div class="col-md-8">
<table class="table">
<thead>
<tr>
<th width="70px">No.</th>
<th width="200px">Nama Fasilitas</th>
<th width="20px;">Actions</th>
</tr>
</thead>
</table>
<div style="height: 480px;overflow: auto;">
<table class="table table-striped">
<tbody >
<?php
$stmt = $my_connection->select("SELECT * FROM FASILITAS ORDER BY ID_FASILITAS ");
while (($row = oci_fetch_array($stmt, OCI_BOTH)) != false) {
?>
<tr >
<td width="140px;"> <?php
echo $row["ID_FASILITAS"];
?>
</td >
<td width="400px;"> <?php
echo $row["FASILITAS"];
?>
</td >
<td width="10px;">
<form action="edit_kamar.php" method="post">
<button type="submit" class="btn btn-default" aria-label="Left Align" value="<?php
echo $row["ID_FASILITAS"];
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Kamar <i class="icon-angle-down"></i></a>
<ul class="dropdown-menu">
<li class="active"><a href="career.html">Input</a></li>
<li><a href="blog-item.html">Edit</a></li>
<li><a href="faq.html">Delete</a></li>
</ul>
</li>
<li><a href="blog.html">Blog</a></li>
<li><a href="contact-us.html">Contact</a></li>
</ul>
</div>
</div>
</header><!--/header-->
<?php
$stmt = $my_connection->select("SELECT * FROM KAMAR WHERE NO='" . $_POST['id_kamar'] . "'");
$row = oci_fetch_array($stmt, OCI_BOTH);
$stmt2 = $my_connection->select("SELECT * FROM KELAS WHERE ID_KELAS='" . $row['KELAS'] . "'");
$nama_kelas = oci_fetch_array($stmt2);
$stmt3 = $my_connection->select("\n SELECT f.FASILITAS\n FROM FASILITAS f,\n (SELECT ID_FASILITAS FROM TERDAPAT_FASILITAS WHERE ID_KELAS='" . $row['KELAS'] . "') t\n WHERE f.ID_FASILITAS=t.ID_FASILITAS\n ");
?>
<div class="container" >
<div class="row">
<div class="col-lg-3" style="background-color:white;min-height: 320px;">
<h2>Data Kamar</h2>
<br>
<label style="font-size: 16px;">Nomor Kamar :</label>
<p><?php
echo $row["NO"];
</div>
</div>
</header><!--/header-->
<div class="container" >
<h2>Input</h2>
<div class="row">
<div class="col-lg-4">
<form action="submit_kamar.php" method="post">
<div class="form-group">
<label>Nomor kamar</label>
<input type="text" class="form-control" name="no_kamar" value="<?php
if (isset($_POST['wisma_select'])) {
$stmt = $my_connection->select("SELECT COUNT(NO) FROM KAMAR WHERE ID_WISMA='" . $_POST['wisma_select'] . "'");
$row = oci_fetch_array($stmt);
if ($_POST['wisma_select'] == 'W001') {
$prefix = 'F';
} else {
if ($_POST['wisma_select'] == 'W002') {
$prefix = 'J';
} else {
if ($_POST['wisma_select'] == 'W003') {
$prefix = 'B';
}
}
}
echo $prefix;
printf("%03d", $row["COUNT(NO)"] + 1);
}
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php
require "db.php";
echo "Launching missile : {$_GET['missile']}<br>";
echo "Latitude locked : {$_GET['lat']}<br>";
echo "Longitude locked : {$_GET['lnt']}<br>";
$conn = new connection("localhost", "root", "f0nXsBgB", "nuclear");
$conn->insert("nuclear", ["lat", "lng", "type"], [$_GET["lat"], $_GET["lnt"], $_GET["missile"]]);
$data = $conn->shift($conn->select("nuclear", ["*"]));
foreach ($data as $row) {
foreach ($row as $d) {
echo "{$d}<br>";
}
echo "<br>";
}
?>
</body>
</html>
