I am starting on an online shopping site, using apache, php & mysql...
I have not attempted a project as large as this before in PHP. I have been considering ways of making my code as flexible as possible. One way in which I have heard of doing SQL database work is to abstract the SQL code generation from the actual page code so that SQL is generated on-the-fly. I would be a big fan of doing it this way... however I am not too experienced with SQL at this point in time.
Has anybody got any experience with doing such on-the-fly generation of SQL, who could possibly supply me with some code to demonstrate this. Or just talk about the general structure of such a site.
Thanks in advance!
Adam.
I have not attempted a project as large as this before in PHP. I have been considering ways of making my code as flexible as possible. One way in which I have heard of doing SQL database work is to abstract the SQL code generation from the actual page code so that SQL is generated on-the-fly. I would be a big fan of doing it this way... however I am not too experienced with SQL at this point in time.
Has anybody got any experience with doing such on-the-fly generation of SQL, who could possibly supply me with some code to demonstrate this. Or just talk about the general structure of such a site.
Thanks in advance!
Adam.