<?php
$dbc = dbc::instance();
$result = $dbc->prepare("SELECT * FROM wmm_members");
$rows = $dbc->executeGetRows($result);
if (count($rows)>0)
{
$all_members = "";
$row=$rows[0];
foreach ($row AS $key => $value) $all_members.= "\"".$key."\",";// output column names
$all_members=substr($all_members,0, (strlen($all_members)-1) );//strip last comma
$all_members.= "\r\n";
foreach ($rows as $row)
{
foreach ($row as $value) $all_members.= "\"".$value."\",";
$all_members=substr($all_members,0, (strlen($all_members)-1) );//strip last comma
$all_members.= "\r\n";
}
}
echo "<form name=\"members\">";
echo "<br><center><b>Outputing member details </b><br>";
echo "<textarea rows=\"8\" name=\"E1\" cols=\"140\">";
echo $all_members."</textarea></form></center>";
include("extract_members.html");
$rows=null;
$row=null;
?>