How do i insert datepicker into database

Asked Jun 06 '17 at 03:09

Active Jun 06 '17 at 03:24

Viewed 28 times

I need to read the 'month' from table site_salmonusage. Here is the example of data in site_salmonusage. Then i need to count whether the data is exist or not, If it exist, then i need to update all data in that 'month'. If not exist, it will insert into.

if ($_POST['register']){
$entry_id=$_POST["entry_id"];
$storenum = $_POST["storenum"];
$store_name=$_POST["store_name"];
$month = $_POST["month"];
$usage = $_POST["usage"];

$remove=mysqli_query($con,"SELECT COUNT(*)  As count FROM site_salmonusage WHERE month='$month' AND storenum='$storenum'");

$row=mysqli_fetch_array($remove);

if($row['count']==1){

    $add1 = "UPDATE site_salmonusage
SET  usage='$usage'
WHERE storenum='$storenum' AND month='$month'";
} 

else if($row['count']==0){
$add = "INSERT INTO site_salmonusage (storenum, month, usage)
VALUES ('$storenum','$month',$usage')";
}
else {
    $del= "DELETE  FROM site_salmonusage WHERE month='$month'"; 
    $adding="INSERT INTO site_salmonusage (storenum,month,usage)
    VALUES ('$storenum','$month','$usage')";
}

Here is my php. But after submit button, it not insert into database.

edited Jun 06 '17 at 03:24

Felix

asked Jun 06 '17 at 03:09

Azim Azman

show the code you execute the insert query – Felix Jun 06 '17 at 03:14
2

You would be open to SQL injections if you ever executed any of those queries. – chris85 Jun 06 '17 at 03:14
Here is my form to insert date and the query in my php that i posted just now. – Azim Azman Jun 06 '17 at 03:23
id you check `month` value is sent to server – Felix Jun 06 '17 at 04:13
no, it didnt sent to server. pls help – Azim Azman Jun 06 '17 at 05:04
THANKYOU. NOW I KNOW WHY IT DIDNOT WORKING, because im using the reserved word in mysql. it is "usage". so after i change the 'usage' to something else, all the data that been entered have sent to my db. sorry for my careless – Azim Azman Jun 06 '17 at 06:00

How do i insert datepicker into database

0 Answers0