banner_manager.php
//Cek apakah ada file yang diupload
if((!empty($_FILES["uploaded_file"])) && ($_FILES["uploaded_file"]['error'] == 0)){
$gambar = uploadPicture("uploaded_file");
}
if (empty($id))
$sqlstr = "INSERT INTO banner(link, gambar) VALUES('".$link."','".$gambar."')";
else
$sqlstr = "UPDATE banner SET link = '".$link."',gambar = '".$gambar."' WHERE id =".$id;
$result = mysql_query($sqlstr) or die(mysql_error());
$confirmation = ($result)? "Data telah tersimpan.":"Gagal menyimpan data.";
$gambar = "";
$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());
$data = mysql_fetch_array($result);
$id = $data['id'];
$link = $data['link'];
$gambar = $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['file:///C|/xampp/htdocs/garuda_news/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="uploaded_file"/></td>
</tr>
<tr>
<td colspan="2">
<?php
if (!empty($_REQUEST['id'])){
?>
<img src="<?php echo $gambar;?>" alt="gambar"/>
<input type="hidden" name="gambar" value="<?php echo $gambar; ?>"/>
<?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 USER
$result = mysql_query("SELECT * FROM banner");
while ($data = mysql_fetch_array($result)){
?>
<tr>
The above codes produces the following output:
Banner Manager
Notice: Undefined variable: confirmation in C:\xampp\htdocs\php_template2\banner_manager.php on line 51
Link Contoh: http://www.garudanews.co.cc
Gambar
--------------------------------------------------------------------------------
Banner Action
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\php_template2\banner_manager.php on line 92
Line 51: <?php echo $confirmation; ?><br/>
Line 92: while ($data = mysql_fetch_array($result)){
Why those error appears?
Thanks before.