I have some problem about uploading and database. I upload the file (abc.jpg) and the file already insert to the folder name (uploads). But when I check in database (php), the file did not enter. Here is my code. Hope anyone can help me.Thank you.
<? include "conn.php";?>
<?php
error_reporting(0);
if(isset($_POST['submit']))
{
$target = "uploads/";
$allowedExts = array("jpg", "jpeg");
$extension = end(explode(".", $_FILES["file_upload"]["name"]));
$target = $target . basename( $_FILES['file_upload']['name']);
$date = date("Y-m-d H:i:s");
//Function to generate image thumbnails
function make_thumb($src, $dest, $desired_width) {
/* read the source image */
$source_image = imagecreatefromjpeg($src);
$width = imagesx($source_image);
$height = imagesy($source_image);
/* find the "desired height" of this thumbnail, relative to the desired width */
$desired_height = floor($height * ($desired_width / $width));
/* create a new, "virtual" image */
$virtual_image = imagecreatetruecolor($desired_width, $desired_height);
/* copy source image at a resized size */
imagecopyresampled($virtual_image, $source_image, 0, 0, 0, 0, $desired_width, $desired_height, $width, $height);
/* create the physical thumbnail image to its destination with 100% quality*/
imagejpeg($virtual_image, $dest,100);
}
//check for allowed extensions
if ((($_FILES["file_upload"]["type"] == "image/jpg")|| ($_FILES["file_upload"]["type"] == "image/jpeg"))&& in_array($extension, $allowedExts))
{
$photoname = $_FILES["file_upload"]["name"];
if (file_exists("../uploads/" . $photoname))
{
die( '<div class="error">Maaf <b>'. $photoname . '</b> telah dimuatnaik sebelum ini</div>');
}
if(move_uploaded_file($_FILES['file_upload']['tmp_name'], $target))
{
$query = "INSERT INTO updown (nama_file,tkh_muatnaik) VALUES ('$photoname','$date')";
mysql_query($query);
$sql = "SELECT MAX(id_gambar) FROM updown";
$max = mysql_query($sql);
$row = mysql_fetch_array($max);
$maxId = $row['MAX(id_gambar)'];
$type = $_FILES["file_upload"]["type"];
switch($type)
{
case "image/jpeg":
$ext = ".jpeg";
break;
case "image/jpg";
$ext = ".jpg";
break;
}
//define arguments for the make_thumb function
$source = "uploads/".$photoname;
$destination = "thumbnails/thumb_". $maxId . $ext ."";
//specify your desired width for your thumbnails
$width = "282";
//Finally call the make_thumb function
make_thumb($source,$destination,$width);
$msg = '<div class="success">
<b>Muatnaik: </b>' . basename($photoname) . '<br />
<b>Format: </b>' . $_FILES["file_upload"]["type"] . '<br />
<b>Size: </b>' . ceil(($_FILES["file_upload"]["size"] / 1024)) . 'Kb<br />
</div>';
}
else
{
$msg = '<div class="error">Maaf, muatnaik gambar tidak berjaya</div>';
}
}
else
{
$msg = '<div class="error">Format gambar ini tidak diterima!</div>';
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link rel="stylesheet" href="style.css" />
<link rel="stylesheet" type="text/css" media="all" href="js/jsDatePick_ltr.min.css" />
<script type="text/javascript" src="js/jsDatePick.min.1.3.js"></script>
<script type="text/javascript">
function redirectpage(){
window.location = "daftar_majlis_1.php";
}
<!--
</script>
<link href="css/style_galeri.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="70%" align="center">
<tr>
<td colspan="2" class="header"></td>
</tr>
<tr>
<td width="79%"><? include "menu_admin.htm"; ?></td>
</tr>
<tr>
<td><H3 class="main_title">Muat Naik Gambar Disini</H3>(<a href="galeri_admin.php" >Lihat Galeri</a>)
<div id="upload">
<?php echo $msg; ?>
<form action="" method="post" enctype="multipart/form-data">
<label for="file">Gambar:</label>
<input type="file" name="file_upload" id="upload_file" />
<input type="submit" name="submit" value="Muatnaik" />
</form>
</div></td>
<td width="21%"> </td>
</tr>
</table>
</body>
</html>
