StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWhy can't instantiate my object to an array[]?
primarykey
Id
14587928
data
AcceptedAnswerId
14588982
AnswerCount
3
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2013-01-29T16:49:26.793
FavoriteCount
0
LastActivityDate
2013-01-29T17:51:55.513
LastEditDate
2013-01-29T17:45:54.497
LastEditorUserId
1288837
OwnerUserId
1288837
ParentId
0
PostTypeId
1
Score
1
ViewCount
188
LastEditorDisplayName
text
Body
Why can't initiate my object to an array[]? This is my work: clothing_product.php <pre><code>include('../database.php'); class Clothing_Product { public $db; public $procode; public $probprice; public $proprice; public $prodes; public $propath; public $prostatus; public $image; public function __construct() { $this->db = new MySqlDatabase(); } public function get_all(){ return self::get_by_query('SELECT * FROM tblclothing_product;'); } public function get_by_query($sql=""){ $result_set = $this->db->query($sql); $object_array = array(); while($row = $this->db->fect_array($result_set)){ $object_array[] = $this->instantiate($row); echo var_dump($object_array); } return $object_array; } private function instantiate($record){ //Dynamic control $object = new self; foreach($record as $attribute=>$value){ if($object->has_attribute($attribute)){ $object->attribute = $value; } } return $object; } private function has_attribute($attribute){ $object_vars = get_object_vars($this); return array_key_exists($attribute,$object_vars); } public function add_new($a,$b,$c,$d,$e,$f){ $this->procode = $a; $this->probprice = $b; $this->proprice = $c; $this->prodes = $d; $this->propath = $e; $this->prostatus = $f; $sql="INSERT INTO `tblclothing_product`(`proCode`,`proBPrice`,`proPrice`,`proDes`,`proPath`,`proStatus`) VALUES( '" . $a ."', '" . $b ."', '" . $c ."', '" . $d ."', '" . $e ."', " . $f ." )"; $this->db->query($sql); } public function image_string($a,$b,$c,$d,$e){ $this->image=''; if($a!=""){ $this->image = $this->image. $a .";"; } if($b!=""){ $this->image = $this->image. $b .";"; } if($c!=""){ $this->image = $this->image. $c .";"; } if($d!=""){ $this->image = $this->image. $d .";"; } if($e!=""){ $this->image = $this->image. $e; } return $this->image; } public function remove_by_id($id){ $this->db->query('DELETE FROM tblclothing_product WHERE proId={$id};'); } public function get_by_id($id=0){ $result_array = self::get_by_query('SELECT * FROM tblclothing_product WHERE proId={$id} LIMIT 1;'); return !empty($result_array) ? array_shift($result_array) : FALSE; } public function image_exploit_string(){ $arr = array(); if($this->image != ""){ $arr = explode(";",$this->image); } return $arr; } } </code></pre> I try to echo the above script var_dump($object_array) my array and it has shown null to every object. It looks like it can't initiate at all. In clothing_view.php it is a script to view my array of object but it has shown null. <pre><code>require_once("../include/function.php"); require_once("../include/database.php"); $buttonname = $_POST["submit"]; $image1 = ''; $image2 = ''; $image3 = ''; $image4 = ''; $image5 = ''; $image1 = $_FILES['image1']['name']; $image2 = $_FILES["image2"]['name']; $image3 = $_FILES["image3"]['name']; $image4 = $_FILES["image4"]['name']; $image5 = $_FILES["image5"]['name']; $obj = new Clothing_Product(); $items = $obj->get_all(); foreach($items as $item){ echo "ProId:".$item->procode." "; echo "ProPath:".$item->propath." "; } </code></pre> In database.php: require_once('config.php'); <pre><code>class MySqlDatabase { private $connection; private $last_query; private $magic_quotes_active; private $real_escape_string_exist; function __construct(){ $this->open_connection(); $this->magic_quotes_active = get_magic_quotes_gpc(); $this->real_escape_string_exist = function_exists("mysql_real_escape_string"); } private function open_connection() { $this->connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS); if (!$this->connection){ die("Connection failed!". mysql_error()); } else{ $db_select = mysql_select_db(DB_NAME); if(!$db_select){ die("Select database failed". mysql_error()); } } } public function query($sql){ $this->last_query = $sql; $result = mysql_query($sql,$this->connection); $this->confirm_query($result); return $result; } public function confirm_query($result){ if(!$result){ $output = "Database query failed: " . mysql_error()." "; $output.= "Last query that fail is:" . $this->last_query; die($output); } } private function escape_value($value) { if ($this->real_escape_string_exist) { if($this->magic_quotes_active) {$value = stripslashes($value);} $value = mysql_real_escape_string($value); } else { if (!$this->magic_quotes_active) {$value = addslashes($value);} } return $value; } public function fect_array($result){ return mysql_fetch_array($result); } public function num_rows($result){ return mysql_num_rows($result); } public function last_id(){ return mysql_insert_id($this->connection); } public function affected_rows(){ return mysql_affected_rows($this->connection); } public function close_connection(){ if(isset($this->connection)){ mysql_close($this->connection); unset($this->connection); } } } </code></pre> Is there problem with $item->? It always returns null.
Tags
<php><arrays><class><instantiation>
Title
Why can't instantiate my object to an array[]?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USBong NakMadaraz
UserOwnerUserId
1. USBong NakMadaraz
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POWhy can't instantiate my object to an array[]?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.