Databases
StackOverflow2013
Postsdbo
POSQL query efficiency when using PHP classes
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL query efficiency when using PHP classes
    primarykey
    data
    text
    <p>I've been programming in PHP for many years, however only recently started programming with classes. I have the following - basic - user class as follows:</p> <pre><code>&lt;?php /* The class for constructing any user's information */ class User { protected $userId, $email, $userGroup; protected function getEmail() { return $this-&gt;email; } protected function getUserId() { return $this-&gt;userId; } protected function getUserGroup() { return $this-&gt;userId; } public function __construct($userId='') { if($userId) { $select = mysql_query("SELECT userId, email, user_group FROM user WHERE userId = '$userId'"); while($user==mysql_fetch_array($select)) { $this-&gt;email = $user[email]; $this-&gt;userId = $userId; $this-&gt;userGroup = $user[user_group]; } } } }?&gt; </code></pre> <p>So I understand I can do the following</p> <pre><code>&lt;?php $user = new User($userId); echo $user-&gt;getEmail(); ?&gt; </code></pre> <p>To display the user's email address for a given userId. What I'd like to know is, what would be the best way - using OOP - to display, say, 40 user's emails. Obviously creating 40 user objects would be silly as that's 40 SQL queries. Would you simply make a "users" class that was used for returning an array of multiple users, after doing an SQL given various parameters?</p> <p>Ie</p> <pre><code>&lt;?php $getUsers = new Users('Tom'); // create 'Users' object where name is 'Tom' print_r($users); // prints the returned array of users? ?&gt; </code></pre> <p>Thanks for your help. Hopefully this is clear.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USTom
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQL query efficiency when using PHP classes
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POSQL query efficiency when using PHP classes
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhere does `$userID` normally come from? If it's from an external source, you're prone to SQL injection. Please switch to prepared statements to prevent that. BTW, the `mysql_*` functions are deprecated.
      singulars
      1. POSQL query efficiency when using PHP classes
      1. USMarcel Korpel
    2. COHi Marcel. I will add security features to my SQL at a later stage - this is just a basic early code whilst I clear up my initial question in my head. Thanks for pointing out about mysql_* - I wasn't aware of this.
      singulars
      1. POSQL query efficiency when using PHP classes
      1. USTom
    3. CO@Tom : have look into [PDO](http://php.net/manual/en/pdostatement.fetch.php). With PDO u can cast a recordset to an array of ex. User. This way u only need 1 SQL and u get 40users in return
      singulars
      1. POSQL query efficiency when using PHP classes
      1. USDarkBee
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload