06-20-2013
Quote:
Originally Posted by
poops
How can i get the buttons on the page to ssh to the server and kick off the scripts?
This is the basic functionality of "CGI". CGI -
Common Gateway Interface is a way to interface logic - scripts - with the webservers operation, so that whenever some event happens (like when a button is clicked, etc.) a certain script starts to run.
Quote:
Originally Posted by
poops
Instead of having to run these update stmnts from the command line or in workbench etc, the main goal is to have a page I can leave open in the browser at all times and just plug a variable into the text field and select the correct button for what i want it to update.
This is quite possible, but depending on how "public" this should be you will have to take various amounts of security precautions. If you simply add the text of your "variable" to a fixed statement and execute this it is possible to add a text which in fact comprises a complete SQL-statement and hence changes the intent of your original statement to something entirely different. This is called "SQL injection" and is one of the biggest issues in Web Development when dealing with user-provided values.
Now, if the three-button interface is just for your personal use you can of course skip any security means, like pre-parsing the user-provided part, etc.. But as the audience using this grows so does the risk of somebody not being as benevolent as you and the necessity of taking precautions increases.
I hope this helps.
bakunin
10 More Discussions You Might Find Interesting
1. Linux
dear experts,
i m newbies of linux. i found that my linux server does not support the webportal links, causing the filing system in the webportal dissapear as well. i suspect 1st: configuration of linux not set properly, 2nd: access link lost for the filing system.
please give me a rough idea... (1 Reply)
Discussion started by: clemeot
1 Replies
2. Shell Programming and Scripting
I want to create a GUI which runs shell scripts in the background. What should I use for creating that GUI. I would be nice if you could point me to some resources where I can learn to create a GUI (2 Replies)
Discussion started by: lassimanji
2 Replies
3. Shell Programming and Scripting
Hello everyone!
I'm looking for a way to build a GUI for various bash scripts I've written.
Is there any "good" way to do it?
I've heard about python/gtk+,qt and other stuff, but I've absolutely no idea where I should look at.
Thanks a lot in advance!
Regards,
xenator
EDIT:
... (1 Reply)
Discussion started by: xenator
1 Replies
4. Shell Programming and Scripting
Hi all! Im wondering if its possible to create a GUI for a shell script I just got done writing as the people that will be using it dont like the command line all to well. Just something simple with radio buttons to select options, maybe a text field to enter a location to save the file generated... (1 Reply)
Discussion started by: Grizzly
1 Replies
5. Solaris
I am using Solaris 10, and would like a web gui for mail or can replace the mail server if needed, it doesnt need to be anything elaborate, just something where i can view mail via a web browser rather than command line and hitting 'd' a 1000 times to delete all my cron job mails etc :p
I've... (8 Replies)
Discussion started by: ippy98
8 Replies
6. Shell Programming and Scripting
Hi,
I want to know whether it is possible to use GUI for cshell scripts?
Thanks
Sarbjit (0 Replies)
Discussion started by: sarbjit
0 Replies
7. Shell Programming and Scripting
what GUI can be used with shell scripting
for example if i want to say hello in prompted window
thnx in advance (3 Replies)
Discussion started by: semosam
3 Replies
8. Fedora
hi all,
this is my first post here...i hope that this is the correct section to write my question.
I have a distro linux without gui, only text mode.
So, it's possible run automatically a command or a program as "top" or "ping" and get the result on the main shell , after the boot and after... (6 Replies)
Discussion started by: gangiaemi
6 Replies
9. Shell Programming and Scripting
Hello Experts,
In my current job I need to upgrade a web GUI to execute Unix commands in a server....I am completely new to programming--So can anyone here help me out with initial steps...
Please notice that statement completely new to programming means-I never did it, SO I might keep on coming... (1 Reply)
Discussion started by: mhadi
1 Replies
10. Shell Programming and Scripting
Hello all!
This is my first post and I'm very new to programming. I would like help creating a simple perl or bash script that I will be using in my work as a junior bioinformatician.
Essentially, I would like to take a tab-delimted or .csv text with 3 columns and write them to a "3D" matrix:
... (16 Replies)
Discussion started by: torchij
16 Replies
cgi(5) Programmer's Manual cgi(5)
NAME
cgi - Common Gateway Interface
DESCRIPTION
The Common Gateway Interface is a way to create dynamic web pages. It defines rules for interaction between a program and the web server
while the server talks to the client. There are some ways to use it.
ENVIRONMENT
Normally the webserver sets several environment variables to give some information to the CGI program so it can determine various stuff.
AUTH_TYPE
This reflects the authentification method used to validate a user.
CONTENT_LENGTH
The length of the data in bytes passed to the CGI program through standard input. This is used by the POST method.
CONTENT_TYPE
The MIME type of the query data, such as "text/html", optional.
DOCUMENT_ROOT
This reflects the document root directory of the webserver.
GATEWAY_INTERFACE
Reflects the version of the Common Gateway Interface that the server is using
HTTP_ACCEPT
A comma separated list of MIME type that the client is willing to accept.
HTTP_FROM
The email address of the user issuing the information request. This is not supported by most browsers.
HTTP_REFERER
Reflects the URL from which this CGI program was accessed.
HTTP_USER_AGENT
The name, version and libraries of the browser making the request. This information can be used to determine if the browser is
capable of graphics and is able to display frames and tables.
PATH_INFO
This shows extra information that was passed to the CGI program via command line. Normally it's empty or non-existent.
PATH_TRANSLATED
The translated path on the local filesystem.
QUERY_STRING
This variable refers to additional arguments that were appended to the CGI program - normally with the '?' sign.
REMOTE_ADDR
This refers to the host from which the information request was issued, as IP number.
REMOTE_HOST
This refers to the host from which the information request was issued.
REMOTE_USER
The authenticated name of the user.
REQUEST_METHOD
This refers to the method with which the information request was issued. Normally this is either GET or POST.
SCRIPT_NAME
The virtual name of the script being executed.
SERVER_NAME
The server's hostname or IP number. This may be used to determine the correct paths or resulting HTML code for CGI programs that
are used on the same machine for several servers.
SERVER_PROTOCOL
This is the name and version of the information protocol the request came in with. Normally this is "HTTP/1.0" or "HTTP/1.1".
SERVER_PORT
This refers to the TCP/IP port on which the webserver is running.
SERVER_SOFTWARE
This reflects the name and revision of the webserver software.
AUTHOR
This CGI library is written by Martin Schulze <joey@infodrom.org>. If you have additions or improvements please get in touch with him.
SEE ALSO
cgiDebug(3), cgiHeader(3), cgiSetType(3), cgiSetHeader(3), cgiGetValue(3), cgiGetVariables(3).
CGI Library 6 April 2008 cgi(5)