'Fatal Error: Cannot access empty property' problem with PHP 5?

xbox2box · March 12, 2009

Hello PHP Anon out there,

I wish to get some of my old PHP code back up on some new sites.

After getting all of my databases connected and getting everything else working perfectly.

I started going through the code and didn't have much of a problem until I ran into ONE issue

This was programed by me and a friend back in the PHPv4 days and my new server has PHP 5.

I have 2 pages that this problem might link to

The main problem is a file below called eflyerListing.php

<? session_start();
include_once ('includes/database.php');
include_once ("includes/dbFunc.php");
if (!isset($_SESSION['user']))
	{
header("Location: login.php"); /* Redirect browser */
exit;  
}
/////////////////////////////////////////////////////////////////////
include('includes/Paging.class.php');
	$arrMainParam['TOTAL_RECORDS']				=	'';
	$arrChildParam['FORM_NAME']	=	'frm';
	$arrMainParam['RECORDS_PER_PAGE']			=	10;
$arrMainParam['PAGELINKS_PER_PAGE']			=	10;

	$arrChildParam['SHOW_TOTAL_RECORDS_FOUND']	=	'0';
	$arrChildParam['PAGINATION_STYLE']			=	'3';
	$arrChildParam['SPT_URL_PARAM']				=	'1';

//////////////////////////////////////////////////////////////////////////

The Fatal error i get when going to this page is Fatal error: Cannot access empty property in /home/content/s/h/o/shouthouse/html/DMTMAIL.COM/includes/Paging.class.php on line 19

The Include for Paging.class.php is below

<?php

class Paging
{
#== Configurable Variables
var $TOTAL_RECORDS;
var $RECORDS_PER_PAGE;
var $PAGELINKS_PER_PAGE;
var $SPT_SQL_WITH_LIMIT;
var $SPT_URL_PARAM = 0;

#== Non-Configurable Variables
var $strErrorMsg;
var $intCurrentPage;
var $strJSCode;

Function Paging($arrParentParam)
{
	$this->$SPT_URL_PARAM = 0;  //<-- THIS IS LINE 19 THAT IS A HOOKER.
	if(!is_array($arrParentParam)) $arrParentParam=array();

Ive dug all over the world wide internetz and have tried getting rid of the dollar sign to make line 19 like below

$this->SPT_URL_PARAM = 0;

w/o the $ symbol

The eflyersListing.php pages purpose is to layout a table of mysql data that it pulls with all of the users save HTML flyers.

after trying to see if it was a PHP 5 problem with the $ symbol place before the var it gave me this error below

Invalid query: Unknown column 'Array' in 'where clause'

Please help me and I will forever be in your debt.

Ill give you good music or something like that in exchange for the help lol

-Copelander

-DMTHouse.com

rhodesa · March 12, 2009

Line 19 should not have that dollar sign as you described. it should look like:

$this->SPT_URL_PARAM = 0;

as for the problem with the where clause...what is the code for that?

xbox2box · March 13, 2009

Well I have gotten rid of the $ sign.. I did an echo on the arrParentParam on line 19 to see if I could get any more idea of how this works.

it posted

Array

Fatal error: Cannot access empty property in /includes/Paging.class.php on line 20

What I cant figure out is if this error is still leading to the $SPT_URL_PARAM var which also appears in an array on the eflyerListing.php

$arrChildParam['SPT_URL_PARAM'] = '1';

Here is my full code below to shead more light on this. plz no sql inject mezz

eflyerListing.php

<? session_start();
include_once ('includes/database.php');
include_once ("includes/dbFunc.php");
if (!isset($_SESSION['user']))
	{
header("Location: login.php"); /* Redirect browser */
exit;  
}
/////////////////////////////////////////////////////////////////////
include('includes/Paging.class.php');
	$arrMainParam['TOTAL_RECORDS']				=	'';
	$arrChildParam['FORM_NAME']	=	'frm';
	$arrMainParam['RECORDS_PER_PAGE']			=	10;
$arrMainParam['PAGELINKS_PER_PAGE']			=	10;

	$arrChildParam['SHOW_TOTAL_RECORDS_FOUND']	=	'0';
	$arrChildParam['PAGINATION_STYLE']			=	'3';
	$arrChildParam['SPT_URL_PARAM']				=	'1';

//////////////////////////////////////////////////////////////////////////	

if($_POST['btnAction']=="delete"  && isset($_POST['selection'])){
	// delete the eflyer account
	$selection = $_POST['selection'];
	$selection_arr=count($selection);
	for($i=0;$i<$selection_arr;$i++){
	$sql_del_eflyer = "delete from tbleflyer  WHERE Eflyer_id ='".$selection[$i]."'";
	$enRes = mysql_query($sql_del_eflyer)or die("Invalid query: " . mysql_error());
	$sql_insert_History="insert into tblhistoryeflyer (History_user_id ,History_eflyer_id) values('".$_SESSION['userID']."','".$selection[$i]."')";
	$res_insert_History= mysql_query($sql_insert_History)or die("Invalid query: " . mysql_error());
	}


$message="E-Flyer deleted succesfully";
	}	


$sql_slct_eflyer="select * from  tbleflyer where Eflyer_user_id='".$_SESSION['userID']."'";
$res_slct_eflyer= mysql_query($sql_slct_eflyer)or die("Invalid query: " . mysql_error());
//die($sql_slct_eflyer);
$num_slct_eflyer = mysql_num_rows($res_slct_eflyer);
$num_rows=mysql_num_rows($res_slct_eflyer);
$arrMainParam['TOTAL_RECORDS'] = $num_rows;
$objPaging = new Paging($arrMainParam);

$sql_slct_eflyer.= $objPaging->SPT_SQL_WITH_LIMIT;
$res_slct_eflyer1=mysql_query($sql_slct_eflyer);

if($num_slct_eflyer>0){
$i=1;
$table_string="<table><tr><td><input type='checkbox' name='tickall' id='tickall' onclick='javascript:checkall();'></td><td>Eflye Name</td><td>Eflyer Area</td><td>Eflyer Created</td><td>Eflyer Send Date</td><td>Eflyer Credit</td><td>Eflyer Status</td></tr>";
	while($rw_slct=mysql_fetch_array($res_slct_eflyer1, MYSQL_BOTH)){

			if($i%2!=0){
				$trcolor = "#EFEFEF";
			}else{
				$trcolor = "#FFFFFF";
			}
				$i++;
		$table_string.="<tr bgcolor=".$trcolor."><td><input type='checkbox' name='selection[]' id='selection[]' value='".$rw_slct['Eflyer_Id']."'></td>";
		$table_string.="<td ><a href='eflyerProof.php?id=".$rw_slct['Eflyer_Id']."'>".$rw_slct['Eflyer_Name']."</a></td>";
		if($rw_slct['Area_Send']=="")
		$area_num=0;
		else
		$area_num=$rw_slct['Area_Send'];

		$area_send_arr=explode(",",$rw_slct['Area_Send']);
		$sql_state="select area_def from tblareadef where area_id  in(".$area_num.") ";

		$res_state= mysql_query($sql_state)or die("Invalid query: " . mysql_error());
		//die($sql_state);
		$area_send="";
		while($rw_state=mysql_fetch_array($res_state, MYSQL_BOTH))
		{
			$area_send.=$rw_state['area_def'].",";
		}
		$area_send=substr($area_send,0,-1);
		$table_string.="<td title='".$area_send."'>".substr($area_send,0,80)."</td>";
		$table_string.="<td>".$rw_slct['Eflyer_datetime']."</td>";
		$table_string.="<td>".$rw_slct['Date_Send']."</td>";
		$table_string.="<td>".$rw_slct['Eflyer_credit']."</td>";

		if($rw_slct['Eflyer_status']==1){
			$table_string.="<td>Paid Send</td></tr>";
		}else if($rw_slct['Eflyer_status']==0){
			$table_string.="<td>Pending</td></tr>";
		}else if($rw_slct['Eflyer_status']==3){
			$table_string.="<td>Viewed</td></tr>";
		}else if($rw_slct['Eflyer_status']==2){
			$table_string.="<td>Paid Un Send</td></tr>";
		}


	}

$table_string.="<tr>
                      <td bgcolor='C9C37F' valign='top' align='center' colspan='7'>
				  <font color='green'>To Edit / Re-Send a E-Flyer previously created, please click on name of E-Flyer
				  </td>
                      </tr></table>";
}else{
$message="No Eflyer Created Yet";
}
// conetent start   	
$data=file_get_contents("template/heade_left_footer.html");
$data=eregi_replace("%%title%%","E-Flyer",$data);

$btnaction='<select name="btnAction">
                            <option value="delete">Delete</option>
                          </select> <input type="submit" name="Go" value="Go">';
					  
$data3=file_get_contents("template/eflyerListing.html"); 
$data3=eregi_replace("%%eflyerList%%","eflyerListing.php",$data3);
$data3=eregi_replace("%%tableString%%",$table_string,$data3);
$data3=eregi_replace("%%btnAction%%",$btnaction,$data3);
$data3=eregi_replace("%%paging%%",$objPaging->fnCreateSPT($arrChildParam),$data3);

$data=eregi_replace("%%inner_table%%",$data3,$data);
if (isset($message))
{
$data=eregi_replace("<!--MESSAGE","<!--MESSAGE-->",$data);
$data=eregi_replace("MESSAGE-->","<!--MESSAGE-->",$data);
$data=eregi_replace("%%message%%",$message,$data);
}
print $data;
exit();
?>

Paging.class.php

<?php

class Paging
{
#== Configurable Variables
var $TOTAL_RECORDS;
var $RECORDS_PER_PAGE;
var $PAGELINKS_PER_PAGE;
var $SPT_SQL_WITH_LIMIT;
var $SPT_URL_PARAM;

#== Non-Configurable Variables
var $strErrorMsg;
var $intCurrentPage;
var $strJSCode;

Function Paging($arrParentParam)
{
	echo $arrParentParam;
	$this->$SPT_URL_PARAM = 0;
	if(!is_array($arrParentParam)) $arrParentParam=array();
	#Init the Error Msg
	$this->strErrorMsg ='<table width="100%" border="0" ';
	$this->strErrorMsg.='style="font-family:Verdana;font-size:11px;color:#FF0000;"><tr>';
	$this->strErrorMsg.='<td width="100%" align="center">';
	$this->strErrorMsg.='Unable to create Smart Paging Technique© [{ERROR}]</td></tr></table>';

	#Init the Total Records
	$TotRec=trim($arrParentParam['TOTAL_RECORDS']);
	if(trim($TotRec)=='') die(str_replace('{ERROR}','Total Records are NULL',$this->strErrorMsg)); 
	else $this->TOTAL_RECORDS=(int)$TotRec;

	#Init Records Per Page
	$RecPerPage=trim($arrParentParam['RECORDS_PER_PAGE']);
	if($RecPerPage!='') $this->RECORDS_PER_PAGE=$RecPerPage;
	else $this->RECORDS_PER_PAGE=10; #Default Value

	#Init Page Links Per Page
	$LinksPerPage=trim($arrParentParam['PAGELINKS_PER_PAGE']);
	if($LinksPerPage1!='') $this->PAGELINKS_PER_PAGE=$LinksPerPage1;
	else $this->PAGELINKS_PER_PAGE=5; #Default Value

	#Init the Current Pagination Page
	$FormValues=array_merge($_POST,$_GET);
	if(trim($FormValues['SPTPage'])=='' OR !isset($FormValues['SPTPage'])) $this->intCurrentPage=1;
	else $this->intCurrentPage=(int) trim($FormValues['SPTPage']);

	#Init the LIMIT Query for the User
	if(($this->intCurrentPage)==1) $LowerLimit=0;
	else $LowerLimit = (($this->intCurrentPage - 1) * $this->RECORDS_PER_PAGE);
	$UpperLimit = $this->RECORDS_PER_PAGE;
	$this->SPT_SQL_WITH_LIMIT = " LIMIT $LowerLimit, $UpperLimit ";

	$this->strJSCode ='<script type="text/javascript">'."\n";
	$this->strJSCode.='<!--'."\n";
	$this->strJSCode.='if(!document.<FUNCTION_NAME>) { ';
	$this->strJSCode.='function <FUNCTION_NAME>() { ';
	$this->strJSCode.=' try { var hndFRM=document.getElementById("<FRM_NAME>"); } catch(e) ';
	$this->strJSCode.='{ alert("Smart Paging Technique [Error: Document.Form is NULL or not an Object]"); '; 
	$this->strJSCode.='return; } ';
	$this->strJSCode.='var URL_Add="<ADD_VALUES>"; var ToPage="?SPTPage="; ';
	$this->strJSCode.='if(<FUNCTION_NAME>.arguments[0]) ToPage+=<FUNCTION_NAME>.arguments[0]; ';
	$this->strJSCode.='hndFRM.action=" "+ToPage+URL_Add; hndFRM.method="POST"; hndFRM.submit(); } ';
	$this->strJSCode.='} '."\n";
	$this->strJSCode.='//--> '."\n";
	$this->strJSCode.='</script>';
}

Function fnCreateSPT($arrChildParam)
{


	if(!is_array($arrChildParam)) $arrChildParam=array();
	$stmtPlaceSPT = '';



	#Init the Form Name
	$tmpFormName=trim($arrChildParam['FORM_NAME']);
	# Code commented below have to be placed in Beta Versions only
	#if($tmpFormName!='')
	#{
	#	$sptFormName=$tmpFormName;
	#	$flagFrmAvailable='Y';
	#} else
	#{
	#	$sptFormName=strtoupper(uniqid('frmSPT'));
	#	$flagFrmAvailable='N';
	#}
	if($tmpFormName!='')
	{
		$sptFormName=$tmpFormName;
		$flagFrmAvailable='Y';
	}else die(str_replace('{ERROR}','Document.Form is NULL or not an object',$this->strErrorMsg));

	$arrDoSPT['FORM_NAME']=$sptFormName;
	$arrDoSPT['FLAG_FORM_AVAILABLE']=$flagFrmAvailable;

	#Init the Flag to Show the Total Records Found
	$tmpFlag_TotRec=trim($arrChildParam['SHOW_TOTAL_RECORDS_FOUND']);
	if($tmpFlag_TotRec!=='') $sptFlag_TotRec=$tmpFlag_TotRec;
	else $sptFlag_TotRec=0;
	if((bool)$sptFlag_TotRec) $arrDoSPT['FLAG_SHOWTOTALREC']='Y';
	else $arrDoSPT['FLAG_SHOWTOTALREC']='N';

	#Init the Move First Link/Image
	$tmpMoveFirst=trim($arrChildParam['IMAGE_MOVE_FIRST']);
	if($tmpMoveFirst=='') $sptMoveFirst='<<First';
	else $sptMoveFirst=$tmpMoveFirst;


	#Init the Move Prev Link/Image
	$tmpMovePrev=trim($arrChildParam['IMAGE_MOVE_PREV']);
	if($tmpMovePrev=='') $sptMovePrev='<Prev';
	else $sptMovePrev=$tmpMovePrev;


	#Init the Move Next Link/Image
	$tmpMoveNext=trim($arrChildParam['IMAGE_MOVE_NEXT']);
	if($tmpMoveNext=='') $sptMoveNext='Next>';
	else $sptMoveNext=$tmpMoveNext;


	#Init the Move Last Link/Image
	$tmpMoveLast = trim($arrChildParam['IMAGE_MOVE_LAST']);
	if($tmpMoveLast=='') $sptMoveLast = 'Last>>';
	else $sptMoveLast = $tmpMoveLast;

	#Init the Additional Values to be passed with the URL (on Submittion)
	$tmpAdditional = trim($arrChildParam['ADDITIONAL_VALUES']);
	if($tmpAdditional=='') $arrDoSPT['ADD_VAL']='';
	else $arrDoSPT['ADD_VAL']=str_replace('?','',$tmpAdditional);


# Added by kalim
	if($sptFlag_TotRec=='1') $ShowTotal=true;
	else $ShowTotal=false;
	if($flagFrmAvailable=='Y') $frmAvailable=true;
	else $frmAvailable=false;
	$URL_APPEND=stripslashes(trim($arrArguments['ADD_VAL']));
	if(substr($URL_APPEND,0,1)!='&') $URL_APPEND='&'.$URL_APPEND;
	$URL_APPEND=addslashes($URL_APPEND);
	$URL_APPEND=str_replace("\\'", "'", $URL_APPEND); #Eliminating the JS Error Possibility

//          echo "here".$arrParentParam["SPT_URL_PARAM"];


	if ( $arrChildParam["SPT_URL_PARAM"] )
	{
		$base_url = substr($_SERVER['QUERY_STRING'], 0, strpos($_SERVER['QUERY_STRING'],"&SPTPage")===false?strlen($_SERVER['QUERY_STRING']):strpos($_SERVER['QUERY_STRING'],"&SPTPage")); 
		$URL_APPEND .= ereg_replace("SPTPage=[0-9]+&","",$base_url);
	}

	#Prepare the JS Code
	$stmtJS = $this->strJSCode;
	$jsFuncName = 'fn'.strtoupper(uniqid('SPT')); #This is the JS Function Name
	$stmtJS = str_replace('<FRM_NAME>', $sptFormName, $stmtJS); #Replacing values
	$stmtJS = str_replace('<FUNCTION_NAME>', $jsFuncName, $stmtJS);
	$stmtJS = str_replace('<ADD_VALUES>', $URL_APPEND, $stmtJS);
	$stmtSPTCode.=$stmtJS; #Appending the JS Code

          $arrDoSPT['JS_FUNC_NAME'] = $jsFuncName;

	$SPT_TotalPages = ceil($this->TOTAL_RECORDS/$this->RECORDS_PER_PAGE); #Calculate Total Pages
	if($this->TOTAL_RECORDS!=0 AND $SPT_TotalPages > 1)
	{
		if(!$frmAvailable) $stmtSPT.='<FORM id="'.$sptFormName.'" ACTION="" METHOD="POST">'."\n";

		$stmtSPT.="<table width='100%' cellpadding='0' cellspacing='0' border='0'><tr>";
		$stmtSPT.="\n<td><table width='100%' cellpadding='0' cellspacing='0'>";
		$stmtSPT.="<tr>";

		if($ShowTotal) 
		{
			$stmtSPT.="<td align='left' style='font-family:Verdana;font-size:11px;color:#000000;'><b> Total ".$this->TOTAL_RECORDS." record(s) found</b></td>";
		}
		else 
		{
			$stmtSPT.='';
		}

		$stmtSPT.="<td align='right'>";
		#== [Create FIRST Page Link]
		if($this->intCurrentPage==1)
		{
			$stmtSPT.=$sptMoveFirst;
		}
		else 
		{
			$stmtSPT.='<a href="#" onclick="javascript:{'.$jsFuncName.'(1);}" title="Move to First Page">'.$sptMoveFirst.'</a>';
		}
		$stmtSPT.=' ';

		#== [Create PREVIOUS Page Link]
		if($this->intCurrentPage==1) $stmtSPT.=$sptMovePrev;
		else $stmtSPT.='<a href="#" onclick="javascript:{'.$jsFuncName.'('.($this->intCurrentPage-1).');}" title="Move to Previous Page">'.$sptMovePrev.'</a>';
		$stmtSPT.=' ';

		$stmtSPT.='  ';

               #Choose the SPT Style
               $intSPTStyle=trim($arrChildParam['PAGINATION_STYLE']);
               switch($intSPTStyle)
               {
                    case '1':
                         $stmtSPT .= $this->fnSPT_Style1($arrDoSPT);
                         break;
                    case '2':
                         $stmtSPT .= $this->fnSPT_Style2($arrDoSPT);
                         break;
                    case '3':
                         $stmtSPT .= $this->fnSPT_Style3($arrDoSPT);
                         break;
                    default:
                         $stmtSPT .= $this->fnSPT_Style1($arrDoSPT);
                          break;
               }

		#== [Create NEXT Page Link]
		if($this->intCurrentPage==$SPT_TotalPages) $stmtSPT.=$sptMoveNext;
		else $stmtSPT.='<a href="#" onclick="javascript:{'.$jsFuncName.'('.($this->intCurrentPage+1).');}" title="Move to Next Page">'.$sptMoveNext.'</a>';
		$stmtSPT.=' ';

		#== [Create LAST Page Link]
		if($this->intCurrentPage==$SPT_TotalPages) $stmtSPT.=$sptMoveLast;
		else $stmtSPT.='<a href="#" onclick="javascript:{'.$jsFuncName.'('.$SPT_TotalPages.');}" title="Move to Last Page">'.$sptMoveLast.'</a>';

		for($i=0;$i<=3;$i++) $stmtSPT.=' ';
		$stmtSPT.="</td></tr>\n</table></td></tr></table>";
		if(!$frmAvailable) $stmtSPT.='</FORM>';
		$stmtSPTCode.=$stmtSPT;
	} else $stmtSPTCode='';
# End 
	return $stmtSPTCode;
}

Function fnSPT_Style1($arrArguments)
{
	$stmtSPTCode='';
	#Config and Fix the Arguments
          $jsFuncName = $arrArguments['JS_FUNC_NAME'];
	$SPT_TotalPages = ceil($this->TOTAL_RECORDS/$this->RECORDS_PER_PAGE); #Calculate Total Pages
	if($this->TOTAL_RECORDS!=0 AND $SPT_TotalPages > 1)
	{
		#== [Create ALL PAGE Dropdown]
		$stmtSPT.="<select name='SPT_CurrentPage' onChange=\"javascript:$jsFuncName(this.value);\">";
		for($i=1;$i<=$SPT_TotalPages;$i++)
		{
		 $stmtSPT.="<option value='$i' ";
		 if($this->intCurrentPage==$i) $stmtSPT.='selected';
		 $stmtSPT.=">$i</option>";
		}
		$stmtSPT.="</select>";
		$stmtSPT.=' ';
	} else $stmtSPT='';
	return $stmtSPT;
}#END FUNCTION fnSPT_Style1()



Function fnSPT_Style2($arrArguments)
{
	$stmtSPTCode='';
          return $stmtSPTCode;
}#END FUNCTION fnSPT_Style2()



Function fnSPT_Style3($arrArguments)
{
	$stmtSPTCode='';
	#Config and Fix the Arguments
          $jsFuncName = $arrArguments['JS_FUNC_NAME'];

	$SPT_TotalPages = ceil($this->TOTAL_RECORDS/$this->RECORDS_PER_PAGE); #Calculate Total Pages
	if($this->TOTAL_RECORDS!=0 AND $SPT_TotalPages > 1)
	{

		#== Create PAGE Links
		if(($this->intCurrentPage-floor($this->PAGELINKS_PER_PAGE/2))<1) $LowerLimit=1;
		else $LowerLimit=($this->intCurrentPage-floor($this->PAGELINKS_PER_PAGE/2));
		if($SPT_TotalPages>=$this->PAGELINKS_PER_PAGE)
		{
			if(($LowerLimit+($this->PAGELINKS_PER_PAGE-1))>$SPT_TotalPages)
			{
				$LowerLimit-=(($LowerLimit+($this->PAGELINKS_PER_PAGE-1))-$SPT_TotalPages);
				$UpperLimit=$SPT_TotalPages;
			}else $UpperLimit=($LowerLimit+($this->PAGELINKS_PER_PAGE-1));
		}else $UpperLimit=$SPT_TotalPages;

		for($i=$LowerLimit;$i<=$UpperLimit;$i++)
		{
			if($this->intCurrentPage==$i) $stmtSPT.=$i;
			else $stmtSPT.='<a href="#" onclick="javascript:{'.$jsFuncName.'('.$i.');}">'.$i.'</a>';
			$stmtSPT.='  ';
		}
	} else $stmtSPT='';

	return $stmtSPT;

}#END FUNCTION fnSPT_Style3()

}#END CLASS

?>

Any help is greatly appreciated as I have been stumped on this for 3 days....

rhodesa · March 13, 2009

i see two problems...first, in eflyerListing.php:

if($_POST['btnAction']=="delete"  && isset($_POST['selection'])){
      // delete the eflyer account
      $selection = $_POST['selection'];
      $selection_arr=count($selection);
      for($i=0;$i<$selection_arr;$i++){
      $sql_del_eflyer = "delete from tbleflyer  WHERE Eflyer_id ='".$selection_arr[$i]."'"; //Needs to be $selection_arr
      $enRes = mysql_query($sql_del_eflyer)or die("Invalid query: " . mysql_error());
      $sql_insert_History="insert into tblhistoryeflyer (History_user_id ,History_eflyer_id) values('".$_SESSION['userID']."','".$selection_arr[$i]."')"; //Needs to be $selection_arr
      $res_insert_History= mysql_query($sql_insert_History)or die("Invalid query: " . mysql_error());
      }

and then the same thing we talked about before in Paging.class.php

   function Paging($arrParentParam)
   {
      print_r($arrParentParam); //If it's an array, you need to use print_r()
      $this->SPT_URL_PARAM = 0; //No dollar sign
      if(!is_array($arrParentParam)) $arrParentParam=array();
      #Init the Error Msg
      $this->strErrorMsg ='<table width="100%" border="0" ';
      $this->strErrorMsg.='style="font-family:Verdana;font-size:11px;color:#FF0000;"><tr>';
      $this->strErrorMsg.='<td width="100%" align="center">';
      $this->strErrorMsg.='Unable to create Smart Paging Technique© [{ERROR}]</td></tr></table>';

more about

$this->SPT_URL_PARAM = 0;

...if there is a dollar sign in front of SPT, it first looks up the value of $SPT_URL_PARAM in the scope of that method, which is empty (cus there is no variable). Then it throws the error, cus you can't have an empty member.

xbox2box · March 13, 2009

Dude, Macgyver

I think with your help that I am getting closer! Thanks for your help but it looks like it is still having that array problem but it is printing the array which states

Array ( [TOTAL_RECORDS] => 3 [RECORDS_PER_PAGE] => 10 [PAGELINKS_PER_PAGE] => 10 ) Invalid query: Unknown column 'Array' in 'where clause'

Still pondering if this problem lies in $this->SPT_URL_PARAM = 0; //No dollar sign

If you can think of anything else, I would appreciate it!

xbox2box · March 13, 2009

I am trying to locate where this problem lies but dosnt seem to be in any of this area of the code.

<?php

class Paging
{
#== Configurable Variables
var $TOTAL_RECORDS;
var $RECORDS_PER_PAGE;
var $PAGELINKS_PER_PAGE;
var $SPT_SQL_WITH_LIMIT;
var $SPT_URL_PARAM;

#== Non-Configurable Variables
var $strErrorMsg;
var $intCurrentPage;
var $strJSCode;

function Paging($arrParentParam)
{
      print_r($arrParentParam); //If it's an array, you need to use print_r()
      $arrParentParam['SPT_URL_PARAM'] = '0'; //No dollar sign
  print_r($arrParentParam);
      if(!is_array($arrParentParam)) $arrParentParam=array();

I dont think be me adding the SPT_URL_PARAM to the Parent Param really did anything but it is chaging the array var now

Array ( [TOTAL_RECORDS] => 3 [RECORDS_PER_PAGE] => 10 [PAGELINKS_PER_PAGE] => 10 [sPT_URL_PARAM] => 1 ) Array ( [TOTAL_RECORDS] => 3 [RECORDS_PER_PAGE] => 10 [PAGELINKS_PER_PAGE] => 10 [sPT_URL_PARAM] => 0 ) Invalid query: Unknown column 'Array' in 'where clause'

I think there is a function in Paging.class that is f'ed up and cant access some unknown column

rhodesa · March 14, 2009

no, the problem shouldn't be with Paging or $arrParentParam...the error is coming from here right:

if($_POST['btnAction']=="delete"  && isset($_POST['selection'])){
      // delete the eflyer account
      $selection = $_POST['selection'];
      $selection_arr=count($selection);
      for($i=0;$i<$selection_arr;$i++){
      $sql_del_eflyer = "delete from tbleflyer  WHERE Eflyer_id ='".$selection_arr[$i]."'"; //Needs to be $selection_arr
      $enRes = mysql_query($sql_del_eflyer)or die("Invalid query: " . mysql_error());
      $sql_insert_History="insert into tblhistoryeflyer (History_user_id ,History_eflyer_id) values('".$_SESSION['userID']."','".$selection_arr[$i]."')"; //Needs to be $selection_arr
      $res_insert_History= mysql_query($sql_insert_History)or die("Invalid query: " . mysql_error());
      }

did you update that file like i said to earlier? change it to this and see what it does:

if($_POST['btnAction']=="delete"  && isset($_POST['selection'])){
      // delete the eflyer account
      $selection = $_POST['selection'];
      $selection_arr=count($selection);
      for($i=0;$i<$selection_arr;$i++){
        $sql_del_eflyer = "delete from tbleflyer  WHERE Eflyer_id ='".$selection_arr[$i]."'"; //Needs to be $selection_arr
        $enRes = mysql_query($sql_del_eflyer)or die("Invalid query: " . mysql_error());
        $sql_insert_History="insert into tblhistoryeflyer (History_user_id ,History_eflyer_id) values('".$_SESSION['userID']."','".$selection_arr[$i]."')"; //Needs to be $selection_arr
        $res_insert_History= mysql_query($sql_insert_History)or die("Invalid query '$sql_insert_History': " . mysql_error());
      }

xbox2box · March 14, 2009

You are so very right about it coming from there and i think i tracked it down to the line but still am stumped ???

Array ( [TOTAL_RECORDS] => 4 [RECORDS_PER_PAGE] => 10 [PAGELINKS_PER_PAGE] => 10 ) Array ( [TOTAL_RECORDS] => 4 [RECORDS_PER_PAGE] => 10 [PAGELINKS_PER_PAGE] => 10 ) Invalid query: Unknown column 'Array' in 'where clause'

I think the error lies somewhere in the code below...

this code

 $sql_del_eflyer = "delete from tbleflyer  WHERE Eflyer_id ='".$selection_arr[$i]."'"; //Needs to be $selection_arr

or this line...

 $sql_insert_History="insert into tblhistoryeflyer (History_user_id ,History_eflyer_id) values('".$_SESSION['userID']."','".$selection_arr[$i]."')";

I am pretty sure there is something screwed up here but looking in phpadmin... all the table names and stuff are correct to the best of my knowledge by comparison.

You are the most awesome Anon i know and truly thank you for the help you have givin so far....

Im so broke and just want to get this going so i can make money again....

I have changed the userID in SESSION to user in the line below as a test

$sql_slct_eflyer="select * from  tbleflyer where Eflyer_user_id='".$_SESSION['userID']."'";

and the page loaded! BUT with out the eflyers listed from the mysql of course...

Thx again and I will give you logins for my online database of music, movies and software once i can sleep at night form this catastrophe of a disaster...

rhodesa · March 14, 2009

i would go through and everywhere it says "Invalid query: " change it to something unique...even if it's Invalid query 1, Invalid query 2, etc. That way you know exactly what query it is.

xbox2box · March 18, 2009

I got it working! I did what you said and traced it down. stupid $ was fing things up....

Now everything works EXECPT the darn payment side of it... I am using a paypal API to send payment, check this out...

The payment goes through and I see the money land in the paypal account but my programmer used a file called xml2array.php to return the payment information so it can email the user and add a credit into the mysql database so they can use the credit to send their flyer out.

at first I didnt see any file called xml2array.php so I did some googlein and found a file just by that name... so I tossed it up and had these errors below.

Warning: Call-time pass-by-reference has been deprecated in /home/content/s/h/o/shouthouse/html/DMTMAIL.COM/includes/xml2array.php on line 64

Warning: Call-time pass-by-reference has been deprecated in /home/content/s/h/o/shouthouse/html/DMTMAIL.COM/includes/xml2array.php on line 64

Warning: Call-time pass-by-reference has been deprecated in /home/content/s/h/o/shouthouse/html/DMTMAIL.COM/includes/xml2array.php on line 65

Warning: Call-time pass-by-reference has been deprecated in /home/content/s/h/o/shouthouse/html/DMTMAIL.COM/includes/xml2array.php on line 66

Warning: Call-time pass-by-reference has been deprecated in /home/content/s/h/o/shouthouse/html/DMTMAIL.COM/includes/xml2array.php on line 68

Warning: Call-time pass-by-reference has been deprecated in /home/content/s/h/o/shouthouse/html/DMTMAIL.COM/includes/xml2array.php on line 73

Warning: Call-time pass-by-reference has been deprecated in /home/content/s/h/o/shouthouse/html/DMTMAIL.COM/includes/xml2array.php on line 73

now after I look at these lines , I noticed that there where aperand "&" symbols in the xml2array file and did more googleing and seen that PHP5 does not need that symbol.......... sooooooooooooooooooooooooo

I removed them but it still is not passing the information to my database!!! this makes me a very sad panda...

There are 2 files mainly involved that I know of.

credit.php

paypalclass.php <- this file calls a bunch of stuff that I am clueless about

but it gets worse, after looking at my back ups of the old site I have a ton of paypal code that is mindboggling to me.

here is the tree of crazyness

So I call upon the powers of MacGyver to help me out once again

Here is a screenshot of the error on the credit.php page

NOTE that i found where that error displays and changed it to "timed out error , please up credits"

here is the code for credit.php with that error on line 981

I will post the rest of the code below this in another reply

xbox2box · March 18, 2009

<?php
/** -------------------------------------
* @copyright 2005 PayPal, Inc
* @author colson
* @license CPL 1.0
* @link http://opensource.org/licenses/cpl1.0.txt (license link)
* @link http://www.paypaltech.com
* @link http://ospaypal.com (off site development and dev builds)
*/ #-------------------------------------
class PayPal
{
/**
*	Define the class variables.
*
* 	Note: I've forced some variables set to specific values
* 	and items listed below the line in the class, marked "do not edit"
* 	should be left alone.
*/

/**
* @var string - private variable that holds the endpoint URL
*/
  var $_apiURL = "https://api.paypal.com/2.0/";
/**
* @var string - full path to the certificate file
*/
  var $_cert = "includes/cert_key_pem.txt";
/**
* @var string - The username set in the class. In PHP 4 there is no way
* to protect this variable from the outside.
*/
  var $_user = "XXXXXXXXXXXXXXXXXXXX";
/**
* @var string - PayPal API password.
*/
  var $_pwd = "XXXXXXXXXXXXXXXXXXXX";
  #*************************/

/**
* @var string - container for the filename and used to set the paths
* to the template directories
*/
  var $_filename;
/**
* @var string - path to the soap header files
*/
  var $_soapheader = "./paypaltemplates/header.php";
/**
* @var string - path to the soap footer files
*/
  var $_soapfooter = "./paypaltemplates/footer.php";
/**
* @var string - only used when setting up for 3rd party access
*/
  var $_subject = null;
/**
* @var string - a full and complete soap request
*/
  var $_request;
/**
* @var string - the result of the API call
*/
  var $_result;
/**
* @var string
*/
  var $_xmlArray;
/**
* @var string
*/
  var $_values;
/**
* @var string
*/
  var $_call;
/**
* @var string
* @access private - This variable holds error strings to be returned by the parser
*/
  var $_errors;
/**
* @var float - The API version to run calls against. This can remain
* static and will increment on new releases of this SDK
*/
  var $_version = '2.1';

/**
  * @access public
  * @param string $call
  * @param mixed @values
  */

  function setCall($call, $values)
  {
    $this->_filename = "./paypaltemplates/" . $call . "/" . $call .".php";
    $this->_values = $values;
    $this->_call = $call;
  }
/**
* @access public
* @param string $path
*/
  # @private function setCert
  function setCert($path)
  {
    $this->_cert = $path;
  }
/**
  * @access public
  * @param string $user
  * @param string $pwd
  * @param mixed $subject
  */

  function setHeader($user, $pwd, $subject = null)
  {
    $this->_user = $user;
    $this->_pwd = $pwd;
    $this->_subject = $subject;

  }
/**
  * @access private
  */
  function getCall()
  {
    # Make the Soap Header available to us
    require_once("$this->_soapheader");
    # Everything is stored in the $SOAPrequest variable
    require_once("$this->_filename");
    require_once("$this->_soapfooter");
    # A fully stacked XML call
    $this->_request = $SOAPrequest;

  }
/**
  * @access public
  */
  function execute()
  {
  	$this->getCall();
  	$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,"$this->_apiURL");
curl_setopt($ch, CURLOPT_SSLCERT, $this->_cert);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_POSTFIELDS, "$this->_request");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

// the three curl settings below are for GoDaddy hosted accounts:
// curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, TRUE);
// curl_setopt($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP);
// curl_setopt($ch, CURLOPT_PROXY, "http://64.202.165.130:3128");



$xmlResponse = curl_exec($ch);
$this->_result = $xmlResponse;

if (curl_error($ch))
{
	printf("Error %s: %s", curl_errno($ch), curl_error($ch));
}
curl_close ($ch);

return $this->_result;
  }
/**
  * @access private
  * @todo - This method will be replaced in a later version.
  */
  function xml2array ()
  {
  	require_once('./includes/xml2array.php');
  	$this->_xmlArray = XML_unserialize($this->_result);

  }

/**
  * @access public
  * @return array - This method will return a formatted array.
  */
  function getResult()
  {
  	$this->execute();
  	$this->xml2array();
  	
# Log the results.

	# Return the results - SOAP-ENV:Body payload only.

  	if ($this->_call == "SetExpressCheckout")
  	{
  		$rKey = "SetExpressCheckoutResponse";
  		$error = $this->_xmlArray["SOAP-ENV:Envelope"]["SOAP-ENV:Body"][$rKey][Errors];
  	}
  	elseif($this->_call == "GetExpressCheckout")
  	{
  		$rKey = "GetExpressCheckoutDetailsResponse";
  		$error = $this->_xmlArray["SOAP-ENV:Envelope"]["SOAP-ENV:Body"][$rKey][Errors];
  	}
  	elseif($this->_call == "DoExpressCheckout")
  	{
  		$rKey = "DoExpressCheckoutPaymentResponse";
  		# The whole reason for this section of code: DoExpCheckout puts errors a level
  		# deeper. This conditional catches this so that errors are all on the same level
  		# and accessible through the getErrors() method.
  		$error = $this->_xmlArray["SOAP-ENV:Envelope"]["SOAP-ENV:Body"][$rKey][Errors][0];
  	}
  	elseif($this->_call == "DoDirectPayment")
  	{
  		$rKey = "DoDirectPaymentResponse";
  		$error = $this->_xmlArray["SOAP-ENV:Envelope"]["SOAP-ENV:Body"][$rKey][Errors];

  	}
  	elseif($this->_call == "MassPay")
  	{
  		$rKey = "MassPayResponse";
  		$error = $this->_xmlArray["SOAP-ENV:Envelope"]["SOAP-ENV:Body"][$rKey][Errors];
  	}
  	else
  	{
  		die('Invalid Response from class');
  	}

if($this->_xmlArray["SOAP-ENV:Envelope"]["SOAP-ENV:Body"][$rKey][Ack] == "Failure")
{
	$this->_errors = $error;
}
return $this->_xmlArray["SOAP-ENV:Envelope"]["SOAP-ENV:Body"][$rKey];
  }

/**
  * @access public
  * @return array
  */
  function getErrors()
  {
  	return $this->_errors;
  }
# End of Class
}
?>

Sign In

'Fatal Error: Cannot access empty property' problem with PHP 5?

Recommended Posts

xbox2box

Link to comment

Share on other sites

rhodesa

Link to comment

Share on other sites

xbox2box

Link to comment

Share on other sites

rhodesa

Link to comment

Share on other sites

xbox2box

Link to comment

Share on other sites

xbox2box

Link to comment

Share on other sites

rhodesa

Link to comment

Share on other sites

xbox2box

Link to comment

Share on other sites

rhodesa

Link to comment

Share on other sites

xbox2box

Link to comment

Share on other sites

xbox2box

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information