nuBuilder Forum

Posted: **Mon Apr 24, 2023 10:54 pm**

Hello, do we have a possibility to use db_affected_rows? Wiki says following are supported:
1 db_fetch_array
2 db_fetch_object
3 db_fetch_row
4 db_field_names
5 db_num_columns

I want to count how many rows have been affected after UPDATE query has been run.

If not implemented yet, can we get it?

Posted: **Tue Apr 25, 2023 1:12 am**

EDIT

worked around it :

Code: Select all

nuRunQuery($sql);

$affected_rows = nuRunQuery("SELECT ROW_COUNT()")->fetchColumn();

if ($affected_rows > 0) {
  $js = "nuMessage('Good!', 2000,closePopup);

	function closePopup() {
		nuClosePopup();
	}
	";
} elseif ($affected_rows === 0) {
  $js = "nuMessage('BAD');";
} else {
  nuDisplayError('WRONG!!!');
  return;
}

nuJavaScriptCallback($js);

Posted: **Tue Apr 25, 2023 8:03 am**

You can use db_num_rows()

nuBuilder Forum

PDO db_affected_rows

PDO db_affected_rows

Re: PDO db_affected_rows

Re: PDO db_affected_rows