Webbserverprogrammering 1

Show sourcecode

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

webbsrvprg/projects/quiz/

access-deneid.png
diagramresultat.php
insert-admin.php
login.php
logout.php
personliga-resultat.php
quiz-sida.php
ransa-quiz-session.php
ransa-skapa-quiz-session.php
resultat.php
session-variabler-unset.php
signin.php
skapa-inloggning-tabell.php
skapa-quiz-tabeller.php
skapa-quiz.php
start.php
tabort-kunder-quiz.php
åtkomst-nekad.php

insert-admin.php

40 lines UTF-8 Windows (CRLF)
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Insert</title>
</head>
<body>
  <?php
  
include ('../../dbconnection.php');
  try {
    
$username "Honk";
    
    
$stmt $dbconn->prepare("SELECT * FROM kunder WHERE username = :username");
    
$stmt->bindParam(':username'$username);
    
$stmt->execute();

    if (
$stmt->rowCount() > 0) {
      echo 
"Admin har redan skapats";
    }
    else {
      
$sql "INSERT INTO kunder (name, username, password, type, reg_date)
      VALUES ('David', 'Honk', 'lösenord123', 'admin', now())"
;

      
$dbconn->exec($sql);
      echo
"Admin Tillagd";
    }



  }
  catch(
PDOException $e){
    echo 
$sql"<br>"$e->getMessage();
  }

  
$dbconn null;
  
?>
</body>
</html>