The Big Spring Sale! Up to 50% off!

SQL

dj1930
11 Posts
dj1930 posted this 03 December 2022
Ask a Question

Hi, how can I pull and display / save data from an sql database please?

Hi, how can I pull and display / save data from an sql database please?
Vote to pay developers attention to this features or issue.
6 Replies
Order By: Standard | Newest
dj1930
11 Posts
dj1930 posted this 12 December 2022

Hi, yes the point of me using nicepage to display the data was to save me having to faff around with css and use the nice blocks to display the data. The reason i am here is because my existing HTML is not displaying the results in a manor i find acceptable lol.

Hi, yes the point of me using nicepage to display the data was to save me having to faff around with css and use the nice blocks to display the data. The reason i am here is because my existing HTML is not displaying the results in a manor i find acceptable lol.
jack.from.canada
118 Posts
jack.from.canada posted this 05 December 2022

The PHP Generator program supports CSS of specific classes, etc. and the documentation is pretty comprehensive. Take a look at some of their demos (such as the Basketball demo) to get a feel for the levels of customization you can accomplish with CSS.

And if you already have working HTML that renders your results in a manner you find acceptable, then just display that code in an iframe within the Nicepage framework.

The PHP Generator program supports CSS of specific classes, etc. and the documentation is pretty comprehensive. Take a look at some of their demos (such as the Basketball demo) to get a feel for the levels of customization you can accomplish with CSS. And if you already have working HTML that renders your results in a manner you find acceptable, then just display that code in an iframe within the Nicepage framework.
dj1930
11 Posts
dj1930 posted this 04 December 2022

Ah ok, thank you for your reply.

I was hoping to use the design and blocks in nicepage to display the data in nice responsive tables etc, if I have to use just HTML and css formatting then I’ve done that already with the existing site, I wanted something a bit more classy lol.

Ah ok, thank you for your reply. I was hoping to use the design and blocks in nicepage to display the data in nice responsive tables etc, if I have to use just HTML and css formatting then I’ve done that already with the existing site, I wanted something a bit more classy lol.
jack.from.canada
118 Posts
jack.from.canada posted this 04 December 2022

What I do to get information from an SQL database is to first build a page (using PHP) that accesses and displays the data. I then use Nicepage HTML element to create an iframe to display the content of the PHP page.

If you don't have the time or PHP skills to access the SQL database directly, you can try third-party tools for creating and accessing SQL databases. My favourite is PHP Generator (https://www.sqlmaestro.com/products/mysql/phpgenerator/) and I frequently use this tool to create and access SQL data. You can then access the code generated by this application inside an iframe.

For an example of how this could work, you can see a simple HTML site I created for a local business that was offering free COVID signage to other local merchants. It uses two iframes (one displays a form created with Simfatic Forms, and the other displays a directory managed by PHP Generator).

What I do to get information from an SQL database is to first build a page (using PHP) that accesses and displays the data. I then use Nicepage HTML element to create an iframe to display the content of the PHP page. If you don't have the time or PHP skills to access the SQL database directly, you can try third-party tools for creating and accessing SQL databases. My favourite is PHP Generator (https://www.sqlmaestro.com/products/mysql/phpgenerator/) and I frequently use this tool to create and access SQL data. You can then access the code generated by this application inside an iframe. For an example of how this could work, you can see a [simple HTML site][1] I created for a local business that was offering free COVID signage to other local merchants. It uses two iframes (one displays a form created with Simfatic Forms, and the other displays a directory managed by PHP Generator). [1]: https://staysafeontario.com

Last edited 04 December 2022 by jack.from.canada

dj1930
11 Posts
dj1930 posted this 03 December 2022

Hello Dave,

Thanks for contacting us

Nicepage doesn't have an SQL database.

how can I pull and display / save data from an sql database please?

These questions you can check over the internet
...................................................
Sincerely,
Ahmad.
Nicepage Support Team

Please subscribe to our YouTube channel: http://youtube.com/nicepage?sub_confirmation=1
Follow us on Facebook: http://facebook.com/nicepageapp

Hi yes I’m aware it doesn’t, but if I have sql server also installed on my windows 2019 server that’s hosting the sites, how can I pull the data from my database in nicepage? Which plug-in can I use etc? I’m assuming the functionality is there as it’s a pretty basic use of a website 😅

> Hello Dave, > > Thanks for contacting us > > Nicepage doesn't have an SQL database. > > >how can I pull and display / save data from an sql database please? > > These questions you can check over the internet > ................................................... > Sincerely, > Ahmad. > Nicepage Support Team > > Please subscribe to our YouTube channel: http://youtube.com/nicepage?sub_confirmation=1 > Follow us on Facebook: http://facebook.com/nicepageapp Hi yes I’m aware it doesn’t, but if I have sql server also installed on my windows 2019 server that’s hosting the sites, how can I pull the data from my database in nicepage? Which plug-in can I use etc? I’m assuming the functionality is there as it’s a pretty basic use of a website 😅
Support Team
Support Team posted this 03 December 2022

Hello Dave,

Thanks for contacting us

Nicepage doesn't have an SQL database.

how can I pull and display / save data from an sql database please?

These questions you can check over the internet
...................................................
Sincerely,
Ahmad.
Nicepage Support Team

Please subscribe to our YouTube channel: http://youtube.com/nicepage?sub_confirmation=1
Follow us on Facebook: http://facebook.com/nicepageapp

Hello Dave, Thanks for contacting us Nicepage doesn't have an SQL database. >how can I pull and display / save data from an sql database please? These questions you can check over the internet ................................................... Sincerely, Ahmad. Nicepage Support Team Please subscribe to our YouTube channel: http://youtube.com/nicepage?sub_confirmation=1 Follow us on Facebook: http://facebook.com/nicepageapp
You must log in or register to leave comments