View Full Version : phpmyadmin tables

03-22-2006, 09:43 PM
im trying to set up a table containing username and passwords for a php login page.

so far i have set up a table inside a database with 2 fields one called "username" and the other "password"...varchar length/value 20
what do i need to do next?

(im a total noob and i dont know any scripting, just using dreamweaver)

03-22-2006, 11:19 PM
im trying to do this tutorial

i have a problem understanding this part in section 1 the rest im fine with

"After you have created your table populate it at least with one entry, for the sake of example we will use admin for username and admin for password. You are free to populate with your own data. "

which part of the table do i add "admin" to?
i see 3 boxs

Transformation options3

or is ther some other part im supposed to open up to add this?

Creative Insanity
03-23-2006, 01:13 AM
Ok now create a folder inside DW and set that up for your local, remote and testing server settings.
Then create 3 files.. login.php, success page (whatever you want that called), and one called fail.php
Now in DW connect to your database and setup a recordset for the login page, the click the server behaviors and select User Authentication and select login.. now fill in the diologs with the info they want.
Make sure you have your form inplace on your login page with the textfields needed.

03-23-2006, 01:53 AM
thanks for your reply....

how do I add the usernames and passwords to the database?

Creative Insanity
03-23-2006, 02:42 AM
You can either create an insert.php page or just add them in phpmyadmin.
Click on the table and then just click the insert tab at the top and walla. :)

But to make it easier once your site is online.. create an insert page under admin access.