• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

how to create a dynamic table retrieving stock information from mysql database?

Dear experts here, I would like to make a webpage including a web table showing some picks information from mysql database. I have already downloaded the data and is able to save the data inside a mysql database. The problem for me is the frontend. I would like to create a dynamic table, the lines of the table matches the records inside the database. In a simple sentence, it should be able to display all records inside the database. I thought of creating a HTML table including more lines than the number of the records in the database, but it's not feasible.

Could anyone here give me some directions for fulfill this task? I attached the spreadsheet table I want to make in web form/table format.

Thanks.
picks-list.png
0
Jason Yu
Asked:
Jason Yu
1 Solution
 
Jason YuAuthor Commented:
BTW, I would like to use python as the backend language to calculate all parameters.
0
 
Pawan KumarDatabase ExpertCommented:
Do you want to create temporary table or a physical table?
0
 
Jason YuAuthor Commented:
a physical table showing on the webpage, the format is like the attachment.
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
Jason YuAuthor Commented:
Any help for this, this is a standard frontend web developer question.
0
 
gheistCommented:
If it is so standard why dont you copy standard examples?

You need to return to the books and learn distinction between mysql table and HTML table, once rounded up with that would be worth pursuing learning some (python or not) web page generation framework.
0
 
slightwv (䄆 Netminder) Commented:
I'm not clear on exactly what you are wanting to do.

If all you want is to display data from a database table on a web page, most web development languages have a datagrid or similar control that is designed to do exactly that.

Since you asked this question in the Python Topic Area, I looked and it appears there is a Python datagrid:
https://pypi.python.org/pypi/DataGrid

I'm not a Python person so I cannot help with the actual code.
0
 
Jason YuAuthor Commented:
Thanks, I will follow this python link to see if I can use this one to display data on webpage.
0
 
Jason YuAuthor Commented:
Thanks for help, I will use this to pull data out from mysql database.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now