1. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    May 2004
    Boston, MA USA
    Rep Power

    Thinking Beyond PHP/MySQL


    A am a pretty amateur developer and I have a business management tool that I started writing in 2003using PHP/MySQL to solve a specific business problem. Over the years, I have taught myself most of what has been needed to expand and improve the functions, with considerable help from the members of this forum. The system has grown to incorporate dozens of business solutions. As well, it is now responsive and has a fair bit of javaScript which I am still pretty green at.

    I am wondering, in the 15 years that I have been doing this, is PHP/MySQL still the best solution for a dynamic, database driven application where multiple users need to create, edit, input data which can be viewed from multiple interconnected web pages?

    I am sure it's a more complicated problem than can be answered in a simple response but what are the new up-and-coming technologies and methods that I might want to consider to keep my application relevant and effective? Is there a good resource for investigating this?

  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2015
    Rep Power
    Hi. I think what you have accomplished sounds great. I firmly believe you are in a good place. You chose open-source technologies that will continue to be improved and supported and made to work well with technologies/devices now and in the future. You have set yourself up to be able to run your solution(s) on ANY platform. You've made your potential market as wide as it could ever be thanks to your choice in development technologies. It's just time for you to resolve yourself to improve yourself in how you implement the technologies. Start to branch out and learn all the best-practices for programming in JavaScript and PHP. Get better at CSS. Come up with ways to re-use your code: the "DRY" principle. As far as deployment: you get to update your code remotely and the users browser/device automatically gets the latest version of it. There are no local installations of your program(s) to worry about or manage. You are centralized in that regard. There's no real walls you will run into with the direction you are heading. There are of course certain exceptions and special cases and needs, but you can deal with them as needed (and they likely won't be needed). Yes, php/MySQL are awesome choices. People who say they hate php or javascript are just week in using those tools and are too lazy to do it right. Sure there are also other good scripting languages, but for someone to say php is not worth using, they would be biased and really ranting more than anything else. PHP 7 has put php devs in a great place speed-wise and quality-wise. Lots of amazing improvements and it was already good before that. JavaScript: can't lose knowing that. Try to really push yourself into implementing js objects in your code, for re-use, etc. Then...you could later if desired make js-driven apps that run on the user's local machine and not necessarily over http.
  4. #3
  5. Lord of the Dance
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Oct 2003
    Rep Power
    It depends on the needs, but PHP and MySQL is still a valid option and will probably be able to solve all you needs.

    There are several reasons why PHP and MySQL has been so popular due to it easiness and cheapness. You can have a greater look about this here: https://softwareengineering.stackexc...on-web-servers

    Another thing is that there have been created several "template engines", making it faster to setup almost all kind of functionalities you want. Some of the more known site could be Wordpress and Joomla.

    Where PHP is purely a server side language, Java Script is mostly used as a front-end language to beautify the user design and experience on the client.
    Just know that Java Script has also been developed for server-side language through Node.js.

    Just be aware that when your requirement changes on your site, there might be other tools for that specific task.
  6. #4
  7. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2017
    Rep Power
    I also started coding in PHP/MySQL 15 years ago, and I still continue using this combo for all my needs. I don't know if it's the best, but I tend to believe so. In other hand, even if it's not the best, it's surely the most popular one, which means it will be easier to learn new things and get help.

    Recently, I finished developing cloud-based restaurants/meals/recipes management system (the biggest project of mine ever), which is now used by many restaurants in my country, and I think PHP/MySQL along with some JS/Ajax was the best solution. I didn't even consider another platform because I would need to learn it from zero. So, instead of spending time on learning completely new stuff, I used my good knowledge of PHP to build something that really works. If I used another platform to create the same application, not only it would take much more time, but whole code would have many more possible flaws (because you can't code like a pro in a new language when you just learned it).

    So, my point is this - if you are good at something (and that something is really popular), why would you want to quit it?
    Do you license and update your PHP scripts?

IMN logo majestic logo threadwatch logo seochat tools logo