PHP OOP Login/Register System: Database (Part 2/23)

Official site

Twitter

[LukeWatts]

Your id column should also always have the UNSIGNED attribute so you don't lose half of your storage space for that column to negative indexes. For example your never going to increment to -1 or -255 so why allocate half your row to negative numbers.

[GwidazMan]

What you think is best way to manage content of the website? Is it to create cms, or just give functions for cartain users to their profiles? Or just manage content by editing pages seperatly?

[Novica]

JSON is pretty easy though, you can google how to use it. Basicly you only need to use json_encode() and json_decode() for mostly any functionality. Decode takes JSON object sent from a .js file to a .php file and makes it a nice PHP array, while Encode does the reverse. Takes a PHP array and makes it .js recognizable array.

[rtester]

I am creating a PHP password class that will take a random salt, site key, and secret key and encapsulate them all together with the password hash that way the salt and keys are all unique for every user.

[Novica]

Cake php docs are the best tutorial for it :)

[MuhammadRizkiRijal]

Hi phpacademy. Your videos very helpful! But I can't find your PHP Basic videos series. Why?

[Novica]

It is on "thenewboston" channel, not phpacademy :)

[ayalaamaury]

facebook login correct implementation with php and js sdk? will alex make a tutorial for that?

[cjvaans]

JSON? Will Alex make a tutorial for that?

It is gonna be fantastic! Thank u Alex!

[TeddyOnYoutube]

I completed the whole tutorial and it helped very much! But I had a problem with the column name "group" in the users table because its a keyword. I think you should name it "gid" or something. Please correct me if I'm wrong!

Thanks for your video. 

[empror]

good, can you give a advanced tutorial in php?

[bulelwanojokwe]

Just for clarity. From a relationship point of view. A User can can have more than one session and also belong to more than one group. Ain't we suppose to have UserID as foreign key on Group's Table

[Dragon]

Got a quick answer.  Why won't my echo's show up on my page.  I have went through the code and all is correct.  But echo's doesn't show. I am confused as hell...

[VallabhRao]

The column name "group" is a MySQL reserved keyword

[_Mackan]

are you using xampp or anything like that to do this?

[akankov]

should we set 'unique' index to `username` to prevent users whith the same username?

[Wiejeben]

Isn't timestamp easier to work with?

[zyphal]

How do I get the thing he's using to even begin making my own database. I don't even know what to call it haha. 

[javedabbasi]

i want to help plz i needed help in php