I have this code that is part of a function in php
to change status
, previously everything worked perfect, but now when changing status
, mark error in:
$result = $connection >executeNonQuery($query,array($_POST['numFile']));
The error says that:
<b>Fatal error</b>: Uncaught Error: Call to undefined function executeNonQuery() in C:\xampp\htdocs\aaa\aaa\aaa.php:620
Stack trace:
#0 {main}
thrown in <b>C:\xampp\htdocs\aaa\aaa\aaa.php</b> on line <b>620</b><br />
This is the part of the code where the error is generated.
$connection = new MySqlServerConnection();
$query1 = 'SELECT quantity, reorder_Level FROM inventory_list WHERE numFile = ?';
$result1 = $connection->executeQuery($query1,array($_POST['numFile']));
if (intval($result1[0][0]) <= intval($result1[0][1]) && intval($result1[0][0]) == 0)
{
$query = 'UPDATE inventory_list SET status = 3 WHERE numFile = ?';
$result = $connection >executeNonQuery($query,array($_POST['numFile']));
}
else
{
$query = 'UPDATE inventory_list SET status = 0 WHERE numFile = ?';
$result = $connection->executeNonQuery($query,array($_POST['numFile']));
}