Displaying results of many sql queries without writing PHP code?
-
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 help very sorry if this is too basic
-
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 help very sorry if this is too basic
Please do not repost the same question; if anyone is able to help you then they will do so in their own time.
Binding 100,000 items to a list box can be just silly regardless of what pattern you are following. Jeremy Likness
-
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 help very sorry if this is too basic
It doesn't seem like you are getting much traffic on this, so I'll give it a shot. SQL, which you are familiar with, is a way for us to interact with the database. It allows us to access the data through structured queries. It is not a web language, or a programming language. It's more of a tool to use with the database PHP is a programming language. You have access to databases and SQL and can get results from it. PHP can use variables, routines, objects, etc in building web pages. PHP itself is not a database language (like SQL is). As far as I know, the answer to your question is no. They are both tools with their own jobs. SQL is how you get/manipulate the information, PHP or another programming language is how you do something with it afterwords. You need both for what you are wanting to do.
If it moves, compile it
-
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 help very sorry if this is too basic
You shouldn't worry about having to use PHP. Running MYSQL queries in PHP is super simple. You use mysql_connect() to get your link to your MYSQL server, you use mysql_select_db() to select the database, you use mysql_query() to run the queries in the database, you use mysql_error() to find out what the error messages are if there were errors, and you use mysql_fetch_assoc() to get the results if there were no errors. Once you have the results, you use echo() on them to print them out wherever you need them on the webpage. So, you see, you'll really only need to learn how to use a handful of commands to do what you need to do.
-
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 help very sorry if this is too basic
There is one simple reason which would fail your journey. you will have to create a report that can be accessed from HTTP client. but you have mysql server which is not http server. so as a matter of fact you would have to go through some kind of scripting that can access mysql server and reply through http server. php is a very good answer and simpler answer