You have a field storing the date of birth. Here I demonstrate how to calculate the age.
DATEDIFF(CURRENT_DATE, STR_TO_DATE(your_field_here, '%Y-%m-%d'))/365 AS AgeWithDecimals
DATE_FORMAT(FROM_DAYS(DATEDIFF(now(),your_field_here)), '%Y')+0 AS AgeWihoutDecimals
...
https://www.youtube.com/watch?v=hHyEcWLn5AY
This tutorial covers a simple but common need. You have a page with a list of files and want your users to select and download multiple files at once. In this example, we will use the upload field that can store multiple files at once.
Get the code here: https://xlinesoft.com/blog/2021/06/09/zip-and-download-selected-files/
Store documents and images in the server’s file system: https://www.youtube.com/watch?v=RD8Au0h_CpE
Stay in touch with us on Twitter: https://twitter.com/phprunner
...
https://www.youtube.com/watch?v=vfbQ3YxVWDc
This new version features the following improvements
1. NEW DASHBOARDS LOOK AND CUSTOMIZATION OPTIONS
2. FONT MANAGER
3. STYLING OF TABS AND SECTIONS
4. NEW GRID STYLING OPTIONS
5. CHARTS EXPORT TO PDF OR IMAGE
6. SHOW DIFFERENT PAGES IN MOBILE AND DESKTOP MODE
Post: https://xlinesoft.com/blog/2022/07/12/version-10-8/
Stay in touch with us on Twitter. Daily updates on PHPRunner, ASPRunner.NET, tech, and startups.
https://twitter.com/phprunner
...
https://www.youtube.com/watch?v=sm33BXUdGsI
Build sophisticated web database applications to your customer’s exact needs with PHPRunner low-code platform. PHPRunner enables you to create robust, dynamic, and secure applications up to 20 times faster than traditional software coding.
Stay in touch with us on Twitter. Daily updates on PHPRunner, ASPRunner.NET, tech, and startups.
https://twitter.com/phprunner
...
https://www.youtube.com/watch?v=lNtn0C1BXsw
Some web applications need to provide quick access to certain pages or documents. For instance, you can share a file via such a link or send a link to a view page of your application as I demonstrated here.
Get the code here: https://xlinesoft.com/blog/2021/09/09/providing-access-to-web-application-via-unique-link/
...
https://www.youtube.com/watch?v=YR--1DRQ3C4
Demonstration on how additional parameters will filter the results.
Facebook: https://www.facebook.com/PHPRunner-101291953274682/
...
https://www.youtube.com/watch?v=5LF7CObYQ50
Here a short demonstration of the new visual features in version 10.5 (AdminLTE like).
https://xlinesoft.com/blog/2020/11/11/version-10-5/
...
https://www.youtube.com/watch?v=TYHBMHhWaHY
The addTab method adds a tab to the Additional WHERE tabs on the List, Print, Export, or Chart page.
Download: https://xlinesoft.com/index.htm
Tutorial Demo: https://phprconsultant.co.za/tutorials/wt/products_list.php
...
https://www.youtube.com/watch?v=FLpAvltnRFM
Part two on REST API, Showing how to set up a parent-child relationship between data sources.
Link to Part One: https://youtu.be/viHtvoYfaF0
...
https://www.youtube.com/watch?v=zNq7E_0n9Os