Phpmaker table heading5/30/2023 ![]() ![]() ![]() (We assume the result of the above mentioned SQL-result is "2021" as $YEAR and "5" as $MONTHNUM) $this->YEAR2 ->Caption. So i have added the third line of code in the top section: ($MONTHNAME = ) Īnd to display the month name the code is like this: How to create dynamic header for tables in PHP. Realizar los siguientes ajustes a su proyecto PHPMaker: -> Adicionar al inicio de Server Events/Global/All Pages/Global Code. The page has a larger page size and the records are. ![]() Copie el contenido del repositorio en la carpeta 'plugins'. Click on any row to see the description notes for the employee. Including the relevant PHPMaker scripts and initializing them: Then, after that, you can use the results in every column caption of your choice like this: You will have already had the minimum tables that needed for your project using Masino Extensions. Main Header -> .($MONTHNUM= ExecuteScalar ("select DISTINCT (CAST((SUBSTR(YEARANDMONTH,6,2)) AS NUMBER(4))) MONTHNUMBER from TABLE WHERE YEARANDMONTH= (SELECT MAX(YEARANDMONTH) FROM TABLE )")) It points out the need to ensure that you have a primary key for the table, synchronizing to update the project and regenerating scripts after adding primary keys. Put the following code in the top of "PageLoad" event: ($YEAR = ExecuteScalar ("select DISTINCT (CAST((SUBSTR(YEARANDMONTH,0,4)) AS NUMBER(4))) YEAR FROM TABLE WHERE YEARANDMONTH = (SELECT MAX(YEARANDMONTH) FROM TABLE )"))
0 Comments
Leave a Reply. |