Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
<style type="text/css" media="all">
@import "c/cms_styles.css";
</style>
</head>
<body>
<div id="container">
<?php
require_once('######.php');
$uploadDir = './upload/';
if(isset($_GET['talent_id']))
{
$q = "SELECT * ".
"FROM ###### ".
"WHERE talent_id = '{$_GET['talent_id']}'";
$r = mysqli_query($dbc,$q) or die('Error : ' . mysqli_error($dbc));
list($talent_id, $first_name,$last_name, $speciality, $website, $resumePath, $headshotPath, $registration_date) = mysqli_fetch_array($r, MYSQL_NUM);
}
else if(isset($_POST['update']))
{
$talent_id = $_POST['talent_id'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$speciality = $_POST['speciality'];
$website = $_POST['website'];
$resumePath = $_POST['resumePath'];
$headshotPath = $_POST['headshotPath'];
if ($_FILES['resume']['size'] > 0 ) {
$resumeName = $_FILES['resume']['name'];
$resumeTmpName = $_FILES['resume']['tmp_name'];
$resumeFileSize = $_FILES['resume']['size'];
$resumeFileType = $_FILES['resume']['type'];
$resumePath = $uploadDir . $resumeName;
$resumeResult = move_uploaded_file($resumeTmpName, $resumePath);
if (!$resumeResult) {
echo "Error uploading resume file";
exit;
}else{
echo "<p>Resume Upload Complete.</p>";
}
}
if ($_FILES['headshot']['size'] > 0 ) {
$headshotName = $_FILES['headshot']['name'];
$headshotTmpName = $_FILES['headshot']['tmp_name'];
$headshotFileSize = $_FILES['headshot']['size'];
$headshotFileType = $_FILES['headshot']['type'];
$headshotPath = $uploadDir . $headshotName;
/* $docCatagory = 'resume';
echo "<p>$docCatagory</p>";
$resumePath = $uploadDir . $resumeName;
echo "<p>$resumePath</p>";
*/
$headshotResult = move_uploaded_file($headshotTmpName, $headshotPath);
if (!$headshotResult) {
echo "Error uploading headshot file";
exit;
}else{
echo "<p>Headshot Upload Complete.</p>";
}
}
// update the article in the database
$q = "UPDATE production ".
"SET first_name = '$first_name',last_name='$last_name', speciality= '$speciality', website= '$website' , resumePath = '$resumePath' , headshotPath = '$headshotPath' ".
"WHERE talent_id = '$talent_id'";
mysqli_query($dbc,$q) or die('Error : ' . mysqli_error($dbc));
echo "<p>Talent Updated</p>";
}
mysqli_close($dbc);
?>
<h3> Update Production Talent:</h3>
<form action="prod_edit.php" method="post" enctype="multipart/form-data" name="uploadform">
<input type="hidden" name="talent_id" value="<?=$talent_id;?>" />
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<fieldset>
<legend>
Production Talent Personal Information:
</legend>
<p><label for="first_name">Talent First Name:</label></p>
<input type="text" id="first_name" name="first_name" value="<?=$first_name;?>" />
<p><label for="last_name">Talent Last Name:</label></p>
<input type="text" id="last_name" name="last_name" value="<?=$last_name;?>" />
<p><label for="website">Talent Last Website:</label></p>
<input type="text" id="website" name="website" value="<?=$website;?>" />
</fieldset>
<br />
<fieldset>
<legend>
Production Talent Speciality:
</legend>
<select name="speciality">
<option value="1">Feature/TV DP</option>
<option value="2">Feature/TV PD</option>
<option value="3">Feature/TV Editors</option>
<option value="4">Feature/TV Costume designers</option>
<option value="5">Commercial/Music Video DP</option>
<option value="6">Commercial/Music Video PD</option>
<option value="7">Commercial/Music Video costume Designer/ Stylist </option>
</select>
</fieldset>
<br />
<fieldset>
<legend>
Production Talent File Upload:
</legend>
<p class="ins">To upload a file, if you're using a reasonably good Web browser, there should be a button marked Choose file or Browse, which will let you pick out a file on your hard drive, .pdf, .jpg. Please make sure that the file name is descriptive (e.g., fname_lname_resume.pdf or fname_lname_headshot.jpg). View your uploaded files: <a href="./upload/index.php" title="file download">Download Files</a> </p>
<p>File Types: .pdf, .jpg.</p>
<p><label for="Resume">Resume</label>
<input name="resume" type="file" class="box" id="resume" /></p>
<p><label for="Headshot">Headshot</label>
<input name="headshot" type="file" id="headshot" /></p>
<input name="update" type="submit" id="upload" value=" Add Talent " /><input type="reset" value="Reset" />
</fieldset>
</form>
<p><a href="./prod_admin.php">Back to production admin page</a> | <a href="./cms_index.php">Back to index page</a> </p>
</div>
</body>
</html>