<?php
/**
* connection with database
*/
$way = new mysqli('localhost','root','','awd61');
// isseting form
if ( isset($_POST['payment'])) {
// Get value
$name = $_POST['name'];
$amount = $_POST['amount'];
$email = $_POST['email'];
$cell = $_POST['cell'];
$batch = $_POST['batch'];
/**
* Form validation
*/
if ( empty($name) || empty($amount) || empty($email) || empty($cell) || empty($batch) ) {
$msg = "<p class=\"text-danger pt-2 ml-5\">All feilds are required !</p>";
}else{
// passing data to database
$sql = "INSERT INTO payment_book (name, amount, email, cell, batch) VALUES ('$name','$amount','$email','$cell','$batch')";
$way -> query($sql);
}
}
?>
<!-- html static form -->
<div class="container top ">
<div class="row shadow">
<div class="col-lg-4">
<div class="box m-auto">
<h1 class="pt-3 text-white">Payment Book</h1>
<!-- validation message -->
<?php
if (isset($msg)) {
echo $msg;
}
?>
<form action="" class="px-5" method="POST">
<input name="name" type="text" placeholder="name" class="w-100 p-1">
<input name="amount" type="text" placeholder="amount" class="w-100 p-1">
<input name="email" type="text" placeholder="email" class="w-100 p-1">
<input name="cell" type="text" placeholder="cell" class="w-100 p-1">
<input name="batch" type="text" placeholder="batch" class="w-100 p-1">
<input name="payment" type="submit" value="Submit Now" class="w-100 p-1">
</form>
</div>
</div>
<!-- Taking data form database table -->
<div class="col-lg-8">
<div class="table m-auto pt-3 pb-3">
<h1 class="text-white">All Members</h1>
<table class="text-white border border-white">
<tr>
<th class="">Id</th>
<th>Name</th>
<th>Amount</th>
<th>Email</th>
<th>Cell</th>
<th>Batch</th>
</tr>
<?php
/**
* taking data from database
*/
$sql = "SELECT * FROM payment_book";
$data = $way -> query($sql);
while( $all_data = $data -> fetch_assoc() ) {
?>
<tr>
<td><?php echo $all_data['id'] ?></td>
<td><?php echo $all_data['name'] ?></td>
<td><?php echo $all_data['amount'] ?></td>
<td><?php echo $all_data['email'] ?></td>
<td><?php echo $all_data['cell'] ?></td>
<td><?php echo $all_data['batch'] ?></td>
</tr>
<?php } ?>
</table>
</div>
</div>
</div>
</div>
-
Notifications
You must be signed in to change notification settings - Fork 0
Nahiankhondokar/PHP_12-Form_with_Database-
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published