Updating Member Profile

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
tobimichigan
Forum Commoner
Posts: 48
Joined: Sun May 10, 2009 1:35 pm

Updating Member Profile

Post 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...
User avatar
jackpf
DevNet Resident
Posts: 2119
Joined: Sun Feb 15, 2009 7:22 pm
Location: Ipswich, UK

Re: Updating Member Profile

Post by jackpf »

Do you have shorttags enabled?
tobimichigan
Forum Commoner
Posts: 48
Joined: Sun May 10, 2009 1:35 pm

Re: Updating Member Profile

Post 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.
tobimichigan
Forum Commoner
Posts: 48
Joined: Sun May 10, 2009 1:35 pm

Re: Updating Member Profile

Post 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']."\" />";
tobimichigan
Forum Commoner
Posts: 48
Joined: Sun May 10, 2009 1:35 pm

Re: Updating Member Profile

Post 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%'>&nbsp;</td>
<td width='69%'>&nbsp;</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>&nbsp;</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>&nbsp;</td>
<td>&nbsp;</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'>&nbsp;</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...
User avatar
jackpf
DevNet Resident
Posts: 2119
Joined: Sun Feb 15, 2009 7:22 pm
Location: Ipswich, UK

Re: Updating Member Profile

Post by jackpf »

Use mysql_error().
Post Reply