Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It would be easier if you just did a quick true/false check in the SQL and checked the flag that came back.</p> <pre><code>$sql = "SELECT " . "(SELECT 1 FROM `users` WHERE `username` = '" . mysql_real_escape_string($username) . "'), " . "(SELECT 1 FROM `users` WHERE `email` = '" . mysql_real_escape_string($email) . "')"; $query = mysql_query($sql); if (mysql_num_rows($query) &gt; 0) { $foundFlags = mysql_fetch_assoc($query); if ($foundFlags['username']) { $error[] = "username is existing"; } if ($foundFlags['email']) { $error[] = "email is existing"; } } else { // General error as the query should always return } </code></pre> <p>When it does not find an entry, it will return NULL in the flag, which evaluates to false, so the <code>if</code> condition is fine.</p> <p>Note that you could generalise it for a field list like this:</p> <pre><code>$fieldMatch = array('username' =&gt; $username, 'email' =&gt; $email); $sqlParts = array(); foreach ($fieldMatch as $cFieldName =&gt; $cFieldValue) { $sqlParts[] = "(SELECT 1 FROM `users` WHERE `" . $cFieldName . "` = '" . mysql_real_escape_string($cFieldValue) . "')"; } $sql = "SELECT " . implode(", ", $sqlParts); $query = mysql_query($sql); if (mysql_num_rows($query) &gt; 0) { $foundFlags = mysql_fetch_assoc($query); foreach ($foundFlags as $cFieldName =&gt; $cFlag) { if ($foundFlags[$cFieldName]) { $error[] = $cFieldName . " is existing"; } } } else { // General error as the query should always return } </code></pre> <p><em>NB.</em> Note that assumes all fields are strings, or other string-escaped types (eg. date/time).</p>
    singulars
    1. This table or related slice is empty.
    1. POCheck record exists db - error show
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USOrbling
    1. USOrbling
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCheck record exists db - error show
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI like how you combined the two queries. @jake In some cases, you might want to separate the queries. The benefit is prompt error handling, and less mysql loads. Best
      singulars
      1. PO
      1. USOV Web Solutions
    2. CO@OV Usually I might have coded that as multiple queries in my own code - but the OP seemed to be going after a shorter, more contained solution. It very much depends on your server setup what will function the best. Those queries are independent, so internally to the server it will just perform the queries as if they were separate, albeit with a slight overhead to combine the results. But there is a lot less overhead in that than performing two separate queries through the client interface. Most of the saving comes from returning 1 or NULL, rather than the value you already have.
      singulars
      1. PO
      1. USOrbling
    3. COI agree. The server setup can play a role on what solution is best to implement. Excellent job posting exactly what was needed. Best
      singulars
      1. PO
      1. USOV Web Solutions
 

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