Someone who manages PDO bindParam, I would greatly appreciate your help [closed]

I hope it is what you are looking for:

Bring all active contacts, from all companies

$stmt = $db->prepare('SELECT * from contacto_empresa INNER JOIN empresa ON empresa.id_empresa = contacto_empresa.empresa_id_empresa WHERE contacto_empresa.estado = 'ACTIVO');
$stmt->execute()

Bring all the active contacts for a particular company (Una Sola), passing the id of the company in $idEmpresa

$stmt = $db->prepare('SELECT * from contacto_empresa INNER JOIN empresa ON empresa.id_empresa = contacto_empresa.empresa_id_empresa WHERE contacto_empresa.estado = 'ACTIVO' AND id_contacto_empresa = :idEmpresa');
$stmt->bindParam('idEmpresa', $idEmpresa);
$stmt->execute()

It would be something like this: -

$stmt = $db->prepare('SELECT * from contacto_empresa inner join empresa on empresa.id_empresa = contacto_empresa.empresa_id_empresa WHERE estado_contacto = :estado AND id_contacto_empresa != :idEmpresa');

 $stmt->bindParam(':estado', 'ACTIVO');
 $stmt->bindParam('idEmpresa', '0');

 $stmt->execute()