عرض الصور من قاعدة البيانات

<?php
define('IN_PowerBB',true);
include('common.php');
// Show Header
$PowerBB->functions->ShowHeader();
//
$query = $PowerBB->DB->sql_query("SELECT  *   FROM " . $PowerBB->table['subject'] . " ORDER BY write_time DESC LIMIT 10");
while ($me = $PowerBB->DB->sql_fetch_array($query))
{
$me['text'] = $PowerBB->Powerparse->replace($me['text']);
$PowerBB->Powerparse->replace_smiles($me['text']);
$PowerBB->Powerparse->replace_wordwrap($me['text']);
echo $me['text'];
}

// Show footer  ?
$PowerBB->functions->GetFooter();
//
?>

<?php
define('IN_PowerBB',true);
include('common.php');
// Show Header
$PowerBB->functions->ShowHeader();
//
$query = $PowerBB->DB->sql_query("SELECT  *   FROM " . $PowerBB->table['subject'] . " ORDER BY write_time DESC LIMIT 10");
while ($me = $PowerBB->DB->sql_fetch_array($query))
{
$me['text'] = $PowerBB->Powerparse->replace($me['text']);
//$PowerBB->Powerparse->replace_smiles($me['text']);
$images = array();
preg_match_all('/src=([\'"])?((?(1).*?|\S+))(?(1)\1)/', $me['text'], $images);
foreach ($images[2] as $src) {
echo '<img border="0" alt="" src="'.$src.'" />';
}

}
// Show footer  ?
$PowerBB->functions->GetFooter();

//
?>

break;

foreach ($images[2] as $src) {
echo '<img border="0" alt="" src="'.$src.'" />';
break;
}

define('IN_PowerBB',true);
include('common.php');
// max display pere pagr
$per_page = 10;

// get start
$start = $_GET['start'];

// count record
$record_count = $PowerBB->DB->sql_num_rows($PowerBB->DB->sql_query("SELECT * FROM pbb_subject"));

// count max pages
$max_pages = $record_count / $per_page;

if (!$start)

$start = 0;




///////
$query = $PowerBB->DB->sql_query("SELECT  *   FROM " . $PowerBB->table['subject'] . " ORDER BY write_time DESC LIMIT $start, $per_page");
while ($me =
$PowerBB->DB->sql_fetch_array($query))
{

$me['text'] = $PowerBB->Powerparse->replace($me['text']);
$me['title'] = $PowerBB->Powerparse->replace($me['title']);

$images = array();
preg_match_all('/src=([\'"])?((?(1).*?|\S+))(?(1)\1)/', $me['text'],
$images);
foreach ($images[2] as $src) {


//////////////////////////////
echo '
    <div id="d">
    <UL class="1">
	 <LI> <a href="">'.$me["title"].'</a></LI>
	 <img src="'.$src.'">
    </UL>
    </div>';

break;

}

}


// setup prev and next
$prev = $start - $per_page;
$next = $start + $per_page;

// show prev button
if (!($start<=0))

echo " <a href='?start=$prev'>prev</a> ";

// show page number

// set variable for first page
$i=1;
for ($x=0;$x<$record_count;$x=$x+$per_page)
{
    if ($start!=$x)
    echo " <a href='?start=$x'>$i</a> ";
    else
    echo " <a href='?start=$x'><b>$i</b></a> ";
    $i++;
}

// show next button
if (!($start>=$record_count-$per_page))

echo "<a href='?start=$next'>next</a>";

$record_count = $PowerBB->DB->sql_num_rows($PowerBB->DB->sql_query("SELECT * FROM " . $PowerBB->table['subject'] . ""));

$record_count = $PowerBB->DB->sql_num_rows($PowerBB->DB->sql_query("SELECT * FROM " . $PowerBB->table['subject'] . " WHERE section = 7"));

$pagesnum = round(ceil($record_count / $per_page));

$record_count = $PowerBB->DB->sql_num_rows($PowerBB->DB->sql_query("SELECT * FROM " . $PowerBB->table['subject'] . " WHERE section = 7 "));

$query = $PowerBB->DB->sql_query("SELECT  *   FROM " . $PowerBB->table['subject'] . " WHERE section = 7 ORDER BY id DESC LIMIT ".$start.",".$per_page." ");