blocks|key|2605281|text|解决方案1:|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2605282|这个解决方案是基于你所期望的，并在RAISEERROR()的SQL语句中产生错误的方法，所以sqlsrv_query()将返回FALSE。|CODE|2605283|<?php
#+Connection
$server+=+'server\instance,port';
$database+=+'database';
$uid+=+'username';
$pwd+=+'password';
$cinfo+=+array(
++++"Database"+=>+$database,
++++"UID"+=>+$uid,
++++"PWD"+=>+$pwd
);
$conn+=+sqlsrv_connect($server,+$cinfo);
if+(+$conn+===+false+)+{
++++echo+"Error+(sqlsrv_connect):+".print_r(sqlsrv_errors(),+true);
++++exit;
}

#+INSERT+statement
$tsql+=+
++++"
++++IF+NOT+EXISTS+(SELECT+1+FROM+SOMETABLE+WHERE+SOMEROW+=+'VALUE5'+)+BEGIN
++++++++INSERT+INTO+SOMETABLE+(SOMEROW)+VALUES+('VALUE5')
++++++++END
++++ELSE+BEGIN
++++++++RAISERROR+(N'This+row+already+exists.',+10,+1);
++++END;
++++";
$stmt+=+sqlsrv_query($conn,+$tsql);++
if+($stmt+===+false)+{
++++die(print_r(sqlsrv_errors(),+true));
}+else+{
++++sqlsrv_free_stmt($stmt);
++++echo+"Success";+
}+++

#+End
sqlsrv_close($conn);
?>|code-block|syntax|javascript|2605284|解决方案2:|2605285|可以从语句返回输出，然后使用sqlsrv_fetch_array()检查结果|2605286|<?php
#+Connection
$server+=+'server\instance,port';
$database+=+'database';
$uid+=+'username';
$pwd+=+'password';
$cinfo+=+array(
++++"Database"+=>+$database,
++++"UID"+=>+$uid,
++++"PWD"+=>+$pwd
);
$conn+=+sqlsrv_connect($server,+$cinfo);
if+(+$conn+===+false+)+{
++++echo+"Error+(sqlsrv_connect):+".print_r(sqlsrv_errors(),+true);
++++exit;
}

#+INSERT+statement
$tsql+=+
++++"
++++SET+NOCOUNT+ON;
++++IF+NOT+EXISTS+(SELECT+1+FROM+SOMETABLE+WHERE+SOMEROW+=+'VALUE'+)+BEGIN
++++++++INSERT+INTO+SOMETABLE+(SOMEROW)+VALUES+('VALUE')
++++++++SELECT+@@ROWCOUNT+AS+RC
++++++++END
++++ELSE+BEGIN
++++++++SELECT+0+AS+RC
++++END;
++++";
$stmt+=+sqlsrv_query($conn,+$tsql);++
if+($stmt+===+false)+{
++++die(+print_r(+sqlsrv_errors(),+true));
}

#+Row+count+information
while+($row+=+sqlsrv_fetch_array($stmt,+SQLSRV_FETCH_ASSOC))+{
++++$rc+=+$row['RC'];
}
if+($rc+==+0)+{
++++echo+"This+Row+already+Exists";
}+else+{
++++echo+"Success";+
}

#+End
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
?>|2605287|备注：|2605288|SQLSRV驱动程序支持sqlsrv_rows_affected()和sqlsrv_num_rows()函数，这两个函数的使用有一定的限制。|2605289|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql?view=sql-server-2017|1|https://docs.microsoft.com/en-us/sql/connect/php/sqlsrv-fetch-array?view=sql-server-2017|2|https://docs.microsoft.com/en-us/sql/connect/php/sqlsrv-rows-affected?view=sql-server-2017|3|https://docs.microsoft.com/en-us/sql/connect/php/sqlsrv-num-rows?view=sql-server-2017^0|0|6|0|1A|E|1R|5|H|C|0|0|0|0|6|0|E|K|1|0|0|0|C|M|2|Z|H|3|0^^$0|@$1|2|3|4|5|6|7|1B|8|@$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1E|8|@$9|1F|A|1G|B|H]|$9|1H|A|1I|B|H]]|D|@$9|1J|A|1K|1|1L]]|E|$]]|$1|I|3|J|5|K|7|1M|8|@]|D|@]|E|$L|M]]|$1|N|3|O|5|6|7|1N|8|@$9|1O|A|1P|B|C]]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1Q|8|@]|D|@$9|1R|A|1S|1|1T]]|E|$]]|$1|R|3|S|5|K|7|1U|8|@]|D|@]|E|$L|M]]|$1|T|3|U|5|6|7|1V|8|@]|D|@]|E|$]]|$1|V|3|W|5|6|7|1W|8|@]|D|@$9|1X|A|1Y|1|1Z]|$9|20|A|21|1|22]]|E|$]]|$1|X|3|-4|5|6|7|23|8|@]|D|@]|E|$]]]|Y|$Z|$5|10|11|12|E|$13|14]]|15|$5|10|11|12|E|$13|16]]|17|$5|10|11|12|E|$13|18]]|19|$5|10|11|12|E|$13|1A]]]]

Solution 1:

This solution is based on approach, that you expect and raises error in SQL statemwent with <a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql?view=sql-server-2017" rel="nofollow noreferrer">RAISEERROR()</a>, so <code>sqlsrv_query()</code> will return <code>FALSE</code>.

<pre><code>&lt;?php
# Connection
$server = 'server\instance,port';
$database = 'database';
$uid = 'username';
$pwd = 'password';
$cinfo = array(
 "Database" =&gt; $database,
 "UID" =&gt; $uid,
 "PWD" =&gt; $pwd
);
$conn = sqlsrv_connect($server, $cinfo);
if ( $conn === false ) {
 echo "Error (sqlsrv_connect): ".print_r(sqlsrv_errors(), true);
 exit;
}

# INSERT statement
$tsql = 
 "
 IF NOT EXISTS (SELECT 1 FROM SOMETABLE WHERE SOMEROW = 'VALUE5' ) BEGIN
 INSERT INTO SOMETABLE (SOMEROW) VALUES ('VALUE5')
 END
 ELSE BEGIN
 RAISERROR (N'This row already exists.', 10, 1);
 END;
 ";
$stmt = sqlsrv_query($conn, $tsql); 
if ($stmt === false) {
 die(print_r(sqlsrv_errors(), true));
} else {
 sqlsrv_free_stmt($stmt);
 echo "Success"; 
} 

# End
sqlsrv_close($conn);
?&gt;
</code></pre>

Solution 2:

It is possible to return output from your statement and then check the results with <a href="https://docs.microsoft.com/en-us/sql/connect/php/sqlsrv-fetch-array?view=sql-server-2017" rel="nofollow noreferrer">sqlsrv_fetch_array()</a>:

<pre><code>&lt;?php
# Connection
$server = 'server\instance,port';
$database = 'database';
$uid = 'username';
$pwd = 'password';
$cinfo = array(
 "Database" =&gt; $database,
 "UID" =&gt; $uid,
 "PWD" =&gt; $pwd
);
$conn = sqlsrv_connect($server, $cinfo);
if ( $conn === false ) {
 echo "Error (sqlsrv_connect): ".print_r(sqlsrv_errors(), true);
 exit;
}

# INSERT statement
$tsql = 
 "
 SET NOCOUNT ON;
 IF NOT EXISTS (SELECT 1 FROM SOMETABLE WHERE SOMEROW = 'VALUE' ) BEGIN
 INSERT INTO SOMETABLE (SOMEROW) VALUES ('VALUE')
 SELECT @@ROWCOUNT AS RC
 END
 ELSE BEGIN
 SELECT 0 AS RC
 END;
 ";
$stmt = sqlsrv_query($conn, $tsql); 
if ($stmt === false) {
 die( print_r( sqlsrv_errors(), true));
}

# Row count information
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
 $rc = $row['RC'];
}
if ($rc == 0) {
 echo "This Row already Exists";
} else {
 echo "Success"; 
}

# End
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
?&gt;
</code></pre>

Notes:

SQLSRV driver supports <a href="https://docs.microsoft.com/en-us/sql/connect/php/sqlsrv-rows-affected?view=sql-server-2017" rel="nofollow noreferrer">sqlsrv_rows_affected()</a> and <a href="https://docs.microsoft.com/en-us/sql/connect/php/sqlsrv-num-rows?view=sql-server-2017" rel="nofollow noreferrer">sqlsrv_num_rows()</a> functions, which can be used with some restrictions.

blocks|key|2394388|text|变量的布尔检查是为了成功执行查询，您应该检查它是否为布尔类型和是否为空。这是由empty函数完成的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2394389|if+(empty($stmt)){
++++var_dump(sqlsrv_errors());
++++die();
}|code-block|syntax|javascript|2394390|entityMap^0|13|5|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Boolean check of variable is for successful execution of the query, you should check it for boolean type and being empty. this is done by <code>empty</code> function.

<pre><code>if (empty($stmt)){
 var_dump(sqlsrv_errors());
 die();
}
</code></pre>

I'm trying to prevent duplicate rows from being created. My current statement works, meaning it prevents duplicates from being created, but it always returns the execution as a success, meaning I don't get an "error" message if no rows were created.

Thanks

<pre><code>$tsql = "
 IF NOT EXISTS ( SELECT 1 FROM SOMETABLE WHERE SOMEROW = 'VALUE' )
 BEGIN
 INSERT INTO SOMETABLE (
 SOMEROW
 )

 VALUES (
 'SOMETHING'
 )
 END
 ";


$stmt = sqlsrv_query( $conn, $tsql);


if(gettype($stmt)=='boolean'){
 if($stmt){
 echo "Success"; 
 } else {
 echo "This Row already Exists";
 die( print_r( sqlsrv_errors(), true)); 
 } 
</code></pre>

I would like to fail the sql execution if nothing was created, which isn't done in this case. (It's always sent back as a success.

Thanks

Send PHP Error if No Rows Created

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在尝试防止创建重复的行。我当前的语句可以工作，这意味着它可以防止创建重复的语句，但它总是将执行作为成功返回，这意味着如果没有创建行，我就不会收到“错误”消息。谢谢$tsql = "    IF NOT EXISTS ( SELECT 1 FROM SOMETABLE WHERE SOMEROW = 'VALUE' ...

问如果未创建行，则发送PHP错误
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如果未创建行，则发送PHP错误EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如果未创建行，则发送PHP错误
EN