Langsung ke konten utama

Tambah Data PHP Mysql

1. input _siswa.php

 <form name="form1" method="POST" action="simpan_siswa.php">
  <table width="400" border="0" align="center" cellpadding="1" cellspacing="1"
    bordercolor="#00FF00" bgcolor="#33CC00">
    <tr bgcolor="#CCFFCC">
      <td height="50" colspan="2"><div align="center">INPUT DATA SISWA </div></td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td height="40">Nis </td>
      <td>:
      <input name="nis" type="text" id="nis"></td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td height="40">Nama </td>
      <td>:
      <input name="nama" type="text" id="nama"></td>
    </tr>

    <tr bgcolor="#FFFFFF">
      <td>&nbsp;</td>
      <td height="50"><input type="submit" name="Submit" value="Simpan"></td>
    </tr>
  </table>
</form>


2. Simpan_siswa.php



<?php
include ("koneksi.php");

        $nis=$_POST['nis'];
        $nama=$_POST['nama'];
        
$simpan="insert into siswa values('$nis','$nama')";

mysql_query($simpan);

 echo "data berhasil disimpan ";
 include ("tampil_siswa.php");
 echo "<br>";
 echo "<a href=input_siswa.php>back</a>";
?>

Komentar

Postingan populer dari blog ini

BELAJAR RPL 2018/2019

PAKET 1 III.         SOAL/TUGAS 1.         Judul Tugas             : Aplikasi Kasir Restoran ( Table Service ) 2.         Langkah Kerja: a.          Lakukan Instalasi dan Pengaturan Software Tools Pemrograman b.          Interpretasikan Spesifikasi Program yang diberikan                                                 i.           Aplikasi berbasis sistem client-server               ...

Membuat Multimedia HTML - Youtube

Listing program html index.html <!DOCTYPE html> <html> <head> <title>Multimedia HTML</title> </head> <body> <table border="0" bgcolor=pink > <tr> <td colspan="2" height="50" width="600" bgcolor=pink> <img src="../media/image/cover.jpg" width="800" height="50"></td> </tr> <td width="600" align="center" bgcolor=black> <video width="320" height="240" controls> <source src="https://www.youtube.com/watch?v=sNY7aPVzgVU&list=RDsNY7aPVzgVU&start_radio=1" type="video/mp4"> </video> <audio controls> <source src="../media/audio/masiv.mp3" type="audio/mpeg"> </audio> </td> <td> <table border="0"> ...

Edit dan Hapus Data PHP MYSQL

EDIT / UPDATE DATA 1. Coding edit_siswa.php   <form name="form1" method="post" action="update_siswa.php">        <table width="400" border="0" align="center" cellpadding="1" cellspacing="1"     bordercolor="#FFFF99" bgcolor="#FF0000">          <tr bgcolor="#FFFFCC">            <td height="50" colspan="2"><div align="center">EDIT DATA</div></td>          </tr>          <?php            include ("koneksi.php");                $sqlTampil="select * from siswa Where nis='$_GET[nis]'";            $qryTampil=mysql_query($sqlTampil);            $dataTampil=mysql_fetch_array($qryTampil);          ?>        ...