=> 102 [2] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near '`'. [message] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near '`'. ) )
yo le paso por url la tabla y el id, eso con mysql funciona muy bien pero aca no me quiere funcionar no se cual es el error.
<?php
$method = $_SERVER['REQUEST_METHOD'];
$request = explode('/', trim($_SERVER['PATH_INFO'],'/'));
$input = json_decode(file_get_contents('php://input'),true);
// connect to the sqlserver database
$serverName = "xxxxx"; //serverName\instanceName
$connectionInfo = array( "Database"=>"xxxx", "UID"=>"xxxx", "PWD"=>"xxxx");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
// retrieve the table and key from the path
$table = preg_replace('/[^a-z0-9_]+/i','',array_shift($request));
$key = array_shift($request)+0;
switch ($method) {
case 'GET':
$sql = "select * `$table`".($key?" WHERE ter_coda=$key":''); break;
case 'PUT':
$sql = "update `$table` set $set where ter_coda=$key"; break;
case 'POST':
$sql = "insert into `$table` set $set"; break;
case 'DELETE':
$sql = "delete `$table` where ter_coda=$key"; break;
}
// excecute SQL statement
$result = sqlsrv_query($conn,$sql);
// die if SQL statement failed
if (!$result) {
http_response_code(404);
die( print_r( sqlsrv_errors(), true));
}
// print results, insert id or affected row count
if ($method == 'GET') {
if (!$key) echo '[';
for ($i=0;$i<sqlsrv_num_rows($result);$i++) {
echo ($i>0?',':'').json_encode(sqlsrv_fetch_object($result));
}
if (!$key) echo ']';
} elseif ($method == 'POST') {
echo sqlsrv_insert_id($link);
} else {
echo sqlsrv_affected_rows($link);
}
// close sqlserver connection
sqlsrv_close($conn);
