如何将html表单连接到数据库sql

Question

im to connect a form to a database but the php is giving problems any advice to help my script

                 <?php
              $connection = mysql_connect("localhost", "root", "");
               $db = mysql_select_db("hot_data", $connection);


            if(isset($_POST['submit']))
            {


                   $userid=_$POST['userid'];
                    $first_name=$_POST['fname'];
               $last_name=$_POST['lname'];
               $livingadress=$_POST['ldress'];
                 $telephone=$_POST['phone'];

                  if($userid !=''||$telephone !=''){

//Insert Query of SQL
                    $query = mysql_query("INSERT INTO personal_data(userid,first_name,last_name,living_address,telephone)


                   VALUES('$userid','$first_name','$last_name','$livingaddress','$telephone')");

              echo "<br/><br/><span>Data Inserted successfully...!!</span>";
              }
            else{
                 echo "<p>Insertion Failed <br/> Some Fields are Blank....!! </p>";
                        }
                     }
                           mysql_close($connection);
                  ?>

Answer 1

You have an error on this line -

$userid=_$POST['userid'];

Should be this -

$userid=$_POST['userid']; // $_POST variable was improperly written