eventid does not fit into the database. Eco prints his lines, but it’s empty. What I missed please tell me.

try{ if (!file_exists("testgb")){ $db = new PDO('sqlite:testgb'); $db->exec("CREATE TABLE guestbook (eventid INTEGER PRIVATE KEY,name VARCHAR(55), message TEXT, date DATETIME)"); } $db = new PDO('sqlite:testgb'); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->exec("INSERT INTO guestbook (name, message, date) VALUES ('KIRILL', 'Hello!!', date('now'))"); $res = $db->query("SELECT * FROM guestbook"); foreach ($res as $row){ echo $row['eventid']."<br>"; echo $row['name']."<br>"; echo $row['message']."<br>"; echo $row['date']."<br>"; echo "<hr>"; } }catch (PDOException $e){ echo $e->getMessage(); }

Yes, it is PRIMARY that should be ... Damn, what a stupid mistake. Thank.

    1 answer 1

      $db->exec("CREATE TABLE guestbook (eventid INTEGER PRIVATE KEY,name VARCHAR(55), message TEXT, date DATETIME)")

    Explain what it means PRIVATE KEY ?? maybe you wanted to specify the PRIMARY KEY