Reply
Phpmyadmin help
Old 12-16-2007, 11:26 PM Phpmyadmin help
Novice Talker

Posts: 7
Name: Jordan
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
my site
daweefolk is offline
Reply With Quote
View Public Profile Visit daweefolk's homepage!
 
When You Register, These Ads Go Away!
     
Old 12-17-2007, 06:20 AM Re: Phpmyadmin help
Experienced Talker

Posts: 30
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, 07:08 AM Re: Phpmyadmin help
Novice Talker

Posts: 7
Name: Jordan
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
my site
daweefolk is offline
Reply With Quote
View Public Profile Visit daweefolk's homepage!
 
Old 12-17-2007, 10:50 AM Re: Phpmyadmin help
Experienced Talker

Posts: 30
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, 12:27 PM Re: Phpmyadmin help
chrishirst's Avatar
Super Moderator

Posts: 11,441
Location: Blackpool. UK
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!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 01-02-2008, 03:49 AM Re: Phpmyadmin help
©®azy-¢øÐ3R's Avatar
Average Talker

Posts: 19
Name: ©®azy-¢øÐ3R
Location: Doncaster
ye and make sure the varibles always match....
__________________
Samari.org <----- check it out.
Proxy @ Samari.org 'N' FatBlitz @ Samari.org...
©®azy-¢øÐ3R is offline
Reply With Quote
View Public Profile Visit ©®azy-¢øÐ3R's homepage!
 
Old 01-02-2008, 10:07 AM Re: Phpmyadmin help
Average Talker

Posts: 24
Name: Nick Cousins
Location: Northern Ireland
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.
__________________
LisburnPages.com
Click it, Find it, Phone it.™
HandCoder is offline
Reply With Quote
View Public Profile Visit HandCoder's homepage!
 
Reply     « Reply to Phpmyadmin help
 

Thread Tools

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

vB 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.14852 seconds with 13 queries