MySQL Database

[johnsonb]

I have MySQL front and am VERY new to this stuff. I don't know how to make a valid database name and is there a site I can go to so that I can punch in the appropriate code in the table?

[cinenganos]

I'd try phpMyAdmin, in order to see, edit, update, delete, and * that you may need regarding your database and tables...

See http://help.powweb.com for the setup instructions.

Enjoy,

[HalfaBee]

Have you ordered mysql from powweb. ($10)

If you have, you have a database. You cant create another database yourself. You can only create tables in your DB.

HalfaBee

[johnsonb]

ok, then do you know of any site where I can get the scripts to put into my tables so I can make a member/password section in my site?

[cinenganos]

I'd say you first write here whatever you need, everything, (now you talk about apsswords, that was not in your previous message), and then we can -gladly- help or suggest some things...

I don't see the need for the database if all you need is password/user access for , say, a directory.

If you do need a database, then pay for the MySQL, and we'll help you setup all the software or code you need in order to have it done, and we can aslo help you, either way, to setup a password protected area, but you have to explain all this a bit more in detail, please.

I have both MySQL database and password protected area for the administration of it, and for other areas, for instance, and to make you more comfortable.

[johnsonb]

I didn't know I was being so vague. Anyways, I did get MySQL database. I have MySQL front, I don't know the difference between that and MyAdmin? Umm yeah, basically I need to know how to 1st get to type code in the database and where to go to do that and 2nd, what to type in the database. I'm so lost as to what and where to write it's pathetic. Anyways, I did find this site called PhPfreaks.com and that has some stuff in it. But I still don't know how to access mySQL. I go to the page on this site after I paid for it and it just asks for new users and stuff. I have absolutely no idea where to go to get into the actual database. That is why I downloaded not only MySQL front but also Mascon. They look like the same thing so I am still lost. Any info as far as how to access it and what to write so that I can get a logon/password thing going would be greatly appreciated.

[HalfaBee]

Now you have your databaseyou have to know what to do with it.

I think cinenganos was a bit harsh, I understand what you are going thru.

First off a database is just somewhere to store stuff you what to remember.
What you have downloaded are just tools to help access what you want to remember and how to organise them.

Database info is a bit hard to get your head around, I understand that.

Before you go to far have a look around for info on sessions in php and see how they work. There are a lot of membership scripts out in cyberspace try doing a search in google and see what comes up.

Explore scipts such as phpnuke, phpwebsite and other website portals.

Checkout www.mysql.com for the manuals for mysql and www.php.org for php info and manuals.

I hope this sets you on the right path

HalfaBee

[cinenganos]

Originally posted by johnsonb
...basically I need to know how to 1st get to type code in the database and where to go to do that and 2nd, what to type in the database...

Hey there. I will help, and you can also email me directly if needed (may be faster).

For the steps needed to password protect a directory, you can see this link: URL=http://help.powweb.com/tutorials/htaccess/passprotect.php]Password protection[/URL] .

Basically, all you have to do is (1) to create and edit a file called ".htaccess ", and upload it to the directory you wish to password protect.

And (2), then you need to create and edit a file called ".htpasswd ", and upload it to the directory "htdocs", your upper level in the website.

Once you have this, we can begin to see how to access your database and how to setup anything...

By the way, what do you want to have in your site, so Ic an recommend some links or books?

[johnsonb]

ok, i tried understanding the site link with the .htaccess and .htpasswords but I don't know how to make a file and upload it.
Also, it says to put Username into the field where [u] is. And others like that. Do I put the actual word "Username" into the field or my username?
Also, I have .htaccess in my FTP folder already but I don't know how to access it. Where would I find the folder or should I just go ahead and make a new one?

[NMS]

username is your username (the one you use to login in the ops)

the u is the first letter of the ops username.

Read this, it might help you

http://www.javascriptkit.com/howto/htaccess.shtml

[johnsonb]

I already set up cookies on the page I wanted to put users/logon for but I do not know how to make it so that they can make out a page where they can set up their user/password stuff. Is there any html script you know of to do that?