I am trying to save data (link & picture) in banner manager.
banner_manager.php
//SIMPAN DATA
if (isset($_POST['simpan'])){
$id = $_POST['id'];
$link = mysql_real_escape_string($_POST['link']);
//$gambar = $_POST['gambar'];
//print_r($_POST); die();
echo $link;
echo $gambar['name'];
}
//Cek apakah ada file yang diupload
if((!empty($_FILES['uploaded_file'])) && ($_FILES['uploaded_file']['error'] == 0)){
//$gambar = uploadPicture('uploaded_file');
$target_path = "Images/";
$target_path = $target_path . basename( $_FILES['uploaded_file']['name']);
$gambar['name'] = $target_path;
if(move_uploaded_file($_FILES['uploaded_file']['tmp_name'], $target_path)) {
echo "The file ". basename( $_FILES['uploaded_file']['name']).
" has been uploaded";
// I add this to test insert data
//mysql_query("INSERT INTO banner(link, gambar) VALUES('".$link."','".$gambar."')");
} else{
echo "There was an error uploading the file, please try again!";
}
}
if (empty($id)){
$sqlstr = "INSERT INTO banner(link, gambar) VALUES('".$link."','".$gambar['name']."')";
echo $sqlstr;
}else{
$sqlstr = "UPDATE banner SET link = '".$link."',gambar = '".$gambar['name']."' WHERE id =".$id;
$result = mysql_query($sqlstr) or die(mysql_error());
$confirmation = ($result)? "Data telah tersimpan.":"Gagal menyimpan data.";
$gambar['name'] = "";
$link = "";
$id = "";
}
//EDIT / DELETE MODE
if (!empty($_REQUEST['id']) && !empty($_REQUEST['mode'])){
if ($_REQUEST['mode'] == 'delete'){
$result = mysql_query("DELETE FROM banner WHERE id=".$_REQUEST['id']) or die(mysql_error());
$confirmation = ($result)? "Data telah terhapus.":"Gagal menghapus data.";
}elseif ($_REQUEST['mode'] == 'edit'){
$result = mysql_query("SELECT * FROM banner WHERE id=".$_REQUEST['id']) or die(mysql_error());
if ($data = mysql_fetch_array($result)){
$id = $data['id'];
$link = $data['link'];
$gambar['name'] = $data['gambar'];
}
}
}
?>
<div align="center">
<div style="width:700px;text-align:left;padding-top:25px;">
<div class="pageTitle">Banner Manager</div>
<?php //echo $confirmation; ?><br/>
<form method="post" enctype="multipart/form-data" action="<?php $_SERVER['PHP_SELF']?>">
<table width="700px" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>Link</td>
<td>
<input type="text" name="link" value="<?php echo $link; ?>"/> Contoh: http://www.garudanews.co.cc
<input type="hidden" name="id" value="<?php echo $id; ?>"/>
</td>
</tr>
<tr>
<td>Gambar</td>
<td><input type="file" name="gambar"/></td>
</tr>
<tr>
<td colspan="2">
<?php
if (!empty($_REQUEST['id'])){
?>
<img src="Images/<?php echo $gambar['name'];?>" width="100" height="100" alt="gambar"/>
<input type="hidden" name="gambar" value="<?php echo $gambar['name']; ?>"/>
<?php
}
?>
</td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="simpan" value="Simpan"/></td>
</tr>
</table>
</form>
<hr/>
<table width="400px" border="1" cellpadding="2" cellspacing="0">
<tr>
<th>Banner</th>
<th>Action</th>
</tr>
<?php
//LOAD BANNER AND ACTION MODE
$result = mysql_query("SELECT * FROM banner");
while ($data = mysql_fetch_array($result)){
?>
<tr>
<td><?php echo $data['link'];?></td>
<td>
<a href="./banner_manager.php?id=<?php echo $data['id']; ?>&mode=delete">Hapus</a> |
<a href="./banner_manager.php?id=<?php echo $data['id']; ?>&mode=edit">Edit</a>
</td>
</tr>
<?php
}
?>
</table>
</div>
</div>
Here is the print out of sqlstr:
INSERT INTO banner(link, gambar) VALUES('www.link.com','Array')
Why the picture does not print out as the name of the picture ?
When I check the database, the data is not there either.