Joining Two Forms

wherertheskips

I am trying to do something simple, at least I thought it was simple. I am trying to make a single form to upload a single mp3 file and fill in information into a MySql database at the same time. I do not have any control over PHP on my webhost and so I had a terrible time finding a canned solution to uploading files. I finally found the following:

<?php

  $my_max_file_size 	= "9291456"; # in bytes
  $image_max_width	= "300";
  $image_max_height	= "300";
  $the_path			= "/home/path/public_html/media";

  $registered_types = array(
  					"audio/mpeg"				=> ".mp3",
  					); # these are only a few examples, you can find many more!

  $allowed_types = array("audio/mpeg");

  # --

  function form($error=false) {

  global $PHP_SELF,$my_max_file_size;

if ($error) print $error . "<br><br>";

print "\n<form ENCTYPE=\"multipart/form-data\"  action=\"" . $PHP_SELF . "\" method=\"post\">";
print "\n<INPUT TYPE=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"" . $my_max_file_size . "\">";
print "\n<INPUT TYPE=\"hidden\" name=\"task\" value=\"upload\">";
print "\n<P>Upload a file";
print "\n<BR>NOTE: Max file size is " . ($my_max_file_size / (1024*1024)) . "Mb";
print "\n<br><INPUT NAME=\"the_file\" TYPE=\"file\" SIZE=\"35\"><br>";
print "\n<input type=\"submit\" Value=\"Upload\">";
print "\n</form>";

  } # END form

  # --

  if (!ereg("^4",phpversion())) {
  	function in_array($needle,$haystack) { # we have this function in PHP4, so for you PHP3 people
  		for ($i=0; $i < count($haystack); $i++) {
  			if ($haystack[$i] == $needle) {	
  				return true;
  			}
  		}
  	}
  }

  # --

  function validate_upload($the_file) {

  global $my_max_file_size, $image_max_width, $image_max_height,$allowed_types,$the_file_type,$registered_types;

$start_error = "\n<b>Error:</b>\n<ul>";

if ($the_file == "none") { # do we even have a file?

	$error .= "\n<li>You did not upload anything!</li>";

} else { # check if we are allowed to upload this file_type

	if (!in_array($the_file_type,$allowed_types)) {
		$error .= "\n<li>The file that you uploaded was of a type that is not allowed, you are only 
					allowed to upload files of the type:\n<ul>";
		while ($type = current($allowed_types)) {
			$error .= "\n<li>" . $registered_types[$type] . " (" . $type . ")</li>";
			next($allowed_types);
		}
		$error .= "\n</ul>";
	}

	if ($error) {
		$error = $start_error . $error . "\n</ul>";
		return $error;
	} else {
		return false;
	}
}
  } # END validate_upload


  # --


  function list_files() {

  global $the_path;

$handle = dir($the_path);
print "\n<b>Uploaded files:</b><br>";
while ($file = $handle->read()) {
	if (($file != ".") && ($file != "..")) {
		print "\n" . $file . "<br>";
   }
}
print "<hr>";
print "\n<a href=\"form.php\">Add the form info</a>";
  }

  # --

  function upload($the_file) {

  global $the_path,$the_file_name;

$error = validate_upload($the_file);
if ($error) {
	form($error);
} else { # cool, we can continue
	if (!@copy($the_file, $the_path . "/" . $the_file_name)) {
		form("\n<b>Something barfed, check the path to and the permissions for the upload directory</b>");
	} else {
		list_files();
		form();
	}
}
  } # END upload

  # --

  ############ Start page

  print "<html>\n<head>\n<title>Upload example</title>\n</head>\n<body>";

  switch($task) {
  	case 'upload':
  		upload($the_file);
  	break;
  	default:
  		form();
  }

  print "\n</body>\n</html>";

  ?>

This works perfectly to upload the file. Currently I inserted the - print "\n<a href=\"form.php\">Add the form info</a>" - to give a link to the next page. Honestly I don't understand alot of what is going on on this page. I guess you know that already since I am writing here. Below is the form that I use to insert the info to MySql

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>New NEWS ITEM</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

<?php
$db = mysql_connect("localhost", "user", "password");
mysql_select_db("sermons",$db);

if ($submit) {

  // process form


  $sql = "INSERT INTO sermon_data (date,link,service,title,speaker) VALUES ('$date','$link','$service','$title','$speaker')";

  $result = mysql_query($sql);
  echo $sql;
  }
else {

  // display form
 ?>

  <form method="post" action="<?php echo $PHP_SELF?>">

Date of sermon (YYYY-MM-DD): <input tabindex="1" name="date"><br>
Name of file (MM-DD-YYam.mp3): <input tabindex="2" name="link" value=".mp3"><br>
Time of service :<select tabindex="3" name="service">
	<option selected="selected">Sun AM</option>
	<option>Sun PM</option>
	<option>Wed PM</option>
</select>
<br>
Sermon Title: <input tabindex="4" size="45" name="title"><br>
Speaker: <input tabindex="5" size="25" name="speaker" value="Dr. Norris Belcher"><br>
<input tabindex="6" name="submit" value="Submit!" type="submit">

  </form>

  <?php
} // end if
?>
</body>
</html>

I am not sure that this form is even as good aas it could be, but hey it works 🙂

Is there a way to combine the forms? I have read on this forum that I might be able to have the first form pass the info to the second form and have the second form handle inserting into MySql. That might actually be better because I don't want the info written into MySql unless the file is uploaded. That is simply over my head though. Especially since I don't completely undertand what all is happening in the first form after the Submit. I am open to anything.

Thanks

Nomaad

Hope it helps . . .

<? //put this above the header info of your HTML

if(isset($_GET['id']))

{
//you will need to add name, type, size, path to your SQL table and make sure id is UI
$id = $_GET['id'];
$query = "SELECT name, type, size, path FROM upload WHERE id = '$id'";
$result = mysql_query($query) or die('Error, query failed');
list($name, $type, $size, $filePath) = mysql_fetch_array($result);

header("Content-Disposition: attachment; filename=$name");
header("Content-length: $size");
header("Content-type: $type");

readfile($filePath);

exit;

}

?>
<html>
<head>
<title>Upload PDFs to Field Controls Areas</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<style type="text/css">

</style>
<link href="../NewIndexStyle.css" rel="stylesheet" type="text/css">
</head>

<body bgcolor="#4682B4">
<table width="720" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top" bgcolor="#FFFFFF"><table width="720" border="0" align="center" cellpadding="4" cellspacing="0">
<tr>
<td height="29" align="center" valign="top"><h3>Field Controls .PDF Upload For New Documents Only</h3></td>
</tr>
</table>
<p>

  </p>
  <p>
    <?

//name this file for the form
$this_file = 'fchupload.php';
//set an upload directory make sure it is writable
$uploadDir = '../pdfs/';
$bid = $_POST['bid'];

if(isset($_POST['upload']))
{

$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];



$filePath = $uploadDir . $fileName;

$result    = move_uploaded_file($tmpName, $filePath);
if (!$result) {
    echo "Error uploading file";
    exit;
}


if(!get_magic_quotes_gpc())
{
    $fileName  = addslashes($fileName);
    $filePath  = addslashes($filePath);
}

//post the form data change to your needs
$formnumber = $POST['formnumber'] ;
$quantity = $POST['quantity'] ;

$section = $POST['section'] ;
${'section'.$section} = "checked=\"checked\"" ;

$linktitle = $_POST['linktitle'] ;

$category = $POST['category'] ;
${'category'.$category} = "selected=\"selected\"" ;

$query = "INSERT INTO upload (formnumber, quantity, section, linktitle, category, name, size, type, path ) ".
         "VALUES ('$formnumber', '$quantity', '$section', '$linktitle', '$category', '$fileName', '$fileSize', '$fileType', '$filePath')";

mysql_query($query) or die('Error, query failed : ' . mysql_error());                    


echo "<br><center><h3>File Uploaded</strong></h3><br>";

}

echo "<form action=\"$this_file\" method=\"post\" enctype=\"multipart/form-data\" name=\"uploadform\">
<table width=\"350\" border=\"0\" align=\"center\" cellpadding=\"8\" cellspacing=\"1\" class=\"box\">
<tr>
<td align=\"center\" valign=\"top\">
<p>Browse to find the .PDF file you would like to upload:</p>
<p>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"5000000\">
<input name=\"userfile\" type=\"file\" class=\"box\" id=\"userfile\">
</p></td>
</tr>
<tr><td align=\"left\" valign=\"top\">Enter the Form Number of the document. <em>NA for no number</em><BR /><input name=\"formnumber\" type=\"text\" size=\"50\"></td></tr>
<tr><td align=\"left\" valign=\"top\">Enter the Pack Quantity for Literature. <em>NA if not literature section</em><BR /><input name=\"quantity\" type=\"text\" size=\"50\"></td></tr>
<tr><td align=\"left\" valign=\"top\">Enter the name you would like displayed in the menu.<BR /><input name=\"linktitle\" type=\"text\" size=\"50\"></td></tr>"; ?>
<tr><td align="center" valign="top"> Enter the Category the file should be associated with.<BR />
<select name="category">
<option selected>Select Category if Instruction Manual</option>
<option value="CONDENSATE PUMPS">CONDENSATE PUMPS</option>
<option value="CLEARWAVE™ WATER CONDITIONERS">CLEARWAVE™ WATER CONDITIONERS</option>
<option value="COMBUSTION AIR & MAKE-UP AIR SYSTEMS">COMBUSTION AIR & MAKE-UP AIR SYSTEMS</option>
<option value="EVENMIST™ HUMIDIFIERS">EVENMIST™ HUMIDIFIERS</option>
<option value="BAROMETRIC DRAFT CONTROLS">BAROMETRIC DRAFT CONTROLS</option>
<option value="Type RC">Type RC</option>
<option value="Type M">Type M</option>
<option value="Type MG1">Type MG1</option>
<option value="Draft Regulators">Draft Regulators</option>
<option value="Black Tee-Joint">Black Tee-Joint</option>
<option value="Type M + MG2">Type M + MG2</option>
<option value="ADA-1 Automatic Damper Adapter">ADA-1 Automatic Damper Adapter</option>
<option value="POWER VENTERS">POWER VENTERS</option>
<option value="Vent Hoods - for use with PV style power venters and other sidewall applications">Vent Hoods - for use with PV style power venters and other sidewall applications</option>
<option value="SWG Power Venters">SWG Power Venters</option>
<option value="Gas Furnace Kits">Gas Furnace Kits</option>
<option value="SWG Replacement Motor Kits and Accessories">SWG Replacement Motor Kits and Accessories</option>
<option value="CONTROL KITS">CONTROL KITS</option>
<option value="Gas - 30MV">Gas - 30MV</option>
<option value="Gas-24 V">Gas-24 V</option>
<option value="Gas-750MV">Gas-750MV</option>
<option value="Gas Furnace or Boiler & Water Heater">Gas Furnace or Boiler & Water Heater</option>
<option value="Oil - All Systems">Oil - All Systems</option>
<option value="DRAFT INDUCERS">DRAFT INDUCERS</option>
<option value="SAFETY SWITCHES">SAFETY SWITCHES</option>
<option value="STAR KAP® CHIMNEY CAPS">STAR KAP® CHIMNEY CAPS</option>
<option value="EVENAIR® AIR BOOSTERS">EVENAIR® AIR BOOSTERS</option>
<option value="GAS VENT DAMPERS">GAS VENT DAMPERS</option>
<option value="UV-AIRE™ AIR PURIFIERS">UV-AIRE™ AIR PURIFIERS</option>
<option value="WATER SENTRY PRO™">WATER SENTRY PRO™</option>
<option value="ACCESSORIES">ACCESSORIES</option>
<option value="MISCELLANEOUS">MISCELLANEOUS</option>
</select>
<center><p>OR</p></center>

  <select name="category">
	    <option selected>Select Category if Wiring Diagrams</option>
	    <option value="For SWG Power Venter or DI Draft Inducer">For SWG Power Venter or DI Draft Inducer</option>
	    <option value="For CAS Units">For CAS Units</option>
	    <option value="Misc. Wiring Diagrams">Misc. Wiring Diagrams</option>
      </select>
	  <BR />
</td></tr> 
<tr>

<? echo " <td align=\"center\" valign=\"top\"> <p>Select which section to display the
file in:<br /><br />
<input type=\"radio\" name=\"section\" value=\"instructions\"
print($section_instructions);>Instructions
<input type=\"radio\" name=\"section\" value=\"wiring\"
print($section_wiring);>Wiring Diagrams <br />
<input type=\"radio\" name=\"section\" value=\"bulletins\"
print($section_bulletins);>Tech Bulletins
<input type=\"radio\" name=\"section\" value=\"literature\"
print($section_literature);>Literature

    </p></td>
</tr>
<tr> 
  <td align=\"center\" valign=\"top\"> 
    <p> 
      <input name=\"upload\" type=\"submit\" class=\"box\" id=\"upload\" value=\"  Upload  \">
    </p></td>";

echo "
</tr>
</table>
</form>
</p>
<p> </p>
<hr>
<table width=\"720\" border=\"0\" align=\"center\" cellpadding=\"4\" cellspacing=\"0\">

<td align=\"center\" valign=\"top\"><p><strong>Current Instruction Manuals:</strong></center></strong></p>
<p>    ";          

$query  = "SELECT id, name, linktitle FROM upload WHERE section = 'instructions'";

$result = mysql_query($query) or die('Error, query failed: ' . mysql_error());
if(mysql_num_rows($result) == 0)
{
echo "Database is empty <br>";
}
else
{
while(list($id, $name, $linktitle) = mysql_fetch_array($result))

{
   echo "<a href=\"fchuploadedit.php?id=$id;\"> 
          $linktitle
          </a><BR />
		  <em>PDF Name: $name</em><br><br>";

}

}

echo "</td><td></td>
<p> </p>

<td align=\"center\" valign=\"top\"><p><strong>Current Wiring Diagrams:</strong></p>
<p>";
$query  = "SELECT id, name, linktitle FROM upload WHERE section = 'wiring'";

$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo "Database is empty <br>";
}
else
{
while(list($id, $name, $linktitle) = mysql_fetch_array($result))
{
echo "<a href=\"fchuploadedit.php?id=$id;\">
$linktitle
</a><BR />
<em>PDF Name: $name</em><br><br>";

}
?>

Nomaad

You can ignore most of the form stuff in there, I was heading home when I saw your post and didn't feel like removing all of it. You can replace it with your own form fields.

neonorange79

Hey, i'm new here too...
I've got EXACTLY the same problem, and i've tried a number of (failed) workarounds. I would really appreciate it if somebody could either comment the code above more clearly so i can follow it, or if somebody could post a slightly clearer example. I really do appreciate the previous reply, i'm just having trouble following it.

Just fyi, my situation is this: I'm writing my own php-mysql CMS, and for the photo gallery, i want to be able to upload a photo, generate a thumbnail for the photo, and then add details and comments on the photo in a form, and store this and the file/thumbnail locations in a mysql database. Currently, i've got 3 php files: the first is for me to select the directory (or create a new directory) for the new photograph, the second file allows me to upload the file and then generates the thumbnail, and the third file adds all the data. Needless to say, it's a complete disaster!

Please help!

Nomaad

Hope this helps. Most everything needs to stay the way it is. I don't know that it will work for you if the UPLOAD field names are changed since I am using an HTTP method. I think it needs certain info to upload correctly. I have tried to explain the lines you need. The formnumber thingi was just for my form. Your form may be different.

<?
// here you are getting your ID kept so you can 
// call it in dynamic links latter on
if(isset($_GET['id']))
{
// define ID
$id = $_GET['id'];
// this will be YOUR query to get the DB going 
// for the upload
$query = "SELECT name, type, size, path FROM upload WHERE id = '$id'";
$result = mysql_query($query) or die('Error, query failed');
// you'll need to name image section fields the same
list($name, $type, $size, $filePath) = mysql_fetch_array($result);

// set the header info for upload and gather some info
header("Content-Disposition: attachment; filename=$name");
header("Content-length: $size");
header("Content-type: $type");

// tell it where the file lives 
readfile($filePath);

// exit this portion 
exit;
}

?>	

<!--// IN THE BODY //-->

<?
//define this page so you can call it in the form action
$this_file = 'fchupload.php';

// set the directory for uploads
$uploadDir = '../pdfs/';

//this was just an extra define of the ID field 
// ended up not using but forgot to take it out, 
// it can be removed
$bid = $_POST['bid'];

// post the form 
if(isset($_POST['upload']))
{

$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];


// set the file path
$filePath = $uploadDir . $fileName;

// move the file from tmp directory to the one 
// you want it in
$result = move_uploaded_file($tmpName, $filePath);
if (!$result) {
echo "Error uploading file";
exit;
}

// I think this adds slashes if your file has quotes in it
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
} 

// to the best of my understanding this section
// would only be needed if register_globals is 
// off in your install, which is the case for me and 
// these have nothing to do with what you may
// be posting but are needed for each field that
// will be populated with data
$formnumber = $_POST['formnumber'] ;
$quantity = $_POST['quantity'] ;

$section = $_POST['section'] ;
${'section_'.$section} = "checked=\"checked\"" ;

$linktitle = $_POST['linktitle'] ;

$category = $_POST['category'] ;
${'category_'.$category} = "selected=\"selected\"" ;

// set YOUR insert here this was for my needs only
$query = "INSERT INTO upload (formnumber, quantity, section, linktitle, category, name, size, type, path ) ".
"VALUES ('$formnumber', '$quantity', '$section', '$linktitle', '$category', '$fileName', '$fileSize', '$fileType', '$filePath')";

mysql_query($query) or die('Error, query failed : ' . mysql_error());

// show some sort of success 
echo "<br><center><h3>File Uploaded</strong></h3><br>";
} 

// this is your form
echo "<form action=\"$this_file\" method=\"post\" enctype=\"multipart/form-data\" name=\"uploadform\">
<table width=\"350\" border=\"0\" align=\"center\" cellpadding=\"8\" cellspacing=\"1\" class=\"box\">
<tr> 
// make sure you have the lines below
<td align=\"center\" valign=\"top\"> 
<p>Browse to find the .PDF file you would like to upload:</p>
<p>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"5000000\">
<input name=\"userfile\" type=\"file\" class=\"box\" id=\"userfile\">
</p></td>
</tr>"; ?>

Nomaad

Do a search for the "maaking uploader" PHP and find the script. That is what mine is loosely based around. As well as some tutorials online.