php problem

begeiste · #1 (**permalink**) Dec 16th, 2006, 17:54

Hi,
Is it possible to merge the html form with php code on the one page for file upload and how can I make the uploads for mp3,wav and ppt format on the php code section? If I want to insert a record to this html form and upload php page, is that possible? Any thoughts will be more appreciate!
This is the upload form in the html page 'fileupload.html'

HTML: Select all

<body>
<form action="fileuploads.php" enctype="multipart/form-data" method="post">
<input type="hidden" name="MAX_FILE_SIZE" value="950000" />
<p><strong>File to Upload:</strong>
<input type="file" name="fileupload" /></p>
<p><input type="submit" value="upload!" /></p>
</form>
</body>
</html>

This is the fileuploads.php page

PHP: Select all


 <?php 
$file_dir = "images"; 
foreach($_FILES as $file_name => $file_array){ 
    echo "path: ".$file_array['tmp_name']."<br>\n"; 
    echo "name: ".$file_array['name']."<br>\n"; 
    echo "type: ".$file_array['type']."<br>\n"; 
    echo "size: ".$file_array['size']."<br>\n"; 
     
    if(is_uploaded_file($file_array['tmp_name'])){ 
        move_uploaded_file($file_array['tmp_name'], "$file_dir/$file_array[name]") or die("Couldn't copy"); 
        echo "File was uploaded!<br><br>"; 
        echo "<a href='fileupload.html'> More uploads...</a>";     
    } 
} 
?>

ukgeoff · #2 (**permalink**) Dec 18th, 2006, 16:18

It's perfectly possible to include the php that processes the form in the same file as your html.

You will have to have the html file parsed by the php parser of course. You can do this by changing the file extention from .html to .php but my prefered method is to keep the .html extention and have an entry in your .htaccess file that tells the server to pass any .html file through the php parser.

The 'action' atribute in your in your 'form' element can then just look like action=''. Basically meaning process myself.

You will need to add code into the php so that it can tell the difference betwen when the file is just being displayed and when it needs to process the form data.

You can upload any type of file using the form method. How you detect the type and process it comes down to your php code.

begeiste · #3 (**permalink**) Dec 18th, 2006, 18:51

I have just copied the form action code from html page and pasted it right before the <?php tag and changed it form action code into '<?php echo $_SERVER['PHP_SELF']; ?>'. The uploadfile.php runs the action itself, it works. But I am not sure how to deal with the insert record button once a file uploaded?How do I do this insert string? Thanks for your help.

ukgeoff · #4 (**permalink**) Dec 18th, 2006, 21:19

Can you be a bit more explicite about what you are doing?

Pheonix · #5 (**permalink**) Dec 19th, 2006, 04:49

PHP: Select all


 <?php
if(is_set($_POST['upload!']))
{
    $file_dir = "images"; 
    foreach($_FILES as $file_name => $file_array){ 
        echo "path: ".$file_array['tmp_name']."<br>\n"; 
        echo "name: ".$file_array['name']."<br>\n"; 
        echo "type: ".$file_array['type']."<br>\n"; 
        echo "size: ".$file_array['size']."<br>\n"; 
     
        if(is_uploaded_file($file_array['tmp_name'])){ 
            move_uploaded_file($file_array['tmp_name'], "$file_dir/$file_array[name]") or die("Couldn't copy"); 
            echo "File was uploaded!<br><br>"; 
            echo "<a href='fileupload.html'> More uploads...</a>";     
        } 
    }
} else {
?> 
<body>
<form action="fileuploads.php" enctype="multipart/form-data" method="post">
<input type="hidden" name="MAX_FILE_SIZE" value="950000" />
<p><strong>File to Upload:</strong>
<input type="file" name="fileupload" /></p>
<p><input type="submit" value="upload!" /></p>
</form>
</body>
</html>
<?php } ?>

begeiste · #6 (**permalink**) Dec 19th, 2006, 05:00

What I wanted to do was to insert a record along with uploading file to the artwork table in the database. Obviously I have such hard time to figure out what to do on this insert.php page.
The gallery database contains 3 table below:
1.artwork (id,category(int),media(int), photo)
2.category(id,type)
3.media(id,kind)

Quote:

<?php require_once('Connections/gallery_conn.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO artwork (caption, category, media, photo) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['caption'], "text"),
GetSQLValueString($_POST['category'], "int"),
GetSQLValueString($_POST['media'], "int"),
GetSQLValueString($_POST['photo'], "text"));

mysql_select_db($database_gallery_conn, $gallery_conn);
$Result1 = mysql_query($insertSQL, $gallery_conn) or die(mysql_error());

$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_gallery_conn, $gallery_conn);
$query_rst_cat = "SELECT * FROM category";
$rst_cat = mysql_query($query_rst_cat, $gallery_conn) or die(mysql_error());
$row_rst_cat = mysql_fetch_assoc($rst_cat);
$totalRows_rst_cat = mysql_num_rows($rst_cat);

mysql_select_db($database_gallery_conn, $gallery_conn);
$query_rst_media = "SELECT * FROM media";
$rst_media = mysql_query($query_rst_media, $gallery_conn) or die(mysql_error());
$row_rst_media = mysql_fetch_assoc($rst_media);
$totalRows_rst_media = mysql_num_rows($rst_media);
?><!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>fileupload</title>
</head>

<body>
<form action="<?php echo $editFormAction; ?>" name="form1" enctype="multipart/form-data" method="POST">
Caption:
<input name="caption" type="caption" />
<br />
Category:<select name="category" id="category">
<?php
do {
?>
<option value="<?php echo $row_rst_cat['cat_ID']?>"><?php echo $row_rst_cat['type']?></option>
<?php
} while ($row_rst_cat = mysql_fetch_assoc($rst_cat));
$rows = mysql_num_rows($rst_cat);
if($rows > 0) {
mysql_data_seek($rst_cat, 0);
$row_rst_cat = mysql_fetch_assoc($rst_cat);
}
?>
</select><br />
Media:<select name="media" id="media">
<?php
do {
?>
<option value="<?php echo $row_rst_media['media_ID']?>"><?php echo $row_rst_media['kind']?></option>
<?php
} while ($row_rst_media = mysql_fetch_assoc($rst_media));
$rows = mysql_num_rows($rst_media);
if($rows > 0) {
mysql_data_seek($rst_media, 0);
$row_rst_media = mysql_fetch_assoc($rst_media);
}
?>
</select>
<input type="hidden" name="MAX_FILE_SIZE" value="950000" />
<p><strong>File to Upload:</strong>
<input type="file" name="photo" />
</p>
<p>
<input name="submit" type="submit" value="Insert" />
</p>

<input type="hidden" name="MM_insert" value="form1">
</form>
<?php
$file_dir = "images";
foreach($_FILES as $file_name => $file_array){
echo "path: ".$file_array['tmp_name']."<br>\n";
echo "photo: ".$file_array['photo']."<br>\n";
echo "type: ".$file_array['type']."<br>\n";
echo "size: ".$file_array['size']."<br>\n";

if(is_uploaded_file($file_array['tmp_name'])){
move_uploaded_file($file_array['tmp_name'], "$file_dir/$file_array[photo]") or die("Couldn't copy");
echo "File was uploaded!<br><br>";
echo "<a href='insert.php'> Add more record...</a>";
}
}
?>
</body>
</html>
<?php
mysql_free_result($rst_cat);

mysql_free_result($rst_media);
?>

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
First image problem and inline list problem	konnor5092	Web Page Design	8	Dec 1st, 2007 09:08

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
php problem