How to insert values from a form into a table using php on click of a insert button

Question

I'm having a html form where i have 3 fields(ID, NAME, BLOOD GROUP). And below that I've 3 buttons(INSERT, UPDATE, DELETE). And then i want to enter the values in the fields and when click on the INSERT button these values should be entered into a table through a PHP script. Similar respective actions must happen with UPDATE and DELETE also. Can anyone help me out?

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);

if (!$conn) {
    die("couldn't connect" . mysql_error());
}
echo 'connected successfully';
mysql_select_db('DB');

$id = $_POST['Id'];
$name = $_POST['Name'];
$blood = $_POST['BloodGroup'];
$order = "Insert into info(Id, name, BloodGroup) values ('$Id', '$Name', '$BloodGroup')";

$result = mysql_query($order);

if (!$result) {
    die('Input data failed' . mysql_error());
}
echo 'Input data entered successfully';
mysql_close($conn);

<?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn) { die("couldn't connect" . mysql_error()); } echo 'connected successfully'; mysql_select_db('DB'); $id = $_POST['Id']; $name = $_POST['Name']; $blood = $_POST['BloodGroup']; $order = "Insert into info(Id, name, BloodGroup) values ('$Id', '$Name', '$BloodGroup')"; $result = mysql_query($order); if(! $result) { die('Input data failed' . mysql_error()); } echo 'Input data entered successfully'; mysql_close($conn); ?> — Naga Naveen
– Naga Naveen, Commented Apr 10, 2015 at 6:53
This is what i've done for insert. I don't know if it's correct or not. — Naga Naveen
– Naga Naveen, Commented Apr 10, 2015 at 6:54
First of all I would advise to change the mysql_ functions to PDO or mysqli since your code is prone to mysql injection stackoverflow.com/questions/60174/… — gbestard
– gbestard, Commented Apr 10, 2015 at 7:00

Rahul Patel · Accepted Answer · 2016-12-02 07:37:31Z

1

Firstly make sure your form is submitting to the PHP script.

For this the INSERT button should be of type="submit". Then you can debug your PHP script line by line. For UPDATE and DELETE you can use the same PHP script with the query strings. Ex - ?id=xx&action=update OR ?id=zz&action=delete. Then you can apply the code in your PHP script corresponding to the action.

answered Dec 2, 2016 at 7:37

Rahul Patel

6396 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Deep Kakkar · Accepted Answer · 2016-12-02 05:37:47Z

0

Use mysql_select_db('DB') or die(mysql_error()); once. and also your variable names are wrong.

Please Use

$order = "Insert into info(Id, name, BloodGroup) values ('$id', '$name', '$blood')";

edited Dec 2, 2016 at 5:37

answered Apr 10, 2015 at 7:05

Deep Kakkar

6,3034 gold badges43 silver badges80 bronze badges

Collectives™ on Stack Overflow

How to insert values from a form into a table using php on click of a insert button

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related