ADD/EDIT/DELETE ALL RUNNING at same time

232 100+

this is just a simple form
department log in
a page displays employees
on this page you may add edit delete employee
but the problem is that my add/edit/delete all option are running at same time even after passing correct variables
please help
homedisp.php

Expand|Select|Wrap|Line Numbers

 <HTML>

<HEAD>

<TITLE="cccc SALARY">

<?php 

SESSION_START();

include ("conn.php");

include ("HEADER.php");

//exit;

IF (ISSET($_SESSION['deptno']))

{

//$deptno="";$RS="";

$deptno=$_SESSION['deptno'];

//ECHO $deptno;

//EXIT;

            $qi="SELECT * FROM PAYMST WHERE DEPTno=$deptno";

            $RESULT=mysqli_query($conn,$qi);
 
//$CONN->CLOSE();

echo "<BODY>";

echo "<TABLE BORDER='1'>";

echo "<TH>cccc SALARY INFORMATION UPDATE</TH>";

WHILE($RS=MYSQLI_FETCH_ARRAY($RESULT))

{

?>
 
<TR><TD><?PHP ECHO $RS['ECODE'] ?></TD><TD><?PHP ECHO $RS['NAME'] ?></TD><TD><A HREF='INDEX.PHP?STRACTION=ADD'>ADD</A></TD>

<TD><A HREF="INDEX.PHP?STRACTION=EDIT & ECODE=<?PHP ECHO $RS['ECODE'] ?>">EDIT</A></TD>

<TD><A HREF="INDEX.PHP?STRACTION=DELETE & ECODE=<?PHP ECHO $RS['ECODE'] ?>">DELETE</A></TD></TR>
 
<?PHP

}

}

ELSE

{

    ECHO "<META HTTP-EQUIV='REFRESH' CONTENT='0 URL=SALLOGIN.PHP'>";

}

?>

</TABLE>

</BODY>

</TITLE>

</HEAD>

</HTML>

index.php

Expand|Select|Wrap|Line Numbers

 <HTML>

<HEAD>

<TITLE="cccc SALARY">

<?php 

SESSION_START();

include ("conn.php");

include ("HEADER.php");

//$STRACTION="";

$ECODE=$NAME="";

//exit;

IF (ISSET($_SESSION["deptno"]))

{

    $DEPTNO=$_SESSION["deptno"];
 
IF(ISSET($_GET["STRACTION"]))

    {

        //ECHO "hhhh";

        //EXIT;    

        $STRACTION=$_GET["STRACTION"];

        ECHO $STRACTION;

      // EXIT;        

    }
 
IF($_SERVER["REQUEST_METHOD"]="POST" AND ISSET($_POST["SUBMIT"]))

{
 
FUNCTION TESTINPUT($DATA)

{

    $DATA=TRIM($DATA);

    $DATA=STRIPSLASHES($DATA);

    $DATA=HTMLSPECIALCHARS($DATA);

    RETURN $DATA;

}

    $ECODE=TESTINPUT($_POST["TXTECODE"]);

    $NAME=TESTINPUT($_POST["TXTNAME"]);
 
        IF ($STRACTION="ADD")

        {

            $qi="INSERT INTO PAYMST (ECODE,NAME,DEPTNO) VALUES ('$ECODE','$NAME',$DEPTNO)";
 
            IF($result=mysqli_query($conn,$qi))

        {

            ECHO "<br/> VALUE INSERTED SUCCESSFULLY";

        }
 
        }

        IF ($STRACTION="EDIT")

        {
 
            $qi="UPDATE PAYMST SET NAME='$NAME' WHERE ECODE='$ECODE' ";
 
            IF(mysqli_query($conn,$qi))

        {

            ECHO "<br/> VALUE UPDATED SUCCESSFULLY";

        }
 
        }

        IF ($STRACTION="DELETE")

        {

            $qi="DELETE FROM PAYMST WHERE ECODE='$ECODE' ";
 
            IF(mysqli_query($conn,$qi))

        {

            ECHO "<br/> VALUE DELETED SUCCESSFULLY";

        }
 
        }
 
//$CONN->CLOSE();
 
}

   IF ($STRACTION="EDIT")

        {

            if(isset($_GET['ECODE']))

            {

                echo "hhhh";

                //exit;

            $ECODE=$_GET['ECODE'];

            }

            $qi="SELECT * FROM PAYMST WHERE ECODE='$ECODE'";
 
            IF($RESULT=mysqli_query($conn,$qi))

         {

            WHILE($RS=MYSQLI_FETCH_ARRAY($RESULT))

            {

                $ECODE=$RS['ECODE'];

                $NAME=$RS['NAME'];

            }
 
         }

        }

    else    

        {

            $ECODE="";

            $NAME="";

        }
 
?>

<BODY>

<form name="a" method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">

<TABLE>

<TH>cccc SALARY INFORMATION UPDATE</TH>

<TR><TD>ECODE</TD><TD><INPUT TYPE="TEXT" NAME="TXTECODE" VALUE="<?PHP ECHO $ECODE; ?>"></TD></TR>

<TR><TD>NAME</TD><TD><INPUT TYPE="TEXT" NAME="TXTNAME" VALUE="<?PHP ECHO $NAME; ?>"></TD></TR>

<TR><TD><INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT"></TD></TR>
 
</form>

<?PHP

}
 
ELSE

{

    ECHO "<META HTTP-EQUIV='REFRESH' CONTENT='0 URL=SALLOGIN.PHP'>";

}

?>

</TABLE>

</BODY>

</TITLE>

</HEAD>

</HTML>

Feb 8 '15 #1

Subscribe Post Reply

1217

Claus Mygind

571

512MB

Your using a single = instead of ==. The result you are setting the value of the variable instead of testing the value of the variable

Expand|Select|Wrap|Line Numbers

IF ($STRACTION="ADD")

this should be

Expand|Select|Wrap|Line Numbers

IF ($STRACTION=="ADD")

also I would get rid of the blank space in the anchor link

Expand|Select|Wrap|Line Numbers

 
 <TD><A HREF="INDEX.PHP?STRACTION=EDIT&ECODE=<?PHP ECHO $RS['ECODE'];?>">EDIT</A></TD>

Feb 16 '15 #2

Similar topics

Multiple Users Running Same Query

by: Jeremy | last post by:

I have built a form that calls queries. I have the first 2 set up as select queries, and the third set up as a make table query. When multiple users are on this application at the same time, they...

Microsoft Access / VBA

one page to edit, delete, and add data to a database

by: Qnavry | last post by:

I am creating one page to edit, delete, and add data to a database. The Add code works but the Edit and Delete do not. What am I doing wrong? If you need more code let me know. Thanks Code:...

ASP.NET

Add, Edit, Delete

by: Smudger | last post by:

I've succesfully connected my MS Access Database to my .NET app and can view / navigate records. What I would like to do now though is perform add, edit & delete functions on these records is...

Visual Basic .NET

Can't edit, delete or add row in an Access database in a website 2

by: dennist685 | last post by:

Can't edit, delete or add row in an Access database in a website 2003 When I implement a walkthrough using Northwind I have no trouble doing this. Also, in a windowsforms project I have no...

ASP.NET

Attempting to change same data same time

by: Darryl | last post by:

I have an Access 2003 front-end tied via ODBC to a SQL Anywhere 8 back-end. When I open a table & try to delete a record in a certain table, I get: "The Microsoft Jet database engine stopped...

Microsoft Access / VBA

delete record same time move record to new table

by: subashini Thiyagarajan | last post by:

hi, i want to delete a record.hope it is very easy.but same time i want to move the deleted record in to new table for report generation in future. i succeeded in deleting the record along with...

ASP / Active Server Pages

Insert query firing Insert & Update trigger at the same time.

by: abhi81 | last post by:

Hello All, I have a table on which I have created a insert,Update and a Delete trigger. All these triggers write a entry to another audit table with the unique key for each table and the timestamp....

Microsoft SQL Server

Disable edit/delete from formview in asp.net

by: TT | last post by:

Hello. I'm working in asp.net and i need to disable the edit/delete functionality from a frmview component. help me.thang you! my ACL sub: Protected Sub Page_Load(ByVal sender As Object,...

ASP.NET

Exposing Web Services methods for Add/Edit/Delete Records

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

Hello, I have a client c# application from which I want to Add/Edit/Delete & list records by connecting to Web Service. HOw can I write classes & methods in Web service projet that will : ...

.NET Framework

Insert query firing Insert & Update trigger at the same time

by: magnolia | last post by:

i created a trigger that will record the changes made to a table .everything works fine except the insert query.whenerever i try to insert a record it fires insert and update triger at the same time...

Microsoft SQL Server

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

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...

General

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...

Microsoft Access / VBA