使用表单中的数据填充数据库

Question

I want to fill all the fields in my database by getting the ones inputted on my form but it won't fill my database.

I don't know what's wrong with it:

    <?php

    $handle = mysql_connect("", "root" , "");       
    return mysql_select_db("bonggarden", $handle);  

    $SQL = "INSERT INTO table1(fname,femail,fphone,fmsg) 
       values('".$_POST['name']."','".$_POST['email']."','".$_POST['number']."','".$_PO  ST['message']."')";

mysql_query($SQL);

?>  

here is my form

    <form id="main-contact-form" accept-charset="utf-8" class="" method="post" >
                <div class="col-sm-5 col-sm-offset-1">
                    <div class="form-group">
                        <label>Name *</label>
                        <input type="text" name="name" id="name" class="form-control" required="required">
                    </div>
                    <div class="form-group">
                        <label>Email *</label>
                        <input type="email" name="email" id="email" class="form-control" required="required">
                    </div>
                    <div class="form-group">
                        <label>Phone *</label>
                        <input type="text" name="number" id="number" class="form-control">
                    </div>

                </div>
                <div class="col-sm-5">

                    <div class="form-group">
                        <label>Message *</label>
                        <textarea name="message" id="message" required="required" class="form-control" rows="8"></textarea>
                    </div>                        
                    <div class="form-group">
                        <button type="submit" name="submit" class="btn btn-primary btn-lg" required="required">Submit Message</button>
                    </div>
                </div>
            </form> 

Answer 1

<?php


    $fname = $_POST['name'];
    $femail = $_POST['email'];
    $fphone = $_POST['number'];
    $fmsg = $_POST['message'];


    $handle = mysql_connect("localhost", "root" , "");       
    mysql_select_db("bonggarden", $handle);  

    $SQL = "INSERT INTO table1(fname,femail,fphone,fmsg) values('$fname','$femail','$fphone','$fmsg')";
    mysql_query($SQL);

?>  

// if it still not working echo the variable $fname, $femail, $fphone, $fmsg check value is proparly getting in veriable or not.