Webbserverprogrammering 1

Show sourcecode

The following files exists in this folder. Click to view.

Webserver1/mySQL/

createtable.php
deletepost.php
deletetable.php
insertdefaultposts.php
insertpost.php
selectposts.php
updatepost.php

deletetable.php

30 lines ASCII Windows (CRLF)
<!-- deletetable.php -->
<!doctype html>
<html>

<head>
  <meta charset="utf-8">
  <title>Create</title>
</head>

<body>
  <?php
  
include('/Webserver1/incl/dbconnection.php');
  try {

    
// sql to delete table
    
$sql "DROP TABLE IF EXISTS pdodemotable";
    
//use exec() because no results are returned
    
$dbconn->exec($sql);
    echo 
"Table deleted successfully";
  } catch (
PDOException $e) {
    echo 
$sql "<br>" $e->getMessage();
  }

  
//Rensa kopplingen till databasen
  
$dbconn null;

  
?>
</body>

</html>