i need login/signup scripting and database
I am looking for a script which will allow my members to sign up for an account.
When they fill up the form and click submit. They will hav to wait till I manually verify that they have entered correct info. After verifying then only will they be able to login.
I want to do something like this.
But i have no idea on how do create the scripts and databse and any other stuff im really a noob. all i know is that my host has a 4.1x mySQL database
You'll need to use some sort of server-side programming, such as PHP, ASP, Perl, etc.; so you need to also find out which of those your host supports.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
having the SQL forum in the server side category is a little ironic.
Ok lets say i have this script which memebers fill out their info and submit it. This form is emailed to my email account. I want to add this account into a database manually
it'd be a simple insert statement then.
INSERT INTO your_table(col1,col2,col3,...,coln) VALUES('val1','val2','val3',....,'valn');
where do i insert that i have no clue on SQL PHP
Check out this link
it's poorly named, but should help you get started
If you have a hosted environment, you should see a tool called "phpMyAdmin" that lets you connect to your database and run queries.
could u chat with me on MSN?
If MySQL has a stored proc area you want to put that in a stored procedure. When you wanto to run it, call that proc to you page and execute it when it needs to be executed. I think using stored procedures will cut down on web server load unless you are running the sql server along side the web server.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)