Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $link=mysqli_connect("mysql.idhostinger.com","u377281409_root","qwerty");
- //include_once 'dbconnect.php';
- if(isset($_POST['btn-signup']))
- {
- $firstname = mysqli_real_escape_string($link,$_POST['firstname']);
- $lastname = mysqli_real_escape_string($link,$_POST['lastname']);
- $email = mysqli_real_escape_string($link,$_POST['email']);
- $phone = mysqli_real_escape_string($link,$_POST['phone']);
- $obatbeli = mysqli_real_escape_string($link,$_POST['obatbeli']);
- $jumlah = mysqli_real_escape_string($link,$_POST['jumlah']);
- $sql="SELECT 'harga' FROM 'tbl_obat' WHERE 'namaobat'='$obatbeli' LIMIT 0,30";
- $hargasatuan=mysqli_query($link,$sql);
- $harga=mysqli_fetch_row($hargasatuan);
- $total=intval($harga[0])*intval($jumlah);
- if(mysqli_query($link,"INSERT INTO tbl_konsumen(`first_name`, `last_name`, `email_id`, `phone`, `namaobat`, `jumlah`, `total`) VALUES('$firstname','$lastname','$email','$phone','$obatbeli','$jumlah','$total')"))
- {
- ?>
- <script>alert('transaksi konsumen berhasil didaftarkan');</script>
- <?php
- }
- else
- {
- ?>
- <script>alert('transaksi konsumen gagal didaftarkan');</script>
- <?php
- }
- }
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="html; charset=utf-8" />
- <title>Input Data Konsumen</title>
- <link rel="stylesheet" href="style.css" type="text/css" />
- </head>
- <body>
- <center>
- <div id="login-form">
- <form method="post">
- <table align="center" width="30%" border="0">
- <tr><td><input type="text" name="firstname" placeholder="first name" required /></td></tr>
- <tr><td><input type="text" name="lastname" placeholder="last name" required /></td></tr>
- <tr><td><input type="text" name="email" placeholder="email" required /></td></tr>
- <tr><td><input type="text" name="phone" placeholder="phone" required /></td></tr>
- <tr><td><input type="text" name="obatbeli" placeholder="obat yang dibeli" required /></td></tr>
- <tr><td><input type="text" name="jumlah" placeholder="berapa yang dibeli?" required /></td></tr>
- <tr><td><button type="submit" name="btn-signup">Input</button></td></tr>
- <tr><td><a href="tabelkonsumen.php">Home</a></td></tr><tr><td><a href="tabelkonsumen.php">Daftar Konsumen</a></td></tr>
- </tr>
- </table>
- </form>
- </div>
- </center>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement