[solved] Need help setting up database tables

  • Nem
  • Guru
  • Guru
  • Nem
  • Posts: 1243
  • Loc: UK

Post 3+ Months Ago

hi,
ok, i done this php tutorial and very happy with the outcome.

I am going to be making a website for a gaming clan. I have created a password protected area "admin". This is the main source where the look can be changed (page made of css), members can be added and so on.

Now please correct me if im wrong.

(i will be using phpmyadmim btw).

I will bee a database first of all. lets call it "members" then 1 row.

This will then have 9 columns?


1) Name (gaming name)
2) Country
3) age
4) Image
5) Favorite map
6) Favorite weopon
7) favorite quote
8) username
9) password

each of these will be Varchar?

now once setting up the tables. how can i go about adding a form to add information on to the database?
And then once on that member page, to be able to edit it using a short "log in script" on that same page.

And then through the admin panel to be able to delete it.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23455
  • Loc: Woodbridge VA

Post 3+ Months Ago

Nem, glad to have you at OZZU, but please take a moment away from your studies and read our Posting Rules:

http://www.ozzu.com/announcements-rules/ozzu-rules-and-regulations-t697.html

One of the things we ask is for members to use descriptive subjects for their posts so others know what the post is about.

I edited both of your generic ones to something more specific to the questions.

Thanks.
  • Nem
  • Guru
  • Guru
  • Nem
  • Posts: 1243
  • Loc: UK

Post 3+ Months Ago

i apologize, and thank you editing in advance.
  • Nem
  • Guru
  • Guru
  • Nem
  • Posts: 1243
  • Loc: UK

Post 3+ Months Ago

i am learning how to connect to dbase etc.... but is my logical thinking, right?

Post Information

  • Total Posts in this topic: 4 posts
  • Users browsing this forum: No registered users and 123 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.