Hi I am trying to insert and update the query in function using Angularjs and returning the data in the form of JSON objects. In this query I am comparing year and email. If there is no data for current year and email the data should be inserted otherwise the data should be updated. But when I am trying that the data is not inserting when I write both conditions (Insert and Update). If I write only insert query it is accepting.
function addrentalproperty($data)
{
$rentalannualrent = $data->rentalProperty->rentalannualrent;
$rentalblock = $data->rentalProperty->rentalblock;
$rentalstreet = $data->rentalProperty->rentalstreet;
$rentalarea = $data->rentalProperty->rentalarea;
$rentaltown = $data->rentalProperty->rentalcity;
$rentalstate = $data->rentalProperty->rentalstate;
$rentalpincode = $data->rentalProperty->rentalpincode;
session_start();
$userInfo = $_SESSION['USER'];
$userEmailid = $userInfo->getEmailid();
if ($rentalannualrent != '' && $rentalblock != '' && $rentalstreet != '' && $rentalarea != '' && $rentaltown != '' && $rentalstate != '' && $rentalpincode != '') {
$query = mysql_query("UPDATE rental_details SET
rental_annual_rent = '$rentalannualrent',
rental_block = '$rentalblock',
rental_street = '$rentalstreet',
rental_area = '$rentalarea',
rental_town = '$rentaltown',
rental_state = '$rentalstate',
rental_pincode = '$rentalpincode',
WHERE email ='$userEmailid' AND currentyear=NOW()");
} else {
$query = mysql_query("INSERT INTO rental_details(email,rental_annual_rent,rental_block,rental_street,rental_area,rental_town,rental_state,rental_pincode,rental_ownership,currentyear)
values('$userEmailid','$rentalannualrent','$rentalblock','$rentalstreet','$rentalarea','$rentaltown','$rentalstate','$rentalpincode','$rentalownership',NOW())");
}
if ($query) {
$successJson = '{"success":"Rental Property Details Added Successfully."}';
print_r($successJson);
} else {
$failureJson = '{"error":"Problem While Saving Property Details."}';
print_r($successJson);
}
}