Is the following correct or have i got it 100% wrong :’(
Assigned Tickets = <?php $sql = "Select Count(*) FROM [Support_DB].[dbo].['Job info$'] WHERE [Job Completed?]= 0;" $stmt = $pdo->query($sql); $stmt->([$count]); $jobcomp = $stmt->fetch(); ?>[/php]
My php error log also shows this:
[05-Apr-2018 09:38:48 UTC] PHP Warning: PHP Startup: Unable to load dynamic library ‘php_pdo_sqlsrv_72_ts.dll’ (tried: C:\php\ext\php_pdo_sqlsrv_72_ts.dll (The specified module could not be found.), C:\php\ext\php_php_pdo_sqlsrv_72_ts.dll.dll (The specified module could not be found.)) in Unknown on line 0
[05-Apr-2018 09:38:48 UTC] PHP Warning: PHP Startup: pdo_sqlsrv: Unable to initialize module
Module compiled with module API=20160303
PHP compiled with module API=20170718
These options need to match
in Unknown on line 0
[05-Apr-2018 09:38:48 UTC] PHP Parse error: syntax error, unexpected ‘$stmt’ (T_VARIABLE) in C:\inetpub\wwwroot\SupportDesk\php\Index.php on line 35
The errors in the PHP error log suggest my PDO is broken but the strange thing is if i comment out the code as there are 2 include statements that is my navbar and my SQLconnection and some other checks it works fine and a clean error log.
Personally i think its the code for my assigned ticket count the Select query works as i have tested it in SQLMAN studio.
Thanks for all your help.