record is not added please rectify code

C

chandanrastogi

Right off the assembly line
<html>(index.php)
<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>Search Student Record</title>
</head>
<body>
<center><h1><u>Student Database</u></h1></center>
<form name="search" method="post" action="search.php">
<table style=" border:1px solid silver" cellpadding="10px" cellspacing="0px" align="center">
<tr>
<td colspan="3" style="background:#0066FF; color:#FFFFFF; font-size:20px">Search</td></tr>
<tr>
<td>Enter Search Keyword</td>
<td><input type="text" name="search" size="40" /></td>
<td><input type="submit" value="Search" /></td>
</tr>
<tr>
<td colspan="3">&nbsp;</td></tr>
<tr bgcolor="#CCCCCC">
<th colspan="5" align="right"><a href="add.php">Add Record</a></th>
</tr>
</table>
</form>
</body>

</html>
(add.php code)

<?

error_reporting(0);
mysql_connect("localhost","root","");
mysql_select_db("demoproject");
?>
<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["submit"]=="ADDRECORD")
{

$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"];
$conn="insert into student value('$roll','$class','$name','$fname','$sex','$addr1','$addr2','$addr3','$city','$phone','$email','$remarks')";
mysql_query($conn);
}
?>
<form name="add" method="post" action="" >
<table style=" border:1px solid silver" cellpadding="5px" cellspacing="0px" align="center" border="0">
<tr>
<td colspan="4" style="background:#0066FF; color:#FFFFFF; font-size: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="submit" name="submit" value="ADDRECORD"></td></tr>
</table>
</form>
</tr>
<p align="center"><a href="index.php">Go Back to Home</a></p>

<?php
include("search.php");?>
</body>
</html><?

error_reporting(0);
mysql_connect("localhost","root","");
mysql_select_db("demoproject");
?>
<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["submit"]=="ADDRECORD")
{

$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"];
$conn="insert into student value('$roll','$class','$name','$fname','$sex','$addr1','$addr2','$addr3','$city','$phone','$email','$remarks')";
mysql_query($conn);
}
?>
<form name="add" method="post" action="" >
<table style=" border:1px solid silver" cellpadding="5px" cellspacing="0px" align="center" border="0">
<tr>
<td colspan="4" style="background:#0066FF; color:#FFFFFF; font-size: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="submit" name="submit" value="ADDRECORD"></td></tr>
</table>
</form>
</tr>
<p align="center"><a href="index.php">Go Back to Home</a></p>

<?php
include("search.php");?>
</body>
</html>
 
You must log in or register to reply here.
Top Bottom