Please code gurus, I need a sharp pointer to the php code below; whenever I click submit button of the html form, it inserts all data except for 'loanrepaid', 'Year', 'Session'. I've double checked the variable names on the html-form with the insert variables and also checked by using 'addslahes', or 'mysql_real_escape_string' but all to no avail as 'loanrepaid', 'Year', 'Session' colums are not inserted into the table.
Here's the table structure:
-- Table structure for table `yearly_reports`
--
CREATE TABLE `yearly_reports` (
`id` int(11) NOT NULL auto_increment,
`name` char(10) NOT NULL,
`department` char(6) NOT NULL,
`pfno` char(10) NOT NULL,
`savings` varchar(255) NOT NULL,
`shares` varchar(255) NOT NULL,
`outloanbal` varchar(255) NOT NULL,
`loanrepaid` varchar(255) NOT NULL,
`loanint` varchar(255) NOT NULL,
`essenco` text NOT NULL,
`month` text NOT NULL,
`Year` varchar(234) NOT NULL,
`date` date NOT NULL,
`session` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
Code: Select all
//Here's the Html-form
<body>
<?php echo("<p align='center'><img src='/LasustaffCams/images/LasustaffCoop2.jpg' alt='' name='LasuStaffCams_Logo' width='700' height='150' id='LasuStaffCams_Logo' /></p>");?>
<?php echo ("<p>Admin | Admin Post | Summary Post | Year Summary | Logout</p>");?>
<?php echo ("<form action='Yearly_Entry_Action.php' method='post' enctype='multipart/form-data' name='register'>
<table width='28%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2'><div align='center'>
<p><font size='2' face='verdana'>ADMIN_YEARLY_POST</font></p>
</div></td>
</tr>
<tr>
<td width='31%'> </td>
<td width='69%'> </td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td height='26'><font size='2' face='verdana'>MEMBER NAME</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='name'>
</font></td>
</tr>
<tr>
<td height='28'><font size='2'>DEPARTMENT</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='department'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2'>PF. NO.</font> </td>
<td><font size='2' face='verdana'>
<input type='text' name='pfno'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2'>SAVINGS</font><font size='2' face='verdana'></td>
<td><font size='2' face='verdana'>
<input type='text' name='savings'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>SHARES</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='shares'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>OUTSTANDING LOAN BAL.</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='outloanbal'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LOAN REPAID IN YEAR</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='loan_repaid'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LOAN INTEREST</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='loanint'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>ESSENCO</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='essenco'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>MONTH</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='month'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>YEAR</font></td>
<td><font size='2' face='verdana'>
<input type='text' name='year'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'></font></td>
<td><font size='2' face='verdana'>
<input type='hidden' name='date'>
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'></font></td>
<td><font size='2' face='verdana'>
<input type='hidden' name='session_id'>
</font></td>
</tr>
</tr>
<td> </td>
<td><font size='2' face='verdana'>
<input type='submit' name='Submit' value='Record Yearly Report'>
</font></td>
</tr><tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form><div align='center'></div>
<td colspan='2'><div align='center'><font size='1' face='verdana'>TM</font></div></td>
<td colspan='2'> </td>");
?>
//Here's the php action script:
<?php
include("cn.php");
$date= date("now");
$department = addslashes($_POST['department']);
$essenco=addslashes($_POST['essenco']);
$loanint =addslashes($_POST['loanint']);
$loan_repaid =addslashes($_POST['loanrepaid']);
$month=addslashes($_POST['month']);
$name=addslashes($_POST['name']);
$outloanbal=addslashes($_POST['outloanbal']);
$pfno=addslashes($_POST['pfno']);
$savings=addslashes($_POST['savings']);
$session=addslashes($_POST['session']);
$shares=addslashes($_POST['shares']);
$year=addslashes($_POST['Year']);
$sql= "Insert into yearly_reports(date, department,essenco,loanint,loanrepaid,month,name,outloanbal,pfno,savings,session,shares,Year) values('now','$department','$essenco','$loanint','$loan_repaid','$month','$name','$outloanbal','$pfno','$savings','','$shares','$year')" or die .mysql_error();
//$result=mysql_query($sql) or die .mysql_error();
if (!mysql_query($sql))
{
die('Error: ' . mysql_error()." SQL: ".$sql);
}
echo ("1 record added");
?>
<html>
<body>
</body>
</html>