insert into Question??

brother

Hi,

I have put In a foreign key that I want to use at a other part (upload section!).
The key is coming from the user registration!!
A part from the Upload-section, I wonder on how to insert into my new key..😕 😕

$dbh = @mysql_connect("19XXXX","root","")
		or die("Kunde inte ansluta mot databasen!");
		mysql_select_db("member");

	$filnamn = $_FILES['fildata']['name'];
	$filtyp = $_FILES['fildata']['type'];
	$filstorlek = $_FILES['fildata']['size'];

	$fildata = addslashes(fread(fopen($_FILES['fildata']['tmp_name'], "rb"), filesize($_FILES['fildata']['tmp_name'])));

	$sql = "INSERT INTO upload (SELECT users.userid, upload.filnamn ,upload.filtyp, upload.fildata, upload.besk
				FROM upload  INNER JOIN  users 
				ON upload.userid = users.userid)";

	//$sql = "INSERT INTO upload (filnamn, filtyp, filstorlek, fildata, besk)";
	$sql .= " VALUES ('$filnamn','$filtyp','$filstorlek','$fildata','$besk')";
	mysql_query($sql);

	$fil_id = mysql_insert_id();

	echo "<h3>Filen fick ID $fil_id</h3><br>";
	mysql_close();

The new code: $sql = "INSERT INTO upload (SELECT users.userid, upload.filnamn ,upload.filtyp, upload.fildata, upload.besk
FROM upload INNER JOIN users
ON upload.userid = users.userid)";

I asume I have to change at some other place also...can anyone help me?? was that first section right?...hmmm?

brother from sweden

Najjar

can you explain more
as where do you want to insert the key
and the tables you are using
because you are using one sql statment and the way you are
coding will never insert the key

brother

Hi Najjar,

I want in some way to implent an upload function in a users personal side where he can upload files, that are his personal ones and that nobody else can get..!
The table users use sessions, the upload code havent that im not sore on howe to do that, in that way..?

I dont know on how to make the file upload, okay!! to come to my solution...:-)

Please help desperate swede..!!

CREATE TABLE upload (
fid mediumint(9) NOT NULL auto_increment,
userid int(25) ,
filnamn varchar(255) default NULL,
filtyp varchar(255) default NULL,
filstorlek varchar(50) default NULL,
fildata blob,
besk varchar(255) default NULL,
PRIMARY KEY (fid)
) TYPE=MyISAM;

<?php <?php 
<html> 
<head> 
<title>Uppladdning av fil mot MySQL</title> 
</head> 
<body> 
<?php 

if (isset($_FILES['fildata'])) { 
   if (is_uploaded_file($_FILES['fildata']['tmp_name'])) { 
      if (empty($_POST['besk'])) 
         $besk = "Ingen beskrivning"; 
      else 
         $besk = $_POST['besk']; 

  $dbh = @mysql_connect("19XXX","root","") 
  or die("Kunde inte ansluta mot databasen!"); 
  mysql_select_db("member"); 


  $filnamn = $_FILES['fildata']['name']; 
  $filtyp = $_FILES['fildata']['type']; 
  $filstorlek = $_FILES['fildata']['size']; 

  $fildata = addslashes(fread(fopen($_FILES['fildata']['tmp_name'], "rb"), filesize($_FILES['fildata']['tmp_name']))); 


           $sql = "INSERT INTO upload (userid, filnamn, filtyp, filstorlek, fildata, besk)"; 
           $sql .= " VALUES ('$userid', '$filnamn','$filtyp','$filstorlek','$fildata','$besk')"; 
           mysql_query($sql); 


  $fil_id = mysql_insert_id(); 

  echo "<h3>Filen fick ID $fil_id</h3><br>"; 
  mysql_close();       
   } 
} 
echo "<h2>Filer i databasen</h2>\n"; 
$dbh = @mysql_connect("194XXXXX","root","") 
or die("Kunde inte ansluta mot databasen!"); 
mysql_select_db("member"); 

$sql = "SELECT fid, filnamn, filtyp, filstorlek, besk FROM upload"; 

$result = mysql_query($sql); 
echo "<table border=0>\n"; 
echo "<tr bgcolor=\"#AAAAAA\"><td>Filnamn</td><td>Filtyp</td><td>Filstorlek</td><td>Beskrivning</td></tr>\n"; 
while ($rad=mysql_fetch_array($result)) { 
   echo "<tr bgcolor=\"#EEEEEE\">\n"; 
   echo "<td><a href=\"download.php?fid=$rad[0]\">$rad[1]</a></td>"; 
   echo "<td>$rad[2]</td><td>$rad[3]</td><td>$rad[4]</td>\n"; 
   echo "</tr>\n"; 
} 
echo "</table>\n"; 
mysql_close(); 

?> 
<h2>Uppladdning av fil mot MySQL databas</h2> 
<form action="<?=$PHP_SELF?>" method="post" enctype="multipart/form-data"> 
Fil att ladda upp:<br> 
<input type="file" name="fildata" size="40"><br> 
Beskrivning av filen:<br> 
<input type="text" name="besk" size="40"><br> 
<input type="reset" value="Återställ"> 
<input type="submit" value="Skicka fil"> 
</form> 
</body> 
</html> 
?>

brother

Najjar

userid field in the table is autoincrement filed
that means when you want to insert values to the table
you do not include it (userid) in the insert because its an auto field

as in this sql stat.
$sql = "INSERT INTO upload (userid, filnamn, filtyp, filstorlek, fildata, besk)";

$sql .= "VALUES '$userid', '$filnamn','$filtyp','$filstorlek','$fildata','$besk')";

I suggest that you insert in the first table and then send the
valuse of $fil_id in a hidden field to the other page.

as
echo "<INPUT TYPE='HIDDEN' NAME='fil_id' VALUE='$fil_id'>";

so keep doing what you are doing but send the value of fil_id
in a hidden field.

good luck

brother

Hi Najjar and thanks for your answer!
I just have some ?

This part.. could you explain that little bit more, what do I insert in the first table (users..???):

I suggest that you insert in the first table and then send the valuse of $fil_id in a hidden field to the other page.
as echo "<INPUT TYPE='HIDDEN' NAME='fil_id' VALUE='$fil_id'>";

You are mentioning that I use autoincrement (userid), will I take away userid from upload or do I have to change the aoutoincr. in some manner...?

Thanks again and your time!

brother

Najjar

What I'm saying that you can not insert any value to an autoincrement field as you have:
$sql = "INSERT INTO upload ( userid , filnamn, filtyp, filstorlek, fildata, besk)";

$sql .= "VALUES (' $userid ', '$filnamn','$filtyp','$filstorlek',
'$fildata','$besk')";

Note the bold value userid - take it out of your sql statment like this:
$sql = "INSERT INTO upload (filnamn, filtyp, filstorlek, fildata, besk)";

$sql .= "VALUES ('$filnamn','$filtyp','$filstorlek',
'$fildata','$besk')";

then use
$fil_id = mysql_insert_id();

and send the value of $fil_id in a hidden field as:

echo "<INPUT TYPE='HIDDEN' NAME='fil_id' VALUE='$fil_id'>";

Do not mention my help I really did not do alot
Plus that I live for help 🙂

brother

Hi Najjad...🙂

I believi I missed something....🙁

my new tables:

CREATE TABLE upload (
fid mediumint(9) NOT NULL auto_increment,
filnamn varchar(255) default NULL,
filtyp varchar(255) default NULL,
filstorlek varchar(50) default NULL,
fildata blob,
besk varchar(255) default NULL,
PRIMARY KEY (fid)
) TYPE=MyISAM;

I dont have to??
put in some new fields at table users ( my inlogg section for the users..) To seperate the files from one user to a other user..?

earlier discussion..

I want in some way to implent an upload function in a users personal side where he can upload files, that are his personal ones and that nobody else can get..!
The table "users" use sessions, the upload code havent that im not sore on howe to do that, in that way..?

The php code after last change..!

$sql = "INSERT INTO upload ( filnamn, filtyp, filstorlek, fildata, besk)"; 
					$sql .= " VALUES ('$filnamn','$filtyp','$filstorlek','$fildata','$besk')"; 
					mysql_query($sql); 



	$fil_id = mysql_insert_id();

    echo "<INPUT TYPE='HIDDEN' NAME='fil_id' VALUE='$fil_id'>";  // NAJJAD!!!!!

	echo "<h3>Filen fick ID $fil_id</h3><br>";
	mysql_close();		
}
}
echo "<h2>Filer i databasen</h2>\n";
$dbh = @mysql_connect("19xxxxx","root","")
or die("Kunde inte ansluta mot databasen!");
mysql_select_db("member");

Sometimes its hard to explain...sorry!
1. I have a Login for the User (private side), then when he is in there he can upload his own files = (private)...:p

hope this will help!

Brother south of sweden... (thanks again!)

Najjar

So did you fix the problem or not
If not please give me the error you are getting

One more thing that I noticed that you have the fid
as an auto increment field too --> that means you can not
insert the values in it

You need to set the field as foreign key but not auto increment

brother

hello again,

Im not that sure on howe to set up the Keys
you are mentioning, what do you think of this..?

The problem I had was that the files was not seperated (all the same...for all) to the the right user that was logged in...:-(

The Tables:

CREATE TABLE users (
userid int(25) NOT NULL auto_increment,
fid mediumint(9)

first_name varchar(25) NOT NULL default '',
last_name varchar(25) NOT NULL default '',
adress varchar(25) NOT NULL default '',
postnummer varchar(25) NOT NULL default '',
stad varchar(25) NOT NULL default '',
email_address varchar(25) NOT NULL default '',
username varchar(25) NOT NULL default '',
org_nummer varchar(25) NOT NULL default '',
company_namn varchar(25) NOT NULL default '',
mobil varchar(25) NOT NULL default '',
info text NOT NULL,
avtal varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
user_level enum('0','1','2','3') NOT NULL default '0',
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
last_login datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') NOT NULL default '0',
PRIMARY KEY (userid)
FOREIGN KEY (fid)
) TYPE=MyISAM;

CREATE TABLE upload (
fid mediumint(9) NOT NULL,
filnamn varchar(255) default NULL,
filtyp varchar(255) default NULL,
filstorlek varchar(50) default NULL,
fildata blob,
besk varchar(255) default NULL,
FOREIGN KEY (fid)
) TYPE=MyISAM;

Do I not need to have a Primary key at Upload....?

Brother

Najjar

This looks good.

But why do you need fid mediumint(9) in the table users
you want it to be in table upload only! right?

brother

hi again,

If i follow what we have discussed, I come to this solution....and it doesnt go throw the error check....:-(

Error message from uploadpart....Tried both MyISAM & InnoDB

"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')TYPE=MyISAM' at line 1"

At the upload part dont I have to have a Primary key...??

CREATE TABLE users (
userid int(25) NOT NULL auto_increment,
first_name varchar(25) NOT NULL default '',
last_name varchar(25) NOT NULL default '',
adress varchar(25) NOT NULL default '',
postnummer varchar(25) NOT NULL default '',
stad varchar(25) NOT NULL default '',
email_address varchar(25) NOT NULL default '',
username varchar(25) NOT NULL default '',
org_nummer varchar(25) NOT NULL default '',
company_namn varchar(25) NOT NULL default '',
mobil varchar(25) NOT NULL default '',
info text NOT NULL,
avtal varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
user_level enum('0','1','2','3') NOT NULL default '0',
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
last_login datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') NOT NULL default '0',
PRIMARY KEY (userid)
) TYPE=InnoDB;

brother

Najjar

Check you SQL statement in MySQL not in the program
and see where is the error.

brother

Hi,

???
At the upload part dont I have to have a Primary key...??

brother