I'm inserting some value in database & after inserting when i check that value in database it's showing different values. why? please.. help me
my code is..
"INSERT INTO `tblRechargeReports`
(`rechargeOnNumber` , `rechargeOnOperator`, `rechargeAmount`, `rechargeOnCircle`, `rechargedOn`)
VALUES('" . $array['rechargeOnNumber'] . "', '" . $array['rechargeOnOperator'] . "','" . $array['rechargeAmount'] . "', '" . $array['rechargeOnCircle'] . "', NOW() )";
when i checked after die() function then it's showing like.....
INSERT INTO `tblRechargeReports` (`rechargeOnNumber` , `rechargeOnOperator`, `rechargeAmount`, `rechargeOnCircle`, `rechargedOn`)
VALUES('9002261639', '1','100', '2', NOW() )
Please take datatype for mobile number as bigint or varchar.
Please try to use below table strtucture:
id INT(11) AUTO_INCREMENT NOT NULL,
rechargeOnNumber VARCHAR(20) NOT NULL,
rechargeOnOperator VARCHAR(100) NOT NULL,
rechargeAmount INT(5) NOT NULL,
rechargeOnCircle VARCHAR(100) NOT NULL,
rechargedOn DATETIME NOT NULL,
rechargeData TEXT(100) NULL,
rechargeStatus ENUM('Y', 'N') NOT NULL DEFAULT 'Y',
isDelete ENUM('Y', 'N') NOT NULL DEFAULT 'N',
PRIMARY KEY (id),
UNIQUE KEY IDX_rechargeOnOperator (rechargeOnOperator)