SQL Query Execute error when using SQL SRV (Php)

Question

I am trying to execute following query, but it provides a syntax error which i couldn't find. Appreciate your help to resolve the issue.

Error

Array ( [0] => Array ( [0] => 07002 [SQLSTATE] => 07002 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver 17 for SQL Server]COUNT field incorrect or syntax error [message] => [Microsoft][ODBC Driver 17 for SQL Server]COUNT field incorrect or syntax error ) )

<?php

session_start();
require_once '../../../config/dbconfig.php';

$sql = "EXEC    smeProBizInspecInsert
@strLeadRefNo   =  ? ,
@strCustName =  ? ,                 
@strEnteredBy  =  ? , 
@dtmEnteredDate =  '',
@strInspectStatus = 'SMS06',
@strBranch = ? ";

$stmt=sqlsrv_prepare($conn,$sql,array(&$_POST['strLeadRefNo'],&$_POST['customerName'],&$_SESSION['NAME'], &$_SESSION['BRANCH'])); 
sqlsrv_execute($stmt);

$stmt = sqlsrv_prepare($conn, $sql);
if (!sqlsrv_execute($stmt)) {die( print_r( sqlsrv_errors(), true) );}
else {echo json_encode("success");} 

?>

Do all POST/SESSION arrays have value? Plus, why are you adding & to them? Is that something in a query as such that I don't know about? Far as I remember, single ampersands are bitwise characters. — Funk Forty Niner
– Funk Forty Niner, Commented Feb 15, 2020 at 16:28
Thank you for your comment, i followed the instructions in php.net/manual/en/function.sqlsrv-prepare.php.. Thats why i put an &sign. And all post and Sessions have values. — cs-87
– cs-87, Commented Feb 15, 2020 at 16:31
You're right, my bad, sorry. Well I am not the guy for this question. It appears that you're using stored procedures so I added that tag to the question. I hope someone who knows will be able to help you. — Funk Forty Niner
– Funk Forty Niner, Commented Feb 15, 2020 at 16:35
Any way thank you very much for commenting out for this post. The boost given by you will help to get an answer. — cs-87
– cs-87, Commented Feb 15, 2020 at 16:37

cs-87 · Accepted Answer · 2020-02-15 17:48:04Z

1

The issue was resolved, when i passed @dtmEnteredDate and @strInspectStatus through variables. Also i have mistakenly kept the following, which caused the error.

sqlsrv_execute($stmt); $stmt = sqlsrv_prepare($conn, $sql);

<?php

session_start();
require_once '../../../config/dbconfig.php';


$sql = "EXEC    smeProBizInspecInsert
@strLeadRefNo   =  ? ,
@strCustName =  ? ,                 
@strEnteredBy  =  ? , 
@dtmEnteredDate =  ? ,
@strInspectStatus = ?,
@strBranch = ? ";

$edate = '';
$status = 'SMS06';

$stmt=sqlsrv_prepare($conn,$sql,array(&$_POST['strLeadRefNo'],&$_POST['customerName'],&$_SESSION['NAME'], 
&$edate, &$status ,&$_SESSION['BRANCH'])); 

if (!sqlsrv_execute($stmt)) {

  die( print_r( sqlsrv_errors(), true) );


}


else 
{

  echo json_encode("success");

} 


?>

edited Feb 15, 2020 at 17:48

answered Feb 15, 2020 at 17:40

cs-87

2161 gold badge7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Query Execute error when using SQL SRV (Php)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related