Update profile and change avatar script, need help please...

[NCC1701]

I have a form here that allows the user to update their profile details. The problem im having is that i require the ability to change their avatar/picture via a button in the form.

I dont know how to work it, i know how to upload files and things but i dont know how to get the form to go to the upload picture form when the change avatar button is pressed.

This is what the page looks like:

Here is the code i have so far:

<?php 
  session_start();
  require_once('main_fns.php');
  do_html_header('Edit Profile');
  check_valid_user();
  $conn = db_connect();
  if (isset($_POST['update'])) 
  {
  	$query = "UPDATE profile
	          SET    realname    = '$_POST[realname]', 
			         age         = '$_POST[age]', 
				     location    = '$_POST[location]',  

				     description = '$_POST[description]' 
	          WHERE  nickname    = '$_POST[nickname]'";
        $sql_result = mysql_query($query);
        if (!$sql_result) 
        { 
          echo("<p>\n Error performing query: " . mysql_error() . "\n</p>"); 
        } 
		else 
	    {
          $msg = "<p>\n Thank you! Profile updated.\n</p>";
        }
	  }
	if (isset($_POST['modifyavatar']))
	{

include('select_pic.php');

}  
  // create SQL statement 
  $query = "SELECT * 
            FROM profile 
			WHERE nickname = '$_SESSION[valid_user]' ";
  // execute SQL query and get result 
  $sql_result = mysql_query($query,$conn);

  //check to see if there are results from the query
  $num=mysql_num_rows($sql_result);
  if($num>0)
  {	   
    // format results by row
   $row = mysql_fetch_array($sql_result);

   echo "<form name=\"profile\" method=\"post\" action=\"$PHP_SELF\">";
   echo "<table width=\"800\" align=\"center\">";
   echo "<tr><td width=\"\"></td><td width=\"\"></td></tr>";
   echo "<tr id=\"row1\"><td><strong>Nickname:</strong></td><td><input name=\"nickname\" type=\"hidden\" value=".$row['nickname']." />".$row['nickname']."</td></tr>";
   echo "<tr><td><strong>Real Name:</strong></td><td><input name=\"realname\" type=\"text\" value=".$row['realname']." /></td></tr>";
   echo "<tr id=\"row1\"><td><strong>Age:</strong></td><td><input name=\"age\" type=\"text\" value=".$row['age']." /></td></tr>";
   echo "<tr><td><strong>Location:</strong></td><td><input name=\"location\" type=\"text\" value=".$row['location']." /></td></tr>";
   echo "<tr id=\"row1\"><td><strong>Description:</strong></td><td><textarea name=\"description\">".$row['description']."</textarea></td></tr>";
   echo "<tr><td><strong>Picture:</strong></td><td><img src=images/".$row['image']." border=0 alt=".$row['nickname']." height=\"100\" width=\"100\" align=\"middle\" /><input type=\"submit\" name=\"modifyavatar\" value=\"Change Avatar\"></td></tr>";
   echo "<tr id=\"row1\"><td align=\"center\" colspan=\"2\"><input name=\"update\" type=\"submit\"  value=\"update\" /></td></tr>";
   echo "<tr><td align=\"center\" colspan=\"2\">". $msg ."</td></tr>";
   echo "<tr><td align=\"center\" colspan=\"2\"><a href=\"member.php\">Back</a></td></tr>";
   echo "</table>";
   echo "</form>";
  }
do_html_footer();
?>

[NCC1701]

this is the upload script that goes with it:

<---------select_item.php------------>

<?php
session_start();
require_once('main_fns.php');
?>

<table width="840" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="840" valign="top" align="center" height="600">
<font face="verdana, arial" size="2" color="#1f3145">
Add a picture & title.<p>
<form enctype="multipart/form-data" action="upload_pic.php" method="post"> 
<br>
<input type="hidden" name="nickname" size="20" value="<?php $_POST['nickname'] ?>"><p>
Select a Photo<br>
<input type="file" name="upfile">
<p> 
<input type="submit" name="submit" value="Add Item"> 
<input type="reset" name="reset" value="Reset">
</form> 
</font> 
</td> 
</tr> 
</table> 

<?php
do_html_footer();
?>

<-------upload_pic.php-------------->

<?php 
session_start();
require_once('main_fns.php');
     // Limits file types
     $file_types = array(   

     'image/pjpeg' => 'jpg', 
     'image/jpeg' => 'jpg',
	 'image/gif' => 'gif',
	 'image/bmp' => 'bmp' 
     ); 

 $nickname = $_POST['nickname']; 
 $max_size = 2000000;
 $filesize = $_FILES['upfile']['size'];
 $filetype = $_FILES['upfile']['type'];
 $upload_dir = $_SERVER['DOCUMENT_ROOT'] . "/Project1/images/"; //change directory to the path to your folder



    if ($filesize > $max_size){
        echo ("File is too big.");
       exit;
    }
     if (!array_key_exists($filetype, $file_types)) { 
           echo ("File is wrong type"); 
        exit;
    } 
    else
    {   
           $new_file = substr(sha1(rand(10, time())), 0, 8) . '.' . $file_types[$filetype]; 
           if (move_uploaded_file($_FILES['upfile']['tmp_name'], $upload_dir . $new_file)) { 

          $filename=$new_file;

            // add your connection strings here
          $conn = db_connect();

          $query = "UPDATE profile 
		            SET image = '$filename'
					WHERE nickname ='$_POST[nickname]'"; 
          $result=mysql_query($query, $conn); 
	}
  }
echo "<p>File Uploaded</p>";
echo "<a href=\"edit_profile.php\">Back</a>"
?> 

[NCC1701]

bump please 😃 anyone got any idea?