<?php
function editMyads(){
$banners_code = $_GET['code'];
$query = mysql_query("SELECT * FROM banners WHERE banner_code='".mysql_real_escape_string($banners_code)."'");
$row = mysql_fetch_array($query);
$id = $row['user_id'];
$size = $row['size'];
$size_cat = explode("-", $size);
$size_cat = $size_cat['1'];
$size_cut = explode("x", $size);
$size_cut_1 = $size_cut['0'];
$size_cut_2 = $size_cut['1'];
$removeWord = explode("-", $size_cut_2);
$fullSize = $size_cut_1." x ".$removeWord['0'];
$dest_url = $row['gourl'];
$bannerurlFull = explode("/", $row['url']);
$bannerurl = $bannerurlFull['2'];
$bannersname = $row['name'];
?>
<center><font><b>Edit banner: <i><a><?php echo $bannersname; ?></a></i></b></font></center><br>
<form action='index.php?act=myads&option=edit&do=update&code=<?php echo $banners_code; ?>' method='post'>
<table width='390' border='0' align='center'>
<tr>
<td width='25%'><font><b>Banner's size:</b></font></td><td width='75%'>
<select name='banner_size'>
<optgroup label='<?php echo $size_cat; ?>'>
<option value='<?php echo $size; ?>'><?php echo $fullSize; ?></option>
</optgroup>
</select>
</td>
</tr>
<tr>
<td width='25%'><font><b>Destination URL:</b></font></td><td width='75%'><input type='text' size='29' value='<?php echo $dest_url; ?>' name='dest_url'></td>
</tr>
<tr>
<td width='25%'><font><b>Banner location:</b></font></td><td width='75%'><font><i> ads/$id/</i></font><input type='hidden' value='ads/$id/' name='banner_path'><input type='text' value='<?php echo $bannerurl; ?>' size='21' name='banner'><font><a href='javascript:findimg(".$id.");'>Find Image!</a></font></td>
</tr>
<tr>
<td width='25%'><font><b>Banner's name:</b></font></td><td width='75%'><input type='text' value='<?php echo $bannersname; ?>' size='29' name='banners_name'></td>
</tr>
<tr>
<td> </td><td><div align='right'><input type='submit' value='Add'> </div></td>
</tr>
</table>
</form>
<?php
}
function updateMyAds(){
$dest_url = $_REQUEST['dest_url'];
$bannersname = $_REQUEST['banners_name'];
$banner_code = $_GET['code'];
$banner = $_REQUEST['banner'];
$banner_path = $_REQUEST['banner_path'];
$bannersurl = $banner_path."".$banner;
if(empty($dest_url) || empty($banner) || empty($bannersname)){
echo "<br><center><font class='error'>Please fill form correctly!</font></center><br>";
}else{
$query = "UPDATE banners SET gourl = '{$dest_url}', name = '{$bannersname}', url = '{$bannersurl}' WHERE banner_code = '{$banners_code}'";
$result = mysql_query($query);
if(!$result){
die("<font class='error'>Something is wrong: </font><font>".mysql_error()."</font>");
}else{
echo "<br><center><font>Banner updated! <a href='index.php?act=myads'>Go back to My ads!</a></font></center><br>";
}
}
}
and in index.php it will look like this:
...
if(isset($_GET['do']) && $_GET['do'] == "update"){
$action->updateMyAds();
}else{
$action->editMyads();
}
}else{
...
Problemo is that when i try to update my things in database.. then it wont..
i have tried everything.. asked from i don't know.. 2-3 whats wrong.. but they don't know.. maybe someone knows..


Sign In
Create Account

Guest_Jaan_*
Back to top










