Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


Getting a web page based on database


 
Thread Tools Search this Thread
# 1  
Getting a web page based on database

I need to connect to a database, run a select query and get the o/p on a web page. please let me know how to do this via shell script.
# 2  
Simplest is to select with a command line tool, and deliver it as Content-Type: text/plain

Nest step up is to postprocess it with sed ( '&' = '&amp;' , '>' = '&gt;' , etc.) and embed into <PRE>...</PRE> in your HTML page.

Next step up is to postprocess it into an html table <TABLE><TR><TD>cell a1<TD>cell a2...</TABLE>.

I often add a leading marker column to help the postprocess find the header and cells: SELECT 'dAtA' as "dAtA", ....

Beyond that, there is PHP that runs queries to build the web page, and the whole gamut of web generation tools for ODBC, JDBC and proprietary to each RDBMS.
 

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Java web console Vs Web-Based Enterprise Management(WBEM)
cyberidude
Java web console Vs Web-Based Enterprise Management(WBEM) 1. I like to understand the difference in purpose of using java web console and Web-Based Enterprise Management (WBEM) 2. As per CIS benchmark, both of them has to be disabled when not used for increased security. Solaris admin(s) -...... Solaris
0
Solaris
nmon and web page !
Mr.AIX
nmon and web page ! Is there any way to let nmon be configured with external Web Page and updating the same web page to be graphic monitoring. Pls advice ... AIX
1
AIX
File to web page
gander_ss
Hi all, I am having an XML file. And as per requirement I need to map fields of this file with various field of web page. So how can I use wput command into it ? Regards, gander_ss... Shell Programming and Scripting
3
Shell Programming and Scripting
Make a Web page
lydia98
I'm 13 years of age and I am into computers. I am trying to learn how to make a webpage. I could use the help and I would greatly appriciate it.... UNIX for Dummies Questions & Answers
1
UNIX for Dummies Questions & Answers
making a web page
shashora
Hey im new to unix! I am tryin to create a web page in unix and have done it all but when i try and load it it says permission denied!?> i have chmod a+rx for folder and file to make sure but still permissions wont let me?! any ideas can anyone do a quick run through of how to make a web page...... UNIX for Dummies Questions & Answers
4
UNIX for Dummies Questions & Answers

Featured Tech Videos