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);

This is what i've done for insert. I don't know if it's correct or not. — Naga Naveen, Apr 10 '15 at 06:54
First of all I would advise to change the mysql_ functions to PDO or mysqli since your code is prone to mysql injection http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php?rq=1 — gbestard, Apr 10 '15 at 07:00
And you could look into AJAX to make diferent calls when you press different buttons — gbestard, Apr 10 '15 at 07:03

score 1 · Answer 1 · answered Dec 02 '16 at 07:37

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.

Deep Kakkar · Answer 2 · 2016-12-02T05:37:47.793

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 02 '16 at 05:37

answered Apr 10 '15 at 07:05

Deep Kakkar

5,831
4
39
75

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

2 Answers2