# From outside get Var value inside class
**URL:** https://forum.kirupa.com/t/from-outside-get-var-value-inside-class/38466
**Category:** Uncategorized
**Created:** [December 23, 2003, 10:02am UTC](https://forum.kirupa.com/t/from-outside-get-var-value-inside-class/38466 "2003-12-23T10:02:49Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@OKtrust](https://forum.kirupa.com/u/OKtrust)
#### Post date: [December 23, 2003, 10:02am UTC](https://forum.kirupa.com/t/from-outside-get-var-value-inside-class/38466/1 "2003-12-23T10:02:49Z")
Hi all,
I’m practicing (hands on 🙂 class in PHP and I have problem with this code:
```php
Class DBSQL
{
function showadmin($sql="")
{
$conn = $this->CONN;
$result = mysql_query($sql,$conn);
return $result;
}
}
$db = new DBSQL($DBName);
$showadminuser = "select adminid, username from
newsadmin";
$db->showadmin($showadminuser);
```
How can I do to get $result to continuous writing these line:
```php
while ($row = mysql_fetch_array($result)){
$adminid=$row['adminid'];
$username=$row['username']; print "$username
";
}
```
Please show me, thanks men.
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [December 23, 2003, 3:42pm UTC](https://forum.kirupa.com/t/from-outside-get-var-value-inside-class/38466/2 "2003-12-23T15:42:44Z")
The same way you perform the internal function…
```php
$db->result
```
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [December 23, 2003, 3:58pm UTC](https://forum.kirupa.com/t/from-outside-get-var-value-inside-class/38466/3 "2003-12-23T15:58:18Z")
sorry, It still … doesnt work
I think you missed one thing, is it $ ?
I write
```php
$result = $db ->result;
print $sesult;
```
but it didn’t display anny thing. even I wrote $result = $db -\>result; :-((
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [December 23, 2003, 4:16pm UTC](https://forum.kirupa.com/t/from-outside-get-var-value-inside-class/38466/4 "2003-12-23T16:16:40Z")
I’m sorry I was looking at your code wrong… since the internal function is returning the variable you should just write:
```php
$db->showadmin();
```
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [December 23, 2003, 4:29pm UTC](https://forum.kirupa.com/t/from-outside-get-var-value-inside-class/38466/5 "2003-12-23T16:29:03Z")
like you wrote, It can’t get query to xecute ($showadminuser = “select adminid, username from newsadmin”😉
i’m not sure that i’m right 😃
but I want to use class to connect, get data from SQL. If you don’t mind, please make me a new one ?
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [December 23, 2003, 6:02pm UTC](https://forum.kirupa.com/t/from-outside-get-var-value-inside-class/38466/6 "2003-12-23T18:02:40Z")
I happen to be writing a class for a lightweight blog.
here is the code I’m using:
```php
_mysqlConn = mysql_pconnect("localhost", $uName, $pass);
mysql_select_db($db, $this->_mysqlConn);
}
/**
* @return array
* @desc Get the top ten entries.
*/
function getEntries(){
$rows = array();
$query = mysql_query("SELECT * FROM entries LIMIT 10", $this->_mysqlConn);
if(!query) print mysql_error($this->_mysqlConn);
while ($row = mysql_fetch_array($query)){
array_push($rows, $row);
}
return $rows;
}
/**
* @return array
* @param number $entryID
* @desc Get an entry. Returns an array of fields of the entry.
*/
function getEntry($entryID){
$id = (int) $id;
$query = mysql_query("SELECT * FROM entries WHERE 'id' = '$id' LIMIT 1", $this->_mysqlConn);
return mysql_fetch_array($query);
}
function customQuery($query) {
$return = array();
$execQuery = mysql_query($query, $this->_mysqlConn);
while($row = mysql_fetch_array($execQuery)){
array_push($return, $row);
}
return $return;
}
}
?>
```
in PHP 5, you’ll be able to use mysql\_connect, as PHP5 lets you run a function when the class is destroyed.