This discussion is now closed.
Check out other Related discussions
- Data science bsc at LSE? (experience, advice)
- About MS Access/MySQL
- Btec it level 3 unit 2
- BTEC IT Unit 2 January 2024 exam discussion
- nea computer science a level
- BTEC IT Level 3 Unit 2 Exam Discussion
- UCAS Clearing
- Sending a PN1 form
- Need help with Manchester Metropolitan University in MSc Physiotherapy
- computer science ocr
- ICE's "Eye of God" program
- Online MSc Data Science
- careers
- NEA Examples For AQA A Level Computer Science
- A level Computer science OCR NEA
- BTEC IT LEVEL 3 unit 2 jan 2024
- Computer science NEA
- URGENT:Used a plagiarism checker & am freaking out because it might have stored my PS
- Bioinformatics / Data Science masters?
- Computer science vs computer science with maths
Getting Data into MySQL Database via Forms
What is the best way to get data input via a html form, into a database?
I realise PHP will be required, is there a certain PHP script or code needed for this?
I realise PHP will be required, is there a certain PHP script or code needed for this?
Saying for example you have a form:
A very simple PHP example to insert the name into a db would be:
Hope that helps
<form method="post" action="script.php">
<p>Name: <input type="text" name="name"></p>
<p><input type="submit" value="Submit"></p>
</form>A very simple PHP example to insert the name into a db would be:
<?php
// check that we have received data
if(!empty($_POST))
{
// get and clean data input
$name = mysql_real_escape_string($_POST['name']);
// insert into db
$sql = mysql_query("INSERT INTO dbname (name) VALUES('".$name."')");
// output success or error
if($sql) { echo "<p>Success.</p>"; } else { echo "Error."; }
}
?>Hope that helps
Related discussions
- Data science bsc at LSE? (experience, advice)
- About MS Access/MySQL
- Btec it level 3 unit 2
- BTEC IT Unit 2 January 2024 exam discussion
- nea computer science a level
- BTEC IT Level 3 Unit 2 Exam Discussion
- UCAS Clearing
- Sending a PN1 form
- Need help with Manchester Metropolitan University in MSc Physiotherapy
- computer science ocr
- ICE's "Eye of God" program
- Online MSc Data Science
- careers
- NEA Examples For AQA A Level Computer Science
- A level Computer science OCR NEA
- BTEC IT LEVEL 3 unit 2 jan 2024
- Computer science NEA
- URGENT:Used a plagiarism checker & am freaking out because it might have stored my PS
- Bioinformatics / Data Science masters?
- Computer science vs computer science with maths
Latest
Trending
Last reply 2 days ago
Is MathsFM French Alevels good for a CS degree at top uni (OX, UCL, Durham etc)Last reply 4 days ago
OCR A-level Computer Science Paper 1 (H446/01) - 12th June 2023 [Exam Chat]Last reply 2 weeks ago
OCR A-level Computer Science Paper 2 (H446/02) - 19th June 2023 [Exam Chat]Last reply 3 weeks ago
AQA A-level Computer Science Paper 1 (7517 1A - 1E) - 12th June 2023 [Exam Chat]Last reply 1 month ago
Not receiving any response from University of Birmingham.Last reply 3 months ago
OCR GCSE Computer Science Paper 1 (J277/01) - 19th May 2023 [Exam Chat]Last reply 3 months ago
AQA GCSE Computer Science Paper 2 (8525/2) - 25th May 2023 [Exam Chat]Trending
Last reply 2 days ago
Is MathsFM French Alevels good for a CS degree at top uni (OX, UCL, Durham etc)Last reply 4 days ago
OCR A-level Computer Science Paper 1 (H446/01) - 12th June 2023 [Exam Chat]Last reply 2 weeks ago
OCR A-level Computer Science Paper 2 (H446/02) - 19th June 2023 [Exam Chat]Last reply 3 weeks ago
AQA A-level Computer Science Paper 1 (7517 1A - 1E) - 12th June 2023 [Exam Chat]Last reply 1 month ago
Not receiving any response from University of Birmingham.Last reply 3 months ago
OCR GCSE Computer Science Paper 1 (J277/01) - 19th May 2023 [Exam Chat]Last reply 3 months ago
AQA GCSE Computer Science Paper 2 (8525/2) - 25th May 2023 [Exam Chat]
