My first MYSQL usage!

[chrisclick]

i dunno were else to put it so i put it in random

Ok i have been wondering how to use flash and im sure everyone knows my just plain "STUPID:h: " but alough im a time wasting idiot “I confess” i have succsesfully made a cool MYSQL login and create new user page!. I hope to use this later on in web design life.

steps

1. put anything you want into the login area and click login. Invalid or incorrect username and pass.
2. copy and paste the username and pass from login area to the account creation area click create.
3. try loggin in again YaAHOO it works.

If you have problems with this email me (EMAIL), i dont mind if you say “TOO BASIC!!!” because this is just a tester and later on i will be making a bussiness opr anything that springs to mind using login with MYSQL

good thing is - INSTANT ACCESS NO ACTIVATION EMAILS!!

[eilsoe]

a link?

[Templarian]

link (and yes this is very basic lawls).

[chrisclick]

soz www.pencaderweb.co.uk/MYSQL/index.php

The forum didnt work just them for me

[Templarian]

You can create a username thats already in the table. Might want to fix that.

[chrisclick]

ok ill try and fix it if i had the brain to lol.

[chrisclick]

@Templarian

You can create a username thats already in the table. Might want to fix that.

Anyone know a code to do what Templarian is wanting me to fix???:sen:

[Seb_Hughes]

@chris.jones071@

Anyone know a code to do what Templarian is wanting me to fix???:sen:

$checkusername = mysql_query(“SELECT * FROM users WHERE username = “"$_POST[‘username’]"””);

if($checkusername > 1) {
echo “Username taken”;
exit();
} else {
rest of sign up code in here
}

[eilsoe]

also might wanna star out the password input field…

[anon1712571]

the first tute i ever learnt and it was easy as heck- yet i still suck at php…

[Seb_Hughes]

@darkmotion

the first tute i ever learnt and it was easy as heck- yet i still suck at php…

:lol:, ill try and help ya lol. I might start on a new guets book for ya

[chrisclick]

Ok i read your posts and i will do the following -

1. Star The Input Of The Password Field
   2.Try and fix the Username problem

@SEB

$checkusername = mysql_query(“SELECT * FROM users WHERE username = “”$_POST[‘username’]”"");

if($checkusername > 1) {
echo “Username taken”;
exit();
} else {
rest of sign up code in here
}

What do you mean “rest of sign up code here”?

[Seb_Hughes]

@chris.jones071@

Ok i read your posts and i will do the following -

1. Star The Input Of The Password Field
   2.Try and fix the Username problem

@SEB

$checkusername = mysql_query(“SELECT * FROM users WHERE username = “"$_POST[‘username’]"””);

if($checkusername > 1) {
echo “Username taken”;
exit();
} else {
rest of sign up code in here
}

What do you mean “rest of sign up code here”?

Its self explanatory

[chrisclick]

Ok sorry seb and thanks its fixed now View it here http://www.pencaderweb.co.uk/MYSQL/V1/index.php

[nightshade]

Congrats!.. sigh i remember my first PHP/MySQL login script. Back at school…my ICT teacher was well impressed! lol he was useless… (skills: basic knowledge of HTML etc…)

[Templarian]

nice work.

[chrisclick]

thanks im very happy i figured out how to that lol as the welsh would say

"Well Chuffed:smirk: "

[chrisclick]

ok, i have updated it a lil bit and now it shows the last user to create an account and shows amount of records the data base has