Update Query by passing id but found error mention below

👨‍💻 Development Help
1

Hi , I am passing id with a button and i had done it but i want add update query in suitecrm like
$sql="UPDATE users SET status='Active' WHERE id='user_id'";

$db->query($sql);

but found error below error on this line $db->query($sql):

Fatal error : Uncaught Error: Call to a member function query() on null in C:\xampp\htdocs\SuiteCRM-7.12.7\custom\MyTimeEntryPoint.php:15

2

Well, what is your $db variable set to? You need to initialize it to contain the database object.

1 Like
3

Hola! El error se debe a que estás intentando utilizar el método “query()” en una variable no definida -null-.
Deberías previamente instanciarlo.

$conexion = “mysql:host=.;dbname=”;
$PDOcon = new PDO($conexion, “use” , “pass”, $options);

luego podrías utilizarlo en tu variable $PDOcon

$PDOcon->query('$sql');
1 Like
4

Hi , i had done it ,it was simple
$id=$_REQUEST[‘user_id’];

$bean = BeanFactory::getBean(‘Users’,$id);

if($_REQUEST[‘user_status’]==‘inActive’){

$bean->status=“Active”;

$bean->save();

}

5

yes you are right it was my mistake i was using $db->query($sql); i was intiallizing $db but it was no use ,i do not how i was using this