php update code |

<?php
include(“connection.php”);
//@extract($_POST);
if($_SESSION[“UserId”]==””)
{
$_SESSION[“lgnError”] = “<p class=\”lgnShowError\” id=\”errUserId\”>Please login…</p>”;
$_SESSION[“lgnError”] = $_SESSION[“lgnError”].”<p class=\”lgnError\” id=\”errPassword\”></p>”;
header(“Location:index.php”);
}

?>
<?php
if(isset($_POST[‘submit1’])&&$_GET[‘action’]==’update’)
{
$catid=$_POST[‘catid’];
$id123=$_GET[‘news_id’];
$newstitle=$_POST[‘newstitle’];
$description=$_POST[‘editor1’];
$img=$_FILES[‘image’][‘name’];
date_default_timezone_set(“Asia/Calcutta”);
mysql_query(“SET SESSION time_zone = ‘+5:30′”);

if($img!=””) {
move_uploaded_file($_FILES[“image”][“tmp_name”],
“newsimages/” . $_FILES[“image”][“name”]);
$upsql=mysql_query(“UPDATE news SET title=’$newstitle’, description=’$description’, image=’$img’, updatedate= now(), cat_id=’$catid’ WHERE news_id =’$id123′”);
header(“location:viewnews.php”);
}
else{
$upsql=mysql_query(“UPDATE news SET title=’$newstitle’, description=’$description’, updatedate= now(), cat_id=’$catid’ WHERE news_id =’$id123′”);
header(“location:viewnews.php”);

}

}
?>
<!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>Admin Upload </title>
<link href=”css/style.css” rel=”stylesheet” type=”text/css” />
<link rel=”stylesheet” href=”Uploadify-scriptData-Sample/uploadify/uploadify.css” type=”text/css” />
<script type=”text/javascript” src=”Uploadify-scriptData-Sample/js/jquery-1.3.2.min.js”></script>
<script type=”text/javascript” src=”Uploadify-scriptData-Sample/js/jquery.uploadify.js”></script>
<link rel=”stylesheet” href=”uploadify/uploadify.css” type=”text/css” />
<script type=”text/javascript” src=”ckeditor.js”></script>
<script type=”text/javascript”>
function validateForm()
{
var x=document.forms[“form1”][“main_id”].value;
if (x==”)
{
alert(“Please Select value from Sub Category”);
return false;
}

}
</script>

$(“#fileUpload3″).fileUpload({
‘uploader’: ‘uploadify/uploader.swf’,
‘cancelImg’: ‘uploadify/cancel.png’,
‘script’: ‘upload.php’,
‘folder’: ‘files’,
‘fileDesc’: ‘Image Files’,
‘fileExt’: ‘*.jpg;*.jpeg;*.gif;*.png’,
‘multi’: true,
‘auto’: true
});
});

</script>
<script type=”text/javascript”>
var timeout = 500;
var closetimer = 0;
var ddmenuitem = 0;

function jsddm_open()
{ jsddm_canceltimer();
jsddm_close();
ddmenuitem = $(this).find(‘ul’).eq(0).css(‘visibility’, ‘visible’);}

function jsddm_close()
{ if(ddmenuitem) ddmenuitem.css(‘visibility’, ‘hidden’);}

function jsddm_timer()
{ closetimer = window.setTimeout(jsddm_close, timeout);}

function jsddm_canceltimer()
{ if(closetimer)
{ window.clearTimeout(closetimer);
closetimer = null;}}

$(document).ready(function()
{ $(‘#jsddm > li’).bind(‘mouseover’, jsddm_open);
$(‘#jsddm > li’).bind(‘mouseout’, jsddm_timer);});

document.onclick = jsddm_close;
</script>
<script type=”text/javascript”>
var timeout = 500;
var closetimer = 0;
var ddmenuitem = 0;

function jsddm_open()
{ jsddm_canceltimer();
jsddm_close();
ddmenuitem = $(this).find(‘ul’).eq(0).css(‘visibility’, ‘visible’);}

function jsddm_close()
{ if(ddmenuitem) ddmenuitem.css(‘visibility’, ‘hidden’);}

function jsddm_timer()
{ closetimer = window.setTimeout(jsddm_close, timeout);}

function jsddm_canceltimer()
{ if(closetimer)
{ window.clearTimeout(closetimer);
closetimer = null;}}

$(document).ready(function()
{ $(‘#jsddm > li’).bind(‘mouseover’, jsddm_open);
$(‘#jsddm > li’).bind(‘mouseout’, jsddm_timer);});

document.onclick = jsddm_close;
</script>
</head>
<body>
<div id=”wrapper”>
<? include(“includes/header.php”);?>
<div class=”middle”>
<div class=”login-middle”>
<div style=”height:30px; width:980px;”></div>
<? $id12=$_GET[‘news_id’];

$query1 = mysql_query(“SELECT * FROM news where news_id=’$id12′”);
$updrest=mysql_fetch_array($query1); ?>

<form id=”form1″ name=”form1″ method=”post” action=”newsupdate.php?action=update&news_id=<? echo $id12; ?>” enctype=”multipart/form-data”>
<input type=”hidden” value=”” />
<div class=”admin-upload”>
<? include(“includes/menu.php”);?>
<div class=”clear”></div>
<div class=”article”>
<div class=”article-upload”>
<span>News Update:</span>
<hr class=”color”/>

<table class=”table-form1″ cellspacing=”10″ cellpadding=”10″>
<tr class=”color1″>
<td> Category:</td>
<td> <label for=”textfield”></label>
<select name=”catid” class=”vechile”>
<option selected=”selected” value=”<?=$updrest[‘cat_id’]?>”><?=$updrest[‘cat_id’];?></option>
<option value=””>–Select Category–</option>
<?php
$sqlc=mysql_query(“select * from news”);
while($rowc=mysql_fetch_array($sqlc))
{
$idc=$rowc[‘cat_id’];

echo ‘<option value=”‘.$idc.'”>’.$idc .'</option>’;
}
?>
</select>
</td>
</tr>
<tr class=”color1″>
<td >Title :</td>
<td><input type=”text” name=”newstitle” value=”<? echo $updrest[‘title’]; ?>” size=”120px” /> </td>
</tr>
<!–<tr class=”color1″>
<td >Description:</td>
<td><textarea id=”editor1″ name=”editor1″><? echo $updrest[‘description’]; ?></textarea><script type=”text/javascript”>
CKEDITOR.replace( ‘editor1’,{ filebrowserUploadUrl: ‘http://127.0.0.1/h2o/uploader/upload.php’} );
</script> </td>
</tr>–>

<tr class=”color1″>
<td >Image</td>
<td> <input type=”file” id=”image” name=”image” tabindex=”23″ /> <img src=”newsimages/<?php echo $updrest[‘image’];?>” width=”100″ title=”<?php echo $row[‘title’];?>” /></td>
</tr>
<tr class=”color1″>
<td > </td>
<td><label for=”textfield”></label>
<input type=”submit” name=”submit1″ id=”submit1″ value=”Update” /></td>
</tr>
</table>
</div>

</div>
<div class=”clear”></div>
</div>
<div class=”clear”></div>
</form>
</div>
<div class=”clear”></div>

</div>
</div>
</body>
</html>