XPX - View sql.xpx

View sql.xpx
<html>
<head>
<title>TEST SQL $phcversion$</title>
<meta HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
<meta HTTP-EQUIV="Expires" CONTENT="0">
</head>
<body>
<a href="ViewFile.xpx?fileName=$phccurrentfile$">Voir le source</a>
<include file="/inc/connect.inc.xpx">

<sql query="SELECT now()">
	$1$
</sql>
<table border="1">
	<sql query="SELECT titre,url from Sites">
		<cond expr="$sqlnumrow$=1">
			<tr>
				<td></td>
				<td colspan="$sqlcolcount$">Résultat</td>
			</tr>
			<tr>
				<td>No</td>
				<th>$#1$</th>
				<th>$#2$</th>
			</tr>
		</cond>
		<tr>
			<td>$sqlnumrow$</td>
			<td>$1$</td>	<!-- ou $titre$ -->
			<td>$2$</td>	<!-- ou $url$ -->
		</tr>
	</sql>
</table>
$sqlrowcount$ $sqlstring$
</body>
</html>
20240426