display data in input text and Option from my sql using php

Ask about general coding issues or problems here.

Moderators: egami, macek, gesf

Post Reply
maideen
New php-forum User
New php-forum User
Posts: 30
Joined: Mon Mar 07, 2011 11:38 pm

Sat Sep 09, 2017 5:47 pm

Hi

I could not load data into input text and select option control.
I don't know where i did wrong.
Pls advice me
Thank you in advence

maideen

Code: Select all

<?php require_once '../inc/header.php'; ?>

<?php

if($_SERVER["REQUEST_METHOD"] == "GET")
    {
        $id=$_GET['id'];
        $sql ="Select * from tbl_parameter where id ='$id'";
        $stmt = $pdo->prepare($sql);
        $stmt->execute();
            while ($row = $stmt->fetch())
            {
                $paramhead =$row['paramhead'];
                $paramdetails =$row['paramdetails'];
                $id =$row['id'];

            // below is display information in page. It is OK
                
              echo "id entered is :",$id,"<br>";
              echo "paramHead entered is :",$paramhead,"<br>";
              echo "Param details entered is :",$paramdetails,"<br>";                            
            }
    }
  
?>
    <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">Update Parameter</span>
            </div>
        </div>
        
        <div class="portlet-body">
            
                <form  action="../classes/cls.parameter.php" method="POST">
                    <div class="form-group">
                        <label for="default" class="control-label">Parameter Details</label>
                        <input id="paramdetails" type="text" class="form-control" placeholder="Parameter Details" name="paramdetails" values ="<?php echo $paramdetails; ?>" >
                    </div>
                    <div class="form-group">
                        <label for="single" class="control-label">Parameter head</label>
                        <select id="paramhead" name="paramhead" class="form-control select2" >
                            <option>-- Select --</option>
                            <?php
                                  $sql  = "select * from tbl_paramhead order by paramhead";
                                  $stmt = $pdo->prepare($sql);
                                  $stmt->execute();
                                      while ($row = $stmt->fetch())
                                      {
                                        $optvalue = $row['paramhead'];
                                        print '<option value ='.$optvalue.'>' .$row['paramhead']. '</option>'; 
                                        //echo '<option value ='.$row['paramhead'].'>' .$row['paramhead']. '</option>';
                                      } 
                            ?>
                        </select>                    

                    </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="add">Submit</button>
                    </div> 
                </form>    
        </div>
    </div>


<?php require_once '../inc/footer.php'; ?>





User avatar
hyper
php-forum Active User
php-forum Active User
Posts: 498
Joined: Mon Feb 22, 2016 5:52 pm

Sun Sep 10, 2017 10:20 am

First thing to do is take your output html code and have a look at it for errors, if you can't see any problems, pass it through an html checker.

Post Reply