title: link to a pop up view via a php query
body: <p>Hi I have a search function in my index.php page.  When a user types in a field and enters 'search' it goes to jobsearch.php and prints out the job summary from a mysqli database.</p>
  
  <p>I've created links that go on the end of the results.  <strong>So when the user sees the job summary the user clicks on the link (click here) then it directs the user to a pop up view which shows more information (job _description) about the job.</strong> Is there a way of doing this?  I don't want to have to create a <em>html page for every job</em> as there could be 100s of jobs in the database.</p>
  
  <p><strong>I would like the click-here link to take the ID of the desired job and print out the job description on a pop up page.</strong></p>
  
  <p>It looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/wim20.jpg" alt="enter image description here"></p>
  
  <p>this is jobs.php which prints out a list of jobs..</p>
  
  <pre><code>&lt;?php
  $servername = "*****";
  $username = "root";
  $password = "*****";
  $dbname = "jobslist";
  
  // Create connection
  $conn = new mysqli($servername, $username, $password, $dbname);
  // Check connection
  if ($conn-&gt;connect_error) {
       die("Connection failed: " . $conn-&gt;connect_error);
  }
  $sql = "SELECT id, job_title, job_description, job_location, job_category  FROM jobs_list";
  $result = $conn-&gt;query($sql);
  
  //display table
  echo "&lt;table border='1'&gt;
  &lt;!--&lt;tr&gt;
  &lt;th&gt;ID&lt;/th&gt;
  &lt;th&gt;Title&lt;/th&gt;
  &lt;th&gt;Description&lt;/th&gt;
  &lt;th&gt;Location&lt;/th&gt;
  &lt;th&gt;Category&lt;/th&gt;
  &lt;/tr&gt;--&gt;";
  
  if ($result-&gt;num_rows &gt; 0) {
       // output data of each row
  
       while($row = $result-&gt;fetch_assoc()) {
  
   echo "&lt;tr&gt;";
         echo "&lt;td min-height:'200' &gt;&lt;h2&gt;". $row["id"] ."&lt;/h2&gt;&lt;/td&gt;";
         echo "&lt;td&gt;". $row["job_title"] . "&lt;/td&gt;";
         echo "&lt;td min-width:'700' &gt;". $row["job_description"] . "&lt;/td&gt; " ;
         echo "&lt;td&gt;". $row["job_location"] . "&lt;/td&gt;";
         echo "&lt;td&gt;". $row["job_category"] . "&lt;/td&gt; " ;
  
  //this prints out a clickable link for every job
  
  echo "&lt;td&gt;&lt;a href='" . $row['id'] .  "'&gt;Click Here&lt;/a&gt;&lt;/td&gt;";
  
  
  
         echo "&lt;/tr&gt;";
      }
  
  }
   else {
       echo "0 results";
  }
  
  echo "&lt;/table&gt;";
  $conn-&gt;close();
  ?&gt;
  </code></pre>