Trung Trung - 5 months ago 84
PHP Question

PHP - Get affected rows in ADODB

I using ADODB to create a connection to my database. I update the data in my database, there is no error. The problem is that I can't get the number of affected rows by

Affected_Rows()
. I tried with very simple code but it is not working. Here is my code:

$sql = "UPDATE User SET Name=N'MyName' WHERE Id=1";
$conn = new COM ("ADODB.Connection") or die("Cannot start ADO");
$cs = "provider=sqloledb;"."server=localhost;database=Test;uid=Admin;pwd=123456;Max Pool Size=100";
$conn->open($cs);

//there is no error in connecting process. I can add, update, delete normally.
if($conn->Execute($sql) === false)
{
trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->ErrorMsg(), E_USER_ERROR);
}
else
{
echo $conn->Affected_Rows(); //<-- Error in here
}


I have read about this function in here. My code above is almost same with example here.
Is there any other way to get the number of affected rows in ADODB-PHP?

Answer

About Affected_Rows(), I don't know why it isn't working. There is another very simple way to get the number of affected rows after execute query.

$conn->Execute($sql,$affected_rows);

echo $affected_rows;

$affected_rows return from Execute function will have value equal to number of affected rows of that query.