This code shows you how to add a record in MySQL database using PHP as my programming language.
I am currently accepting programming work inventory system, enrollment system, accounting system, payroll system, information system, website design and development using WordPress, IT projects, school and application development, programming projects, thesis, and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details. If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.
My telephone number at home here in Bacolod City, Negros Occidental Philippines is +63 (034) 4335675.
Here in Bacolod City, Negros Occidental I also accepting computer repair, web development using WordPress, Computer Networking and Arduino Project development at a very affordable price.
My personal website is http://www.jakerpomperada.com
My programming website is http://www.jakerpomperada.blogspot.com
I am also a book author you can purchase my books on computer programming and information technology in the following links below.
https://www.mindshaperspublishing.com/
https://www.unlimitedbooksph.com/
Program Listing
add.php
<html>
<head>
<title>Add Persons Record in PHP and MySQL</title>
</head>
<body>
<?php
include_once("config.php");
if(isset($_POST['Submit'])) {
$fname = mysqli_real_escape_string($mysqli, $_POST['fname']);
$lname = mysqli_real_escape_string($mysqli, $_POST['lname']);
$mname = mysqli_real_escape_string($mysqli, $_POST['mname']);
$gender = mysqli_real_escape_string($mysqli, $_POST['gender']);
$status = mysqli_real_escape_string($mysqli, $_POST['status']);
$bdate = mysqli_real_escape_string($mysqli, $_POST['bdate']);
$bplace = mysqli_real_escape_string($mysqli, $_POST['bplace']);
$address = mysqli_real_escape_string($mysqli, $_POST['address']);
$nationality = mysqli_real_escape_string($mysqli, $_POST['nationality']);
if(empty($fname) || empty($lname) || empty($gender)) {
if(empty($fname)) {
echo "<font color='red'>First Name field is empty.</font><br/>";
}
if(empty($lname)) {
echo "<font color='red'>Last Name field is empty.</font><br/>";
}
if(empty($gender)) {
echo "<font color='red'>Gender field is empty.</font><br/>";
}
echo "<br/><a href='javascript:self.history.back();'>Go Back</a>";
} else {
$result = mysqli_query($mysqli, "INSERT INTO student(fname,lname,gcode,mname,status,bdate,bplace,address,nationality) VALUES('$fname','$lname','$gender','$mname','$status','$bdate','$bplace','$address','$nationality')");
echo"<script>alert('Data added successfully');window.location.href='index.php'</script>";
}
}
?>
</body>
</html>
I am currently accepting programming work inventory system, enrollment system, accounting system, payroll system, information system, website design and development using WordPress, IT projects, school and application development, programming projects, thesis, and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details. If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.
My telephone number at home here in Bacolod City, Negros Occidental Philippines is +63 (034) 4335675.
Here in Bacolod City, Negros Occidental I also accepting computer repair, web development using WordPress, Computer Networking and Arduino Project development at a very affordable price.
My personal website is http://www.jakerpomperada.com
My programming website is http://www.jakerpomperada.blogspot.com
I am also a book author you can purchase my books on computer programming and information technology in the following links below.
https://www.mindshaperspublishing.com/
https://www.unlimitedbooksph.com/
Program Listing
add.php
<html>
<head>
<title>Add Persons Record in PHP and MySQL</title>
</head>
<body>
<?php
include_once("config.php");
if(isset($_POST['Submit'])) {
$fname = mysqli_real_escape_string($mysqli, $_POST['fname']);
$lname = mysqli_real_escape_string($mysqli, $_POST['lname']);
$mname = mysqli_real_escape_string($mysqli, $_POST['mname']);
$gender = mysqli_real_escape_string($mysqli, $_POST['gender']);
$status = mysqli_real_escape_string($mysqli, $_POST['status']);
$bdate = mysqli_real_escape_string($mysqli, $_POST['bdate']);
$bplace = mysqli_real_escape_string($mysqli, $_POST['bplace']);
$address = mysqli_real_escape_string($mysqli, $_POST['address']);
$nationality = mysqli_real_escape_string($mysqli, $_POST['nationality']);
if(empty($fname) || empty($lname) || empty($gender)) {
if(empty($fname)) {
echo "<font color='red'>First Name field is empty.</font><br/>";
}
if(empty($lname)) {
echo "<font color='red'>Last Name field is empty.</font><br/>";
}
if(empty($gender)) {
echo "<font color='red'>Gender field is empty.</font><br/>";
}
echo "<br/><a href='javascript:self.history.back();'>Go Back</a>";
} else {
$result = mysqli_query($mysqli, "INSERT INTO student(fname,lname,gcode,mname,status,bdate,bplace,address,nationality) VALUES('$fname','$lname','$gender','$mname','$status','$bdate','$bplace','$address','$nationality')");
echo"<script>alert('Data added successfully');window.location.href='index.php'</script>";
}
}
?>
</body>
</html>
