I have a page where I can insert files into my MySQL database.
As it works now it inserts anykind of files but I would like it to only approve powerpoint-files ( application/vnd.ms-powerpoint).
Here below is my page and if anyone could help me to make an if-query or whatever you think would do the trick, I would greatly appreciate it!.
<?
require("dbmanager.php");
?>
<HTML>
<HEAD><TITLE>Storing powerpoints</TITLE>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/JavaScript">
function koll()
{
if (document.getElementById('form_data').value.length<=4)
{
alert('Du måste välja en fil!');
return false;
}
return true;
}
</SCRIPT>
</HEAD>
<BODY>
<?php
<br>
//INSERTING THE DATA
if ($submit) {
$kid = $_POST['kategori'];
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
$result=MYSQL_QUERY("INSERT INTO powerpoint (name,file_desc,file_type,file_size,file_data,kid) ".
"VALUES ('$form_data_name','$form_description','$form_data_type','$form_data_size','$data', '$kid')");
$id= mysql_insert_id();
print "<p>Du har lagt in en presentation i databasen med id: <b>$id</b><br><br><a href=\"javascript:history.go(-1)\"><-Tillbaka</a>";
MYSQL_CLOSE();
} else {
//THE FORM WHERE I SELECT A FILE TO BE UPLOADED
?><form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data" onsubmit="return koll()">
Kort beskrivning av filen:<br>
<input type="text" name="form_description" size="40">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>Filen du vill ska laddas up:<br>
<input type="file" name="form_data" size="40"><br>
Kategori:<br>
<select name="kategori" id="kategori">
<?
$kat = "SELECT * FROM kategori ORDER BY kategori ASC";
$result2 = mysql_query($kat,$db_link);
$rows = mysql_num_rows($result2);
$lID = 0;
$lname ="";
for($index = 0; $index< $rows; $index++) {
$lID = mysql_result($result2,$index,"kid");
$lname = mysql_result($result2,$index,"kategori");
?>
<option value="<? echo "$lID";?>"><? echo"$lname";
}?>
</option>
</select>
<p><input type="submit" name="submit" value="submit">
</form>
<?php
}
?>
</BODY>
</HTML>
