on error want to keep value on update or insert

[rjusman90]

<?php
include"header.php";
if(empty($_SESSION['UserName'])){
header("Location:  login.php"); 
exit;}
$start=0;
$limit=5;
$page='';
$tbl_name="menu";       
$targetpage = "menu.php";   //your file name  (the name of this file)

if(isset($_POST['fullname'])){
$term=$_POST['fullname'];}
if(isset($_GET['page'])){
$page=$_GET['page'];
$start=($page-1)*$limit;
}
{
if(isset($_POST['Submit'])){
$query=mysql_query
("select * from $tbl_name  where MenuName like '%$_REQUEST[fullname]%' LIMIT $start, $limit");
$search_num_rows = mysql_num_rows($query);
echo "<div class='main'>";
echo"Found " .$search_num_rows. " results for " .$term."</div>";
}
else{
$query=mysql_query("select * from $tbl_name LIMIT $start, $limit");
}
$query_sting = "type=abc";
$url3="$targetpage?".$query_sting;

echo "<div class='main'>";
if(!isset($_GET['Id'])){
    if(!isset($_GET['type'])){
echo "<table border='0'>
<tr class='tableheader'>
<th><a href='$url3'>
<img src='images/create.png'>Add New </a></th>
<th>PageName</th>
<th>MenuName</th>
<th>ParentMenuId</th>
<th>LinkWidth</th>
<th>OtherUrl</th>
<th>Status</th>
<th>CreatedDate</th>
<th>OnMainMenu</th>
<th>FooterMenu</th>
<th>Delete</th>
</tr>";
while($row = mysql_fetch_array($query)) {
echo "<tr class='tablerow'>";
$query_sting = "Id={$row['ID']}";
$url1="$targetpage?".$query_sting;
echo "<td><a href='$url1'><img src='images/UPDATE.png'>Edit</a></td>";
$rpId=$row['PageID'];
$result1=mysql_query("SELECT * FROM page WHERE ID=$rpId  ");
$row1=mysql_fetch_array($result1);
if ($row['PageID'] == $row1['ID'])
echo "<td>" . $row1['Title']     . "</td>";
else if($row['PageID'] == '0')
echo "<td>Null</td>";
echo "<td>" . $row['MenuName']       . "</td>";
$parentmenuId=$row['ParentMenuID'];
$result2=mysql_query("SELECT * From $tbl_name WHERE ID=$parentmenuId");
$row2=mysql_fetch_array($result2);
if($row['ParentMenuID'] == '0')
echo "<td>Null</td>";
else
echo "<td>" . $row2['MenuName']      . "</td>";
echo "<td>" . $row['LinkWidth']  . "</td>";
if ($row['OtherUrl'] =='')
echo "<td>Null</td>";
else if($row['OtherUrl'] != '0')
echo "<td>" . $row['OtherUrl']       . "</td>";
if($row['Status'] == '1')
echo  "<td>active</td>";
else if($row['Status']=='0')
echo "<td>deactive</td>";
echo "<td>" . $row['CreatedDate'] . "</td>";
if($row['OnMainMenu'] == '1')
echo  "<td>Yes</td>";
else if($row['OnMainMenu']=='0')
echo "<td>No</td>";
if($row['FooterMenu'] == '1')
echo  "<td>Yes</td>";
else if($row['FooterMenu']=='0')
echo "<td>No</td>";   
$query_sting = "Id={$row['ID']}";
$url = " menu_delete.php?". $query_sting;
echo "<td><a href='$url' onclick='return checkDelete()'><img src='images/DELETE.png'  ></a></td>";
echo "</tr>";
}
echo "</table>";
$rows=mysql_num_rows(mysql_query("select * from $tbl_name"));
$total=ceil($rows/$limit);
echo "<ul class='page'>";
for($i=1;$i<=$total;$i++){
if($i==$page) {
echo "<li class='current'>".$i."</li>"; }
else {
echo "<li><a href='?page=".$i."'>".$i."</a></li>"; }
}
echo "</ul>";
if(isset($_POST['insert'])){

$Number     =$_POST['pagination'];
$Number=urlencode($Number);
header ("Location: $targetpage?page=$Number");
if ($Number >= $i || '0'){
header ("Location: $targetpage?page=1"); 
exit;
}}
echo"<form method='post' id='frm' name='frm' action='menu.php'>
    <table width='500' border='0'>
    <tr>
      <th>Search :</th>
      <td><input type='text'  name='fullname' id='fullname' /></td>
    </tr>
    <tr>
      <td><input type='submit' name='Submit' value='Search' /></td>
      <td>&nbsp;</td>
    </tr>
  </form>
  <form style='width:50%'  method='post' id='123' name='1234' action='' >
    <tr>
      <th>Go To Page:</th>
      <td><input type='text' value=''  name='pagination' class=''/></td>
    </tr>
    <tr>
      <td><input name='insert' type='submit' class='button' value='go'/></td>
      </table>
  </form>";
    }}}
$PageId=
$MenuName=
$ParentMenuId=
$LinkWidth=
$OtherUrl=
$Status1=
$CreatedDAte=
$FooterMenu=
$OnMainMenu=
$row=
$class=
$LinkWidth="";
if(isset($_GET['Id'])||isset($_GET['type'])){
$Id=$_GET['Id'];
$query = mysql_query("SELECT * FROM menu WHERE ID='$Id'");
$row = mysql_fetch_array($query);
$PageId=$row['PageID'];
$MenuName=$row['MenuName'];
$ParentMenuId=$row['ParentMenuID'];
$LinkWidth=$row['LinkWidth'];
$OtherUrl=$row['OtherUrl'];
$Status1=$row['Status'];
$OnMainMenu=$row['OnMainMenu'];
$FooterMenu=$row['FooterMenu'];

?>
<form style="width:100%"  method="post" id="form" >
  <table class="viewjob" align="center" ac>
    <tr class="tableheader">
      <td align="center" colspan="4"> Update </td>
    </tr>
    <tr class="tablerow">
      <td>Page Id</td>
      <td><select name='pageID' class="select">
          <option  value='0' >select any page</option>
          <?php

$sql10 = "SELECT ID,Title FROM page";
$val=$PageId?:'';
$rs = mysql_query($sql10) or die(mysql_error());
while($row = mysql_fetch_array($rs)){
$selected = ($val == $row['ID'] ? 'selected="selected"' : '');
echo '<option value ="' . $row['ID'] . '" '. $selected .'>' . $row['Title'] . '</option>';
}
mysql_free_result($rs);
?>
        </select></td>
      <td>Menu Name</td>
      <td><input type="text" value="<?php  echo $MenuName;?>"  name="menuname" class="inputbox validate[required]"/></td>
    </tr>
    <tr class="tablerow">
      <td>Parent Menu Id</td>
      <td><select name='parentmenuID' class="select">
          <option  value='0' >Non</option>
<?php

if(isset($_GET['Id'])){
$sql9="SELECT 
  * 
FROM
  menu 
WHERE   ID!=$Id";
$rs3 = mysql_query($sql9) or die(mysql_error());
while($row3 = mysql_fetch_array($rs3)){
$val3=$ParentMenuId?:'';
$selected3 = ($val3 == $row3['ID'] ? 'selected="selected"' : '');
echo '<option value ="' . $row3['ID'] . '"'. $selected3 . '>' . $row3['MenuName'] . '</option>';
}
mysql_free_result($rs3);
}
?>
</select></td>
      <td>Link Width</td>
      <td><select class="select" name="linkwidth" >
          <option  value="page" <?php if($LinkWidth = 'page'){ echo 'selected="selected"';}?>>Page</option>
          <option  value="otherlink" <?php if($LinkWidth = 'otherlink'){ echo 'selected="selected"';}?>>Other Link </option>
        </select></td>
    </tr>
    <tr class="tablerow">
      <td>OtherUrl</td>
      <td><input type="text" value="<?php  echo $OtherUrl;?>" name="otherurl" class=""/></td>
      <td>Status</td>
      <td><input class="validate[required] radio" type="radio" name="group0"  value="1" 
<?php if ($Status1 == 1): ?> checked="checked" <?php endif;?> />
        <span>Active </span>
        <input class="validate[required] radio" type="radio" name="group0"  value="0"
<?php if ($Status1 != 1): ?> checked="checked" <?php endif;?> />
        <span>De active </span></td>
    </tr>
    <tr class="tablerow">
      <td>OnMainMenu</td>
      <td><input  type="checkbox" name="onmainmenu" value="1"
<?php if($OnMainMenu == 1) echo "checked='checked'"; else("checked=''"); ?>  /></td>
      <td>Footer Menu</td>
      <td><input  type="checkbox" name="footermenu" value="1"
<?php if($FooterMenu == 1) echo "checked='checked'"; else("checked=''"); ?>  /></td>
    </tr>
    <tr class="tableheader">
      <td colspan="4" class="last"><input name="insert" type="submit" class="button" 
<?php if(!isset($_GET['Id'])){echo "value='Create New'";} else{echo "value='Update'";} ?> />
        <input name="reset" type="reset" class="button" value="Reset">
        <button type="button" onclick="history.back();" class="button">Back</button>  </td>
    </tr>
  </table>
</form>
<?php
date_default_timezone_set("Asia/Karachi");
if(isset($_POST['insert'])){
$Page_Id        =$_POST['pageID'];
$Menu_Name      =$_POST['menuname'];    
$ParentMenu_Id  =$_POST['parentmenuID'];
$Link_Width     =$_POST['linkwidth'];   
$Other_Url      =$_POST['otherurl'];
$State          =$_POST['group0'];
$Footer_Menu    =$_POST['footermenu'];
$OnMain_Menu    =$_POST['onmainmenu'];
if(isset($_REQUEST['linkwidth']) && $_REQUEST['linkwidth']  == 'page'){
if(isset($_REQUEST['pageID']) && $_REQUEST['pageID'] == '0'){
echo"Please Select Any Page";
die;
}   
}
if(isset($_REQUEST['linkwidth']) && $_REQUEST['linkwidth']  == 'otherlink'){
if(isset($_REQUEST['otherurl']) && $_REQUEST['otherurl'] == ''){ 
echo "Please Enter Other Url";
die;
}
}
if($Link_Width=='page'){
$Other_Url="";
}
elseif($Link_Width=='otherlink'){
$Page_Id="";
}
if (isset($Id)){
$sql="UPDATE menu SET PageId='$Page_Id' , MenuName='$Menu_Name', ParentMenuID='$ParentMenu_Id',LinkWidth='$Link_Width',OtherUrl='$Other_Url'
,Status='$State',FooterMenu='$Footer_Menu',OnMainMenu='$OnMain_Menu' WHERE ID='$Id'";
if (!mysql_query($sql)){
die('Error: '. mysql_error());
}
echo "Sucessfully Updated";
header("Location: menu.php"); 
exit;
}
else{
$query = mysql_query("SELECT MenuName FROM menu WHERE MenuName='$Menu_Name'");
if (mysql_num_rows($query) != 0){
die( "Menu Name already exists");
}
$sql1="INSERT INTO menu ( PageId , MenuName , ParentMenuID , LinkWidth ,OtherUrl , Status, FooterMenu, OnMainMenu )
VALUES ('$Page_Id','$Menu_Name','$ParentMenu_Id','$Link_Width','$Other_Url','$State','$Footer_Menu','$OnMain_Menu')";
if (!mysql_query ( $sql1)){
die('Error: ' . mysql_error());
}
echo "Sucessfully Registers";
mysql_close();
header("Location: menu.php"); 
exit;
}}
}
include "footer.php";
?>

[pritaeas]

on error want to keep value on update or insert

You'll need to be more specific.

[rjusman90]

want to retain or keep the value of textbox when error occur

You can keep the data in a session variable. Or even in a url querystring - but that's ugly.

[rjusman90]

any body knows postback php here i want to do it through postback in php

Your code is not indented to any useful degree, so it is very difficult to read. When you say "postback" what do you mean? It can have a few meanings.

I'm assuming that you're passing data from a form via POST to a different file for processing, on failure, there's a redirect (header) to the form page again. So you want all the POST vars sent to the redirected page so that the user does not have to start again. Am I correct?

You could do this...

$_SESSION['bad_form'] = $_POST;

Obviously you must have session_start() at the top of every page for this to work.

In your form page you can then have something like...

$frmData = array("name"=>"","email"=>"");

if(isset($_SESSION['bad_form']))
{
    foreach($_SESSION['bad_form']['data'] as $key=>$value)
    {
        $frmData[$key] = $value;
    }
    unset($_SESSION['bad_form']);
}

Just an idea, what you do with those values will depend upon the type of data, e.g. text, checkbox, optionbutton, select (even multiselect), etc.