Pastable version of Object with Field names as resources

<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8">
          <div class="section">
            <span style="margin:0;padding:4px 6px;font-size:12px;float:right;">Table</span>
            <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1
2
3
4
5
6
7
8
9</pre>
            <pre class="sunburst">+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| user_id  | int(11)     | NO   | PRI | NULL    | auto_increment | 
| username | varchar(20) | YES  |     | NULL    |                | 
| password | varchar(32) | YES  |     | NULL    |                | 
| email    | varchar(50) | YES  |     | NULL    |                | 
+----------+-------------+------+-----+---------+----------------+

</pre>
          </div>
        </div>

<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8">
          <div class="section">
            <span style="margin:0;padding:4px 6px;font-size:12px;float:right;">Query</span>
            <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15</pre>
            <pre class="sunburst">&lt;?php

<span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>db</span> <span style="color:#E28964;">=</span> <span style="color:#DAD085;">mysql_connect</span>(<span style="color:#65B042;"><span style="color:#65B042;">'</span>localhost<span style="color:#65B042;">'</span></span>, <span style="color:#65B042;"><span style="color:#65B042;">'</span>root<span style="color:#65B042;">'</span></span>, <span style="color:#65B042;"><span style="color:#65B042;">'</span>rootpass<span style="color:#65B042;">'</span></span>)<span style="color:#E28964;">;</span>
	<span style="color:#DAD085;">mysql_select_db</span>(<span style="color:#65B042;"><span style="color:#65B042;">'</span>dname<span style="color:#65B042;">'</span></span>, <span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>db</span>)<span style="color:#E28964;">;</span>	
	
	<span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>query</span> <span style="color:#E28964;">=</span> <span style="color:#65B042;"><span style="color:#65B042;">&quot;</span>SHOW COLUMNS FROM users;<span style="color:#65B042;">&quot;</span></span><span style="color:#E28964;">;</span>
	<span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>result</span> <span style="color:#E28964;">=</span> <span style="color:#DAD085;">mysql_query</span>(<span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>query</span>, <span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>db</span>)<span style="color:#E28964;">;</span>
	<span style="color:#E28964;">while</span>(<span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>row</span> <span style="color:#E28964;">=</span> <span style="color:#DAD085;">mysql_fetch_assoc</span>(<span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>result</span>))
	{
		<span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>fields</span>[] <span style="color:#E28964;">=</span> <span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>row</span>[<span style="color:#65B042;"><span style="color:#65B042;">'</span>Field<span style="color:#65B042;">'</span></span>]<span style="color:#E28964;">;</span>
	}
	<span style="color:#DAD085;">var_dump</span>(<span style="color:#3E87E3;"><span style="color:#3E87E3;">$</span>fields</span>)<span style="color:#E28964;">;</span>

?&gt;

</pre>
          </div>
        </div>

<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8">
          <div class="section">
            <span style="margin:0;padding:4px 6px;font-size:12px;float:right;">Result Array</span>
            <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1
2
3
4
5
6
7
8
9
10
11</pre>
            <pre class="sunburst">array(4) {
  [0]=&gt;
  string(7) &quot;user_id&quot;
  [1]=&gt;
  string(8) &quot;username&quot;
  [2]=&gt;
  string(8) &quot;password&quot;
  [3]=&gt;
  string(5) &quot;email&quot;
}

</pre>
          </div>
        </div>

<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8">
          <div class="section">
            <span style="margin:0;padding:4px 6px;font-size:12px;float:right;">Overall Goal</span>
            <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1
2
3
4
5
6
7</pre>
            <pre class="sunburst">//dynamically made class
class user {
	public $user_id;
	public $username;
	public $password;
	public $email;
}
</pre>
          </div>
        </div>

<a href="http://refactormycode.com/codes/400-object-with-field-names-as-resources" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://refactormycode.com/images/small_logo.gif" style="border:0" /></a>

counter free hit invisible