Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There's quite a few problems in your code. Here's what you should do:</p> <ol> <li><code>explode</code> needs a delimiter. You want to separate it by commas, so do <code>explode(",","state/Gold,International/Participant,School/Participant,School/Bronze,national/Bronze,School/Gold")</code>.</li> <li>You should not use array_diff: in fact, the way you did it would remove just the elements that only contain 'Participant' - while they're more complex strings.</li> </ol> <p>What you need is a beautiful function called <code>array_filter</code>. It's one of the few really great things in PHP, so bear me for a little while I explain how it works.</p> <p>It takes two arguments: the array, and a function. </p> <p>It returns an array containing only the elements that, once passed to the function, will return true.</p> <p>Let's come back to your particular case. To check if a string contains a substring (that is, to check if in a given array element there is a 'Participant' string) you can use <code>strpos($haystack, $needle)</code>. It will return the position of your substr, or FALSE if it is not present.</p> <p>Another concept (solution is coming) we will use is pretty new in php, and is called "anonymous function". It's a function created on the fly, without a name, usually to be used as callback.</p> <p>Here is the code:</p> <pre><code> $string = "state/Gold,International/Participant,School/Participant,School/Bronze,national/Bronze,School/Gold"; $new_array = array_filter( explode(",",$string), //so, every element of this array gets checked against function ($var) { //this function here. if true is returned, it goes in $new_array return (strpos($haystack, 'Participant')=== NULL); } ); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POParse string and filter data in php
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. UScbrandolino
    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. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COYou're following his wrong algorightm but fail to achieve his goal
      singulars
      1. PO
      1. USYour Common Sense
    2. COfuuu, didn't read the updated question. anyway, read this thing. it took me 7 minutes.
      singulars
      1. PO
      1. UScbrandolino
    3. CO@Col. Shrapnel, I could do it with a one-line regex - just wanted to write something instructive. Also, his goal was different at the beginning. Also, please avoid assuming anyone != you's a newbie.
      singulars
      1. PO
      1. UScbrandolino
 

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