Why?!!!
Why is modal add form is incomplete?
CREATE TABLE IF NOT EXISTS `student` ( `student_id` INT(100) NOT NULL AUTO_INCREMENT, `fname` VARCHAR(100) NOT NULL, `mname` VARCHAR(100) NOT NULL, `lname` VARCHAR(100) NOT NULL, `address` VARCHAR(100) NOT NULL, `email` VARCHAR(100) NOT NULL, PRIMARY KEY (`student_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
<?php $conn = new PDO('mysql:host=localhost; dbname=add_pdo','root', ''); ?>
<?php require_once('db.php'); $fname= $_POST['fname']; $mname= $_POST['mname']; $lname= $_POST['lname']; $address= $_POST['address']; $email= $_POST['email']; $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "INSERT INTO student (fname, mname, lname, address, email) VALUES ('$fname', '$mname', '$lname', '$address', '$email')"; echo "<script>alert('Account successfully added!'); window.location='index.php'</script>"; ?>
<?php include('db.php'); $result = $conn->prepare("SELECT * FROM student where student_id='$ID'"); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ $id=$row['student_id']; ?> <form class="form-horizontal" method="post" action="edit_PDO.php<?php echo '?student_id='.$id; ?>" enctype="multipart/form-data" style="float: right;"> <hr> <div class="control-group"> <div class="controls"> <input type="text" name="fname" required value=<?php echo $row['fname']; ?>> </div> </div> <div class="control-group"> <div class="controls"> <input type="text" name="mname" required value=<?php echo $row['mname']; ?>> </div> </div> <div class="control-group"> <div class="controls"> <input type="text" name="lname" required value=<?php echo $row['lname']; ?>> </div> </div> <div class="control-group"> <div class="controls"> <input type="text" name="address" required value=<?php echo $row['address']; ?>> </div> </div> <div class="control-group"> <div class="controls"> <input type="email" name="email" required value=<?php echo $row['email']; ?>> </div> </div> <div class="control-group"> <div class="controls"> </div> </div> </form> <?php } ?>
<?php include 'db.php'; $get_id=$_REQUEST['student_id']; $fname= $_POST['fname']; $mname= $_POST['mname']; $lname= $_POST['lname']; $address= $_POST['address']; $email= $_POST['email']; $sql = "UPDATE student SET fname ='$fname', mname ='$mname', lname ='$lname', address ='$address', email ='$email' WHERE student_id = '$get_id' "; echo "<script>alert('Successfully Edit The Account!'); window.location='index.php'</script>"; ?>
<?php require_once('db.php'); $get_id=$_GET['student_id']; // sql to delete a record $sql = "Delete from student where student_id = '$get_id'"; // use exec() because no results are returned ?>