Databases
StackOverflow2013
Postsdbo
POTry Catch Block in PDO wrapper Class?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTry Catch Block in PDO wrapper Class?
    primarykey
    data
    text
    <p>I have wrote a neat PDO wrapper in class. I am trying to figure it out where is the best place to put <code>Try/Catch</code> block? In the PDO class wrapper or other files?</p> <p>For example:</p> <pre><code>public function fetchData($sql, $params = array(), $fetchMode = 'all') { try { $this-&gt;sth = $this-&gt;db-&gt;prepare($sql); if (count($params) &gt; 0) $this-&gt;setBind($params); $this-&gt;sth-&gt;execute(); $fetch = ($fetchMode == 'single') ? "fetch" : "fetchAll"; return $this-&gt;sth-&gt;$fetch(); } catch (PDOException $e) { return $data['error'] = array( 'status' =&gt; 'error', 'message' =&gt; $e-&gt;getMessage() ); } } </code></pre> <p>Or should I do like this without <code>try/catch</code> block:</p> <pre><code>public function fetchData($sql, $params = array(), $fetchMode = 'all') { $this-&gt;sth = $this-&gt;db-&gt;prepare($sql); if (count($params) &gt; 0) $this-&gt;setBind($params); $this-&gt;sth-&gt;execute(); $fetch = ($fetchMode == 'single') ? "fetch" : "fetchAll"; return $this-&gt;sth-&gt;$fetch(); } </code></pre> <p>Example Query:</p> <pre><code>try { $SQL = "SELECT * FROM table"; $result = $db-&gt;fetchData($SQL); print_r($result); } catch (PDOException $e) { $data['error'] = array( 'status' =&gt; 'error', 'message' =&gt; $e-&gt;getMessage() ); } </code></pre> <p>Update: Which would be more efficient? For example I don't want to repeat try/catch block in all functions or files.... and I still be able to return different "fail-message" on each one.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USj0k
    1. USI'll-Be-Back
    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
    1. This table or related slice is empty.
    1. COThe echo in your first example smells a little funny, but if you returned the error nicely and renamed the function `tryFetchData` I think it's ok. Or, use the second, but catch the PDOException and throw your own, this way the caller doesn't have to know about PDOException.
      singulars
      1. POTry Catch Block in PDO wrapper Class?
      1. USlc.
    2. CO@lc. Oops, fixed first example.
      singulars
      1. POTry Catch Block in PDO wrapper Class?
      1. USI'll-Be-Back
    3. CONot sure if it's what you're looking for, but for things like this I tend to have a "runQuery" that will return true/false (this is where the try/catch are), if it returns true I continue to "getResults()" into $result, if it's false, I use "getError()" to read the error message I would have set in the catch. This is under the assumption you're database function is within a class.
      singulars
      1. POTry Catch Block in PDO wrapper Class?
      1. USZeritor
 

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