PHP (recursive acronym for "PHP: Hypertext Preprocessor") is a widely-used Open Source general purpose scripting language that is especially suited for Web development and can be embedded into HTML.
This is the simple Code Example through which you can insert data into the MySql Database.
Paste this code and save the file as written above. Create a database named test and create a table student as below structure.
CREATE TABLE `student` ( `roll` int(11) default NULL, `class` varchar(20) default NULL, `name` varchar(40) default NULL, `f_name` varchar(40) default NULL, `sex` varchar(6) default NULL, `addr1` varchar(20) default NULL, `addr2` varchar(20) default NULL, `addr3` varchar(20) default NULL, `city` varchar(20) default NULL, `phone` varchar(12) default NULL, `email` varchar(100) default NULL, `remarks` varchar(40) default NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Add below code to your . php page.
<?ScreenShot
mysql_connect("localhost");
mysql_select_db("test") or die("database could not connect ");
?>
<html>
<head>
<meta name="description" content="Php Code for View, Search, Edit and Delete
Record" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Add Student Record</title>
</head>
<body>
<center>
<h1><u>Student Database</u></h1>
</center>
<?
if($_POST["do"]=="store")
{
$roll=$_POST["roll"];
$class=$_POST["class"];
$name=$_POST["name"];
$fname=$_POST["fname"];
$sex=$_POST["sex"];
$addr1=$_POST["addr1"];
$addr2=$_POST["addr2"];
$addr3=$_POST["addr3"];
$city=$_POST["city"];
$phone=$_POST["phone"];
$email=$_POST["email"];
$remarks=$_POST["remarks"];
$query="insert into student
value($roll,'$class','$name','$fname','$sex','$addr1','$addr2','$addr3','$city','$phone','$
email','$remarks')";
mysql_query($query);
echo "<center>Successfully store in DATABASE</center>";
}
?>
<form name="add" method="post" action="add.php">
<table style=" border:1px solid silver" cellpadding="5px" cellspacing="0px"
align="center" border="0">
<tr>
<td colspan="4" style="background:#0066FF; color:#FFFFFF; fontsize:
20px">ADD STUDENT RECORD</td>
</tr>
<tr>
<tr>
<td>Enter Roll Number</td>
<td><input type="text" name="roll" size="20"></td>
<td>Enter Class</td>
<td><input type="text" name="class" size="20"></td>
</tr>
<tr>
<td>Enter Name of Student</td>
<td><input type="text" name="name" size="20"></td>
<td>Enter Father's Name</td>
<td><input type="text" name="fname" size="20"></td>
</tr>
<tr>
<td>Sex</td>
<td><input type="radio" name="sex" value="Male">
Male
<input type="radio" name="sex" value="Female">
Female </td>
<td>Address1</td>
<td><input type="text" name="addr1" size="20"></td>
</tr>
<tr>
<td>Address2</td>
<td><input type="text" name="addr2" size="20"></td>
<td>Address3</td>
<td><input type="text" name="addr3" size="20"></td>
</tr>
<tr>
<td>City</td>
<td><input type="text" name="city" size="20"></td>
<td>Phone</td>
<td><input type="text" name="phone" size="20"></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email" size="20"></td>
<td>Remarks</td>
<td><input type="text" name="remarks" size="20"></td>
</tr>
<tr>
<td colspan="4" align="center"><input type="hidden" name="do" value="store">
<input type="submit" value="ADD RECORD"></td>
</tr>
</table>
</form>
</body>
</html>
if($_POST["do"]=="store") : (Undefined Index error)
ReplyDeletewhy we'r using this :
input type="hidden" name="do" value="store"