HTH - Anthony
<?php
/* add.php -- part of the SOGI website media module
writen by Knightrider version 1.0 9-24-02
This script will alow a user to upload files into the database
*/
// lets include some files so that this crap will work
include 'database.inc';
include 'functions.inc';
// get some info from the config record so we know about upload settings
getConfig();
//echo "<pre>Diag mode:<BR>";
//print_r($HTTP_POST_VARS);
if (empty($_POST['short']) || empty($_FILES['newfile']) || empty($_POST['gen']) || empty($_POST['category']))
{
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>SOGI Media Module - Upload a file</title>
<link rel='stylesheet' type='text/css' href='media.css'>
</head>
<body>
<table border='0' width='100%'>
<tr>
<td width='50%' valign='top'class='pageheader'>
Media - Add a file
</td>
<td width='50%'>
</td>
</tr>
</table>
<HR class='headertxt'>
<table width='500' class='border'>
<tr>
<td align='center'>
<form method='post' action='add.php' enctype='multipart/form-data'>
Upload an Image File
Please fill in the details below to upload your file.<BR>
Fields shown in <font class='bad'>red</font> are mandatory.
<?
if (isset($_POST['submit']))
echo "<p class='bad'>You did not enter info into a required field!</p>";
?>
<table width='100%' class='border'>
<col span='1' align='right'>
<tr>
<td valign='top'>
<font class='bad'>Short description:</font>
</td>
<td>
<input type='text' name='short' size=50><BR>
</tr>
<tr>
<td>
Long Description
</td>
<td>
<textarea rows='5' name='longdesc' cols='33'></textarea><BR>
</td>
</tr><tr>
<td>
Uploaded by:
</td>
<td><input type='text' name='user' cols='33'>
</td>
</tr><tr>
<td>
<font class='bad'>Select a Car Type</font>
</td>
<td><select size='1' name='gen' class='smalltext'>
<option selected >Select One</option>
<? catDropDown('1'); ?>
</select>
</tr><tr>
<td>
<font class='bad'>Select a media depiction</font>
</td><td>
<select size='1' name='category' class='smalltext'>
<option selected >Select One</option>
<? catDropDown('2'); ?>
</select>
</td>
</tr>
<tr>
<td><font class='bad'>File:</font></td>
<td><input name='newfile' type='file'></td>
</tr>
<tr>
<td align='right'>
<input type='hidden' name='MAX_FILE_SIZE' value='16777216'>
<input name='submit' class='smalltext' type='submit' value='Upload your file'>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<div align="center">
<table border="0" width="300" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="center" class="smalltext">
<hr class="headertxt">
<a href="default.php">Browse Media</a>
</td>
</tr>
</table>
</div>
</body>
</html>
<?php
}
else
{
$s=""; // set the var blank to add to query
// Was a file uploaded?
if (is_uploaded_file($_FILES['newfile']['tmp_name']))
{
// open and read the uploaded file
$file1=fopen($_FILES['newfile']['tmp_name'], "r");
$file=fread($file1, $_FILES['newfile']['size']);
// Escape special characters in the file
$file=AddSlashes($file);
$tmp=split('/',$_FILES['newfile']['type']);
if ($tmp[0]=='image')
{
$size = getimagesize($_FILES['newfile']['tmp_name']);
$s=",width='{$size[0]}', height='{$size[1]}'";
}
}
else
$file=NULL;
$insertQuery = "INSERT INTO media_files SET
shortdesc='{$_POST['short']}',
longdesc='{$_POST['longdesc']}',
username='{$_POST['user']}',
mimetype='{$_FILES['newfile']['type']}',
filedata='{$file}',
filesize='{$_FILES['newfile']['size']}',
filename='{$_FILES['newfile']['name']}',
uploaded=CURDATE(),
category1='{$_POST['gen']}',
category2='{$_POST['category']}'
";
$insertQuery.=$s;
// check for unknown file type, if it's unknown, automatically censor it.
$foo=split("/",$_FILES['newfile']['type']);
if (AUTOCENSOR or !($foo[0]=="image" or $foo[0]=="video" or $foo[0]=="audio"))
$insertQuery.=", censor='t'";
if ((doQuery($insertQuery)))
{
//&& @ mysql_affected_rows() == 1)
$lastid=mysql_insert_id();
$statement="INSERT INTO media_stats SET id=$lastid";
if ((doQuery($statement)))
{
header("Location: receipt.php?status=T&file=$lastid");
}
else
{
echo getError();
}
}
else
echo getError();
}
?>
HTH - Anthony
Boa Constructor wrote:
I'm new to file uploads, however I managed to get it working. Are you copying the file after its been uploaded? If not you need to do this as the temp file is destroyed after the script has finished running so you need to copy it if you wish to store it. You also will have to chmod 777 to the directory you wish to copy the file to. It may help if we can see the tutorial to try and find out exactly what you are doing.I've been working from "Build Your Own Database Driven Website Using PHP & MySQL" By Kevin Yank and its really helpful it covers file uploads. I'm also using "PHP and MySQL Web Development" by Luke Wellling and Laura Thomson. This covers file uploads also, infact I found it more helpful for file uploads. Hope this helps. Cheers, G :) ----- Original Message ----- From: "Seabird" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 13, 2002 8:47 PM Subject: [PHP-DB] upload data to MySqlHi everyone, I don't get my upload to work properly. It's a tutorial of the web, but it doesn't function (unless I made a mistake). Please help me... I have a form passing on 5 fields (text for testing), name: year, make, model, price, picture and submit to PHP_SELF <?php if ($submit) { $db = mysql_connect("localhost","myname","mypassword"); mysql_select_db("$test",$db); //DB Test for testing... $sql = "INSERT INTO test (year,make,model,price,picture) VALUES ('$year,$make,$model,$price,$picture')"; //I created these columns in the table test echo "year: $year<br>\n"; echo "make: $make<br>\n"; echo "model: $model<br>\n"; echo "price: $price<br>\n"; echo "picture: $picture<br>\n"; } ?> I know I need globals on for this. Thanx for the help, Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching???? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php