如何将文本框的值复制到我的查询中

Question

I have my textbox named Title here!

The Title is the upper most Textbox! I have a query where i should copy the value of that textbox which is 'A' to my query here

        $sql_query="SELECT * FROM tblpost WHERE Page = 'A' ";

this is exactly my code! Hope everyone can guide me because I am Actually new in PHP this is my whole code

        <form method="post">
        <div class="form-group">
      <label>Page Title</label>
      <input name="title" type="text"  value="<?php echo $fetched_row['Title']; ?>" required class="form-control" placeholder="Page Title">
    </div>
  <div class="form-group">
      <select class="form-control" name="active"  id="active">
          <option value="">~~SELECT~~</option>
          <option value="Actived">Activated</option>
          <option value="Deactivated">Deactivated</option>
        </select>
    </div>
    <div class="form-group">
      <label>Meta Tags</label>
      <input type="text"  value="<?php echo $fetched_row['Tags']; ?>" name="tags" required class="form-control" placeholder="Add Some Tags...">
    </div>
    <div class="form-group">
      <label>Category</label>
      <input type="text" name="description"  value="<?php echo $fetched_row['Description']; ?>" class="form-control" required placeholder="Add Category...">
    </div>

         <table class="table table-striped table-hover" id="myTable">
                  <tr>
                    <th>Page Title</th>
                    <th>Status</th>
                    <th>Date Created</th>
                    <th></th>
                  </tr>

                         <?php



                        $sql_query="SELECT * FROM tblpost WHERE Page = //I think it's right here ";

                        $result_set=mysql_query($sql_query);
                        while($row=mysql_fetch_row($result_set))
                        {
                          ?>

                        <tr>
                            <td><?php echo $row[1]; ?></td>
                            <td><?php echo $row[3]; ?></td>
                            <td><?php echo $row[6]; ?></td>
                            <td><a class="btn btn-primary" href="javascript:edt_id('<?php echo $row[0]; ?>')">Edit</a>   <a class="btn btn-danger" href="javascript:delete_id('<?php echo $row[0]; ?>')">Delete</a></td>      
                          </tr>
                            <?php
                     }
                     ?>

                          <script>
                          function myFunction() {
                            var input, filter, table, tr, td, i;
                            input = document.getElementById("myInput");
                            filter = input.value.toUpperCase();
                            table = document.getElementById("myTable");
                            tr = table.getElementsByTagName("tr");
                            for (i = 0; i < tr.length; i++) {
                              td = tr[i].getElementsByTagName("td")[0];
                              if (td) {
                                if (td.innerHTML.toUpperCase().indexOf(filter) > -1) {
                                  tr[i].style.display = "";
                                } else {
                                  tr[i].style.display = "none";
                                }
                              }       
                            }
                          }
                          </script>


             </table>

           <center> <button type="submit" class="btn btn-primary" name="btn-update"><strong>UPDATE</strong></button> <button type="submit" class="btn btn-default" name="btn-cancel"><strong>Cancel</strong></button></center>

                 </form>

Answer 1

If I understand your code snippet correctly, at page load time the "title" is carries in a array variable: $fetched_row['Title']

So essentially your code should be something like:

$sql_query="SELECT * FROM tblpost WHERE Page = '".mysql_real_escape_string($fetched_row['Title'])."';";

If this is new code, you really should use mysqli instead of the deprecated mysql, if at all possible.