Hahaha, honestly, this really made me laugh. Security isn't just about paying; Or it depends, you can pay someone and he will try his best to make it as secure as possible, but 2 servers doesn't increase the security in any way?
I have edited the main post and added some code snippets. Hope they will do for now, I'm embracing every feedback I can get, afterall, this will be for you guys.
@Linxon if you really want to use multiple servers for load-balancing I suggest you get a linux server with nignx, and setup load-balancing for the websites. Although that probably wont be needed for such a small thing as a retro.
Unless the data is saved/updated somewhere, it will always go back to it's normal state when you leave the site, because it doesn't really do anything.
You can, in the database setup columns to just be empty upon submition. You don't actually need to fill all columns for each register unless there is a rule for the specific columns to not be empty.
I get what you mean, thank you for the advice. I will look into that! :D
I can upload some code snippets later when I feel that the worst has past.
Keep it coming guys, I love the feedback I've been given so far!
Well that obviously depends on what cms he uses and how often the cms gets new information from the database. Also it could be the position of the servers. If the servers are not in the same continent as each other it might aswell be a factor.
@Linxon what are your server specs?
First of all I would suggest that you don't mix params with pure data. Now for the answer I think you get an error because you don't define the 3rd value in bindParam which is the data type. Personally I just use array inside of execute which is much easier. I would do it as follows.
$stmm =...
The lag appears because for every request the cms makes, it needs to contact the other server, access the database and return the data to the first server. Why do you need to have the hotel divided into 2 servers?
Actually, it could be something as simple as the firewall blocking the port. Try to connect locally via 127.0.0.1 and set it up locally. If you can connect locally it means that the firewall is blocking connections on your MUS port.
Since I use PDO and prepared statements I seperate data from the actual operation. The searchbar basically works as follows:
%as - search for every username which ends with as
za% - search for every username starting with za
%as% - search for every username containing as
As for code snippets, I...
Thanks for the feedback! I'm making it in a way where it will be easy for people to create different themes for the cms, but I will think about that. I might just add a second light theme to come with it.
Hello everyone! I have been working on this cms for a while now, and I decided it's time to get some feedback and maybe some input on features you would love to see.
What have been done so far?
+ Pages: Index, Register, Maintenance, Me, Settings, Profile etc (prints down below)
+ AdminCP - This...