473,320 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Was wondering if I can have HTML run an SQL query?

Hello,

I was wondering if it was possiable to have an HTML page and when a user fills it out and clicks submit it dumps all the information into a database" table.
I assume it would be and SQL call but I'm not quite sure how to code it.

Can anybody tell me or direct me to a page that can?

Thank you.
Oct 7 '10 #1
1 1287
Frinavale
9,735 Expert Mod 8TB
HTML stands for Hyper Text Markup Language. It is used to describe to browsers how text/images should be displayed.

It does not have any logic built into it. In other words, it's not a "programming language" it's just a defined way to "mark up" text so that it displays the way you want it to display in a web browser.

This means that HTML cannot be used to store things into a database. You need to submit the page to some code that is running on a web-server that will take what the user provided, validate this information (sanitize it), and then (if the data is valid/clean) store it in the database.

You can use any server-side language that you want: PHP, ASP/ASP.NET, Java (JSP), Perl etc. etc.

-Frinny
Oct 7 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: developer | last post by:
I have the following query that takes anywhere from 1 to 3 seconds to run. I would expect it to run in less than 1/2 a second (and I really need it to do so). I've added the appropriate indices...
2
by: sumi | last post by:
I am very new to python , I have small query could some one help me. every time I get a new load i need to do few things like creating some dir, changing some file contents and moving some files ,...
3
by: Brian Keanie | last post by:
I Have an existing query based on two tables which performs as it was intended. I added two fields from a third table and now the query does not perform. Any ideas as to what might be going on...
3
by: tdmailbox | last post by:
I set up my code to disable the shift bypass however for certain users I want to allow them through a button no a form to be able open up the list of tablies and queries. Is there a vb command...
2
by: comp.lang.php | last post by:
I am trying to replace within the HTML string $html the following: With Where I'm replacing "action=move_image" with "action=<?= $_REQUEST ?>"
32
ChaseCox
by: ChaseCox | last post by:
I have a form that I use to input criteria that I have then being passed into a query. Currently the query saves the results as an excell file. I would also like to have the results show up in the...
1
by: mirangk | last post by:
guys i have a query regarding vb i want to convert hexadecimal into ieee(floating point value) and finally display the decimal value using vb so can anyone help me in that pls. i am stuck i am not...
5
by: wugon.net | last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad query performance Env: db2 LUW V8 + FP14 Problem : We have history data from 2005/01/01 ~ 2007/05/xx in single big...
1
mikek12004
by: mikek12004 | last post by:
with one query I would something like this SELECT COUNT(id) AS numrows FROM pelates where owned='112'; to get the number of results and this SELECT * FROM pelates where owned='122' LIMIT...
6
by: Debbie link | last post by:
I have an access query that is outputting to an excel spreadsheet. How do I hide the null colmns on the excel spreadsheet when it opens. Thanks
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.