How to show result of sql query in a page?

Solved! I follow this tutorial: https://wordpress.org/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/writing-your-first-block-type/ https://wordpress.org/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/creating-dynamic-blocks/ And complimented with this: https://gist.github.com/mattheu/7cf235b4f932de891bc21cb5f3ff3de6

Execute a function every hour in the background

I setup something similar. Using IIS – look into writing a .bat file which fires off a php shell script to do whatever it is you need to accomplish. once you have that bat file working, setup a “scheduled task” in IIS http://technet.microsoft.com/en-us/library/cc721871.aspx if you are on a linux system, then use crontab https://www.freebsd.org/doc/handbook/configtuning-cron.html If … Read more

How do I configure WordPress to talk to a Microsoft SQL Server database?

I think there is a new approach to it: https://blogs.msdn.microsoft.com/brian_swan/2010/05/12/running-wordpress-on-sql-server/ You can also use a 3rd party version of WordPress (not my cup of tea, by the way): https://code.google.com/archive/p/wordpress-mssql/ https://github.com/ProjectNami/projectnami Or follow this guide, but it might be a bit old: https://blog.building-blocks.com/installing-wordpress-on-windows-using-sql-server-2008-r2-part-1/ In the end I think the first link would be the best approach. … Read more

tech