shownsa.blogg.se

(We assume the result of the above mentioned SQL-result is "2021" as $YEAR and "5" as $MONTHNUM) $this->YEAR2 ->Caption. This is the first PHPMaker 2018 Template file that released after PHPMaker 2018 was released on July 25. When you click on the Connect button, you should see your two tables appear in the left panel. 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: You can always change that through phpMyAdmin for extra security. Then the caption if the "YEAR2"-column will be: "In two Years it will be the year 2023 and the month number is 5"Įxtra: In my case I had in some columns the need to display the full month name based on the month number. (We assume the result of the above mentioned SQL-result is "2021" as $YEAR and "5" as $MONTHNUM) $this->YEAR2 ->Caption. Example 2: Full-fledge and featured CSV to MySQL import Let us see this elaborate example by following the above three steps. Develop PHP file reading endpoint to import CSV to MySQL database. Design import form and handle validation. Then, after that, you can use the results in every column caption of your choice like this: Steps to implement importing CSV to MySQL Create a target database to store CSV records.

Table: Cast Data ExecuteScalar ("select DISTINCT (CAST((SUBSTR(YEARANDMONTH,6,2)) AS NUMBER(4))) MONTHNUMBER from TABLE WHERE YEARANDMONTH= (SELECT MAX(YEARANDMONTH) FROM TABLE )")) .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 )"))