Show sourcecode
The following files exists in this folder. Click to view.
exercise/
hi.php
include_1.php
include_2a.php
include_2b.php
include_2c.php
include_lib.php
index.php
ovn_cookie-session1.php
ovn_cookie-session2.php
ovn_cookie-session3.php
ovn_cookie-session3a.php
ovn_cookie-session4.php
ovn_form1.php
ovn_form1a.php
ovn_form2.php
ovn_form2a.php
ovn_form3.php
ovn_form3a.php
ovn_form4.php
ovn_form4a.php
ovn_form5.php
ovn_form5a.php
ovn_form6.php
ovn_form6a.php
ovn_form7.php
ovn_form7a.php
ovn_ft1.php
ovn_ft1a.php
ovn_ft2.php
ovn_ft3.php
ovn_ft4.php
ovn_ft5.php
ovn_ft6.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_klass1.php
ovn_klass2.php
ovn_klass3.php
ovn_klass4.php
ovn_klass5.php
ovn_klass6.php
ovn_klass7.php
ovn_ms1.php
ovn_ms1a.php
ovn_ms1b.php
ovn_ms1c.php
ovn_ms2.php
ovn_ms2a.php
ovn_ms2b.php
ovn_ms2c.php
ovn_ms3.php
ovn_ms3create.php
ovn_ms3init.php
ovn_ms3insert.php
ovn_ms3view.php
ovn_rep1.php
ovn_rep2.php
ovn_rep3.php
ovn_rep3a.php
ovn_str1.php
ovn_str1a.php
ovn_str2.php
ovn_str2a.php
ovn_str3.php
ovn_str3a.php
ovn_str4.php
ovn_str4a.php
ovn_str5.php
ovn_str5a.php
ovn_str6.php
ovn_str6a.php
testFramework.php
ovn_ms1a.php
65 lines ASCII Windows (CRLF)
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465
<!-- selectposts.php -->
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Select</title>
</head>
<body>
<?php
include ('../incl/dbconnection.php');
try {
/*** The SQL SELECT statement ***/
$sql = "SELECT * FROM kompisar";
$stmt = $dbconn->prepare($sql);
// parameters in array, if empty we could skip the $data-variable
$data = array();
$stmt->execute($data);
$res = $stmt->fetchAll();
$output = htmlentities(print_r($res, 1));
echo "<pre>$output</pre>";
// fetch width column names
$data = array();
$stmt->execute($data);
$res = $stmt->fetch(PDO::FETCH_ASSOC);
$output = htmlentities(print_r($res, 1));
echo "<pre>$output</pre>";
// fetch columnindex
$data = array();
$stmt->execute($data);
$res = $stmt->fetch(PDO::FETCH_NUM);
$output = htmlentities(print_r($res, 1));
echo "<pre>$output</pre>";
// fetch width column names, create a table
$data = array();
$stmt->execute($data);
$output = "<table><caption>En ostylad tabell!</caption>";
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$output .= "<tr>".
"<td>".htmlentities($res['id'])."</td>".
"<td>".htmlentities($res['fname'])."</td>".
"<td>".htmlentities($res['sname'])."</td>".
"<td>".htmlentities($res['phonenum'])."</td>".
"<td>".htmlentities($res['email'])."</td>".
"</tr>";
}
$output .= "</table>";
echo "$output";
}
catch(PDOException $e)
{
echo $sql . "<br />" . $e->getMessage();
}
$dbconn = null;
?>
</body>
</html>