edit data

40 New Member

i need to edit data from the databse through a form.my code is below

Expand|Select|Wrap|Line Numbers

 
<?php

require_once "../inc/functions.php";

require_once "../inc/vars.inc.php";

sessionCheck();

session_start();
 
$old_sessionid = session_id(); //i've added these lines
 
session_regenerate_id(); //i've added these lines
 
$new_sessionid = session_id(); //i've added these lines

?>

<?php include_once "admin_templates/case_header.php"; ?>
 
<html>

<head>

<title>Untitled Document</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>
 
<body>

<?php

$query="select * from designation where designation='Minister'";

$exe=caseQuery($query);

if(mysql_num_rows($exe))

{

$output ='<table  border="1">

<tr><td>Name</td><td>Designation</td><td>Date of Appointment</td><td>Phone Office</td><td>Mobile</td><td>Residence</td><td>District</td><td>Taluka</td>

<td>Panchayat Name</td><td>Panchayat Address</td><td>Edit</td></tr>';

$res=@mysql_fetch_object($exe);

$id=$res->sr_no;

$output .='<tr><td>'.$res->name.'</td><td>'.$res->designation.'</td><td>'.$res->dte.'</td><td>'.$res->ph_o.'</td><td>'.$res->ph_m.'</td><td>'.$res->ph_r.'</td><td>'.$res->district.'</td><td>'.$res->taluka.'</td><td>'.$res->pan_name.'</td><td>'.$res->pan_addr.'</td><td><a href="info.php?cmd=edit&id=$id">Edit</a></td></tr>';
 
}

$output .= '</table>';

echo "$output";
 
?>

<?

if($_GET["cmd"]=="edit")

{

$sql="select * from designation where designation='Minister'";

    $resl = caseQuery($sql);

    $result=mysql_fetch_array($resl);

    $name=$result["name"];

    $dsg=$result["designation"];

    $dt=$result["dte"];

    $ph_o=$result["ph_o"];

    $ph_m=$result["ph_m"];

    $ph_r=$result["ph_r"];

    $dis=$result["district"];

    $tal=$result["taluka"];

    $name=$result["pan_name"];

    $addr=$result["pan_addr"];

     }

?>
 
</body>

</html>

on clicking edit a form should appear where i can edit the details.any idea how i can go about it?

Feb 22 '10 #1

Subscribe Reply

2695

dlite922

1,584

Recognized Expert Top Contributor

Do you know how to create HTML forms?

Dan

Feb 22 '10 #2

lisles

New Member

hey,i've worked on the code.managed to create he from on clicking edit.but after i edit and click the update button,the update doesnt take place.my code is below:

Expand|Select|Wrap|Line Numbers

 
<?php

require_once "../inc/functions.php";

require_once "../inc/vars.inc.php";

sessionCheck();

session_start();
 
$old_sessionid = session_id(); //i've added these lines
 
session_regenerate_id(); //i've added these lines
 
$new_sessionid = session_id(); //i've added these lines

function getdsgType(){

    global $desig;

    $output = '<select name="dsgn" id="dsgn">';

    $output .= '<option value="">Designation</option>';    

    foreach($desig as $k=> $v){

        if($_POST['dsgn'] == $k){

            $output .= '<option value="'.$k.'" selected>'.$v.'</option>';

        }else{

            $output .= '<option value="'.$k.'">'.$v.'</option>';        

        }

    }

    $output .= '</select>';

    return $output;

}

?>
 
<?php include_once "admin_templates/case_header.php"; ?>
 
<html>

<head>

<title>Untitled Document</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>
 
<body>

<?php

$query="select * from designation where designation='Minister'";

$exe=caseQuery($query);

if(mysql_num_rows($exe))

{

$output ='<table  border="1">

<tr><td>Name</td><td>Designation</td><td>Date of Appointment</td><td>Phone Office</td><td>Mobile</td><td>Residence</td><td>District</td><td>Taluka</td>

<td>Panchayat Name</td><td>Panchayat Address</td><td>Edit</td></tr>';

$res=@mysql_fetch_object($exe);

$id=$res->sr_no;

$output .='<tr><td>'.$res->name.'</td><td>'.$res->designation.'</td><td>'.$res->dte.'</td><td>'.$res->ph_o.'</td><td>'.$res->ph_m.'</td><td>'.$res->ph_r.'</td><td>'.$res->district.'</td><td>'.$res->taluka.'</td><td>'.$res->pan_name.'</td><td>'.$res->pan_addr.'</td><td><a href="info.php?cmd=edit&id=$id">Edit</a></td></tr>';
 
}

$output .= '</table>';

echo "$output";
 
?>

<?

if($_GET["cmd"]=="edit")

{

$sql="select * from designation where designation='Minister'";

    $resl = caseQuery($sql);

    $result=mysql_fetch_array($resl);

    $id=$result["sr_no"];

    $name=$result["name"];

    $dsg=$result["designation"];

    $dt=$result["dte"];

    $ph_o=$result["ph_o"];

    $ph_m=$result["ph_m"];

    $ph_r=$result["ph_r"];
 
    echo "<form ENCTYPE=\"multipart/form-data\" action=\"".$_SERVER['PHP_SELF']."\" method=\"post\" name=\"src_frm\">";

    echo "Sr_no:";

    echo "<input type=\"text\" value=\"".$result["sr_no"]."\" maxlength=\"64\" readonly name=\"id\" size=\"25\" /><br />";

    echo "<br/>";
 
    echo "Name:";

    echo "<input type=\"text\" value=\"".$result["name"]."\" maxlength=\"64\" name=\"name\" size=\"25\" /><br />";

    echo "<br/>";
 
    echo "Designation:";

    $query=caseQuery("select designation from dsg");

    echo "<select name='dsgn' ><option value=''>Select one</option>";

    while($noticia = mysql_fetch_array($query)) { 

    echo  "<option value='$noticia[designation]'>$noticia[designation]</option>";

     }

    echo "</select>";

    echo "<br/>";

    echo "<br/>";
 
    echo "Phone office:";

    echo "<input type=\"text\" value=\"".$result["ph_o"]."\" maxlength=\"64\" name=\"office\" size=\"25\" /><br />";

    echo "<br/>";
 
    echo "Mobile:";

    echo "<input type=\"text\" value=\"".$result["ph_m"]."\" maxlength=\"64\" name=\"mobile\" size=\"25\" /><br />";

    echo "<br/>";
 
    echo "Residence:";

    echo "<input type=\"text\" value=\"".$result["ph_r"]."\" maxlength=\"64\" name=\"res\" size=\"25\" /><br />";

    echo "<br/>";

    echo "<button type=\"submit\" name=\"submit\">Update</button>";

    echo "</form>";
 
    echo "PLEASE LEAVE THE MOBILE NUMBER AND RESIDENCE NUMBER FIELD BLANK IF THERE IS NO NUMBER.<br/>";
 
    if($_POST['submit']){

    $id=escape($_POST['id']);

    $name = escape($_POST['name']);

    $desg = escape($_POST['dsgn']);    

    $ph_o= escape(trim($_POST['office']));

    $ph_mob = escape($_POST['mobile']);

    $ph_res = escape($_POST['res']);

    echo "$id";

    $errCnt = 0;

    if(!$name)

    {

    $msg[] = "<h5>PLEASE ENTER A NAME</h5>";

    $errCnt++;

    }

    else

    if(!ctype_alpha($name))

    {$msg[] = "<h5>YOU CAN ENTER ONLY ALPHABETS</h5>";

    $errCnt++;

    }
 
    if(!$desg)

    {

    $msg[] = "<h5>PLEASE SELECT A DESIGNATION</h5>";

    $errCnt++;;

    }
 
    if(!$ph_o)

    {

    $msg[] = "<h5>PLEASE ENTER THE OFFICE PHONE NUMBER</h5>";

    $errCnt++;

    }

    else

    if(!is_numeric($ph_o))

    {

    $msg[] = "<h5>THE OFFICE PHONE NUMBER CAN ONLY HAVE NUMBERS</h5>";

    $errCnt++;

    }
 
    if(!$ph_mob)

    {

    $ph_mob="---- ";

    }

    else if(!is_numeric($ph_mob))

    {

    $msg[] = "<h5>THE MOBILE NUMBER CAN ONLY HAVE NUMBERS</h5>";

    $errCnt++;

    }
 
    if(!$ph_res)

    {

    $ph_res="----";

    }

    else if(!is_numeric($ph_res))

    {

    $msg[] = "<h5>THE RESIDENCE NUMBER CAN ONLY HAVE NUMBERS</h5>";

    $errCnt++;

    }
 
    $check="SELECT * FROM dsg, designation WHERE dsg.dsg_id BETWEEN 1 AND 7 AND designation.pan_name='".$vil_n."'

     AND dsg.designation = designation.designation";

    $chk=caseQuery($check);

    if(mysql_num_rows($chk))

    {

    $message= "you already have a entry for this panchayat";

    }
 
    if($errCnt == 0 && !message){

    $sql='UPDATE `designation` SET  `name`="'.$name.'",`designation`="'.$desg.'",`ph_o`="'.$ph_o.'", `ph_m`="'.$ph_mob.'",`ph_r`="'.$ph_res.'" WHERE sr_no="'.$id.'"';
 
            $dist = caseInsertQuery($sql);

            if($dist)

            {

            $ms= "<b>THE DATA HAS BEEN ADDED SUCCESFULLY</b>";

            }

            else

            {

            $ms= "<b>THE DATA COULD NOT BE ADDED</b>";

            }

            }

            else

            {

            $msgs = addslashes(@implode("<br>",$msg));

            }

    }

echo "$msgs";

echo "$ms";

echo "$message";

     }
 
?>
 
</body>

</html>

Feb 23 '10 #3

lisles

New Member

i've changed my code a lil.but still having some problem.once i edit the data and click submit,nothing appens-the data doesnot get updated.my code is

Expand|Select|Wrap|Line Numbers

 
<?php

require_once "../inc/functions.php";

require_once "../inc/vars.inc.php";

sessionCheck();

session_start();
 
$old_sessionid = session_id(); //i've added these lines
 
session_regenerate_id(); //i've added these lines
 
$new_sessionid = session_id(); //i've added these lines

function getdsgType(){

    global $desig;

    $output = '<select name="dsgn" id="dsgn">';

    $output .= '<option value="">Designation</option>';    

    foreach($desig as $k=> $v){

        if($_POST['dsgn'] == $k){

            $output .= '<option value="'.$k.'" selected>'.$v.'</option>';

        }else{

            $output .= '<option value="'.$k.'">'.$v.'</option>';        

        }

    }

    $output .= '</select>';

    return $output;

}

?>
 
<?php include_once "admin_templates/case_header.php"; ?>
 
<html>

<head>

<title>Untitled Document</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>
 
<body>

<?php
 
if(!isset($cmd)) 

{

   //display all the news

   $result = caseQuery("SELECT * 

FROM dsg, designation

WHERE dsg.dsg_id

BETWEEN 1 

AND 7 

AND dsg.designation = designation.designation order by dsg.dsg_id"); 

   $rows=mysql_num_rows($result);

   if($rows)

{

echo "<div style='padding-left:20px;'><table style='border-collapse:collapse; border-color:#000' border='1' cellspacing='0' cellpadding='5' width='400'>";

        echo "<tr><td width='150'>Id</td><td width='100'>Name</td><td width='60'>Designation</td><td width='150'>Office</td><td width='150'>Mobile</td><td width='150'>Res</td><td>Edit</td></tr>";

        for($i=1;$i<=$rows;$i++) {

            $r=mysql_fetch_array($result); 

        $id=$r["sr_no"];

echo "<tr><td>{$r['sr_no']}</td><td>{$r['name']}</td><td>{$r['designation']}</td><td>{$r['ph_o']}</td><td>{$r['ph_m']}</td><td>{$r['ph_r']}</td><td><a href='edit.php?cmd=edit&id=$id'>Edit</a></td></tr>";

        echo "";

        }

        echo "</table></div>";

}}

?>
 
<?

if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")

{

   if (!isset($_POST["submit"]))

   {

      $id = $_GET["id"];

      echo "$id";

      $sql = "SELECT * FROM  designation WHERE sr_no=$id";

      $result = caseQuery($sql);        

      $myrow = mysql_fetch_array($result);

      ?>
 
      <form action="edit.php" method="post">

      <input type=hidden name="id" value="<?php echo $myrow["sr_no"] ?>">
 
      Name:<INPUT TYPE="TEXT" NAME="name" VALUE="<?php echo $myrow["name"] ?>" SIZE=30><br>

      Designation:<?php

  $query=caseQuery("select designation from dsg");

echo "<select name='dsgn' ><option value=''>Select one</option>";

while($noticia = mysql_fetch_array($query)) { 

echo  "<option value='$noticia[designation]'>$noticia[designation]</option>";

}

echo "</select>";

?><br>

     Phone Office:<INPUT TYPE="TEXT" NAME="ph_o" VALUE="<?php echo $myrow["ph_o"] ?>" SIZE=30><br>

    Phone Mobile:<INPUT TYPE="TEXT" NAME="ph_m" VALUE="<?php echo $myrow["ph_m"] ?>" SIZE=30><br>

     Phone Residence:<INPUT TYPE="TEXT" NAME="ph_r" VALUE="<?php echo $myrow["ph_r"] ?>" SIZE=30><br>

      <input type="hidden" name="cmd" value="edit">
 
      <input type="submit" name="submit" value="submit">
 
      </form>
 
   <? } ?>
 
   <?

   if ($_POST["$submit"])

   {

      $name = $_POST["name"];

      $dsgn = $_POST["dsgn"];

      $ph_o = $_POST["ph_o"];

      $ph_m = $_POST["ph_m"];

      $ph_r = $_POST["ph_r"];

      $id=$_POST["id"];

      $sql = "UPDATE designation SET name='$name',designation='$dsgn',ph_o='$ph_o',ph_m='$ph_m',ph_r='$ph_r' WHERE sr_no=$id";
 
      $result = caseQuery($sql);

      if($result)

      {

      echo "Thank you! Information updated.";

      }

      else

      {

      echo "cannot update your data";

      }

   }

}

?>
 
</body>

</html>

please please help me some one.i need the code urgently

Feb 23 '10 #4

Similar topics

2051

edit/update - all in one PHP pages?

by: Jim | last post by:

Hi, Let me explain how I'd generally do things. For a page where the user edits data, I'd generally call it something like editfred.php (for example), the page which updates the data would be called updatefred.php and equally the page which processes a delete would be deletefred.php. I like splitting the pages up this way, it feels less cluttered and more organised than throwing all the functionality in one fred.php.

PHP

2149

Beginner: Can a form edit identical data from more than one table?

by: Terry | last post by:

I need some help refining an MS 2000 relational databse. I have created a simple relational database using two tables, 'Student Details', 'Exam Details' and two forms, 'Input/Edit Exam Details', 'Input/Edit Student Details'. 'Student Details' has a field called 'Log Book No' (no duplicates allowed) and this is the Primary Key. 'Exam Details' also has a field called 'Log Book No' (duplicates allowed) and has no Primary Key, (as each...

Microsoft Access / VBA

3120

Use the DataList Control to Present and Edit Data

by: Alex | last post by:

Interested in more .NET stuff visit www.dedicatedsolutions.co.uk The DataList is not as powerful as the DataGrid. It requires more work from you since it has no default data presentation format. However, the DataGrid begins to get very cumbersome as the number of columns of data you present increases. Anything more than half a dozen columns or so and you probably induce horizontal scrolling - a real no-no for me. If you put such a...

ASP.NET

1769

Use the DataList Control to Present and Edit Data PART 2

by: Alex | last post by:

Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Configuration Public Class Main : Inherits Page Private strConn As String =

ASP.NET

3481

Masked edit control and database (.NET)

by: Kostis | last post by:

Hello there! I have created a windows application in VB.NET and I want to retrieve data from an access database. I create the OleDbConnection, an OleDbAdapter, a dataset and finally a Data Form using the Data Form Wizard. Everything works fine. The problem is that I want to use the masked edit control to manage the way some fields appear, and are being stored to the database. I insert the "Microsoft Masked Edit Control, version 6.0" (Path...

Visual Basic .NET

2734

DataGrid Edit Problem

by: rn5a | last post by:

A Form has a DataGrid which displays records from a SQL Server 2005 DB table. Users can modify the records using this DataGrid for which I am using EditCommandColumn in the DataGrid. This is the code: <script runat="server"> Dim sqlConn As New SqlConnection(".....") Sub Page_Load(ByVal obj As Object, ByVal ea As EventArgs) If Not (Page.IsPostBack) Then FillDataGrid()

ASP.NET

7756

Update or CancelUpdate without AddNew or Edit

by: bhcob1 | last post by:

Hey guys, 'Update or CancelUpdate without AddNew or Edit' On my database i keep occasionly get this error when i try and edit a field, it is not everytime. It will be working fine and then this error appears. I will be editing records and then a random one will get the error. A bit of background on my form, this will seem a bit lengthy but here is my code. The form has a navigation list which the user can select a record to view. An...

Microsoft Access / VBA

1997

Breaking out a record with in a datagrid to edit it (ASP 1)

by: =?Utf-8?B?bWlrZWc=?= | last post by:

Hi, I am building a small Help Desk application for my company and need to be able to edit "open" help desk issues. I use a simple datagrid to display each issue (6 per page) , with an Edit button. There are a lot of fields across, and my Network Admins would like a way of editing/updating each issue seperately in a a vertical form. I need a way of clicking on the edit button ,bringing up a form with the record, editng the fields, and...

ASP.NET

2168

EDIT product but OPTION not showing all Categories

by: ollielaroo | last post by:

Hi guys, Firstly I did do a search for this one first but I couldn't find anything related in this forum. I am using Dreamweaver MX and trying to build admin pages for an ASP site. My problem is I have Categories and various Products in each Category. I'm trying to build a page to EDIT/UPDATE each product.I want to be able to change the Category that a product belongs to, but all I get in the drop-down menu is the one specific Category. ...

ASP / Active Server Pages

3333

OOP: Problem with edit form

by: chromis | last post by:

Hi, I'm having trouble fully implementing the edit section of a contact admin system, so far I have written the following: - Bean (Contact.cfc) - Data Access object (ContactDAO.cfc) - Gateway (ContactGateway.cfc) - index.cfm - Deals with the business logic - display/form.cfm - Produces the form for both add and edit behaviour

ColdFusion

9724

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9604

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10644

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10127

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9201

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7665

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5552

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5690

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3863

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP