SEACOOS Wave data page
";
$self=$_SERVER['PHP_SELF'];
$file_path="/data/wera/efs/waves/";
$upload_tmp_dir="/var/www/tmp/";
if ($_GET['action']=="delete"){
$host="localhost";
$user="root";
$pass="12surf34";
$db="wera";
$connection = mysqli_connect($host, $user, $pass) or die ("Unable to connect!");
$id=$_GET['fileid'];
$sql="SELECT * FROM wavefiles WHERE id = '$id'";
$res=mysqli_query($sql);
$row=mysqli_fetch_object($res);
$filename=$row->file;
unlink($filename);
$del_sql="DELETE FROM wavefiles WHERE id = '$id'";
$res=mysqli_query($del_sql);
printFiles($self,$file_path);
uploadForm($self);
} elseif ($_POST['submit']){
if (file_exists($file_path . $_FILES['userfile']['name'])){
echo "file:",$_FILES['userfile']['name']," exists.
Try again";
printFiles($self,$file_path);
uploadForm($self);
exit;
} else {
//move file to location
$pfile=$_FILES['userfile']['name'];
move_uploaded_file($_FILES['userfile']['tmp_name'], "$file_path$pfile");
$description=$_POST['description'];
$owner=$_POST['owner'];
//print out some messages
echo "File: $pfile succesfully uploaded";
echo "
Description: $description";
echo "
Owner: $owner";
//add image caption etc to database
$pfile="$file_path$pfile";
$query = "INSERT INTO wavefiles VALUES ('0','$pfile','$description','$owner','$now')";
add2DB($query);
printFiles($self,$file_path);
uploadForm($self);
}
} else {
printFiles($self,$file_path);
uploadForm($self);
}
function add2DB($query){
// open database connection
$host="localhost";
$user="root";
$pass="12surf34";
$db="wera";
$connection = mysqli_connect($host, $user, $pass) or die ("Unable to connect!");
mysqli_select_db($db) or die ("Unable to select database!");
$result = mysqli_query($query) or die ("Error in query: $query. " . mysqli_error());
}
function uploadForm($self){
print"
";
}
function printFiles($self,$path){
// open database connection
$host="localhost";
$user="root";
$pass="12surf34";
$db="wera";
$webpath="/waves/";
$connection = mysqli_connect($host, $user, $pass) or die ("Unable to connect!");
mysqli_select_db($db) or die ("Unable to select database!");
$query = "SELECT * FROM wavefiles ORDER BY timestamp DESC";
$result = mysqli_query($query) or die ("Error in query: $query. " .mysqli_error());
if ($result){
print"
Available Files: |
";
while ($row = mysqli_fetch_object($result)) {
$fileloc=str_replace($path,$webpath,"$row->file");
$filename=basename("$row->file");
$fsize=filesize("$row->file");
$size = ($fsize > 512)?( ($fsize/1024 > 512) ? sprintf("%.02f MB",($fsize/1024)/1024) :sprintf("%.02f kB",$fsize/1024)) :sprintf("%d B",$fsize);
echo "
$filename
Size: $size
Description:$row->description
Owner:$row->owner
Uploaded: $row->timestamp
id>DELETE
| |
\n";
}
print "
";
} else {
print "none
";
}
}
?>