John Davidson

Message:

I'm trying to echo a piece of text with PHP nested in it, anyone know how? I've tried it like this:

function update_category(){



    global $connection;



    if (isset($_GET['edit'])) {

        $edit_cat_key = $_GET['edit'];



        $query = "SELECT * FROM categories WHERE cat_id = {$edit_cat_key }";

        $edit_cat_query = mysqli_query($connection, $query);



        echo    '<form action="categories.php" method="post">

                    <div class="form-group">

                        <label for="new-cat-title">New name of category</label>

                            <input value="<?php if(isset($cat_title)){echo $cat_title;} ?>" type="text" class="form-control" name="new-cat-title">

                    </div>

                    <div class="form-group">

                        <input class="btn btn-primary" type="submit" name="submit" value="Rename Category">

                    </div>

                </form>';



            

        while($row = mysqli_fetch_assoc($edit_cat_query)) {

            $cat_title = $row['cat_title'];

            $cat_id = $row['cat_id'];

        }

    }



}

It prints: <?php if(isset($cat_title)){echo $cat_title;} ?>

I've tried it like this:

<input value="' . <?php if(isset($cat_title)){echo $cat_title;} ?> . '" type="text" class="form-control" name="new-cat-title">

---

My Answer:
"UPDATE categories SET cat_title = '' WHERE cat_id = '';"