Version 9.7 of PHPRunner, ASPRunnerPro and ASPRunner.NET

ASP.NET, News, PHP, PHP Code Generator, PHP Form Generator

PHPRunner 9.7, ASPRunnerPro 9.7 and ASPRunner.NET 9.7 released!

New customer purchase links:
PHPRunner
ASPRunnerPro
ASPRunner.NET

Upgrade links:
PHPRunner
ASPRunnerPro
ASPRunner.NET

Trial version download links:
http://xlinesoft.com/download

Here is the list of new features in version 9.7.

1. Improved password hashing

Option to use industry standard bcrypt hashing algorithm. Send password reset link to user’s email, link expires in 24 hours.


2. Code snippets in dashboards

You can insert any sort of code snippet as dashboard element. This can be some code that displays current weather, calculates order totals, displays number of active users or even displays a Youtube video.

See this live demo for inspiration.

3. ‘Sort by’ dropdown control

When this option is useful:

  • Vertical or columns List page mode that previously didn’t have sorting options
  • ‘Sort by’ control in mobile mode
  • Need to setup application specific sort modes

You can also choose if users still can sort data by clicking on column headers.

Here is how it looks in generated application.

4. Grid row/field click actions

This one is pretty cool, you can assign actions like open a certain page, make record selected, expand/collapse details or run a custom code to row/cell click.

Check this live demo.

Click CustomerID cell to open Orders view page in popup.

Click OrderID field to retrieve current order total and display it in OrderID field.

Code for this example:

Client Before event

// pass OrderID to Server event
params["OrderID"] = row.getFieldValue("OrderID");

Server event

// run SQL Query to retrieve order total
$result["total"] = DBLookup("select sum(Quantity*UnitPrice) from 
`Order Details` where OrderID=".$params["OrderID"]);

Client After event

// change cell background
row.fieldCell("OrderID").css('background', 'yellow' );
// add order total to OrderID cell content
row.fieldCell("OrderID").html(
   row.fieldCell("OrderID").html()+"
Total: "+result["total"]);

5. New APIs

If you enjoy pushing your web applications beyond built-in functionality you going to love this update. We have added five new APIs in this version that will help you build modern applications. Here are some highlights and use cases. See full list of functions each API provides in updated manual.

Security API

Get username or user group of current user. Get or set OwnerID or permissions for any specific table. Verify username and password. Log user in automatically from your code. Check if user is logged in, if user is an admin, if user is a guest.

Labels/Titles API

Things like change project logo on the fly, modify table captions, modify breadcrumbs display format, modify field label or tooltip etc.

Tabs/Sections API

Make a tab active, enable/disable a tab, add a tab in runtime, change tab header or content, expand/collapse a section etc.

Search API

Lets you run a totally custom searches. For instance you have Order and OrderDetails tables setup as Master-Details. With the help of Search API you can display all orders that include a specific product in OrderDetails.

Ajax row click API

You can see an example of this API usage in previous code sample where we dynamically display order totals in OrderID column. You can change any field visual appearance or content using this API. Besides using it in ‘Click action’ event you can also access this API from any button added to the grid.

6. Improved appearance of cross-tab reports

Try scrolling down and right to see freezing columns and header.

Live demo

7. Form field placeholders

Placeholders are in-place tooltips that disappear as soon user starts typing something in that field.

Live demo

Enjoy!

30 thoughts on “Version 9.7 of PHPRunner, ASPRunnerPro and ASPRunner.NET

  1. Nice, nice, nice, nice. Thanks for continuing to push your products to the next level. I am looking forward to playing with this beta version.

  2. I really like the new features. Can’t find info on those APIs though. Is it not in the manual yet?

  3. Is this product version available in “Trial” only?
    I have a “Enterprise” license in version 9.6, can I install it next to it?
    Regards,

  4. Fantastic developments! PHPRunner keeps getting better and better and better!!

    I’m so impressed with the new security features. With password hashing using bcrypt, AES encryption and the ability to use Azure servers (allowing the use of the azure keys/certificates – which actually use AES-256 as standard) means that PHP Runner applications will meet the requirements for processing “sensitive” data in the UK and EU (eg: patient data, classified data). This is impressive as no other RAD can generate the apps to this standard. I’ve been waiting for this day to come… Thank you Sergey and team!

  5. oh very cool feature to have cells click functional – means i can do the navigate to view parent record on my wish list!! i.e., when listing activities on a project, i can click the project name and review the project view page!! woohoo!
    and the password hashing is absolutely on time too. i was having trouble making something 100% HIPAA compliant unless I coded all that myself to do resets etc.
    Thanks – a very valuable update!
    paul

  6. Excelente noticia en la adaptación de novedosas herramientas para el diseño e implementación de plataformas cloud. A la espera de que liberen ésta versión. Felicitaciones.

  7. hi,this is getting better with each version.
    it will be any improvement on printing page as far as printing order in columns instead of side to side when 2 or more columns design is used?

    keep the good work

  8. I was just going to add a tab or a list page with a horizontal grid so that the user can sort the data. You read my mind. You are a primo developer. Thank you very much for all the good work.

  9. Fantastic!!! Love the tool tips,crosstab report and field click actions the most. Great job!

  10. Once again Sergey you and your team hit the mark! Thanks for never stopping to make a great product even better.

  11. Congrats on all new features. As always, Sergey & team make us all feel very proud of being part of this fantastic PHPRunner phenomenon…

  12. Sergey,

    I love these new features! When you plan to update the docs and give us a non trial version on this new version?

  13. What elegances with phprunner, when we will have the chance to start with the new upgrade

  14. Very nice. Looking forward especially to trying out the APIs and code snippets in dashboards. You just made dashboards so much more useful for integrating other apps and data.

  15. 6. Improved appearance of cross-tab reports
    – Can you order by Customer Name alphabetically?

  16. I have to say, you and your team just keep making the software better and better, with more and more features… I can almost figure out everything myself, the software is so intuitive. Great job!

  17. Been using your product for over 10 years and it has been a great experience. Changing over to the newer builds has been a pretty easy step. I am just impressed with the constant level of “understanding” in what the majority of us are looking for it keeps your product relevant. Thank you!

  18. Always a delight, about the only product I have that when updates and new features arrive I see real application for, even I have I had not previously thought about.

    As always GREAT WORK

    Congratulation to all the Xlinesoft Team

    my thanks and gratitude

    Simon (UK)

Leave a Reply

Your email address will not be published. Required fields are marked *