users > files

[Harbinger]

okay, authentication works.

after that how to point to appropriate files that belong to user?

bill >bill's files in an index form (a downloadable list)

sally > sally's files in an index form

any ideas?

[Harbinger]

my code if it helps...

THE AUTH FORM>>>

<?php

if (session_is_registered("valid_user"))
{
echo "You are are logged in as: $valid_user <br>";
echo "<a href=\"logout.php\">Log Out</a><br>";
}
else
{
if (isset($userid))
{
//if they've tried and failed to log in
echo "Could not log you in";
}
else
{
//they've tried to log in yet or have logged out
echo "You are not logged in.<br>";
}

//Provide form to log in
echo "<form method=post action=\"appraise.php\">";
echo "<table>";
echo "<tr><td>UserId:</td></tr>";
echo "<tr><td><input type=text name=userid></td></tr>";
echo "<tr><td>Password:</tr></td>";
echo "<tr><td><input type=password name=password></td></tr>";
echo "<tr><td colspan=2 align=left>";
echo "<input type=submit value=\"Log in\"></td></tr>";
echo "</table></form>";
}
?>

the session grabber>>>

<?php
session_start();

if ($userid && $password)
{
//If the user has just tried to log in

$db_conn = mysql_connect("localhost" , "******" , "******");
mysql_select_db("auth" , $db_conn);
$query = "select * from auth "
	."where name='$userid' "
	."and pass=password('$password')";
$result = mysql_query($query, $db_conn);
if (mysql_num_rows($result) >0 )
{
//If they are in the database register the user id
$valid_user = $userid;
session_register("valid_user");
}
}
?>

any help would be wonderful!

[cahva]

Im bit puzzled here... What do you mean users files. Do you mean doc, pdf etc. files on the server? Are they in their own directory?

Sorry, dont know what you mean with index form.

But anyway... If you want to have different files for every user. Put them in a mysql table.

Table name would be for example user_files.
Fields for the table: id,rel_userid,filename where rel_userid is relative to userid. BTW, why do you register username as userid? It would be better to register the id-number from the table for the user, so you can use that to relate to other tables.

After you have inserted the filenames in the user_files table, you can fetch them to your page

$query="SELECT * FROM user_files WHERE rel_userid='$userid'";
$result=mysql_query($query);

while ($row=mysql_fetch_array($result))
{
echo "<a href='".$row['filename']."'>".$row['filename']."</a>";
}

Something like that...

[Harbinger]

i appreciate your explanation, but it is still somewhat foggy.

i understand what you mean about making the primary key "id" and using that to relate to other tables.

my tables are now:

+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| name | varchar(10) | | | | |
| pass | varchar(30) | | | | |
| uid | int(11) | | PRI | NULL | auto_increment |
+-------+-------------+------+-----+---------+----------------+

+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| filename | varchar(100) | | | | |
+----------+--------------+------+-----+---------+----------------+

are the tables right?

yes files, like a word or exel document. as for index, i mean a dynamic page that lists the users files. they could have one file, or twenty.

would the sample script you put in there display them, or list them?

oh, and how do you get files into mysql? i have three books i am reading, but none seem to have it. :rolleyes:

i am lost still.

[Harbinger]

the new user_files table:

+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| filename | varchar(255) | | | | |
| mimetype | varchar(50) | | | | |
| description | varchar(255) | | | | |
| filedata | mediumblob | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+

hmmmm?

[cahva]

Actually I didnt mean to put files physically in the mysql-table. Just their filenames(urls). Whenever I see an article about inserting raw data to mysql, they say almost everytime: Dont do it!.

I have an idea. Lets forget totally the user-files table. I think it would be wiser to create directory for every user. And list the files according to name that user logged in. So if you have user 'bob', scan the directory 'bob' and then list that. That way, it would be sooo much easier.

I think the reason why people usually dont insert raw data to mysql is because if your mysql-table gets mangled, it would be very difficult to save it.

If you still are going to save the files to DB. Your table is allmost right. Just add the rel_userid-field to know whom that file belongs to.

Im sorry if my explanation is foggy again, Im veeery tired right now and my brain is not functioning correctly 🙂

user_files table:
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| rel_userid | int(11) | | | NULL | |
| filename | varchar(255) | | | | |
| mimetype | varchar(50) | | | | |
| description | varchar(255) | | | | |
| filedata | mediumblob | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+

[Harbinger]

cahva, do you have any examples?

would that be that fopen command?
what script would I use to tell mysql which user belongs to which directory? that is the real trouble spot for me. i am grasping this like learning a foreign language-very slowly. 🙂

[Harbinger]

anyone else have any ideas?

[cahva]

With fopen command you open files, not directories. Use opendir and then readdir. Heres an example:

<?php
// You used variable $userid for the name so you would add that as a subdirectory

$directory=$_SERVER['DOCUMENT_ROOT']."/$userid";
if ($dir = @opendir($directory)) {
	while (($file = readdir($dir)) !== false) {
  		if ($file==="." || $file==="..") {}
		else
		{
			echo $file."<br>";
		}	
	}
}
?>

This would open the dir and list the contents for the logged user. In order this to work, you must create directory which is the same as the username in your auth-table.