[PHP-DB] preg_replace and database

[Özgür Odabasi]

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=cimgimg src=thumb.php?w=200q=60id=\1
'.getImgAttributes(\\1).' //div';
$text = preg_replace ($search, $replace, $text);
echo $text;
}
$text='pLorem ipsum dolor sit amet, consectetuer adipiscing elit.
Donec fermentum aliquam dolor./p
img id=433 /
pPellentesque convallis, felis vel imperdiet tincidunt, urna augue
porttitor leo, eu luctus elit ante non mi./p';
writeImgTag($text);
?
returns id but not DB result
pLorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec
fermentum aliquam dolor./p
div class=cimgimg src=thumb.php?w=200q=60id=433 id=433
width= height= alt= //div
pPellentesque 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

[PHP-DB] preg_replace and database

[Özgür Odabasi]

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=cimgimg src=thumb.php?w=200q=60id=\1 
'.getImgAttributes(\\1).' //div';
	$text = preg_replace ($search, $replace, $text);
	echo $text;
}

$text='pLorem ipsum dolor sit amet, consectetuer adipiscing elit. 
Donec fermentum aliquam dolor./p
img id=433 /
pPellentesque convallis, felis vel imperdiet tincidunt, urna augue 
porttitor leo, eu luctus elit ante non mi./p';

writeImgTag($text);
?
returns id but not DB result
pLorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec 
fermentum aliquam dolor./p

div class=cimgimg src=thumb.php?w=200q=60id=433 id=433 
width= height= alt= //div

pPellentesque 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