/
display.php
58 lines (47 loc) · 1.39 KB
/
display.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php include("dbconnect.php"); ?>
<h2>資料列表 2015/11/14</h2>
<?php
if($_POST['submit'])
{
$id = $_POST['id'];
$name = $_POST['name'];
$age = $_POST['age'];
$memo = $_POST['memo'];
//取得上傳檔案資訊
$filename=$_FILES['image']['name'];
$tmpname=$_FILES['image']['tmp_name'];
$filetype=$_FILES['image']['type'];
$filesize=$_FILES['image']['size'];
$file=NULL;
if(isset($_FILES['image']['error'])){
if($_FILES['image']['error']==0){
$instr = fopen($tmpname,"rb" );
$file = addslashes(fread($instr,filesize($tmpname)));
}
}
//新增圖片到資料庫
pg_query("insert into testtable (id,name,age,memo, img) values ('$id','$name','$age','$memo', '$file')");
}
?>
<?php
{
$result = pg_query("select * from testtable ") or
die (pg_error());
$xx = pg_fetch_all($result);
foreach ($xx as $row )
{
echo "<b>ID:</b>". $row['id']
."<br><b>Name:</b>". $row['name']
."<br><b>Age:</b>". $row['age']
."<br><b>Memo:</b>". $row['memo']
// ."<br><b>Image:</b>". $row['img']
."<br><br><br>";
}
pg_free_result($result);
}
?>
<h2><a href="search.php">修改</a></h2>
<h2><a href="delete.php">刪除</a></h2>
<h2><a href="insert.php">新增</a></h2>
</form>