yesterday i started writing a little program, which uploads files (till now pics prefered) to the folder, which contains the PHP-file.
on the first page, u select the file u want to upload, and may enter a Title( in order to enable a gallery-database with my-sql);
second page shows u wether the data has been sent to the database([COLOR=Red]THIS IS THE MAIN PROBLEM because it wont save anything to the database[/COLOR]), info about the file, where its gonna be saved, or if a file(pic) alrady exists with the same name, in this case the script should view the “new-version”(which cant be uploaded) and the “old-version”(which alrady exists"[COLOR=Red]but problem is, it wont show the already existing file
[COLOR=Black]here are the two scripts, and css(in order u need to see more)
FIRST FILE,
[/COLOR][/COLOR]
<html>
<head>
<link rel="stylesheet" type="text/css" href="style_1.css">
</head>
<body>
<div style="background-color:#efefef;width:480px;border:5px solid #00c000;padding:1px;margin:0px auto;text-align:center;">
<form enctype="multipart/form-data" action="showit.php" method="post">
data: <input name="upfile" type="file" size="25">
<p>titel: <input name="titel" size="25">
<p><input type="submit" value="send" name="sent">
</form>
</div>
</body>
</html>
**SECOND FILE
**
<html>
<head>
<link rel="stylesheet" type="text/css" href="style_1.css">
</head>
<body>
<div style="background-color:#efefef;width:480px;margin:0px auto;border:5px solid #00c000;padding:1px;text-align:center;">
<?php
if(isset($sent))
{
mysql_connect(localhost,root);
mysql_select_db("daten");
$sqlab = "insert upload (name, typ, titel) values ($upfile_name, $upfile_type, $titel)";
mysql_query($sqlab);
$num = mysql_affected_rows();
}
if ($num>0)
{
echo "<g>one data has been added<p></g>";
}
else if($num<=0)
{
echo "<r>an Error appeared, ";
echo "no data has been added<p></r>";
}
echo "<h3><ul><k>control:</k></ul></h3><p>";
echo "original-name: <zitat>$upfile_name</zitat><br>";
echo "size: <zitat>$upfile_size Byte</zitat><br>";
echo "type: <zitat>$upfile_type</zitat><br>";
$dname = explode(".",$upfile_name);
$dnamesize = count($dname);
$upfile_ext = $dname[$dnamesize-1];
echo "data-extension: <zitat>" . $upfile_ext . "</zitat><br>";
list($headw, $headh) = getimagesize($upfile);
echo "original-properties: <zitat>" . $headw . "x" . $headh . "</zitat><br>";
$verz = getcwd();
$exi = $verz ."/". $upfile_name;
if($upfile_size>0 && !file_exists($exi))
{
echo "new home of " . $upfile_name . " : <zitat>" . $verz. "</zitat><br>";
copy($upfile,$upfile_name);
echo "data has been copied in: <zitat>$upfile_name</zitat><br>";
if($headw>470)
{
echo "<img src= $upfile_name width= '470'>";
}
else
{
echo "<img src= $upfile_name>";
}
}
else if(file_exists($exi))
{
echo "<r>a file with the name: <zitat>" . $upfile_name . "</zitat> does already exist!</r><br>";
echo "<table>";
echo "<tr><td><k>new-" . $upfile_name . "</k></td><td><k>old-" . $upfile_name . "</k></td></tr>";
echo "<tr><td><img src= $upfile_name width= '200'></td><td><img src= $exi width= '200></td></tr>";
echo "</table>";
}
else
{
echo "copy-error: data does not exist";
echo " or false data-type";
}
?>
</div>
</body>
</html>
and the CSS, which isnt really necessary
/----standarts-/
div {background-color:#efefef;width:480px;margin:0px auto;border:5px solid #00c000;padding:1px;text-align:center;}
body{font-family:Verdana; font-size:10pt; color:#636363; background-color:#c3c3c3}
- {font-size:10pt;color:#636363;}
/-/
/link/
a:link {color:636363}
a:visited {color:606060}
a:hover {color:606060; background-color:#a3a3a3}
/-/
/tabel/
table {border:solid 3px #ffffff;background-color:#efefef;margin:auto}
td {font-family:Verdana; font-size:10pt; color:#636363; background-color:#c3c3c3}
/_____________________/
/----class-selector-/
.top {background-color:#CCCCCC; color:#333333}
.ul {text-decoration:underline}
.ol {text-decoration:line-through}
.fett {font-weight:bold}
.italic {font-style:italic}
/-/
/color/
.red {color:#FF0000}
.blue {color:#0000FF}
.green {color:#00FF00}
.yellow {color:#FFFF00}
.key {color:#000000}
.white {color:#FFFFFF}
/_____________________/
/----typ-selector-/
/text-typen/
zitat {text-shadow:#333333; color:#0066FF}
/font-color/
r {color:#FF0000}/red/
b {color:#0000FF}/blue/
g {color:#00FF00}/green/
y {color:#FFFF00}/yellow/
k {color:#000000}/key/
w {color:#FFFFFF}/white/
/-/
/background-color/
runder {background-color:#FF0000}/red/
bunder {background-color:#0000FF}/blue/
gunder {background-color:#00FF00}/green/
yunder {background-color:#FFFF00}/yellow/
kunder {background-color:#000000}/key/
wunder {background-color:#FFFFFF}/white/
/-/
/font-decoration/
top {background-color:#CCCCCC; color:#333333}
ul {text-decoration:underline}
ol {text-decoration:line-through}
fett {font-weight:bold}
italic {font-style:italic}
/-/
[COLOR=Red]
[COLOR=Black]maybe i have to say that i am a very noob in php, and php/mysql, so please be patient:ub:
thank u
[/COLOR] [/COLOR]
