PHP - What Is The Best Way To Handle Pdf To Jpg Page Number Conversions

<?php

$con=mysqli_connect("address","username","pass","db name");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

if (!(isset($pagenum))) 
{ 
 $pagenum = 1; 
 }

$data = mysqli_query($con,"SELECT * FROM info");

$rows = mysql_num_rows($data);

$page_rows = 15;

$last = ceil($rows/$page_rows);

if($pagenum < 1);
{ 

 $pagenum = 1;
 
 } 
 elseif ($pagenum > $last); 
 {
$pagenum = $last; 
 } 
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; 
 
$result = mysql_query($con,"SELECT * FROM topsites $max") or die(mysql_error()); 
 
 
echo "<table border='1' class='boldtable' cellpadding='2'>
<tr>
<th>Creditor</th>
<th>dd/mm/yyyy</th>
<th>Credit Score</th>
<th>State</th>

<th>Income</th>

<th>Approval</th>
<th>Credit Line</th>
<th>Interest</th>
<th>Comment</th>
</tr>";

while($row = mysqli_fetch_array($result)) {
  echo "<tr>";
  echo "<td>" . $row['creditor'] . "</td>";
  echo "<td>" . $row['date'] . "</td>";	 
  echo "<td>" . $row['fako'] . "</td>";
  echo "<td>" . $row['state'] . "</td>";

  echo "<td>" . $row['income'] . "</td>";

  echo "<td>" . $row['approval'] . "</td>";
  echo "<td>" . $row['creditline'] . "</td>";
  echo "<td>" . $row['interest'] . "</td>";
  echo "<td>" . $row['comments'] . "</td>";
  echo "</tr>";
}

echo "</table>";

echo " --Page $pagenum of $last-- <p>";
if ($pagenum == 1)

{

} 
 
 else
 
{

echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";

echo " ";

$previous = $pagenum-1;

echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";

}

echo " ---- ";

if ($pagenum == $last)

{

}

else {

$next = $pagenum+1;

echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";

echo " ";

echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";

}

mysqli_close($con);

?>

public function Update(Entry $e)
    {
        try
        {
            $query = "update entry set string = $e->string,delimiter=$e->delimiter where entryid= $e->id";
            $stmt = $this->db->mysqli->prepare($query);
            $stmt->bind_param('ssi',$e->string,$e->delimiter,$e->id);

            $stmt->close();
           

        }
        catch(Exception $ex)
        {
            print 'Error: ' .$ex->getMessage();
        }
    }

I have 2 PHP scripts : opendb.php and closedb.php

In opendb.php I have this code :

<?php
session_start();
$conn = mysqli_connect(................................);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
} else {
  echo "DB open.";
  $_SESSION['dbhandler'] = $conn;
}
?>

In closedb.php I have this code :

<?php
session_start();
$conn = $_SESSION['dbhandler']
mysqli_close($conn);
echo "DB closed";
?>
 

When I run opendb.php I get the expexted message "DB Open."

But when running the closedb.php ,   I get an error 500.

I was hoping to be able to pass the Handle, needed to operate in my database, between PHP scripts, by pushing it

into $_SESSION['dbhandler'] , and retreiving it in other scripts.

Is this possible ?

Regards,

Martin