synapp2

Having been registered on phpfreaks for awhile and contributing a few posts, I'll take a moment to say hi and add a little plug for my free and open source software project: SynApp2 - Web Application Generator and MVC Framework. SynApp2 is an ultra fast and effective web application builder. Create beautifully integrated relational database management and reporting systems in record time. Written largely in PHP, there's lots of very generalized functionality that's neatly tied together with HTML, JavaScript, AJAX, SQL and of course - PHP. SynApp2 creates complete web applications - without generating a lot of code. It's so much more than just another CRUD tool. Whether you're a seasoned professional or just starting out with PHP, download the project and take a look. All of the source code is there. If your web server is already running PHP (and MySQL), just copy a few files, create an admin database with one table and you're ready to go. Using SynApp2 to create web applications with just a few clicks is so fast and easy. And, not only can you do serious work, you can study the details of extremely high-functioning, database-driven web applications. See the inner workings of JavaScript DOM manipulation, AJAX data exchange, user authentication, feature authorization, application navigation, GUI, record pagination, CRUD, searching and sorting. And, top it off with very elegant PDF reports. Deploy applications locally or on the Web. Visit http://www.synapp2.org Watch the growing collection of videos at http://www.youtube.com/user/SynApp2 - see SynApp2 in action. Best Regards, -Richard Howell

Code examples and/or screenshots would be really helpful. But, based on your descriptions, you're grappling with the fundamental issues of web application architecture. It's good that you recognize that a lot of conditionals - "if" statements - is not the way to go. Understanding abstraction and polymorphism are your keys to dealing with runaway control structures. About the only concrete thing I can recommend is study. There are many books and online references available, and it's hard to know where to start. "PHP and MySQL Web Development" by Welling and Thomson - covers most of the things you're trying to learn. There's lots of good software engineering discussion and practical examples. Take your time and heed that voice that tells you there's got to be a better way. There almost always is.

Use the index.php page only to re-direct to the page you would like to show. One way to do it would be to have your index.php generate a JavaScript statement: window.location="the page you want to display"; Don't put any real content into an index page.

JR I find your example and descriptions to be - well - confusing. Sorry. That may be why you haven't gotten a response, thus far. In the absence of a clear question, it's difficult to discern what you're trying to figure out, but I'll take a stab... I gather that you're attempting to understand how to work with records that you want have a master-detail, or one-to-many relationship. Is that correct? I'll assume yes, for the moment. Thinking out-loud, I'm wondering why the only ID value I see is: 1. I'm guessing, but I think perhaps you might do well to review some basic database design principles. Concepts like primary and foreign keys play into what it seems you're talking about and I don't really see that reflected in your examples. Here's a link to more information: http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html I hope this helps. - Richard