PHP PDO SQLSRV Issue

[jbeitz107]

$hostname="SERVERNAME\SQLEXPRESS";
$dbname="User";
$username='SERVERNAME';
$password='MYPASSWORD';
$first_bind = $conn->prepare("UPDATE Account  SET Birthday = '23-01-1978 00:00:00' WHERE UserID = 'test'");
$update = $first_bind->execute;

When I run this script manually in SQL Server the database updates so I assume it is something to do with php. Anyhow the issue is that everything else updates with no problems but, the datetime field will not update or even insert into the database. Any suggestions would be greatly appreciated.

 

[TimeBomb]

It's good practice and I highly recommend you to set all column values as statement parameters in your SQL query when using prepared statements.

$hostname="SERVERNAME\SQLEXPRESS";
$dbname="User";
$username='SERVERNAME';
$password='MYPASSWORD';
$userId = 123;
$date = 'whatever';
$first_bind = $conn->prepare("UPDATE Account SET Birthday = :birthday WHERE UserID = :userId");
$first_bind->bindParam(':birthday', $date, PDO::PARAM_STR); // or date(...) instead of $date
$first_bind->bindParam(':userId', $userId, PDO::PARAM_STR); // or PDO::PARAM_INT if your user id is a number
$update = $first_bind->execute;

Consider trying to use the PHP date function instead of a string, in case that helps. Though I don't know why a properly formatted string wouldn't work in a datetime column. Are you getting any errors?

 

[Joopie]

You need to create an instance of the PDO class first (

You must be registered to see links

). Also make sure you have the right drivers/extentions installed for your PHP version.

 

[jbeitz107]

@TimeBomb - I have used the date function of php but, only posted in here for reference. I can update fields that only consist of date but, not those of datetime. That is my issue at this time. Thank you for at least responding.

 

[s-p-n]

I haven't used PHP in a while, but isn't PDO::execute a method? If it is, you're not invoking it, try `$update = $first_bind->execute()`