- I have problems displaying data in php form from sql database.
my code is this;
<?php
$dsn="GeoManagerv31";
$User="Kanyi";
$Password="trainer";
$SqlConnect=odbc_connect($dsn,$User,$Password);
if (isset($POST['vselect']))
{
if ($POST['Vselect']=="Plot Number")
{
$From=$_POST['txtsearch'];
$SqlCommand="select dbo.LMS_Plot.PlotNo,dbo.LMS_Plot.DistCode,dbo.LMS_Plot.SectCode,dbo.LMS_Plot.CellCode,dbo.LMS_Plot.ActArea from dbo.LMS_Plot where (dbo.LMS_Plot.PlotNo='$From')";
$Process=odbc_exec($SqlConnect,$SqlCommand);
if (!odbc_fetch_row($Process))
{
echo "Could not find Information for Plot No $From";
}
else
{
// information is there, display it in a table
$process=odbc_exec($sqlconnect,$sqlCommand);
echo '<Table border=1 align=left>';
echo '<tr bgcolor=#999999>';
//echo '<td><b> Customer No </b></td>';
echo '<td><b> Plot No </b></td>';
echo '<td><b> DistCode </b></td>';
echo '<td><b> SectCode </b></td>';
echo '<td><b> CellCode </b></td>';
echo '<td><b> ActArea </b></td>';
echo '<td><b> PlotUseCode </b></td>';
//echo '<td><b> Area </b></td>';
echo '</tr>';
while (odbc_fetch_row($process))
{
$Plotno=odbc_result($process,"PlotNo");
$DistCode=odbc_result($process,"DistCode");
$SectCode=odbc_result($process,"SectCode");
$CellCode=odbc_result($process,"CellCode");
$ActArea=odbc_result($process,"ActArea");
$PlotUse=odbc_result($process,"PlotUseCode");
echo '<td>$Plotno</td>';
echo '<td>$DistCode</td>';
echo '<td>$SectCode</td>';
echo '<td>$CellCode</td>';
echo '<td>$ActArea</td>';
echo '<td>$PlotUseCode</td>';
}
}
odbc_free_result($process);
odbc_close($sqlconnect);
}
}
?>
- i would also like to know how to call a crystal report in php, or how to create, call any other form of report in php.
Charles
