PHP & MYsql, username, pass and downloads

[larsj]

I want to set up an page to log in with username and password, and users would be able to select downloads from the database.
like admin.php and downloads.php or users.php

I need an admin page where I can add new users and downloads to the database.

Result of admin page would be existing users and downloads, and possibility to add new records to both tables, and with an browse button for files of course.😃

Users get redirected to the user page where sql returns the result from the downloads table.

Im new to this, and I picture how it would look like, but I cant get the right way to start.

Please help me, thanks😕

[LordShryku]

Starting a new, database heavy project, I'll usually start with the database design. Think of how data should link to each other, how you want things stored, and the fastest most reliable way of using your SQL with this. After the design is done, building the pages for it shouldn't be that hard.

[larsj]

Tables would look something like this:

---

Downloads ;

FileID

Filename

Users;

Firstname
Last name

Username

---

My userpage would then display current downloads aviable with a link to its name.

My admin page would then display Users in database, and downloads in database.

I would be able to add new users adn files through a page, or 2 different, dosnt matter, just that i can use the web interface..

Maby i miss a table? im not so "in" to this yet 😃 but i hopefully learn alot with this question.

[larsj]

maby i could start the admin page with something like this:

<?php
    /* Connecting, selecting database */
    $link = mysql_connect("localhost", "username", "passwd")
        or die("Could not connect : " . mysql_error());
    print "Current Users";
    mysql_select_db("users") or die("Could not select database");


/* Performing SQL query */
$query = "SELECT uname, name, lastname  FROM users";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
?>

And do something similar with downloads table.

Then its the question, how to get this working... to add new records with the admin page, i cant see the links and how its done, just picture of how the result would be..

[olaf]

and the 5 years old child asked Henry Ford "how do i build a car"

🆒

maybe you have to start with some simple tutorials like "how to create repeat regions, insert records, arrays..."

looc in th article secrion on this page

[larsj]

Originally posted by olaf
and the 5 years old child asked Henry Ford "how do i build a car"

🆒

maybe you have to start with some simple tutorials like "how to create repeat regions, insert records, arrays..."

looc in th article secrion on this page

I doubt that a 5 yr old child knew much about cars at that time ... and surtenly how to build one, so this didnt help at all, shame on u 😛

So hopefully there is someone that can help, and yes, i have read some tutorials.. but where do i find for something like this?

Thanks

[olaf]

Hi,

what you are looking for is not only a question of "how do I set a table". There are so many features what you have to learn. Maybe it helps to try Dreamweaver, the most common features should be done by this software without knowledge in PHP