113 replies to this topic

[QuickTrick]

Works great thanks

[stripe]

Hi mate, I've tried your script and it works fine!
to bad you don't use sessions cuz this is what i was realy looking for.
i've made a site in php5 with multiple pages that have sql fed dropdown menu's that a user would be able to feed him/her self. Now i want to add an usersystem to this, so the same site is usable for multiple users. each having there own logins and db info i know how i wanna manage the db and site with the seperate user info. but the session stuff is completely new to me.

the way it is now is could make a verry simple insecure page reload in place of the welcome message and it would work for me.. but then theres the problem that other users could simply try a ton of other usernames to get into some one else's page.. 1 problem i realy dont want to have.

can you give me a nice pointer in the right direction how to make the sessions?

[gerrybenny]

I wanrt to include regural expression to the code. And an email. What should i do as am knew to coding.

Buy the way. Thanks for this code. And bringing oop to coding. But how can i include regural expression to this great code and an email.

[papabear]

I wanrt to include regural expression to the code. And an email. What should i do as am knew to coding.

Buy the way. Thanks for this code. And bringing oop to coding. But how can i include regural expression to this great code and an email.

you can use the function preg_match
here is the syntax

and here's an example use of it

<?php
// The "i" after the pattern delimiter indicates a case-insensitive search
if (preg_match("/php/i", "PHP is the web scripting language of choice.")) {
    echo "A match was found.";
} else {
    echo "A match was not found.";
}
?>

for more information about this function please go to http://php.net/manua....preg-match.php

[Galhetas]

hy, nice tutorial, but its have a bug you can register the same user name how many times you want so you must to put it restrict when the user name is allready registed

[papabear]

hy, nice tutorial, but its have a bug you can register the same user name how many times you want so you must to put it restrict when the user name is allready registed

this is for illustration or tutorial purpose of making your POST values secured
I really did not put a rule about the username being unique.. it's up to the reader if he wants to improve everything

[metadome]

Very nice tutorial, great reading stuff.
I'm new in OOP, but I'm playing around with your script.

[papabear]

Very nice tutorial, great reading stuff.
I'm new in OOP, but I'm playing around with your script.

It's good to know that people are enjoying my tutorials Good Luck into your programming career bro

[metadome]

If some have problems with PDO driver, I can say you need to install php(53)-extensions and configure it with PDO driver for MySQL support.
I'm sitting behind a FreeBSD server, can't say if you need to do that in other systems, or how if so.
Just to mention it, if it could be helpful

[aljosa]

Super tutorial papabear. Amazing learning example! I'm a PHP newbie and have one question regarding tutorial.
Why did you use composite primary keys in created table `users` PRIMARY KEY (`userID`,`username`) ?

[Orjan]

Sounds unnecessary to me, but both fields should be indexed unique, but only userID needs to be in primary in my opinion.

[papabear]

Sounds unnecessary to me, but both fields should be indexed unique, but only userID needs to be in primary in my opinion.

yes, if following the database normalization userID must be the only primary key there... I haven't noticed that I also make the username primary key instead of making it a unique key, but this will work... my purpose is to have a unique username, I might have click the button in phpmyadmin wrong >_<