youngboy84

I am tring to learn about PDO people have said its easy and the best way to interact with the database, but im not finding it easy. can any help? Should i have my connection in its own class and extend it to the rest of my classes or should i use a global variable to connect? or is there another way better? i read up about the try and catch method not very good either. my database is mysql

hi all this is my first post so hello. I am tring to learn php and build a project that i will use. so this is my project. basically i am building a work rota that has a sign up/sign in page and a members area. so after you register and sign in you will go to a members area which will display your personal rota for the year. i am still in the planing stage so go easy on me. What i need help with is how best to make tables for my project. so far i have created a database called rota and a table called users with 1. id int 2. username varchar 3. password varchar 4. shift enum '1','2','3','4' (not sure if enum will work to choose shift????) so for example i am shift 3 so my members area shiuld display a calender with red squares for day shift and blue for night for every month. Mabey this is too hard for a beginner but i will try my best. ANY HELP AND criticisms WELCOME