hi...
i want to update employee's record but its not being updated.....can u help me out....
no error is shown to me..... -
<html>
-
<body bgcolor="pink">
-
<?
-
$con=mysql_connect("localhost","root","root");
-
if (!$con)
-
{
-
die('Could not connect: ' . mysql_error());
-
}
-
mysql_select_db("master", $con);
-
$result=mysql_query("select * from emp_company");
-
echo "<table border='3'> <BR><BR><BR><BR>
-
<tr>
-
<th >Employee Code</th>
-
<th>Name</th>
-
<th>Company</th>
-
<th> Shift</th>
-
<th>DOJ</th>
-
<th>DOL</th>
-
<th> Dept</th>
-
<th> Subdept</th>
-
<th>ESI Code</th>
-
<th>P/F</th>
-
<th>Card No.</th>
-
<th>Bank A/C No.</th>
-
</tr>" ;
-
while($row=mysql_fetch_assoc($result))
-
{
-
echo "<tr>";
-
echo "<td>" . $row['ecode'] . "</td>";
-
echo "<td>" . $row['ename'] . "</td>";
-
echo "<td>" . $row['ecom']. "</td>";
-
echo "<td>" . $row['eshift'] . "</td>";
-
echo "<td>" . $row['edoj'] . "</td>";
-
echo "<td>" . $row['edol'] . "</td>";
-
echo "<td>" . $row['edpt'] . "</td>";
-
echo "<td>" . $row['esubdpt'] . "</td>";
-
echo "<td>" . $row['eesicode'] . "</td>";
-
echo "<td>" . $row['epf'] . "</td>";
-
echo "<td>" . $row['ecardno'] . "</td>";
-
echo "<td>" . $row['ebank'] . "</td>";
-
echo "</tr>";
-
echo '<a href="update.php?ecode='.$row['ecode'].' ">Update</a> ' ;
-
}
-
mysql_close($con);
-
?>
-
</body></html>
-
-
<?
-
mysql_connect("localhost","root","root");
-
mysql_select_db("master");
-
-
// ***** This part will process when you Click on "Submit" button *****
-
// Check, if you clicked "Submit" button
-
if($_POST['Submit']){
-
-
// Get parameters from form.
-
$ecode=$_POST['ecode'];
-
$ename=$_POST['ename'];
-
$ecom=$_POST['ecom'];
-
$eshift=$_POST['eshift'];
-
$edoj=$_POST['edoj'];
-
$edol=$_POST['edol'];
-
$edpt=$_POST['edpt'];
-
$esubdpt=$_POST['esubdpt'];
-
$eesicode=$_POST['eesicode'];
-
$epf=$_POST['epf'];
-
$ecardno=$_POST['ecardno'];
-
$ebank=$_POST['ebank'];
-
-
-
mysql_query("update emp_company set ecode='$ecode', ename='$ename',ecom='$ecom', eshift='$eshift',edpt='$edpt',esubdpt='$esubdpt',edoj='$edoj',edol='$edol',eesicode='$eesicode',epf='$epf',ecardno='$ecardno,ebank='$ebank' where ecode='$ecode'");
-
-
// Re-direct this page to select.php.
-
header("location:select.php");
-
exit;
-
}
-
// ************* End update part *************
-
-
// *** Select data to show on text fields in form. ***
-
-
// Get id parameter (GET method) from select.php
-
$ecode=$_GET['ecode'];
-
-
// Get records in all columns from table where column id equal in $id and put it in $result.
-
$result=mysql_query("select * from emp_company where ecode='$ecode'");
-
-
// Split records in $result by table rows and put them in $row.
-
$row=mysql_fetch_assoc($result);
-
-
// Close database connection.
-
mysql_close();
-
?>
-
-
<!-- END OF PHP CODES AND START HTML TAGS -->
-
-
<html>
-
<body>
-
<!-- set this form to POST method and target this form to itself ($PHP_SELF;)-->
-
<form id="form1" name="form1" method="post" action="<? echo $PHP_SELF; ?>">
-
<p>code
-
<input name="ecode" type="text" id="ecode" value="<? echo $row['ecode']; ?>"/>
-
<p>Name :
-
<!-- name of this text field is "name" -->
-
<input name="ename" type="text" id="ename" value="<? echo $row['ename']; ?>"/>
-
<br />
-
<p>Company
-
<input name="ecom" type="text" id="ecom" value="<? echo $row['ecom']; ?>"/>
-
<p>
-
<p>shift :
-
<!-- name of this text field is "email" -->
-
<input name="eshift" type="text" id="eshift" value="<? echo $row['eshift']; ?>"/>
-
<br />
-
<p>DOJ
-
<input name="edoj" type="text" id="edoj" value="<? echo $row['edoj']; ?>"/>
-
<p>
-
<p>DOL :
-
<!-- name of this text field is "tel" -->
-
<input name="edol" type="text" id="edol" value="<? echo $row['edol']; ?>"/>
-
</p>
-
<p>Dept.
-
<input name="edpt" type="text" id="edpt" value="<? echo $row['edpt']; ?>"/>
-
<p>
-
-
<p>Sub Dept.
-
<input name="esubdpt" type="text" id="esubdpt" value="<? echo $row['esubdpt']; ?>"/>
-
<p>
-
<p>ESICODE
-
<input name="eesicode" type="text" id="eesicode" value="<? echo $row['eesicode']; ?>"/>
-
<p>
-
<p>P/F
-
<input name="epf" type="text" id="epf" value="<? echo $row['epf']; ?>"/>
-
<p>
-
<p>CardNo.
-
<input name="ecardno" type="text" id="ecardno" value="<? echo $row['ecardno']; ?>"/>
-
<p>
-
<p>Bank A/C No.
-
<input name="ebank" type="text" id="ebank" value="<? echo $row['ebank']; ?>"/>
-
<p>
-
<input type="submit" name="Submit" value="Submit" />
-
</p>
-
</form>
-
</body>
-
</html>
-
1  1437  Atli 5,058
Expert 4TB @puneetmca
That does not surprise me, since you don't even bother to check the result of your UPDATE query before you redirect the page.
Read this post, specifically the second part regarding the MySQL error messages.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: |
last post by:
Hello,
Sorry to ask what is probably a simple answer, but I am having problems
updating a table/database from a PHP/
PHTML file. I can Read From the Table, I can Insert into Table/Database, But...
|
by: M Wells |
last post by:
Hi All,
Just wondering if you perform an update using a where condition that
actually returns no rows to be updated, does @@Error contain an error
message afterwords?
We want to fire an...
|
by: Mike |
last post by:
Hello,
We are using mysql v4.0.24 on Linux machines.
I'm trying to set up replication with a master and only one slave
database.
The syncronization seems to work well, the relay file on slave...
|
by: Lee Rouse |
last post by:
Hello all,
This is going to be a rather lengthy "question".
I have an Access 2k database, separated front end/back end. Front end
copies are on about 30 workstations and used frequently during...
|
by: Lumpierbritches |
last post by:
Thank you in advance. I have a database that I've written in Access 97 and have
some clients using the program. My question is, when I update tables, so they
don't loose their data, is there a way...
|
by: Vladimir Koudela |
last post by:
Hi people,
I am sure most of you have already solved the Access' stupid problem: there
is no simple way of numbring of records shown in a continuous form, needed
so often (top-lists, achieved...
|
by: Ian Davies |
last post by:
Hello
Needing help with a suitable solution.
I have extracted records into a table under three columns 'category',
'comment' and share (the category column also holds the index no of the
record...
|
by: Ron |
last post by:
Hi All,
Using Access2000, winXP.
Table 1 = tblClients displayed on frmClients via qryClients. 2nd table =
tblInvoices shown on frmInvoices via qryInvoices. 2nd table = tblDetails
shown on...
|
by: PhilOwens |
last post by:
Morning/Afternoon all,
Having slight problem with showing users the progress of a query.....
Bit of background....The database allows users to view the status of documents i.e. Completion date,...
|
by: KrazyKoder |
last post by:
Hello,
I have MS Access form that basically allows the user to configure an update statement to a single table via the gui. A requirement is to show the count of records that will be updated...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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,...
|
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...
|
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...
|
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,...
| |
