0

I want to data in my table tbljobcategory but for example , if the return data is Infomation and Technology it is only returning Infomation...

<?php

            $stmt = $pdo->prepare("select * from  tbljobcategory where category_id=:catid");
            $stmt -> execute(array(":catid"=>$_GET["catid"]));
            $rows = $stmt ->fetch(PDO::FETCH_ASSOC);
            $CategoryName = htmlspecialchars($rows["Category"]);
    
            


            ?>
        <div class="card text-center form-add" style="width:35%;">
            <div class="card-header">
                Edit Job Category
            </div>
            <div class="card-body">
                <form method="post" action="">
                <div class="mb-3">
                <label for="exampleFormControlInput1" class="form-label">Current Job Category</label>
            
            
                <input class="form-control" type="text"  value=<?php echo  "$CategoryName "  ;?>  disabled readonly>
                </div>
                <div class="mb-3">
                <label for="exampleFormControlTextarea1" class="form-label">New Job Category</label>
                <input class="form-control" type="text" name="NCategory" placeholder="New Job Category" aria-label="default input example">
                </div>
                <button type="submit" name="btn-update" class="btn btn-primary">Save Changes</button>
                <button type="submit" name="btn-cancel"  class="btn btn-secondary">Cancel</button>
            </div>
            </form>
Progman
  • 16,827
  • 6
  • 33
  • 48
Mr Smith
  • 3
  • 2

0 Answers0