Calling method

LionRock

Hi,

I have class with functions set...() get...() etc.

class User {

  private $Name;
  private $Country;
  private $Length;

     public function setName($data)
   {
      $this->Name = $data;
   }

   public function setCountry($data)
   {
      $this->Country = $data;
   }

   public function setLength($data)
   {
      $this->Length = $data;
   }



    public function getName()
   {
      return $this->Name;
   }

   public function getCountry()
   {
      return $this->Country;
   }

   public function getLength()
   {
      return $this->Length;
   }


    public function getUsers()
   {
      global $DB;

     $rs = $DB->executeQuery( "SELECT * FROM user");

      while($rs->next()) {
         $this->Name = $rs->getString('name');
         $this->Country = $rs->getString('country');
         $this->Length = $rs->getString('length');

     }
                    // Problem is here. How I can save variables that will not overwrite each other. I would like to use getName() and not $v['name']... in template engine.
     //return WHAT ? ?
   }
} {

Im would like to use it like this:

$c = new User();

$cir = $c->getUsers();

foreach ($user as $u) {
   echo $u->getName();
}

All works if I want to get user info where I have know userID. But problem is when I want to fetch all users and get data with functions getName() etc ....

I hope anybody understands me what I want 🙂

Have a nice day 😉

LionRock

Anybody ? :/

thread_PHP

Hi check this

THIS IS EDITCATEGORYALL.PHP
<?php 
session_start();

[B]require_once("library1/properties.php");
[/B]

$catid=$_REQUEST['catid'];

$uid= $_SESSION['loguid'];
if($uid=='')
{
	$_SESSION['loguid']="Guest";

$uid=  $_SESSION['loguid'];
}
$languageid=$_SESSION['languageid'];
if( $languageid=='')
{

$_SESSION['languageid']=2;
$languageid= $_SESSION['languageid'];
}
[B]$ob=new Properties;
$ob->openDB();
$ob->selDB();//this is calling a class[/B]
$alist[]= array();

if(isset($_REQUEST['rowstatval']))
$rowstatval=$_REQUEST['rowstatval'];
else
$rowstatval=0;
$pagename="editcatall";
$irow=0;
	  	   ?>
<html>
<head>
<title>Edit Category</title>

<link href="class.css" type="text/css" rel="stylesheet">

</head>
<body bgcolor="#FFFFF0" text="#000000">



<?php




print("<td><input type=text class=textbox  name='txtprodname$prodid' value=\"$prodname\">");

$qrylang2=sprintf("select distinct prodname from superprod where  prodname!='' and    langid='%s'  order by prodname",$languageid);
$rslang2=mysql_query($qrylang2);
if(mysql_affected_rows() > 0)
{
	$column="txtprodname";
	print "<br><a style=\"color:black\"  href=\"javascript:Newtextproddesc('$column','$prodid')\">Click here for pre-defined values</a>";
	print "<br><select name='txtprodname1$prodid'  style=\"display:none;\" size=5 onclick=\"Newtextproddesc1('$column','$prodid')\">";
	while($rowlang2=mysql_fetch_array($rslang2,MYSQL_BOTH))
	{
		$rowvalue=$rowlang2[0];
		print "<option value='$rowvalue'>$rowvalue</option>";
	}
	print "</select>";
}

print("</td>");
print("<td><input type=text class=textbox  name='txtprodcolor$prodid' value=\"$prodcolor\">");

$qrylang2=sprintf("select distinct prodcolor from superprod where prodcolor!='' and     langid='%s'  order by prodcolor",$languageid);
$rslang2=mysql_query($qrylang2);
if(mysql_affected_rows() > 0)
{
	$column="txtprodcolor";
	print "<br><a style=\"color:black\"  href=\"javascript:Newtextproddesc('$column','$prodid')\">Click here for pre-defined values</a>";
	print "<br><select name='txtprodcolor1$prodid'  style=\"display:none;\" size=5 onclick=\"Newtextproddesc1('$column','$prodid')\">";
	while($rowlang2=mysql_fetch_array($rslang2,MYSQL_BOTH))
	{
		$rowvalue=$rowlang2[0];
		print "<option value='$rowvalue'>$rowvalue</option>";
	}
	print "</select>";
}

print("</td>");
print("<td><input type=text class=textbox   name='txtprodsize$prodid' value=\"$prodsize\">");

$qrylang2=sprintf("select distinct prodsize from superprod where  prodsize!='' and    langid='%s'  order by prodsize",$languageid);
$rslang2=mysql_query($qrylang2);
if(mysql_affected_rows() > 0)
{
	$column="txtprodsize";
	print "<br><a style=\"color:black\"  href=\"javascript:Newtextproddesc('$column','$prodid')\">Click here for pre-defined values</a>";
	print "<br><select name='txtprodsize1$prodid'   style=\"display:none;\" size=5 onclick=\"Newtextproddesc1('$column','$prodid')\">";
	while($rowlang2=mysql_fetch_array($rslang2,MYSQL_BOTH))
	{
		$rowvalue=$rowlang2[0];
		print "<option value='$rowvalue'>$rowvalue</option>";
	}
	print "</select>";
}

print("</td>");
print("<td ><input type=text class=textbox style=\"Width:120;  \" name='txtprodprice$prodid' value=\"$prodprice\">");

$qrylang2=sprintf("select distinct prodprice from superprod where  prodprice!='' and    langid='%s'  order by prodprice",$languageid);
$rslang2=mysql_query($qrylang2);
if(mysql_affected_rows() > 0)
{
	$column="txtprodprice";
	print "<br><a style=\"color:black\"  href=\"javascript:Newtextproddesc('$column','$prodid')\">Click here for pre-defined values</a>";
	print "<br><select name='txtprodprice1$prodid'  style=\"display:none;\" size=5 onclick=\"Newtextproddesc1('$column','$prodid')\">";
	while($rowlang2=mysql_fetch_array($rslang2,MYSQL_BOTH))
	{
		$rowvalue=$rowlang2[0];
		print "<option  value='$rowvalue'>$rowvalue</option>";
	}
	print "</select>";
}

print("</td>");

print("<td><input type=text class=textbox  style=\"Width:60\" name='txtdisplay$prodid' value=\"$isdisplay\">");

$qrylang2=sprintf("select distinct isdisplay from superprod where   isdisplay!='' and   langid='%s'  order by isdisplay",$languageid);
$rslang2=mysql_query($qrylang2);
if(mysql_affected_rows() > 0)
{
	$column="txtdisplay";
	print "<br><a style=\"color:black\"  href=\"javascript:Newtextproddesc('$column','$prodid')\">Click here for pre-defined values</a>";
	print "<br><select name='txtdisplay1$prodid'  style=\"display:none;\" size=5 onclick=\"Newtextproddesc1('$column','$prodid')\">";
	while($rowlang2=mysql_fetch_array($rslang2,MYSQL_BOTH))
	{
		$rowvalue=$rowlang2[0];
		print "<option  value='$rowvalue'>$rowvalue</option>";
	}
	print "</select>";
}

print("</td>");
for($i=12;$i<mysql_num_fields($fields);$i++)
{
	$fieldname=mysql_field_name($fields,$i);
	$qry3x=sprintf("select $fieldname from superprod where prodid='%s' and   langid='%s'",$prodid,$languageid);
	$rs3x=mysql_query($qry3x);
	$row3x=mysql_fetch_row($rs3x);
	$fieldvalue=$row3x[0];
	print("<td><input type=text class=textbox  style=\"Width:120\" name='$fieldname$prodid' value=\"$fieldvalue\">");

	$qrylang2=sprintf("select distinct $fieldname from superprod where   $fieldname!='' and   langid='%s'  order by $fieldname",$languageid);
	$rslang2=mysql_query($qrylang2);
	if(mysql_affected_rows() > 0)
	{
		$txtfieldname=$fieldname."1".$prodid;
		$column="$fieldname";
		print "<br><a style=\"color:black\"  href=\"javascript:Newtextproddesc('$column','$prodid')\">Click here for pre-defined values</a>";
		print "<br><select name='$txtfieldname'  style=\"display:none;\" size=5 onclick=\"Newtextproddesc1('$column','$prodid')\">";
		while($rowlang2=mysql_fetch_array($rslang2,MYSQL_BOTH))
		{
			$rowvalue=$rowlang2[0];
			print "<option  value='$rowvalue'>$rowvalue</option>";
		}
		print "</select>";
	}

	print("</td>");
}
print("</tr>");
$imagerowid=$imagerowid+1;

}

print "<tr class=trbg><td colspan=30>";
print "<input type=submit class=buttonbg  name=Submit value='$dbdelete'  onclick='return deleteprod()'>";
print "&nbsp;&nbsp;<input type=submit class=buttonbg  name=Submit value='$dbaddnewimg'  >";
print "&nbsp;&nbsp;<input type=submit class=buttonbg  name=Submit value='Change Image'   onclick='return changeimages()'>";

print "<div align=left><br>";
print "<a style='color:black; cursor:pointer;'  onclick=\"callfuncall( '0' ,   '$countrowscnt')\">Show All Records</a>&nbsp;&nbsp;&nbsp;&nbsp;";
print "Select rows: <select name=selnoofrowsslt  onchange=\"callfunc( '$rowstatval')\" >";
for($ival=1;$ival<11;$ival++)
{
	$ivalue=$ival*10;
	if($rowminval==$ivalue)
	print "<option selected value='$ivalue'>$ivalue</option>";
	else
	print "<option value='$ivalue'>$ivalue</option>";
}
for($ival=2;$ival<6;$ival++)
{
	$ivalue=$ival*100;
	if($rowminval==$ivalue)
	print "<option selected value='$ivalue'>$ivalue</option>";
	else
	print "<option value='$ivalue'>$ivalue</option>";
}
print "</select>&nbsp;&nbsp;&nbsp;&nbsp;";
$rowstatvalsend=$rowstatval-$rowminval;
if($rowstatval>= $rowminval)
{

print "<a style='color:black; cursor:pointer;'    onclick=\"callfunc('0' )\"><img alt='First' src='images/GFirst.gif'></a>&nbsp;&nbsp;&nbsp;&nbsp;";
print "<a style='color:black; cursor:pointer;'   onclick=\"callfunc( '$rowstatvalsend' )\" ><img alt='Previous' src='images/GPrevious.gif'></a>&nbsp;&nbsp;&nbsp;&nbsp;";
}
$rowendvaluesend=$rowstatval+$rowminval;
if($rowendvaluesend < $rowmaxval)
{

$rowmaxvalsend=$rowmaxval-$rowminval;
print "<a style='color:black; cursor:pointer;'    onclick=\"callfunc( '$rowendvaluesend')\" ><img alt='Next' src='images/GNext.gif'></a>&nbsp;&nbsp;&nbsp;&nbsp;";
print "<a style='color:black; cursor:pointer;'    onclick=\"callfunc('$rowmaxvalsend')\" ><img alt='Last' src='images/GLast.gif'></a>&nbsp;&nbsp;&nbsp;&nbsp;";
}

print "</div>";
print "</td></tr>";

print "<tr class=trbg><td colspan=30><div align=center>";
print "<input type=submit class=buttonbg  name=Submit value='$dbupdate'   onclick=\"callfunc('$rowstatval')\">";
print "&nbsp;<input type=Submit   name=Submit value='$dbgoback' class=buttonbg>";
print "&nbsp;&nbsp;&nbsp;<a href='TotalPageWords.php?pagename=$pagename'><font color=black>$dbeditpagewords</font></a>";
print "</div>";
print "</td></tr>";

print " </table>";
print "</td></tr>";
print "</table>";


print ("</form>");
print("</body>");
print("</html>");
          ?> 
        <?php
       [B] $ob-> closeDB();[/B]
  ?>     

   //properties.php

<?php
class Properties
{

VAR $asro=array();
VAR $asri=array();
VAR $fri=array();


function openDB()
{
	mysql_connect("localhost","root","") or die("Sorry Unable to connect".mysql_error());
}
function selDB($dbnam="tb1")
{
	mysql_select_db($dbnam);
}
function closeDB()
{
	mysql_close();
}
}
				?>

like the above editcategoryall.php