I am trying to insert form data into database but its give error(undefine index: name and fname)

Question

THis is my html code i have checked multiple time but again its not working.

<form action="insert.php" method="POST">
        <input type="text" name="name"><br>
        <input type="text" name="fname"><br>
        <input type="submit" name=""><br>

    </form>

This is my php code i think code is correct but don't know its not working.

<?php
//include("php\DB.php");

$connection=new mysqli("localhost","root","","sms");
if($connection){
    echo "Connected";
}else{echo "Sorry";}



$username=$_POST["name"];
$fname=$_POST["fname"];



 $query="INSERT INTO student(name,fname)VALUES('".$username."','".$fname."')";



$connection->query($query);


?>

It seems that may be your table field is different. please post structure of student table. — Roshan Dandgavhal, Feb 28 '17 at 05:30
use error_reporting(0); or declare the variables before using them. — VishalParkash, Feb 28 '17 at 05:32
or may be your form action is not correct. my be form didn't able to find `insert.php` — Alive to die - Anant, Feb 28 '17 at 05:32
are both `form code` and php code files are at same location? — Alive to die - Anant, Feb 28 '17 at 05:34
@MuhammadYounas. May be there is space in field name of table. Could you please check? — Roshan Dandgavhal, Feb 28 '17 at 05:35
@RoshanDandgavhal that will not produce undefined index error. it will just related to form and php code before query — Alive to die - Anant, Feb 28 '17 at 05:37
yes i have checked multiple time there is no space in field name and also action path is correct but i don't know why its giving the error when send data its shows that the data is gone to php but its not inserting in database — Muhammad Younas, Feb 28 '17 at 05:42
Make sure You are getting POST data, Please check print_r($_POST) & see the result — Shan, Feb 28 '17 at 05:47
i have did echo $query also in the same page its working and also in php my admin query is correct — Muhammad Younas, Mar 01 '17 at 04:51

score 0 · Answer 1 · answered Feb 28 '17 at 05:46

0

according to my little knowledge please give space between insert statement

insert into student(name,fname) values('$username','$fname');

answered Feb 28 '17 at 05:46

rch

345
1
6
20

I am trying to insert form data into database but its give error(undefine index: name and fname)

1 Answers1