|
|
Posted by Reggie on 09/15/07 12:06
am trying to associate username and filename in my database.basically
am trying to create a script when users upload a file the file is then
associated with the user in the database.so when the user logon into
his account the database brings forward to file he or she uploaded.
I get this notice:
Notice: Undefined index: filename in /home/fhlinux169/c/clashoff.co.uk/
user/htdocs/upload.php on line 47
Could not insert data because Column count doesn't match value count
at row 1
this is the script. Am really stuck at the moment any help will be
appreciated.
<?php
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$table=""; // Table name
$target = "upload/";
$target = $target . basename( $_FILES['uploaded']['name']) ;
$ok=1;
//This is our size condition
$upload_size = $_FILES['uploaded']['size'];
if ($upload_size > 1000000000000)
{
echo "Your file is too large.<br>";
$ok=0;
}
//This is our limit file type condition
$upload_type = $_FILES['uploaded']['type'];
if ($upload_type =="text/php")
{
echo "No PHP files<br>";
$ok=0;
}
//Here we check that $ok was not set to 0 by an error
if ($ok==0)
{
Echo "Sorry your file was not uploaded";
}
//If everything is ok we try to upload it
else
{
if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target))
{
echo "The file ".
basename( $_FILES['uploaded']['name']). " has been uploaded";
$filename=basename( $_FILES['uploaded']['name']);
mysql_connect("$host", "$username", "$password")or die("cannot
connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="update $table set filename = '$filename' WHERE
username='session_is_registered('username')' ";
mysql_query($sql);
$insert = mysql_query("insert into $table values ('NULL','".
$_POST['filename']."')")
or die("Could not insert data because ".mysql_error());
}
else
{
echo "Sorry, there was a problem uploading your file.";
}
}
?>
<html>
<body>
<a href="/user.php">Return to User Page</a> </form>
</body>
</html>
Navigation:
[Reply to this message]
|