6 replies to this topic

[Sentin]

http://www.pixel2life.com/twodded/t_integr...lication/page1/

I was working on that tutorial with a friend and we completed everything except we need a table with the login information and we dont know how to make one. Can anyone help?

[liveman]

Ok, first off a table is in a database, the login information is for the database. What panel are you using? IE: cpanel. Second a table can be created using phpMyAdmin if you do not have that contact your host and yell! lol its a free program that will make your life easier. Now if you don't have it you must learn "advanced" SQL which would be a query like "create_table". So after you fill it in the questions I am sure someone, if not myself, will go into detail on what to do.

[Sentin]

Sorry I should of been more specific. My host created there own control panel. But I can go into the sql DB and create tables I just dont know what to do. I have looked for scripts and the only thing I have found is this:
http://www.devshed.com/c/a/PHP/Creating-a-...P-Login-Script/

And even at that I dont know how to put it together. I have a login form and everything ready all I need is the sql table with the information.

Edited by Sentin, 12 March 2006 - 10:20 AM.

[rc69]

You can try using my DBMS to create the table for you since you don't have phpMyAdmin.

[Sentin]

My host does have myphpadmin.

http://godaddy.com

They make there own control panel but use phpmyadmin. This is not localhost . I just need a script or some way to get tables that contain user and password info for the login script.

[coolaid]

use php to create the table.

run this but edit the info.

<?
$createtable = mysql_query("create table users(
id int(11) not null auto_increment,
username text not null,
password text not null,
primary key(id)
)");
?>

and thats creates a table named 'users' with 3 columns: id, username, password.

[Sentin]

coolaid, on Mar 14 2006, 07:02 PM, said:

use php to create the table.

run this but edit the info.

<?
$createtable = mysql_query("create table users(
id int(11) not null auto_increment,
username text not null,
password text not null,
primary key(id)
)");
?>

and thats creates a table named 'users' with 3 columns: id, username, password.

Ok cool thanks but I am a noob when it comes to this stuff so sorry for this but. Where do I put my username and password that the login form will will use to login with. Like what part of that script do I edit to put that? And the second part is dont I need a connection script also to connect to the DB? I dont know how to makes those.