<?php
session_cache_limiter('private,must-revalidate');
session_start();
require_once("config.php");
include ("classes/db_functions.php");
include ("classes/display.php");
$dbf=new db_functions(SM_DB_HOST,SM_DB_USER,SM_DB_PASS,SM_DB_NAME);
?>
<link href="style/report.css" rel="stylesheet" type="text/css" />
<?php
if (@$_POST['Submit']=="Save Report")
{
$sql = "select * from customreport order by id desc";
$linkID=mysql_connect(SM_DB_HOST,SM_DB_USER,SM_DB_PASS);
mysql_select_db(SM_DB_NAME, $linkID);
$result = mysql_query($sql)or die(mysql_error());
$nume = mysql_num_rows($result);
$row=mysql_fetch_array($result);
if (!empty($nume))
$nume = $row['id'] + 1;
else
$nume=1;
$reportname = $_POST['reportname'];
$whereclause = addslashes($_POST['whereclause']);
$choose = addslashes($_POST['choose']);
$tablename = $_POST['tablename'];
if (isset($_SESSION['USERID']) and isset($_SESSION['groupid']))
{
$userid = $_SESSION['USERID'];
$groupid = $_SESSION['groupid'];
}
else
{
$userid = "NAN";
$groupid = "NAN";
}
$viewtype = $_POST['viewtype'];
$sql = "INSERT INTO customreport (id,userid,reportname,whereclause,choose,tablename,viewtype,groupid)".
" VALUES ('$nume','$userid','$reportname','$whereclause','$choose','$tablename','$viewtype','$groupid')";
//echo $sql;
$result= mysql_query($sql);
echo "<center>Report Saved !!</center>";
exit;
}
$geo = isset($_POST['geo']) ? $_POST['geo'] : "";
$country = isset($_POST['country']) ? $_POST['country'] : "";
$cat = isset($_POST['cat']) ? $_POST['cat'] : "";
$typeofreport = isset($_POST['typeofreport']) ? $_POST['typeofreport'] : "";
$select2= isset($_POST['select2']) ? $_POST['select2'] : "";
$CAM = isset($_POST['CAM']) ? $_POST['CAM'] : "";
$start = isset($_GET['start']) ? $_GET['start'] : "";
$where = isset($_GET['where']) ? $_GET['where'] : "";
if (!empty($select2))
{
for ( $i = 0 ; $i < count($select2) ; $i++ )
{
if ($i==0)
$choose = "`".$select2[$i]."`";
else
$choose = $choose . "," ."`".$select2[$i]."`";
}
$_SESSION['choose'] = $choose;
}
else
{
$choose = $_SESSION['choose'];
$select2 = explode(",",$_SESSION['choose']);
}
if (empty($where))
{
$whereclause = "";
if ($typeofreport=="tec")
if ($cat=="1")
{
$sCountry = "`venue_asn.Country`";
$sGEO = "`venue_asn.GEO`";
}
else
{
$sCountry = "`venue_pep.Country`";
$sGEO = "`venue_pep.GEO`";
}
elseif ($typeofreport=="ec")
{
$sCountry = "`company.Country`";
$sGEO = "`company.GEO`";
}
elseif ($typeofreport=="pc")
{
$sCountry = "`company.Country`";
$sGEO = "`company.GEO`";
$sCAM = "`company.CAM`";
}
elseif ($typeofreport=="pu")
{
$sCountry = "Country";
}
elseif ($typeofreport=="ac")
{
$sCountry = "Country";
$sGEO = "geo";
}
else
{
// echo "stop";
// exit;
}
if (!empty($geo))
$whereclause = " where $sGEO ='$geo'";
if (!empty($country))
if(!empty($whereclause))
$whereclause = $whereclause." and $sCountry='$country'";
else
$whereclause = " where $sCountry='$country'";
//if (!empty($date1) && !empty($date2))
// if(!empty($whereclause))
// $whereclause = $whereclause." and (StartDate >= '$date1' and StartDate <= '$date2')";
// else
// $whereclause = " where (StartDate >= '$date1' and StartDate <= '$date2')";
if (!empty($CAM) && !empty($CAM))
if(!empty($whereclause))
$whereclause = $whereclause." and $sCAM ='$CAM'";
else
$whereclause = " where $sCAM ='$CAM'";
}
else
{
$whereclause = stripslashes($_GET['where']);
}
if (empty($typeofreport))
$typeofreport = isset($_GET['typeofreport']) ? $_GET['typeofreport'] : "";
if (empty($cat))
$cat = isset($_GET['cat']) ? $_GET['cat'] : "";
if ($typeofreport=="tec")
if ($cat=="1")
$tablename = "vwtrainingandeventcats_asn";
else
$tablename = "vwtrainingandeventcats_pep";
elseif ($typeofreport=="ec")
$tablename = "vwelearningcat";
elseif ($typeofreport=="pc")
$tablename = "vwpartnerscat";
elseif ($typeofreport=="pu")
$tablename = "pep_user";
elseif ($typeofreport=="ac")
$tablename = "vwaccreditation";
$where = urlencode($whereclause);
$sql = "select ".$choose." from ".$tablename.$whereclause." Group by ".$choose;
//echo $sql;
$page_name="create_report.php"; // If you use this code with a different page ( or file ) name then change this
if(strlen($start) > 0 and !is_numeric($start)){
echo "Data Error";
exit;
}
$eu = ($start - 0);
$limit = 10; // No of records to be shown per page.
$this1 = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;
$linkID=mysql_connect(SM_DB_HOST,SM_DB_USER,SM_DB_PASS);
mysql_select_db(SM_DB_NAME, $linkID);
//$result2=mysql_query($sql)or die('Error, query failed');
$query = mysql_query($sql);
$nume = mysql_num_rows($query); --> line 202
echo $nume;
?>
<script language="javascript">
function checkData()
{
var a = document.savereport.reportname.value;
if (a=="")
{
alert("Please enter the report name !!");
return false;
}
}
</script>
<?php
echo "<form action=\"create_report.php\" name=\"savereport\" method=\"post\" onSubmit=\"return checkData();\">";
echo "Report Name : <input type=\"text\" name=\"reportname\">";
echo "<input type=\"hidden\" name=\"whereclause\" value=\"$whereclause\">";
echo "<input type=\"hidden\" name=\"choose\" value=\"$choose\">";
echo "<input type=\"hidden\" name=\"tablename\" value=\"$tablename\">";
echo "<input type=\"Submit\" name=\"Submit\" value=\"Save Report\"><br>";
echo "<input type=\"radio\" name=\"viewtype\" value=\"Public\" checked>Public";
echo "<input type=\"radio\" name=\"viewtype\" value=\"Private\">Private";
echo "</form>";
//paging start
$p_limit=100; // This should be more than $limit and set to a value for whick links to be breaked
@$p_f=$_GET['p_f']; // To take care global variable if OFF
if(!($p_f > 0)) { // This variable is set to zero for the first page
$p_f = 0;
}
$p_fwd=$p_f+$p_limit;
$p_back=$p_f-$p_limit;
//////////// End of variables for advance paging ///////////////
/////////////// Start the buttom links with Prev and next link with page numbers /////////////////
echo "<table align = 'center' width='70%'><tr><td align='left' width='20%'>";
if($p_f<>0){print "<a href='$page_name?start=$p_back&p_f=$p_back&cat=$cat&where=$where&typeofreport=$typeofreport'><font face='Verdana' size='2'>PREV $p_limit</font></a>"; }
echo "</td><td align='left' width='10%'>";
//// if our variable $back is equal to 0 or more then only we will display the link to move back ////////
if($back >=0 and ($back >=$p_f)) {
print "<a href='$page_name?start=$back&p_f=$p_f&cat=$cat&where=$where&typeofreport=$typeofreport'><font face='Verdana' size='2'>PREV</font></a>";
}
//////////////// Let us display the page links at center. We will not display the current page as a link ///////////
echo "</td><td align=center width='50%'>";
for($i=$p_f;$i < $nume and $i<($p_f+$p_limit);$i=$i+$limit){
$number = $i/10+1;
if($i <> $eu){
$i2=$i+$p_f;
echo " <a href='$page_name?start=$i&p_f=$p_f&cat=$cat&where=$where&typeofreport=$typeofreport'><font face='Verdana' size='2'>$number</font></a> ";
}
else { echo "<font face='Verdana' size='2' color=red>$number</font>";} /// Current page is not displayed as link and given font color red
}
echo "</td><td align='right' width='10%'>";
///////////// If we are not in the last page then Next link will be displayed. Here we check that /////
if($this1 < $nume and $this1 <($p_f+$p_limit)) {
print "<a href='$page_name?start=$next&p_f=$p_f&cat=$cat&where=$where&typeofreport=$typeofreport'><font face='Verdana' size='2'>NEXT</font></a>";}
echo "</td><td align='right' width='20%'>";
if($p_fwd < $nume){
print "<a href='$page_name?start=$p_fwd&p_f=$p_fwd&cat=$cat&where=$where&typeofreport=$typeofreport'><font face='Verdana' size='2'>NEXT $p_limit</font></a>";
}
echo "</td></tr></table>";
echo "</td></tr></table>";
echo "<form action='export_report.php' method='post' target='_blank'>";
echo "<INPUT type=\"hidden\" name=\"report_type\" value=\"customized_report\">";
echo "<INPUT type=\"submit\" value=\"Export To Excel\">";
echo "</form>";
//paging end
// echo $tablename.$whereclause.$choose;
// $groupby = " group by ".$choose;
$report = new display($dbf,"vwelearningreport","Company","Company","0");
$report->showreport2($dbf,$tablename,$select2,$whereclause." Group by ".$choose." limit $eu, $limit",$choose);
$out = "";
for($i = 0; $i < count($select2); $i++)
{
$out .= $select2[$i]."\t";
}
$out .= "\n";
$mymysql="SELECT ".$choose." FROM ".$tablename." ".$whereclause." Group by ".$choose;
$myresult=mysql_query($mymysql);
$fieldcount = mysql_num_fields($myresult); --> line 295
while($myrow=mysql_fetch_array($myresult)) --> line 297
{
for($k=0;$k<$fieldcount;$k++)
{
$out .= $myrow[$k]."\t";
}
$out .= ""."\n";
}
//echo $out;
$_SESSION["out_customized_report"] = $out;
?>can anyone help me out?
i got this error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/emcasia/public_html/pepadmin/create_report.php on line 202
at line 295 & 297
