File:  [Local Repository] / db / prgsrc / new / Attic / common.php
Revision 1.1: download - view: text, annotated - select for diffs - revision graph
Tue Dec 6 15:41:16 2005 UTC (18 years, 6 months ago) by roma7
Branches: MAIN
CVS tags: HEAD
Initial

<?
$limit=200;
function print_question($row) {
	$row['tFileName']=str_replace('.txt','',$row['tFileName']);
	$row['t1FileName']=str_replace('.txt','',$row['t1FileName']);
	foreach ($row as $k=>$v) {
 		$row[$k]=preg_replace('/\(pic: ([^\)]*)\)/','<p><img src="/znatoki/images/db/$1"><p>',$v);
		$row[$k]=preg_replace('/^\|([^\n]*)/','<pre>$1</pre>',$row[$k]);
		$row[$k]=preg_replace('/^\s+/ms','<br>&nbsp;&nbsp;&nbsp;&nbsp;',$row[$k]);
	}
	include "question_template.php";
}

function print_questions_sql($sql,$search=false) {
	$res=mysql_query($sql) or print mysql_error().$sql;
	print_questions_res($res,$search);	
}

function print_questions_res($res,$search=false) {
	global $limit;
	$kvo=mysql_num_rows($res);
	if ($search) {
		if ($kvo==$limit) {
			print "More than $limit results";
		} else print "$kvo results";
		while ($row=mysql_fetch_assoc($res)) {
			print_question($row);
		}
	}
}

?>

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>