I have this page where I insert images binary into my mysql database.
There is one problem though. I would like it to only except images of a certain width and heigth (for example max width = 400, max heigth = 600).
How should I adjust my script in order to do so? Any ideas?
<?
require("dbmanager.php");
if($id) {
$query = "SELECT file_data,file_type FROM bilder WHERE id=$id";
$result = @mysql_query($query);
$data = @mysql_result($result,0,"file_data");
$type = @mysql_result($result,0,"file_type");
Header( "Content-type: $type");
echo $data;
};
?>
<HTML>
<HEAD><TITLE>Storing images</TITLE>
</HEAD>
<BODY>
<br>
<?php
//INSERTING THE DATA
if ($submit) {
$kid = $_POST['kategori'];
$sid = $_POST['sid'];
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
if ($form_data_type == "image/gif"||$form_data_type == "image/pjpeg"||$form_data_type == "image/jpeg") {
$result=MYSQL_QUERY("INSERT INTO bilder (name,file_desc,file_type,file_size,file_data,kid,sid) ".
"VALUES ('$form_data_name','$form_description','$form_data_type','$form_data_size','$data', '$kid', '$sid')");
$id= mysql_insert_id();
print "<p>text: <b>$id</b><br><br><a href=\"javascript:history.go(-1)\"><-Tillbaka</a>";
}else{
echo "<p>text<br><br><a href=\"javascript:history.go(-1)\"><-Tillbaka</a></p>";
}
} 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 bilden:<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>
Under vilken länk bilden ska visas:<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><br>
Sidan som bilden ska visas pƄ :<br>
<input type="text" name="sid" size="4"><br><br>
<input type="submit" name="submit" value="submit">
</form>
<?php
}
?>
</BODY>
</HTML>
