simple (?) upload...

mistafeesh

Hi. I'm trying to build a form with two upload buttons.

I want the files to be uploaded, and their names added to the mySQL database along with the other info.

At the moment, nothing for the files seems to be going into $POST or $FILES, so I'm stuck before I even begin.

I just used

<input type="file" id="image" name="image">

in the form, which is a normal POST form.

I don't need any code to check whether the upload is appropriate or anything, as it's only ever going to be used by trusted and savvy people anyway.

any ideas how I can do this easily?

TheDefender

Well what code are you using to even check the $_POST array to begin with? We can't help with your code if we can't see it. 😉

mistafeesh

just to see what post and file data was coming through, I have

<?php print_r($_POST); echo ":"; print_r($_FILES);
?

on the page which the form points to

onion2k

I wrote an article about this: http://www.ooer.com/index.php?section=php&id=21

In particular, make sure your form has the correct enctype.. enctype="multipart/form-data"

mistafeesh

Thanks, I'll have a look.

Unfortunately, some other urgen work has come up, so I'm going to have to leave this a couple of days, which is a real pain. I'll post back here with any Q's!!!

mistafeesh

I can't get this to work...no files arrive in the folder.

here's the code of the first page - it's built in Dreamweaver, so there's a bit of SQL and PHP in there that's DW generated - it just gets the contents of a couple of the drop down lists, and shows what's in the DB at present.

<?php require_once('../Connections/oxdance.php'); ?>
<?php

mysql_select_db($database_oxdance, $oxdance);
$query_type = "SELECT * FROM types";
$type = mysql_query($query_type, $oxdance) or die(mysql_error());
$row_type = mysql_fetch_assoc($type);
$totalRows_type = mysql_num_rows($type);

mysql_select_db($database_oxdance, $oxdance);
$query_client = "SELECT * FROM clients";
$client = mysql_query($query_client, $oxdance) or die(mysql_error());
$row_client = mysql_fetch_assoc($client);
$totalRows_client = mysql_num_rows($client);

mysql_select_db($database_oxdance, $oxdance);
$query_portfolio = "SELECT * FROM portfolio";
$portfolio = mysql_query($query_portfolio, $oxdance) or die(mysql_error());
$row_portfolio = mysql_fetch_assoc($portfolio);
$totalRows_portfolio = mysql_num_rows($portfolio);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style1 {font-family: Geneva, Arial, Helvetica, sans-serif}
-->
</style>
</head>

<body>
<p align="center" class="style1"><u>Add new portfolio item</u></p>
<form action="pf-process.php" method="POST" name="form1">

  <p> type:
<select name="typeid" id="typeid">
  <?php
do {  

?>
  <option value="<?php echo $row_type['typeid']?>"><?php echo $row_type['type_name']?></option>
  <?php
} while ($row_type = mysql_fetch_assoc($type));
  $rows = mysql_num_rows($type);
  if($rows > 0) {
      mysql_data_seek($type, 0);
	  $row_type = mysql_fetch_assoc($type);
  }
?>
    </select>
    <br>client:    

    <select name="clientid" id="clientid">
      <?php
do {  

?>
      <option value="<?php echo $row_client['clientid']?>"><?php echo $row_client['client_name']?></option>
      <?php
} while ($row_client = mysql_fetch_assoc($client));
  $rows = mysql_num_rows($client);
  if($rows > 0) {
      mysql_data_seek($client, 0);
	  $row_client = mysql_fetch_assoc($client);
  }
?>
    </select>
    <br>
    description:<br>
    <textarea name="text" cols="50" rows="7" wrap="VIRTUAL" id="text"></textarea>
</p>
  <p>  thumbnail:
    <input type="file" id="thumb" name="thumb">
  </p>
  <p>full view:
    <input type="file" id="image" name="image">
</p>
  <p>URL: 
     <input name="url" type="text" id="url">
</p>
  <p align="center">
    <input type="submit" name="Submit" value="Submit"></p>
</form>
portfolio items:
<?php do { ?>
<p class="style1"><img src="<?php echo $row_portfolio['thumb']; ?>"></p>
<p class="style1"><?php echo $row_portfolio['thumb']; ?></p>
<p class="style1"><?php echo $row_portfolio['clientid']; ?></p>

<p class="style1"><?php echo $row_portfolio['text']; ?></p>
<hr width="65%" size="1">
<?php } while ($row_portfolio = mysql_fetch_assoc($portfolio)); ?>
<p class="style1">&nbsp;</p>
<p class="style1">&nbsp;  </p>
</body>
</html>
<?php
mysql_free_result($type);

mysql_free_result($client);

mysql_free_result($portfolio);
?>

and here's the code for the page the form acts upon. all I've got going on there at the moment is your upload code as I understand it...

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php


move_uploaded_file($_FILES['thumb']['tmp_name'] ,"/Volumes/work/websites/oxdance_nu/images/pfimages/".basename($_FILES['thumb']['name']));
 /* this folder is within the web root on my testing server - I've used the physical address - is that right? */

print_r($_POST);

?>
</body>
</html>