CODEWITHSUNDEEP
phpmysql
Adolf
Adolf

Reputation: 1

Displaying results of many sql queries without writing PHP code?

Sorry if this question might sound stupid to you guys, but am total newbie to programming, apart from knowing SQL, the thing is i have been given a MYSQL database containing various information about kids diseases and a web interface written in php to create reports from the database that can be accessed via the interface. there are almost 25 different variables that need to be computed in the report, i have written sql queries to compute all these values, but i don't know anything about PHP, if i have all these queries isn't there a way for me to combine all these sql queries to be display results on a webpage and come up with this report without writing PHP code?

Thanks for your

again very sorry if this is too basic.

Upvotes: 0

Views: 427

Answers (4)

symcbean
symcbean

Reputation: 48357

As mr_jp suggests, phpmysqladmin provides a simple front end for running queries, but also changing the data and modifying the schema. Although you can restrict named users to only have SELECT privilege, they'll still need to know SQL to run the queries.

It's not that hard to build a front end to take a set of parameters, substitute them into a SELECT statement and send the output to a formatted table. There are lots of datagrid tools (e.g. phplens, phpgrid, have a google for 'mysql datagrid' for more) which will handle the formatting of a MySQL resultset (or just download it as CSV - your browser should be able to transfer the data into your spreadsheet program automatically).

There are a couple of report generators for PHP - but the last time I looked at this in any depth, I wasn't overly impressed.

Upvotes: 2

Radu Murzea
Radu Murzea

Reputation: 10900

The combination PHP + MySQL is a very popular one and it's highly recommended that you use them together.

The code that you will need to write in order to display that information using PHP is pretty straightforward and not very hard. If you do know some basic programming concepts, you can learn to do that in a matter of hours. PHP is well known for its extremely accessible learning curve. There are thousands of code samples online that you can look at to see how this is done.

Upvotes: 0

feeela
feeela

Reputation: 29932

You could write Python. Or Ruby. Or something you know. ;-) But you need something to output your queried data.

If you just want to check the results by yourself without having the needs to publish that directly, you might use some MySQL query browser or administrator like phpMyAdmin or the MySQL Workbench. Those tools allow you to query the database but display the returned data only as raw tables. If you need some styling or your own layout, you'll have to use an own application or edit the exported data manually (e.g. using a CSV export and re-open it using some spreadsheet application like Excel or Calc).

Upvotes: 1

mr_jp
mr_jp

Reputation: 31

Your web host would probably have phpmyadmin installed. Try getting access from the web host.

You can enter your queries there and export the results as html, csv, excel and others.

Upvotes: 1

Related Questions