Page 1 of 1
Updating Member Profile
Posted: Mon Aug 10, 2009 8:04 am
by tobimichigan
Hi Code Gurus,
Code: Select all
<?php
include("cn.php");
$pfno=$_GET['pfno'];
$result=mysql_query("SELECT (*) FROM user_table WHERE pfno=$pfno");
//$result = mysql_fetch_assoc($select);
$num=mysql_num_rows($result);
//mysql_close();
$i=0;
while ($i < $num) {
$amountd=mysql_result($result,$i,"amountd");
$department=mysql_result($result,$i,"department");
$email=mysql_result($result,$i,"email");
$fname=mysql_result($result,$i,"fname");
$oname=mysql_result($result,$i,"oname");
$lname=mysql_result($result,$i,"lname");
$lga=mysql_result($result,$i,"lga");
$marital=mysql_result($result,$i,"marital");
$Nationalty=mysql_result($result,$i,"Nationalty");
$pfno=mysql_result($result,$i,"pfno");
$residentialadd=mysql_result($result,$i,"residentialadd");
$sex=mysql_result($result,$i,"sex");
$soorigin=mysql_result($result,$i,"soorigin");
$telno=mysql_result($result,$i,"telno");
//Space For Code
$query = ("UPDATE contacts SET amountd = '$amountd', department = '$department', email = '$email', fname = '$fname', lga = '$lga', lname = '$lname',marital='$marital', Nationalty='$Nationalty',oname='$oname', residentialadd='$residentialadd', soorigin='$soorigin',telno='$telno', WHERE pfno = '$pfno'");
mysql_query($query);
echo //"Record Updated";
mysql_close();
++$i;
}
$amountd=$_POST['amountd'];
$department=$_POST['department'];
$email=$_POST['email'];
$fname=$_POST['fname'];
$lga=$_POST['lga'];
$lname=$_POST['lname'];
$marital=$_POST['marital'];
$Nationalty=$_POST['Nationalty'];
$oname=$_POST['oname'];
$residentialadd=$_POST['residentialadd'];
$soorigin=$_POST['soorigin'];
$telno=$_POST['telno'];
?>
There are 2 things I'd love to do.
Firstly, display the existing member's profile data on an html form.
Secondly, update the previous values stored by new ones with sql update as above.
When I preview in an explorer on the form it gives me this-><? echo $lname; ?> as a form return value instead of showing the current member information and after clicking submit, updating the profile accordingly. Please gurus help me out...
Re: Updating Member Profile
Posted: Mon Aug 10, 2009 11:30 am
by jackpf
Do you have shorttags enabled?
Re: Updating Member Profile
Posted: Mon Aug 10, 2009 3:30 pm
by tobimichigan
jackpf wrote:Do you have shorttags enabled?
Even with the full tags it refuses to display the field value in the input tag.
Re: Updating Member Profile
Posted: Mon Aug 10, 2009 4:00 pm
by tobimichigan
Please how do I include this in the html form field above with the php tags?
<input type=\"text\" name=\"location\" value=\"".$row['location']."\" />";
Re: Updating Member Profile
Posted: Tue Aug 11, 2009 4:37 am
by tobimichigan
Jack please check out:
[code-php]
<?php
include("cn.php");
$pfno=$_GET['id'];
$row=mysql_query("SELECT (*) FROM user_table WHERE id=$id");
//$result = mysql_fetch_assoc($select);
$num=mysql_fetch_array($row);
//mysql_close();
$i=0;
while ($i < $num) {
$amountd=mysql_result($result,$i,"amountd");
$department=mysql_result($result,$i,"department");
$email=mysql_result($result,$i,"email");
$fname=mysql_result($result,$i,"fname");
$oname=mysql_result($result,$i,"oname");
$lname=mysql_result($result,$i,"lname");
$lga=mysql_result($result,$i,"lga");
$marital=mysql_result($result,$i,"marital");
$Nationalty=mysql_result($result,$i,"Nationalty");
$pfno=mysql_result($result,$i,"pfno");
$residentialadd=mysql_result($result,$i,"residentialadd");
$sex=mysql_result($result,$i,"sex");
$soorigin=mysql_result($result,$i,"soorigin");
$telno=mysql_result($result,$i,"telno");
//Space For Code
$query = ("UPDATE user_table SET amountd = '$amountd', department = '$department', email = '$email', fname = '$fname', lga = '$lga', lname = '$lname',marital='$marital', Nationalty='$Nationalty',oname='$oname', residentialadd='$residentialadd', soorigin='$soorigin',telno='$telno', WHERE pfno = '$pfno'");
mysql_query($query);
echo //"Record Updated";
mysql_close();
++$i;
}
$amountd=$_POST['amountd'];
$department=$_POST['department'];
$email=$_POST['email'];
$fname=$_POST['fname'];
$lga=$_POST['lga'];
$lname=$_POST['lname'];
$marital=$_POST['marital'];
$Nationalty=$_POST['Nationalty'];
$oname=$_POST['oname'];
$residentialadd=$_POST['residentialadd'];
$soorigin=$_POST['soorigin'];
$telno=$_POST['telno'];
?>
<form action='Edit_Profile.php' method='post' enctype='multipart/form-data' name='register'>
<table width='28%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2'><div align='center'>
<p><font size="2" face="verdana">Edit your Profile</font></p>
</div></td>
</tr>
<tr>
<td width='31%'> </td>
<td width='69%'> </td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td height='26'><font size='2' face='verdana'>PF NO.</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['pfno'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>FIRST NAME</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['fname'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>OTHER NAMES</font><font size='2' face='verdana'></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['oname'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LAST NAME</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['lname'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>STATE OF ORIGIN</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['soorigin'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LOCAL GOVERNMENT</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['lga'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>NATIONALITY</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['Nationalty'] ?>">
</font></td>
</tr>
<tr>
<td height='26'><font size='2' face='verdana'>Email address</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['email'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>RESIDENTIAL ADDRESS</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['residentialadd'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>TELEPHONE NUMBER</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['telno'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>DEPARTMENT</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['department'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>MARITAL STATUS</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['marital'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>SEX</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['sex'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>AMOUNT DEDUCTIBLE</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['amountd'] ?>">
</font></td>
</tr>
<tr>
<td> </td>
<td><font size='2' face='verdana'>
<input type='submit' name='Submit' value='Update'>
</font></td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form><div align='center'><font size='1' face='verdana'><a href='Admin_Login.php'>Back to login page</a></font></div>
<td colspan='2'><div align='center'><font size='1' face='verdana'>TM</font></div></td>
<td colspan='2'> </td>
</body>
</html>
Is an edit_profile code, which is meant to display existing member information from the database and after editing the info update a table. But its not showing the exisitng data much less updating.
Besides, its morelike show at the top of the browser:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line24="$num=mysql_fetch_array($row);"
Please any valid pointers would be appreciated. Thanks...
Re: Updating Member Profile
Posted: Tue Aug 11, 2009 5:06 pm
by jackpf
Use mysql_error().