Multiple Variables Insertions from one Page in to one Field

[moog69]

Excuse me if I'm asking a stupid question, but I'm a complete Newbie.
Basically what I'm trying to do is to have a insertion webpage, which can access 2 fields. The first field is "User" and the second field is "FileName".
I want to be able to have multiple "FileName" insertions with only one "User" insertion. So that the input into the "User" insertion field will be the same for each of the different "FileName" insertions.
ie
INPUT
User : John
Filename: alpha
Filename: beta
Filename: gama

DATABASE

User | FileName

John alpha
John beta
John gama

Any Ideas?
Thanks for reading 🙂

[gufmn]

I don't see the problem. For each insert query just use the same user name. Am I missing something here?

[Aybabtu]

Put your filenames into an Array and then use a [man]while[/man] statement to run your query until the array is empty. I can go more in depth if you would like but this should get you started.

[laserlight]

moog69, you might want to read up on Database Normalization and Design Techniques.

[moog69]

If you could get me started with your arrays and while statement idea that would be great!
I have a limited php vocab. Sorry. I'm only starting into the world of php. I'm more use to actionscript and html. I'm sure when I spend a few monthes at it, this problem will seem so simple.
Thanks for reading.
moog69

[cyberlew15]

Okay you basicly want them to be able to enter a username and gain access to three files based on my understanding of this here is my help

Think of an array like a Treeview or XML file you can have a simple array

array(apple, plum, pear);

or you could have a mor complex multidimensional array. Now I know this sounds a little bit stephen hawking but it's just like having a child node so think of multidimensional arrays like

parent1
child1
grandchild1
grandchild2
parent2
child1
grandchild1
grandchild2
grandchild3
grandchild4
child2
grandchild1
parent3
child1
grandchild1
grandchild2
grandchild3

now essentially a multidimensional array could encompas the whole family tree but for this we would probably like to use a database instead. creating arrays drains php's resources until it adversely affects the entire script.

what you want is a multidimensional array in this format

array
username1
alpha file
beta file
gamma file
username2
alpha file
beta file
gamma file

to access the username username1 it would be array[0];
to access the alpha file fr username 1 it would be array[0][0];
to access the beta file from username 1 it would be array[0][1];
and so on if you find this hard you can have user1 and include the file for user1 which would contain the array data for user1

if(file_exists($userdir.$_POST['uname'].$extension)){
     include ($userdir.$_POST['uname'].$extension);
}
if(!file_exists($userdir.$_POST['uname'].$extension)){
     echo "this is an invalid username please die!";
}

😃