01.<?php
02.$uploaddir = 'UploadFile/';
03.$uploadfile = $uploaddir . basename($_FILES['userfile']['name']);
04.$name = $_POST['name'];
05.
06.if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile))
07.{
08.}
09.else { echo "File size greater than 300kb!\n\n"; }
10.
11.echo "'$name'\n";
12.
13.$conn = pg_pconnect("dbname=postgres user=postgres password=p@ssw0rd");
14.$query = "insert into image values ('$name', lo_import('$uploadfile'), 'now')";
15.$result = pg_query($conn,$query);
16.
17.if($result)
18.{
19. echo "File is valid, and was successfully uploaded.\n";
20. unlink($uploadfile);
21.}
22.else
23.{
24. echo "Filename already exists. Use another filename. Enter all the values.";
25. unlink($uploadfile);
26.}
27.pg_close($conn);
28.?>
Quote:
