Website Help

u851662 · 09:04 AM

I know this is a long shot, but i was wondering if any of you have any experience with creating a log-in database for a website. ive been reading up on PHP and Sequel but i am still unable to figure out how to create the login page. Im not sure if i said this right but any help would be appreciated. Thanks BBS.

SwoLy-D · 11-19-2008, 09:00 AM

What are your skills right now? Do you know some programming? PHP is easy to pick up if you know your "C" type languages, and if you know JavaScript or ECMA and your Java or C++, it's easy to pick up.

I don't do too much Database Web development (see DrLudicrous, Lady_Di, etc., for that), but I have dabbled into a lot of AUTOMATED PHP using Dreamweaver's scripts and some tweaking of my own. It's easy to create a MySQL connection, then a recordset and subsequently populate some pages with database query results in DreamWeaver.

Start at W3Schools for easy reading on PHP, then move onto PHP.net for the real documentation. There are plenty of tutorials out there on MySQL and SQL database connectivity.

Good luck.

What exactly is a "long database", in your own definition? Is this for work? Check out some PHP beginner books at www.bookpool.com if you can wait a couple of weeks for delivery, reading, etc.

u851662 · 11-19-2008, 09:07 AM

Quote:

Originally Posted by SwoLy-D

What exactly is a "long database", in your own definition? Is this for work? Check out some PHP beginner books at www.bookpool.com if you can wait a couple of weeks for delivery, reading, etc.

My bad, i meant LOG-In database. Dont know if that makes sense or not. I am not very familiar with programming\code the site I built I did by reverse engineering. My knowledge is Exchange\AD administration. However I will follow up on your suggestions and see where that gets me. Thanks again.

DrLudicrous · 11-19-2008, 09:50 AM

Is this site being hosted at a third party hosting service? If so, they should have some sort of admin utility to create your database/tables. Most hosting sites that offer PHP/MySQL use CPanel with some sort of web based MySQL admin tool.

u851662 · 11-19-2008, 11:04 AM

Quote:

Originally Posted by DrLudicrous

Is this site being hosted at a third party hosting service? If so, they should have some sort of admin utility to create your database/tables. Most hosting sites that offer PHP/MySQL use CPanel with some sort of web based MySQL admin tool.

Yep they do, and your right Cpanel & MySql admin. They have some video instructions but I need to learn the concept and the basics to really undertsand whats going on. i see it, but I really dont understand it.

SwoLy-D · 11-19-2008, 11:44 AM

It seems like you may have to learn MySQL or just databases in general before you dive into those "open waters" without a floating device, brother.

I recommend a couple of books or tutorial sites for that before you create your site. If you can 'reverse-engineer' proficiently, more power to you... but be careful you don't accidentally delete some IMPORTANT database, or such.

DrLudicrous · 11-19-2008, 12:33 PM

Quote:

Originally Posted by u851662

Yep they do, and your right Cpanel & MySql admin. They have some video instructions but I need to learn the concept and the basics to really undertsand whats going on. i see it, but I really dont understand it.

Here's a few sites with the basic concepts of relational databases that could help you understand the basic concepts. If all you'll be storing is username/password and some basic demographic information you'll probably just need one table though. If you have any specific questions just ask and I'll try to answer them.

http://en.wikipedia.org/wiki/Relational_database

The third page about views probably won't be very useful to you.
http://www.databasejournal.com/sqlet...-Databases.htm

http://www.miswebdesign.com/resource...apter-3-1.html