issue in inserting data from dropdown into mysql table

Hi
I am new in PHP. I have used dropdown to bind with my sql data. It is ok
But I could not insert data into table only from dropdown. Other controls like text can be inserted.
I have given code below.
Pls advise me.
Maideen
[php]

<?php require_once '../inc/header.php'; ?>
<div class="portlet light bordered">
    <div class="portlet-title">
        <div class="caption">
            <i class="icon-social-dribbble font-green"></i>
            <span class="caption-subject font-green bold uppercase">Parameter</span>
        </div>
    </div>
    <form class="forget-form" action="../classes/cls.parameter.php" method="POST">
        <div class="portlet-body">
            <div class="form-group">
                <label for="default" class="control-label">Parameter Details</label>
                <input id="default" type="text" class="form-control" placeholder="Parameter Details" name="paramdetails"> 
            </div>
            <div class="form-group">
                <label for="single" class="control-label">Parameter head</label>
                <select id="paramhead" class="form-control select2" name="paramhead">
                    <option>-- Select --</option>
                    <?php
                          $sql  = "select * from tbl_paramhead order by paramhead";
                          $stmt   = $pdo->prepare($sql);
                          $stmt->execute();
                              while ($row = $stmt->fetch())
                              {
                                echo '<option value>' .$row['paramhead']. '</option>'; 
                              } 
                    ?>
                </select>
            </div>
        </div>
    <div class="form-actions">
        <button type="submit" class="btn green uppercase btn btn-danger mt-ladda-btn ladda-button" data-style="zoom-out" name="paramhead">Submit</button>
    </div> 
</form>    
</div>
<?php require_once '../inc/footer.php'; ?>

[/php]

[php]

<?php require_once '../inc/config.php'; if(isset($_POST['paramhead'])) { if($_SERVER["REQUEST_METHOD"] == "POST") { $paramhead =$_POST['paramhead']; $paramdetails =$_POST['paramdetails']; $bool = true; $sql="insert into tbl_parameter(paramhead,paramdetails) values ('$paramhead','$paramdetails')"; $stmt=$pdo->prepare($sql); $stmt->execute(); $pdo = null; print ''; print ''; } } ?>

[/php]

You have this
[php]echo ‘’ .$row[‘paramhead’]. ‘’; [/php]

should be like this
[php]echo ‘’ .$row[‘paramhead’]. ‘’; [/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service