Newbieeeee

15/09/2007, 14h06

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 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>

15/09/2007, 15h08

Show us your html form.

Where are you getting $_POST['filename'] from?

15/09/2007, 15h33

Reggie wrote:
> 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 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>
>

Additionally, you have a SQL problem which you should follow up in
comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

15/09/2007, 14h06	#1
Reggie Messages: n/a Hébergeur:	Newbieeeee 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 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>

15/09/2007, 15h08	#2
macca Messages: n/a Hébergeur:	Re: Newbieeeee Show us your html form. Where are you getting $_POST['filename'] from?

15/09/2007, 15h33	#3
Jerry Stuckle Messages: n/a Hébergeur:	Re: Newbieeeee Reggie wrote: > 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 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> > Additionally, you have a SQL problem which you should follow up in comp.databases.mysql. -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ==================

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email