Sir Jack, I tried as u directed but I got this outputjackpf wrote:Try puttingjust before the query.Code: Select all
var_dump($session); die();
Also try inserting a number. As in 10 or something, and see if that works.
Also, this line "mt_srand((double)microtime())*1000000;" is completely useless. You're not assigning it to anything.
string(0) ""
Here's my modified code:
Code: Select all
<?php
include("cn.php");
session_start();
//mt_srand((double)microtime())*1000000;
$session=mt_srand();//create uniqiue sessionid
$date= addslashes($_POST['date']);
$department = addslashes($_POST['department']);
$essenco=addslashes($_POST['essenco']);
$loanint =addslashes($_POST['loanint']);
$loanrepaid =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']);
var_dump($session); die();
$sql= "Insert into yearly_reports(date, department,essenco,loanint,loanrepaid,month,name,outloanbal,pfno,savings,session,shares,Year) values(SYSDATE(),'$department','$essenco','$loanint','$loanrepaid','$month','$name','$outloanbal','$pfno','$savings','$session','$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>Sir Jack, is there something I'm missing?