note 104898 added to function.mysql-query
| From: | neerajswarnkar0207 at gmail dot com | Date: | Thu, 14 Jul 2011 14:19:47 +0000 |
| Subject: | note 104898 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-181499@lists.php.net to get a copy of this message | ||
<?php
mysql_connect("localhost","root","rootpw") or die("could not
connect to server");
@mysql_select_db("detail");
?>
<html>
<head>
<title>EMP DETAIL</title>
<script language="javascript" type="text/javascript"
src="validation.js"></script>
<script type="text/javascript">
<script language="javascript" type="text/javascript"
src="validation.js"></script>
<script type="text/javascript">
</script>
</head>
<body>
<?
$pass=$_REQUEST['Name'];
function custinfo($pass)
{
$edit_user = " SELECT Name,Salary
FROM employee
WHERE ID = '$pass'";
$result=mysql_query($edit_user);
$num=mysql_numrows($result);
mysql_close();
}
if($_POST['button'] == 'Submit')
{
$unique=$_POST[unique];
$update_user = "UPDATE employee SET
Name = '$_POST[Name]',
Salary = '$_POST[Salary]'";
$update_user.= "WHERE ID = '$unique'";
$update_user_query = mysql_query($update_user) or die(mysql_error());
mysql_close();
header("Refresh:0;URL='edit.php");
exit();
}
else
{
$edit_user = "SELECT ID,Name,Salary
FROM employee
WHERE ID = '$pass'";
$result=mysql_query($edit_user);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num)
{ $Name=mysql_result($result,$i,"Name");
$Salary=mysql_result($result,$i,"Salary");
$unique=mysql_result($result,$i,"ID");
$i++;
}
}
?>
<form name="form1" method="post" action="edit1.php">
<p> </p>
<table cellspacing='2' cellpadding='2' border=''
align='center' width='50%' >
<TR >
<td COLSPAN="2"><center><h1> Enter EMP
details</h1></center>
</td>
</TR>
<TR>
<TD>Name</TD>
<TD><input type="text" size="12" maxlength="12"
name="Name" id='Name' value='<?php echo $Name; ?>' >
<input type="hidden" size="12" maxlength="12"
name="unique" id='unique' value='<?php echo $unique; ?>' >
</TD>
</TR>
<TR>
<TD>Salary:</TD>
<TD><input type="text" size="12" maxlength="36"
name="Salary" id='Salary' value='<?php echo $Salary; ?>'
></TD>
</TR>
<TR>
<TD>submit
</TD>
<TD><input type='submit' name='button' value='Submit' >
</TD>
</TR>
</TABLE>
</form>
</body>
</html>
----
Server IP: 69.147.83.197
Probable Submitter: 220.227.73.102
----
Manual Page -- http://www.php.net/manual/en/function.mysql-query.php
Edit -- https://master.php.net/note/edit/104898
Del: integrated -- https://master.php.net/note/delete/104898/integrated
Del: useless -- https://master.php.net/note/delete/104898/useless
Del: bad code -- https://master.php.net/note/delete/104898/bad+code
Del: spam -- https://master.php.net/note/delete/104898/spam
Del: non-english -- https://master.php.net/note/delete/104898/non-english
Del: in docs -- https://master.php.net/note/delete/104898/in+docs
Del: other reasons-- https://master.php.net/note/delete/104898
Reject -- https://master.php.net/note/reject/104898
Search -- https://master.php.net/manage/user-notes.php