What is this code doing?

getphp

What is going on here, Really struggling over here to understand the below:😕 😕

for ($i=0;$i<$cnt;$i++) {
		$num++;
		if ($num==1) print $TMPL["partsdelimtop"];
		$template=$TMPL["partsbit"];
		$template=str_replace("%CTITLE",mysql_result($r,$i,0),$template);
		$template=str_replace("%CID",mysql_result($r,$i,1),$template);
		$template=str_replace("%CCOUNT",mysql_result($r,$i,2),$template);
		print $template;

drew010

its looking at a template file, and replacing dummy values (the %CTITLE things) with actual values from a database and then showing the template.

for example, you have a file
<html>
<head>
<title>%TITLE</title>
</head>
<body>
Hello %NAME,
welcome to our site. you are on %PAGE
</body>
</html>

doing something like
$template = str_replace("%TITLE", "$pageTitle", $template);
$template = str_replace("%NAME", $SESSION['username'], $template);
$template = str_replace("%PAGE", $SERVER['PHP_SELF'], $template);
print $template;

would print out

<html>
<head>
<title>Some title from a variable</title>
</head>
<body>
Hello Person,
welcome to our site, you are on /index.php
</body>
</html>

hope that helps you a little bit.

getphp

thanks for that

What does bottom code do preciously? :

mysql_result($r,$i,0)

could $r and $i be values from a database? and what is the '0' their for?

Many thanks

drew010

mysql_result($r,$i,0)
returns row $i, field 0 from the mysql resource $r, which is a mysql query. basically its pulling values from a database and replacing the template values with them.