hi all,
I have trouble with preg_replace and querying database, my code is below,
<?php include("h/h.php");
function getImgAttributes($id){
$dsn = array(
'phptype' => "mysql",
'hostspec' => "localhost",
'database' => "db",
'username' => "root",
'password' => "pass"
);
$myDbc = DB::connect($dsn);
$myDbc->setFetchMode(DB_FETCHMODE_ASSOC);
$select_sql="select width, height, name from files where id='$id'";
$execute_query = $myDbc->query($select_sql);
$row=$execute_query->fetchRow();
return 'id="'.$id.'" width="'.$row['width'].'" height="'.$row['height'].'" alt="'.$row['name'].'"';
}
function writeImgTag ($text){
$search = '<img id="(.*?)" />';
$replace = 'div class="cimg"><img src="thumb.php?w=200&q=60&id=\1" '.getImgAttributes("\\1").' /></div';
$text = preg_replace ($search, $replace, $text);
echo $text;
}
$text='<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec fermentum aliquam dolor.</p>
<img id="433" />
<p>Pellentesque convallis, felis vel imperdiet tincidunt, urna augue porttitor leo, eu luctus elit ante non mi.</p>';
writeImgTag($text);
?>
returns id but not DB result....
<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec fermentum aliquam dolor.</p>
<div class="cimg"><img src="thumb.php?w=200&q=60&id=433" id="433" width="" height="" alt="" /></div>
<p>Pellentesque convallis, felis vel imperdiet tincidunt, urna augue porttitor leo, eu luctus elit ante non mi.</p>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php