Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Old 12-17-2007, 12:26 AM Phpmyadmin help
Novice Talker

Posts: 7
Name: Jordan
Trades: 0
I'm trying to create a user database but every time I try I screw something up and the "user cannot be added to the database". Can someone give me a tutorial on how to make a user login/registration system using phpmyadmin?
__________________
My name is... DEAD... because I killed it

Please login or register to view this content. Registration is FREE
daweefolk is offline
Reply With Quote
View Public Profile Visit daweefolk's homepage!
 
 
Register now for full access!
Old 12-17-2007, 07:20 AM Re: Phpmyadmin help
Experienced Talker

Posts: 30
Trades: 0
Maybe show, what you have so far, and what you are acctualy looking for..
klaroen is offline
Reply With Quote
View Public Profile
 
Old 12-17-2007, 08:08 AM Re: Phpmyadmin help
Novice Talker

Posts: 7
Name: Jordan
Trades: 0
ok well what i was doing is the tutorial at http://www.daniweb.com/forums/thread97183.html and i had it all done except i can't figure out the "name type Addition" when making the table. I have a feeling that's why it won't let me create new users. Can you show me how to set a table to name type addition?
__________________
My name is... DEAD... because I killed it

Please login or register to view this content. Registration is FREE
daweefolk is offline
Reply With Quote
View Public Profile Visit daweefolk's homepage!
 
Old 12-17-2007, 11:50 AM Re: Phpmyadmin help
Experienced Talker

Posts: 30
Trades: 0
You can insert a table in phpmyadmin in 2 easy ways:

#1, run a mysql query. I made one that is suppose to work for your tutorial.
When you just open PHPmyadmin you select your database, and then click "SQL" button at the top. Insert the next text and run it. The table should then be created.
PHP Code:
CREATE TABLE `dbUsers` (
  `
idint(10unsigned NOT NULL auto_increment,
  `
usernamevarchar(16NOT NULL,
  `
passwordchar(255NOT NULL,
  `
emailvarchar(25NOT NULL,
  
PRIMARY KEY  (`id`)
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=
#2, another way is to make it yourself. Also on the index of phpmyadmin, under the list of your tables, you can create a new one at the bottom. And you can then make it.
klaroen is offline
Reply With Quote
View Public Profile
 
Old 12-17-2007, 01:27 PM Re: Phpmyadmin help
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,517
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
name = the column name (id, username, password etc)

type = the column type (int, longint, text, memo, blob etc)

addition = any modifiers added to the column (unique, auto_increment, NOT NULL etc)
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 01-02-2008, 04:49 AM Re: Phpmyadmin help
©®azy-¢øÐ3R's Avatar
Average Talker

Posts: 19
Name: kokokoko
Trades: 0
ye and make sure the varibles always match....
©®azy-¢øÐ3R is offline
Reply With Quote
View Public Profile
 
Old 01-02-2008, 11:07 AM Re: Phpmyadmin help
Skilled Talker

Posts: 75
Name: Nick Cousins
Location: Northern Ireland
Trades: 0
There is an excellent article here:

http://www.evolt.org/article/PHP_Log...384/index.html

This is about the best tutorial to creating a login system that I have seen. I have personally implemented this one, and it really is an excellent system and didn't take much modification for my purpose.

Check it out.
__________________
Join
Please login or register to view this content. Registration is FREE


Knowledge is power. Never underestimate the power of stupid people in large numbers.

HandCoder is offline
Reply With Quote
View Public Profile Visit HandCoder's homepage!
 
Reply     « Reply to Phpmyadmin help
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.24371 seconds with 12 queries