I want to save newpassword into database

10 New Member

Expand|Select|Wrap|Line Numbers

  
<html>
 
<head>

  <style type="text/css">

  h2{color:#A02820}

  </style>
 
</head>
 
<script language=javascript>

 function fnNew_Retype_Pswd()

        {

              var pass1 = document.useredit.txtEmployeeNewPassword.value;

              var pass2 = document.useredit.txtEmployeeRetypePassword.value;
 
                 if(document.useredit.txtEmployeeNewPassword.value =="")

                {

                        alert("Please Enter New Password...");

                        //useredit.txtEmployeeNewPassword.focus();

                        return false;

                }
 
                else if(document.useredit.txtEmployeeNewPassword.value.length < 6)

                {

                        alert("Your New Password Length Should Be 6 Characters...");

                        return false;

                //      useredit.txtEmployeeNewPassword.value = "";
 
                }
 
                else  if(document.useredit.txtEmployeeRetypePassword.value =="")

                {

                        alert("Please Enter Retype Password...");

                        return false;

                }
 
                else if(document.useredit.txtEmployeeRetypePassword.value.length < 6)

                {

                        alert("Your Retype Password Length Should Be 6 Characters..."); alert("Your Retype Password Length Should Be 6 Characters...");

                        useredit.txtEmployeeRetypePassword.value = "";

                }
 
                else if(pass1 != pass2)

                {

                        alert("Your New Password Did Not Match With The Retype Password.. ");

                         event.returnValue = false;
 
                }
 
                function fnSave()

                {

                        if( fnNew_Retype_Pswd()== false)

                        {

                        event.returnValue = true;

                        }

}

<?php
 
        $code = $_GET['code'];

        $name = "";

        $desg = "";

   $weeklyoff = "";

         $doj = "";

 $activatedon = "";

$passwordexpireson = "";
 
                $dbconnect=pg_connect("host=10.10.2.12 dbname=punch_system  user=postgres password=postgres") or

         die("could not connect to the database");
 
        $query = "select pmt19_emp_code,pmt19_activatedon,pmt19_passwordexpireon,";

        $query = $query . " pmt06_emp_code,pmt06_emp_name,pmt06_desg_code,pmt06_date_of_join,";

        $query = $query . " pmt06_weekly_off,pmt12_desg_code,pmt12_desg_desc";

        $query = $query . " from  pmt_web_users,pmt_employee,pmt_designation ";

        $query = $query . "where pmt19_emp_code=pmt06_emp_code and pmt12_desg_code=pmt06_desg_code";

        $query = $query . " and  pmt19_emp_code   = '" . $code . "'";
 
         $rs = pg_query($query)

                      or die('Could not Open Recordset...') . pg_last_error($rs);
 
         if (pg_num_rows($rs) > 0)

 {

                        $row = pg_fetch_row($rs);
 
                        $code = $_GET['code'];

                        $name = $row[4];

                        $desg = $row[9];

                         $doj = $row[6];

                   $weeklyoff = $row[7];

                 $activatedon = $row[1];

           $passwordexpireson = $row[2];
 
                }

                 pg_free_result($rs);

                 pg_close($dbconnect);
 
?>
 
        <body bgcolor="#F0F0F0 ">

         <h2 align=center>User Edit Information </h2>

        <form name=useredit method=post action="" onsubmit=fnSave() >

        <br><center>

        <fieldset style='width:50%'><legend>User Edit Data</legend>

        <table align=center cellspacing=2 cellpadding=2 bgcolor=FFFFCC >

        <tr>

          <td align=right>

                 <font face="Garamond" size=3><b>

                     Employee Code :

                    </b></font>

                    </td>

<td>

                     <font face="Garamond" size=2><b>

                    <input  title  = "Specify Employee Code..."

                         style     = "WIDTH: 100px; HEIGHT: 21px"

                         maxLength = 7

                         align     = left

                                id = txtEmployeeCode

                         name      = txtEmployeeCode

                         tabindex  = 1 readonly

                         value     = "<? echo $code ?>">

            </b></font> </td>
 
              <td align=right>

                 <font face="Garamond" size=3><b>

                      Employee Name :

                       </b></font>

                      </td>
 
                      <td align=left>

                        <font face="Garamond" size=4><b>

                         <input  title     = "Specify Employee Name..."

                                 style     = "WIDTH: 100px; HEIGHT: 21px"

                                 maxLength = 7

                                 align     = left

                                 id        = txtEmployeeName

                                 name      = txtEmployeeName

                                 tabindex  = 1 readonly

                                 value     = "<? echo $name ?>">

             </b></font> </td></tr>

 <tr>

           <td align=right>

            <font face="Garamond" size=3><b>

               Employee Desig:

           </b></font> </td>
 
            <td align=right>

                <font face="Garamond" size=4><b>

                <input  title     = "Specify Employee Desig..."

                        style     = "WIDTH: 100px; HEIGHT: 21px"

                        maxLength = 7

                        align     = left

                        id        = txtEmployeeDesig

                        name      = txtEmployeeDesig

                        tabindex  = 1 readonly

                        value     = "<? echo $desg?>">

              </b></font> </td>
 
         <td align=right>

             <font face="Garamond" size=3><b>

                  Weeklyoff:

                 </b></font> </td>
 
                  <td align=left>

                      <font face="Garamond" size=4><b>

                      <input  title     = "Specify Employee WeeklyOff..."

                              style     = "WIDTH: 100px; HEIGHT: 21px"

                              maxLength = 7

                              align     = left

                              id        = txtEmployeeWeeklyOff

 name      = txtEmployeeWeeklyOff

                              tabindex  = 1 readonly

                              value     = "<?
 
                                                      if($weeklyoff == 1)

                                                        {

                                                        $weeklyoff = "Sunday";

                                                        }

                                                else if($weeklyoff == 2)

                                                        {

                                                        $weeklyoff = "Monday";

                                                        }

                                                else if($weeklyoff == 3)

                                                        {

                                                        $weeklyoff = "Tuesday";

                                                        }

                                                else if($weeklyoff == 4)

                                                        {

                                                        $weeklyoff = "Wednesday";

                                                        }

                                                else if($weeklyoff == 5)

                                                        {

                                                        $weeklyoff = "Thursday";

                                                        }

                                                else if($weeklyoff == 6)

                                                        {

                                                        $weeklyoff = "Friday";

                                                        }
 
                                                else if($weeklyoff == 7)

                                                        {

 $weeklyoff = "Saturday";

                                                        }
 
                                         echo $weeklyoff ?>">

        </b></font> </td> </tr>
 
                 <tr><td><hr></td><td><hr></td><td><hr></td><td><hr></td></tr>

<!--<HR NOSHADE="NOSHADE">-->

        <tr>

           <td align=right>

              <font face="Garamond" size=3><b>

                   Doj:

                </b></font></td>
 
               <td>

                   <font face="Garamond" size=4><b>

                       <input  title     = "Specify Employee Doj..."

                               style     = "WIDTH: 100px; HEIGHT: 21px"

                               maxLength = 7

                               align     = left

                               id        = txtEmployeeDoj

                               name      = txtEmployeeDoj

                               tabindex  = 1 readonly

                               value     = "<? echo $doj ?>">

                  </b></font> </td>
 
        <td align=right> <font face="Garamond" size=3><b>

                  Role:

                    </b></font>

          </td>

 </td>
 
        <td>

    <select id=Role name=Role style="width: 100px"><option>[Select One]</option><?php fnRoles(); ?></select></td>

       </tr>
 
        <tr>

                <td align=left>

                 <font face="Garamond" size=3><b>

                   Current Password:

                  </b></font> </td>
 
          <td>

           <font face="Garamond" size=4><b>

             <input  title     = "Specify Employee Current Password..."

                     type      = password

                     style     = "WIDTH: 100px; HEIGHT: 21px"

                     maxLength = 7

                     align     = left

                     id        = txtEmployeeCurrentpassword

                     name      = txtEmployeeCurrentPassword

                     tabindex  = 1>

               </b></font></td>
 
         <td align=right> <font face="Garamond" size=3><b>

                 Valid Compinies:

                   </b></font> </td>

<td>

        <select name="ValidCompinies" id="Select1" size="4" multiple="multiple"

         style="width: 180px"><option>[Select-One]</option><?php fnValidCompinies(); ?></select></tr>
 
        <tr>

         <td align=right>

           <font face="Garamond" size=3><b>

                   New Password:

                   </b></font> </td>
 
          <td>

            <font face="Garamond" size=4><b>

             <input  title     = "Specify Employee New Password..."

                         type  = password

                     style     = "WIDTH: 100px; HEIGHT: 21px"

                     maxLength = 7

                     align     = left

                    id         = txtEmployeeNewpassword

                     name      = txtEmployeeNewPassword

                     tabindex  = 1 onfocusout=fnNew_Retype_Pswd() >

                 </b></font>

            </td></tr>
 
                <tr>

                   <td>

                   <font face="Garamond" size=3><b>

                         Retype Password:

                       </b></font>

<td>

                    <font face="Garamond" size=4><b>

                       <input  title     = "Specify Employee Retype Password..."

                               type      = password

                               style     = "WIDTH: 100px; HEIGHT: 21px"

                               maxLength = 7

                               align     = left

                               id        = txtEmployeeRetypepassword

                               name      = txtEmployeeRetypePassword onfocusout=fnNew_Retype_Pswd()

                               tabindex  = 1>

                        </b></font>

                  </td></tr>

<table align=center>

        <tr><td>

    <input type=submit value=Save id=Save name=Save style="width: 75px" onclick=fnPasswordSave()></td>

        <td> <input type=Reset value=Reset id=reset name=reset style="width: 75px"></td>
 
         <td> <input type=button value=Close id=close name=close style="width: 75px" onclick='window.close()'>

        </td></tr>

        </table>

<?php

  function fnPasswordSave()

         {
 
                       $code = $_GET['code'];

                 $CurrentPwd = $_POST[' txtEmployeeCurrentPassword'];

                 $NewPwd     = $_POST['txtEmployeeNewPassword'];

                 $RetypePwd  = $_POST['txtEmployeeRetypePassword'];
 
         $dbconnect=pg_connect("host=10.10.2.12 dbname=punch_system  user=postgres password=postgres") or

                 die("could not connect to the database");
 
        $query = "update pmt_login_info set pmt19_password=$NewPwd where  pmt19_emp_code='" . $code . "'";

                echo $query;
 
                $rs = pg_query($query) or die('Could not Open Recordset...') . pg_last_error($rs);

if($rs)

        {

                echo "Password Updated Successfully..";

        }

        else

         {

                echo "Password Updation Unsuccessfull..";

         }
 
        }
 
?>

</form>

</body>

</html>

any one tell me,is my code correct to save newpassword into database.but output is not grtting.please, correct the code

Aug 5 '09 #1

Subscribe Reply

2281

dlite922

1,584

Recognized Expert Top Contributor

are you getting any errors?
What have you done to debug so far? I can't run your code on my computer so you have to do some debugging and narrow down the issue.

Your SQL password field value does not have quotes around it. Put some quotes around that as well. You should be getting a SQL error though.

Dan

Aug 5 '09 #2

Similar topics

25031

New, Open, Save, Save As, Close

by: Andras Gilicz | last post by:

Hi VB fans I'm working on a relatively large project in VB6 with about a dozen forms, including graphs, labels, text boxes, etc. The software itself is actually a flow simulator with more or less complex technical calculations, several input variables. I would like to equipp the starting panel with the usual New, Open, Save, Save As, Close etc. menus (like in Excel, or Word, etc.) What is the best way to accomplish Save, or Save As?...

Visual Basic 4 / 5 / 6

3704

HTML doc save dialog

by: joseph.inglis | last post by:

I have a web browser object on a form which I have set to edit mode and use the UCOMIConnectionPointContainer interface to hook in and catch events. All working sweetly. Except there are instances where i rewrite the Document.Content and the

C# / C Sharp

1272

Application Ending : Save the static object in a File to reload it alter !

by: Shanli RICHEZ | last post by:

I'm using ASP.NET and quite a lot of object in memory instead of a database. The question is that I tried to save the data, serialize them in a XML file to save them when the application is ending. event : Application_End in Global.asax. But the object are not accesible from there so I can't save them. Any idea ???

ASP.NET

10692

Want to be able to create or view database diagrams

by: teedilo | last post by:

Our MS SQL (SQL Server 2000) DBA has database privileges locked down pretty tightly. We end users/developers do not have administrator privileges for most databases. That arrangement has worked out OK for the most part. However, it's a bit aggravating that we can't even create our own database diagrams. When we attempt to do so (in Enterprise Manager), we get a dialog that says "You do not have sufficient privilege to create a new...

Microsoft SQL Server

9184

SQL Server 2005 - Save tran save point name case sensitive?

by: xAvailx | last post by:

Hello: I didn't find any documentation that notes save point names are case sensitive, but I guess they are... Stored Proc to reproduce: /* START CODE SNIPPET */ If Exists (Select * From sysobjects Where Type = 'P' and Name =

Microsoft SQL Server

8656

I want to KEEP trailing zeros

by: Chester | last post by:

I'm working on an app that records data collected by service technicians (VB.Net front-end, SQL Server 2000 back end). The technicians need to record numbers with varying scale and precision. For example, they may record one reading as 63.45 and the next as 123.1 and a third as 1.32456. That's fine - those can be saved as floating point numbers (very little math is done with these numbers so I'm not too worried about strange floating...

Visual Basic .NET

4143

Copied Reports won't save

by: Josetta | last post by:

Access 2003 I've been experiencing some problems with my "monster" database the last couple of days. I imported all objects into a new database yesterday, which pretty much stopped the crashing problems, but here's something weird: Whenever I copy an object (reports so far), I am able to open it and make changes, but when I try to save it (without closing), it appears to save (message box goes off), but it doesn't. Then, if I try to...

Microsoft Access / VBA

2617

Save data doesn't work

by: TonyJ | last post by:

Hello! I'm using VS2005. I'm looking at ADO.NET and have found some test tutorial solution on microsoft MSDN. The one that I'm looking at now is called Walkthrough: Saving Data to a Database (Single Table) I have followed the walkthrought exectly but it doesn't work as expected.

C# / C Sharp

2664

ASP script with upload files, want to add SQL statement

by: somnamblst | last post by:

I have a Flash form that uses ASP to write to Access db. I have an HTML form that uses ASP to upload files and email those files and sends copies to recipients based on the form fields. I would like to also save all this data to an Access db and have created one that has all the same field names. I have copied my working SQL statement, modified with correct fields for new db and appended it to the bottom of my existing ASP email script. Good...

ASP / Active Server Pages

9511

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

10199

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10139

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9983

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

9020

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

6768

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5551

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

4092

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3697

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