Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include"topmenu.php";
- if(isset($_POST['submit'])) //Langkah #2 : Semak jika butang submit ditekan
- {
- //Langkah #3 : Mengambil data POST
- $nosiri=$_POST['nosiri'];
- $tujuan=$_POST['tujuan'];
- $tarikhpinjam = date("Y-m-d H:i:s");
- session_start();
- $nokp=$_SESSION["user"];
- //Langkah #4: Memanggil fail yang menghubungkan pangkalan data
- include("connect_db.php");
- //Langkah #5 : Masukkan data dalam Pangkalan Data
- if(mysqli_query($connect_db, "INSERT INTO peminjaman(nosiri, nokp, tarikhpinjam, tujuan) VALUES ('$nosiri', '$nokp', '$tarikhpinjam', '$tujuan')")){
- echo "<script>alert('Rekod Pinjaman Berjaya Disimpan'); window.location.href='menuUtama.php'; </script>";
- }
- else{
- echo "<script>alert('Rekod Pinjaman Gagal Disimpan'); window.history.back(); </script>";
- }
- }
- ?>
- <!--Langkah #1 : Binakan Borang (form) Pinjam Alatan -->
- <html>
- <style>
- body
- {
- background-color:teal;
- }
- h1
- {
- color:#FFD700;
- }
- </style>
- <head><title>SPABK</title></head>
- <body>
- <h1>Sistem Pinjaman Alatan Bengkel Kayu</h1>
- <h2>Peminjaman Alatan</h2>
- <form method="POST" action="pinjam.php">
- <p>Nama Alatan:
- <select name="nosiri">
- <option selected disabled value>Sila Pilih</option>
- <?php
- include("connect_db.php");
- $sqlselect=mysqli_query($connect_db, "SELECT * FROM alatan ORDER BY
- (nosiri) ASC");
- while($data=mysqli_fetch_array($sqlselect)){
- echo"<option value='".$data['nosiri']."'>
- ".$data['nosiri']." - ".$data['alatan']."</option>";
- }
- ?>
- </select>
- </p>
- <p>Tujuan : <textarea name="tujuan" cols="100" rows="10"> </textarea></p>
- <input type="submit" name="submit" value="Pinjam Alatan">
- </form>
- </body>
- </html>
- <!--Tamat Bina Borang -->
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement