fetching data and displaying it on [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

---

Want to improve this question? Add details and clarify the problem by editing this post.

Closed 1 hour ago.

Improve this question

<?php include("../../navbar.php"); ?>


<div class="container">

<div class="text-left">
    <h2>Semi-Synthetic Compounds</h2>
</div>

<a class="btn btn-primary" href="https://fgcsl.ihbt.res.in/Chihbt/chcompounds/semi_synthetic/tableformat.php?page=1"     role="button">Table Format</a>


<div class="row">


<?php include("../../conn.php"); ?>

<?php  
       $query = "select * from semi_synthetic";
       $result = mysqli_query($conn,$query); 
       $per_page_record = 30;

        if (isset($_GET["page"])) {
            $page  = $_GET["page"];
        }
        else {
          $page=1;
        }

        $start_from = ($page-1) * $per_page_record;
        $query = "SELECT * FROM semi_synthetic LIMIT $start_from, $per_page_record";
        $result = mysqli_query ($conn, $query); 

        while($rows = mysqli_fetch_array($result)) {

        ?>


<div class="col-lg-4">
<div class="card" style="width: 18rem;">
  <img src="<?php echo $rows['images']; ?>" class="card-img-top" alt="...">
        <div class="text-center card-body">
    <h4><a name="CHIHBT_ID"  href="../../compound_report_card/index.php?CHIHBT_ID=<?php echo $rows["CHIHBT_ID"]?>"><?php echo $rows["CHIHBT_ID"]; ?></a></h4>
       
        <p>Formula :<?php echo $rows['formula']; ?> </p>
        <p>logp M logp:<?php echo $rows['logp_M_logp']; ?> </p>
        </div>
</div>
</div>

<?php

                                }

                           ?>
<!--
<div class="col-lg-4">
<div class="card" style="width: 18rem;">
  <img src="/var/www/html/Chihbt/Data/FINAL_SEMI_SYNTHETIC.tsv" class="card-img-top" alt="...">
    <div class="text-center card-body">
    <h4><a href="">CHIHBT-ID:</a></h4>
    <p>Formula : </p>
    <p>Alogp :</p>
    </div>
</div>
</div>

<div class="col-lg-4">
<div class="card" style="width: 18rem;">
  <img src="/var/www/html/Chihbt/Data/FINAL_SEMI_SYNTHETIC.tsv" class="card-img-top" alt="...">
        <div class="text-center card-body">
        <h4><a href="">CHIHBT-ID:</a></h4>
        <p>Formula : </p>
        <p>Alogp :</p>
        </div>
</div>
</div>

<div class="col-lg-4">
<div class="card" style="width: 18rem;">
  <img src="/var/www/html/Chihbt/Data/FINAL_SEMI_SYNTHETIC.tsv" class="card-img-top" alt="...">
        <div class="text-center card-body">
        <h4><a href="">CHIHBT-ID:</a></h4>
        <p>Formula : </p>
        <p>Alogp :</p>
        </div>
</div>
</div>

<div class="col-lg-4">
<div class="card" style="width: 18rem;">
  <img src="/var/www/html/Chihbt/Data/FINAL_SEMI_SYNTHETIC.tsv" class="card-img-top" alt="...">
        <div class="text-center card-body">
        <h4><a href="">CHIHBT-ID:</a></h4>
        <p>Formula : </p>
        <p>Alogp :</p>
        </div>
</div>
</div>


<div class="col-lg-4">
<div class="card" style="width: 18rem;">
  <img src="/var/www/html/Chihbt/Data/FINAL_SEMI_SYNTHETIC.tsv" class="card-img-top" alt="...">
        <div class="text-center card-body">
        <h4><a href="">CHIHBT-ID:</a></h4>
        <p>Formula : </p>
        <p>Alogp :</p>
        </div>
</div>
</div>

<div class="col-lg-4">
<div class="card" style="width: 18rem;">
  <img src="/var/www/html/Chihbt/Data/FINAL_SEMI_SYNTHETIC.tsv" class="card-img-top" alt="...">
        <div class="text-center card-body">
        <h4><a href="">CHIHBT-ID:</a></h4>
        <p>Formula : </p>
        <p>Alogp :</p>
        </div>
</div>
</div>

-->
</div>

 <div class="pagination">
<?php
$query = "SELECT COUNT(*) FROM semi_synthetic";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_row($result);
$total_records = $row[0];

    echo "</br>";
        // Number of pages required.   
        $total_pages = ceil($total_records / $per_page_record);
        $pagLink = "";

        if($page>=2){
            echo "<a href='diagramformat.php?page=".($page-1)."'>  Prev </a>";
        }

        for ($i=1; $i<=$total_pages; $i++) {
          if ($i == $page) {
 $pagLink .= "<a class = 'active' href='diagramformat.php?page=".$i."'>".$i." </a>"; }               else  {
 $pagLink .= "<a href='diagramformat.php?page=".$i."'> ".$i." </a>";
          }
             }

        echo $pagLink;
if($page<$total_pages){
echo "<a href='tableformat.php?page=".($page+1)."'>  Next </a>";
        }

      ?>
</div>


<?php include("../../footer.php"); ?>

**THE CODE ABOVE IS THE PAGE IN WHICH THERE ARE ALL CARDS WITH HYPERLINK AND ON EACH ONCLICK I WANT DATA FOR THAT I HAVE CREATED **

<?php include ("../navbar.php");

?>

<?php include("../conn.php"); 
    $query = "select * from semi_synthetic";
        $result = mysqli_query($conn,$query);
 ?>



<div class="container">
<div class="compound_report_card">
    <h2>Compound Report</h2>
    
    <div class="card-content">
    
<?php
//Check If Id Isset.

if(isset($_GET["CHIHBT_ID"]))

   //Display Id On A Webpage.
   echo "<p>Calculated Properties of : " . $_GET[ "CHIHBT_ID" ] . "</p>";
   
 
    
?>

          <ul>
             <li>Canonical smiles :</li>
             <li> Molecular weight :</li>
             <li> Number of heavy atoms :</li>
             <li> Number of aeromatic heavy atoms :</li>
             <li> Number of rotatable bonds :</li>
             <li> Number of H bond acceptors :</li>
             <li> Number of H bond donors:  </li>
             <li> Tpsa A**2 :</li>
          </ul>

<?php
                while($row = mysqli_fetch_assoc($result)) {
                ?>
        <ul>
             <li><?php echo $row['smile_notation']; ?></li>
             <li><?php echo $row['molecular_weight']; ?></li>
             <li><?php echo $row['number_of_heavy_atoms']; ?></li>
             <li><?php echo $row['number_of_aeromatic_heavy_atoms']; ?></li>
             <li><?php echo $row['number_of_rotatable_bonds']; ?></li>
             <li><?php echo $row['number_of_h_bond_acceptors']; ?></li>
             <li><?php echo $row['number_of_h_bond_donors']; ?></li>
             <li><?php echo $row['tpsa']; ?></li>
         </ul>


     <?php }; ?>

 </div>            
</div>
</div>


<?php include ("../footer.php");   ?>

**OK SO THIS IS MY HYPERLINK PAGE THAT I AM CREATING AND I HAVE CREATED A LOT OF HYPERLINKS IN PAGE CODE ABOVE WHEN I CLICK IAM CLICKING IN ONE PAGE IT IS SHOWING ME DATA OF 30 HYPERLINKS AT ONCE HOW DO I REDUCE IT TO ONE DATA FOR ONLY ONE THAT I WANT **