Here is a simple full databased web site. The page content and menu's are all dynamic.
It consists of 1 report page which displays all the web pages and 2 admin data entry pages so you can edit the menu system and also add new pages.
First you will need to add your datasource (Project > Data Source Manager) you will see the current database is a mySQL - even if your db is mySQL you still need to add it. When you have you need to Map the current DB settings to your new datasource (Create the data source you want to export to, then go to export settings and in the map section at the bottom, double click the field next to the original (easy2) datasource and select the new data source, then double click the field next to the new (easyGen) data source and set to Don't Export)
Modify the page template in main, or for test purposes leave it as is and just export and remember to check the update datasource so easyGen will build your new tables.
Now you have admin, which is page admin and menu_admin which is for your menus
admin
Page: enter the page name such as About_Us, Contact, More, Products, whatever (this is called to display the content so if you entered "More" to bring up that page you would enter www.yourdomain.com/main.php?page=More
Content: Enter the content of that page
Image, any image you want on the page use this format to correctly address the image and give it the path and filename. <img border=0 src=path and filename>
Save, then add new to enter a new page
For menu
Use this format and just replase the links? with your page names
<a href=main.php?page=Link1>Link1</a> |
<a href=main.php?page=Link2>Link2</a> | <a href=main.php?page=Link3>Link3</a> |
<a href=main.php?page=Link4> Link4</a> | <a href=main.php?page=link5 Link 5/a> | <a href=index.php>Home</a> | <a href=admin.php target=_blank>Page Admin</a> | <a href=menu_admin.php target=_blank>Menu Admin</a>
So to add a page to Link1, replace both Link1 first one with the name of the page in the database (the page to call) the second with the name to display on the menu)
You may want to delete or password protect your 2 admin pages, you can also add as many pages and menus options as you like.
You can edit and save when ever you need to update.
The index page will be the page visitors first arrive at, so modify this to be your welcome page.