I am trying to create a piano website where users can watch some piano lessons for free but have to pay to access other videos. I have divided my lessons into the following categories, such as primer level, level 1, level 2 and level 3. Primer level is free but level 1 costs $100, level 2 costs $200 and level 3 costs $300 with a one off fee. I also would like to do an email activation and someone told me to set it to bit,is this correct? Should it be set to bit or tinyint?.. I have attached a picture of what my database should look like below…
I also want to make it in such a way that level 1, 2 and 3 are locked videos until they have paid for it…
I looked for the post in your other topics but didn’t find it. I’m interested in the why. AFAIK both a TINYINT holding a 0/1 and a BIT holding a 0/1 have the same storage requirements - 1 byte.
Did they say it was more efficient or was it only their preference?
I know this isn’t the response you want. But I strongly suggest that you take a step back and focus on understanding the basics first. What I mean by basics is simple basic functions like output functions, variables, etc. I feel like if you jump the boat too soon, you’ll drown. Not only that, if you don’t know the basics of HTML, then I strongly suggest you learn that first before trying to grasp PHP. HTML is the building block to all websites. If you fail to understand this simple markup language, then you will have a hard to understanding PHP and the concepts that follow.
What you are suggesting requires an extensive knowledge in PHP, Javascript, and HTML. Just because you can host a video on Youtube, doesn’t mean that it’s going to be safe from anyone. If you set it to unlisted, guess what will happen? Someone will right click → view Page Source → look for that Youtube video and then just watch it from there. You need knowledge in HTML because obviously, this will build and make your website look nice. It also helps with Javascript as well because Javascript will be your video player. And PHP for grabbing data.
So take a step back and don’t rush this. You will always end up struggling through this whole thing if you don’t take a step back and take baby steps. Which is going through HTML & CSS first, then Javascript, then PHP.
Since outputting HTML is the main purpose of PHP (Hypertext Pre-Processor) in the context of website creation, knowing HTML is kind of pre-requisite to attempting to learn PHP.
It’s like deciding you are going to build a pie making machine, when you don’t actually know how to make a pie yourself.
