php sql query and display questions
Permalink
I have a legacy php website and SQL database. I have migrated the DB to SQL server on my host's website account and migrated the table access and display code into a page-type on my C5 site. The connection, query, and display table code work well. I would like to display the table in a content block on an existing page. How can I do this taking as much advantage as possible of existing code. Can I drop all or some of the code into a new block. There is no interaction with the user required!
Just an update that may help others using features of custom blocks. The problem with borders in tables is NOT a problem with blocks BUT with the default theme which maybe should be changed. The link shows the solution.http://www.concrete5.org/community/forums/chat/greek-yogurt-problem...
PHP works fine. Apparently the closing ? > from the test block is not required. I forgot all the keywords that needed to be changed for a new test but it came back.
html works almost entirely so far. I have not seen any list of restrictions but table borders seems to fail. I have not tried multi-table joins in sql but all legacy code seems fine without errors!
Even passed parms on paging routines from Dreamweaver port correctly and work!
Maybe this will help others?