\n"; // print "

";
	// print "File name   = ". $_FILES['flag']['name'] . "
\n";
	// print "Mime type   = ". $_FILES['flag']['type'] . "
\n";
	// print "File size   = ". $_FILES['flag']['size'] . "
\n";
	// print "Local name  = ". $_FILES['flag']['tmp_name'] . "
\n";
	// print "Error code  = ". $_FILES['flag']['error'] . "
\n";
	// print "

"; $ffile = fopen($_FILES['flag']['tmp_name'],"rb"); $contents = fread($ffile,$_FILES['flag']['size']); $dbconn = mysql_connect("localhost","root","TMGData1"); mysql_select_db("McMembers"); $eflag = mysql_escape_string($contents); If(!empty($theImgId)){ $qVals = "UPDATE img SET filetype = '" . $theMime . "',filesize = '" . $theSize . "', img_name = '" . $name . "', img_data = '" . $eflag . "' WHERE img_id=".$theImgId; } else{ $qVals = "INSERT INTO img SET MemId = ". $theMemId . ", filetype = '" . $theMime . "',filesize = '" . $theSize . "', img_name = '" . $name . "', img_data = '" . $eflag . "'"; } $result = $connector->query("$qVals"); echo ''; } If (($thehiddenSubmitter == "pookachoo") && ($theSubmitCall=="Remove Image")){ If(!empty($theImgId)){ // echo $theImgId."
"; $qVals = "DELETE FROM img WHERE img_id=".$theImgId; // echo $qVals; } $result = $connector->query("$qVals"); echo ''; } // >> GET ORG ID if($_SESSION['McMember_OrgId']){ // everything is alright }else{ // something has gone wrong, the org id cant be located $_SESSION['McMember_FailureReason'] = "UnableToLocateOrgId"; header("location: Login.php"); } // USED FOR TESTING PURPOSES // $_SESSION['McMember_OrgId'] = 1; // Gets rid of all the error reporting on servers which are not configured appropriately. error_reporting(E_ALL ^ E_NOTICE); // Get the PHP file containing the DbConnector class require_once('DbConnector.php'); // Create an instance of DbConnector $connector = new DbConnector(); // GET THE ORG DETAILS // THROW THEM INTO VARIABLES $qVals11 = "SELECT * FROM org WHERE OrgId =".$_SESSION['McMember_OrgId']; $result = $connector->query($qVals11); // Get the result $row = $connector->fetchArray($result); $OrgName = $row["OrgName"]; $OrgNumber = $row["OrgNumber"]; // >> GET MEMBER PERMISSIONS // CHECK PERMISSIONS OF THE USER TO SEE WHAT THEY CAN DO WITH MEMBERS // POPULATE SESSION PERMISSIONS BASED ON THOSE VALUES. // >> PULL UP THE DATA TO BE USED IN THE LIST if(isset($_GET['ID'])){ $theMemId = $_GET['ID']; } $qVals11 = "SELECT mem.MemID, mem.FirstName, mem.LastName, mem.Phone_Display, oda.OrgId, img.img_id FROM (mem INNER JOIN oda ON mem.MemID = oda.MemId) LEFT JOIN img ON mem.MemID = img.MemId WHERE oda.OrgId =".$_SESSION['McMember_OrgId']." AND mem.Deleted=0 AND mem.MemID=".$theMemId." ORDER BY mem.LastName"; $result = $connector->query($qVals11); $record_found = mysql_num_rows($result); $nrows = mysql_num_rows($result); $row = $connector->fetchArray($result); if($record_found > 0){ // UPDATE THE EXISTING ONE ?>

\n"; } else{ print "

No Member Image Records Located"; print "No Member Images located."; print "To Return to Membership Administration, click here."; } ?>


Current Image :
Description :
Image File (GIF ONLY) :