create a carousel from a table created and managed with appgini

I have a web page at the url: [login to view URL] 1) I created an ftp account with this configuration to edit the [login to view URL] file: FTP Username: *************** FTP server: **************** FTP & explicit FTPS port: 21 password: *************** (I will communicate the personal data to who will carry out the work) 2) in the folder you will find the php code already configured to connect to the database and display some of the fields of the foto_gallery table: foto_id (primary key) pubblica_in_home_page (checkbox) foto (image url) attivita_foto (activity to which the photo refers) event_photo (event the photo refers to) descrizione (description of the photo). From this code I would like to create a carousel that shows only the last 15 records entered in the database and only if the pubblica_in_home_page_field is checked (value = 1). The carousel should automatically change the image every 5 seconds but it should also have two lateral areas that allow you to scroll orizontally the images manually in two directions (left and right for the previous and next image) in photo overlay the textual content of the fields "attivita", "evento" and "didascalia" must appear (if they are not empty) clicking on an image should open a link that meets these conditions: - if the photo refers only to an event (ie if the photo_event field is not empty and the photo_activity field is empty) the link must direct to the carousel / [login to view URL] page? pri_key = [the pri_key of the current record] - if the photo refers only to an activity (ie if the photo_activity field is not empty and the photo_event field is empty) the link must direct to the carousel / activity [login to view URL] pri_key = [the pri_key of the current record] -if the photo refers to both an event and an activity (ie if both the photo_activity field and the photo_event field are filled in) the link must direct to the carousel / event_attivta [login to view URL] pri_key = [the pri_key of the current record] (the above mentinoed pages "evento", "attivita", "evento_attivita" will be created by me later but it is important that the links works. Attacched here: [login to view URL] file that must become an images carousel