setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo "Failed to connect to the database using DSN:
$dsn
"; throw $e; } // Prepare the SQL statement to drop the table echo "

Prepare to drop the table, if it exists.

"; $sql = <<prepare($sql); $stmt->execute(); // Prepare the SQL statement to create the table echo "

Prepare to create the table.

"; $sql = <<prepare($sql); $stmt->execute(); // Prepare SQL statement to INSERT new rows into table echo "

Prepare to insert into the table.

"; $sql = <<prepare($sql); // Insert each row echo "

Inserting rows into the table.

"; $params = [1,'Buster XXL','Yamaha 115hk',635,240,'Adam']; $stmt->execute($params); $params = [2,'Buster M','Yamaha 40hk',460,186,'Berit']; $stmt->execute($params); $params = [3,'Linder 440','Tohatsu 4hk',431,164,'Ceasar']; $stmt->execute($params); // Check whats in the database $sql = "SELECT * FROM Jetty"; $stmt = $db->prepare($sql); echo "

Execute the SQL-statement:
$sql

"; $stmt->execute(); // Get the results as an array with column names as array keys $res = $stmt->fetchAll(PDO::FETCH_ASSOC); echo "

The result contains " . count($res) . " rows.

"; // Loop through the array and gather the data into table rows $rows = null; foreach ($res as $row) { $rows .= ""; $rows .= "{$row['jettyPosition']}"; $rows .= "{$row['boatType']}"; $rows .= "{$row['boatEngine']}"; $rows .= "{$row['boatLength']}"; $rows .= "{$row['boatWidth']}"; $rows .= "{$row['ownerName']}"; $rows .= "\n"; } // Print out the result as a HTML table using PHP heredoc echo << jettyPostion boatType boatEngine boatLength boatWidth ownerName $rows EOD;