Webbserverprogrammering 1

Show sourcecode

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

webbsrvprg/exercises/

hej.php
hej.py
index.php
ovn_ajax1.php
ovn_ajax2.php
ovn_ajax3.php
ovn_cookie1.php
ovn_cookie2.php
ovn_cookie3_1.php
ovn_cookie3_2.php
ovn_cookie4.php
ovn_cookie5.php
ovn_cookie6.php
ovn_form1.php
ovn_form2.php
ovn_form3_1.php
ovn_form3_2.php
ovn_form7_1.php
ovn_form7_2.php
ovn_form8_1.php
ovn_form_tillamp1_1.php
ovn_form_tillamp1_2.php
ovn_form_tillamp2.php
ovn_form_tillamp3.php
ovn_form_tillamp4.php
ovn_form_tillamp5.php
ovn_form_tillamp6.php
ovn_funk1.php
ovn_funk2.php
ovn_funk3.php
ovn_funk4.php
ovn_funk5.php
ovn_funk6.php
ovn_funk7.php
ovn_funk8.php
ovn_funk9.php
ovn_gr1.php
ovn_gr2.php
ovn_gr3.php
ovn_gr4.php
ovn_gr5.php
ovn_gr6.php
ovn_gr7.php
ovn_incl1/
ovn_incl2/
ovn_incl3/
ovn_klass1.php
ovn_klass2.php
ovn_klass3.php
ovn_klass4.php
ovn_klass5.php
ovn_klass6.php
ovn_klass7.php
ovn_mysqlintro1_1.php
ovn_mysqlintro1_2.php
ovn_mysqlintro1_3.php
ovn_mysqlintro1_4.php
ovn_mysqlintro1_5.php
ovn_mysqlintro2_1.php
ovn_mysqlintro2_2.php
ovn_mysqlintro2_3.php
ovn_str1_1.php
ovn_str1_2.php
ovn_str2_1.php
ovn_str2_2.php
ovn_str3_1.php
ovn_str3_2.php
ovn_str4_1.php
ovn_str4_2.php
ovn_str5_1.php
ovn_str5_2.php
ovn_str6_1.php
ovn_str6_2.php

ovn_mysqlintro1_3.php

40 lines UTF-8 Windows (CRLF)
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>mysql</title>
</head>
<body>
<?php
include ('../incl/dbconnect.php');
try {
    
# sql
    
$sql "INSERT INTO kompisar (firstname, lastname, mobil, epost) 
    VALUES (?, ?, ?, ?)"
;
    
# prepare
    
$stmt $dbconn->prepare($sql);
    
# the data we want to insert
    
$data = array('viggo''skjönsberg'0704235235'viggo@varmdo');
     
# execute width array-parameter
    
$stmt->execute($data);
    
    
$data = array('Amanda''Anka'070352352'postt@post');
    
$stmt->execute($data);
    
    
$data = array('Per''Anka'0704532'post@post');
    
$stmt->execute($data);    
    echo 
"New records created successfully";

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

//Rensa kopplingen till databasen
$dbconn null;

?>
</body>
</html>