$db->exec('CREATE TABLE data (`username` TEXT, `password` TEXT, `nickname` TEXT, `login` TEXT)'); $sql = 'INSERT INTO data (`username`, `password`, `nickname`, `login`) VALUES (:username, :password, :nickname, :login)'; $query = $db->prepare($sql); $query->execute([':username' => $number, ':password' => $pw, ':nickname' => $nickname, ':login' => '1']); } $db = new \PDO('sqlite:' . $fileName, null, null, [PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); $sql = 'SELECT username, password, nickname, login FROM data'; $row = $db->query($sql); $result = $row->fetchAll(); $username = $result[0]['username']; $password = $result[0]['password']; $nickname = $result[0]['nickname']; $login = $result[0]['login']; $w = new WhatsProt($username, $nickname, $debug); $GLOBALS['wa'] = $w; $w->setMessageStore(new SqliteMessageStore($username)); $events = new MyEvents($w); $w->eventManager()->bind('onGetSyncResult', 'onSyncResult'); $w->eventManager()->bind('onGetRequestLastSeen', 'onGetRequestLastSeen'); $w->eventManager()->bind('onPresenceAvailable', 'onPresenceAvailable'); $w->eventManager()->bind('onPresenceUnavailable', 'onPresenceUnavailable'); $w->eventManager()->bind('onGetImage', 'onGetImage'); $w->eventManager()->bind('onGetVideo', 'onGetVideo'); $w->eventManager()->bind('onGetAudio', 'onGetAudio'); $w->connect(); try { $w->loginWithPassword($password); } catch (Exception $e) { echo "Error: {$e}"; exit; }