I've got a SQL DB in Azure. I am running the Webapps PHP link to that DB.

I can connect fine, and retrieve data. I am having troubles trying to update a table.

My SQL statement is:

$sql3="UPDATE EmpBonus SET EmpBonus_BonusAmt=?, EmpBonus_StartDate=?, EmpBonus_EndDate=?, EmpBonus_Current=? WHERE Id=?";
I can pass the parameters over via this line of code
$params=array($bonusamt,$startdate,$enddate,$currentstr,$primkey);
My problem is that the DATES $startdate or $enddate have to have the single quote around the date i.e. '2015-01-01' or else SQL will reject it.
I can't find on the web where I can insert the single quote around the date in PHP.
Can anyone help?
      

Hi Jeff,

Is there a reason why you can't put single quotes around question mark? Like this:

$sql3="UPDATE EmpBonus SET EmpBonus_BonusAmt=?, EmpBonus_StartDate='?', EmpBonus_EndDate='?', EmpBonus_Current=? WHERE Id=?";

Thanks,
Veljko

I did try it, but it still doesn't work.

Is there a way to see what the actual SQL statement looks like?

$stmt3=sqlsrv_query($conn,$sql3,$params)
My array gives these values
Array (    [0] => 50000    [1] => 2015-01-01    [2] => 2016-12-31    [3] => 1    [4] => 1 ) 
When I type in those values into the SQL console, the only thing stopping it from updating is the missing ' ' from the dates.
I assume that where my problem lies?

• Edited by Jeff12345564634 11 hours 59 minutes ago

I did try it, but it still doesn't work.

Is there a way to see what the actual SQL statement looks like?

$stmt3=sqlsrv_query($conn,$sql3,$params)
My array gives these values
Array (    [0] => 50000    [1] => 2015-01-01    [2] => 2016-12-31    [3] => 1    [4] => 1 ) 
When I type in those values into the SQL console, the only thing stopping it from updating is the missing ' ' from the dates.
I assume that where my problem lies?

• Edited by Jeff12345564634 Friday, June 19, 2015 7:07 PM

I did try it, but it still doesn't work.

Is there a way to see what the actual SQL statement looks like?

$stmt3=sqlsrv_query($conn,$sql3,$params)
My array gives these values
Array (    [0] => 50000    [1] => 2015-01-01    [2] => 2016-12-31    [3] => 1    [4] => 1 ) 
When I type in those values into the SQL console, the only thing stopping it from updating is the missing ' ' from the dates.
I assume that where my problem lies?

• Edited by Jeff12345564634 Friday, June 19, 2015 7:07 PM

I did try it, but it still doesn't work.

Is there a way to see what the actual SQL statement looks like?

$stmt3=sqlsrv_query($conn,$sql3,$params)
My array gives these values
Array (    [0] => 50000    [1] => 2015-01-01    [2] => 2016-12-31    [3] => 1    [4] => 1 ) 
When I type in those values into the SQL console, the only thing stopping it from updating is the missing ' ' from the dates.
I assume that where my problem lies?

• Edited by Jeff12345564634 Friday, June 19, 2015 7:07 PM

Arrgh. It was my fault. I forgot to input the ID in the primary key. It wasn't the date at all.

• Marked as answer by Jeff12345564634 5 hours 51 minutes ago

Arrgh. It was my fault. I forgot to input the ID in the primary key. It wasn't the date at all.

• Marked as answer by Jeff12345564634 6 hours 1 minutes ago

Arrgh. It was my fault. I forgot to input the ID in the primary key. It wasn't the date at all.

• Marked as answer by Jeff12345564634 Thursday, July 02, 2015 1:16 AM

Arrgh. It was my fault. I forgot to input the ID in the primary key. It wasn't the date at all.

• Marked as answer by Jeff12345564634 Thursday, July 02, 2015 1:16 AM

Arrgh. It was my fault. I forgot to input the ID in the primary key. It wasn't the date at all.

• Marked as answer by Jeff12345564634 Thursday, July 02, 2015 1:16 AM