StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP String Differences and Dynamic Restrictions
primarykey
Id
15141928
data
AcceptedAnswerId
15143051
AnswerCount
1
ClosedDate
CommentCount
14
CommunityOwnedDate
CreationDate
2013-02-28T17:32:07.670
FavoriteCount
0
LastActivityDate
2013-11-20T19:53:03.897
LastEditDate
2013-11-20T19:53:03.897
LastEditorUserId
426671
OwnerUserId
1928445
ParentId
0
PostTypeId
1
Score
2
ViewCount
163
LastEditorDisplayName
text
Body
Example A [the simplified one]: -------------------------------------------------------------------- <blockquote> MODEL: String {1} and keeeeeep on {2} and oooon... CASE_A: String hello and keeeeeep on two words and oooon... CASE_B: String anything else and keeeeeep on just for fun and oooon... </blockquote> I need to get a list with n vars called <code>$v1</code>, <code>$v2</code>, <code>$vn</code>... with their respective matched values: EDIT: Note that the variable names are given depending on the placeholder. Placeholders are always an INT. (The numbers are just indexes not word count) For case A: <code>$v1</code>=hello <code>$v2</code>=two words <code>$vn</code>=etc... For case B: <code>$v1</code>=anything else <code>$v2</code>=just for fun <code>$vn</code>=etc... As you can see the references to get these values are the "constant" parts of both strings. Example B [the almost-real one]: -------------------------------------------------------------------- Now we suppose that each possible match is saved in an array (real case is a long database), like this: possible_matches{ [0] string three <<<< [1] Oneword <<<< [2] Other stuff [3] Harry Poppotter [4] two words <<<< [5] Magic words magic feelings } In the previous example it was not necessary, because each {n} "placeholder" was separated by "constant" strings. But there are cases where these "placeholders" are together... so I have to invent a new way to match the possible matches (fixed list). <blockquote> String {1} and keeeeeep on {2} {3} and oooon... String Oneword and keeeeeep on two words string three and oooon... </blockquote> As you can see (based on the array shown above), the result should be: <code>$v1</code>=hello <code>$v2</code>=two words <code>$v3</code>=string three But how knows PHP how I want my strings to be separated? My idea is doing the next: 1) Get the {2}{3} block as a single one. 2) Check in the array if this block (two words and three words) is <code>in_array()</code> 3) If NOT: 4) Remove the last word of it 5) Check again with the new (two words and three). 6) If NOT: <<<< 4') Remove the last word of it 5') Check again with the new (two words and). 4'') Remove the last word of it 5'') Check again with the new (two words). <<<< 7) Repeat 4 and 5 till it is one possible match (<code>in_array()</code>) 8) The matched one will be {2} and the rest of the string will be {3} My question: how can I make this, in PHP? I tried to explain it the most simplified I could, and I hope you understand what I am trying to ask for. If anyone needs more examples I will write them down, just let me know. Thanks for reading. EDIT -------------------------------------------------------------------- A real example: Array: possible_matches{ [0] Christopher Johnson [1] McCandless [2] cinema [3] tomorrow at night } <blockquote> MODEL: My name is {1} {2}, and I am going to the {3}{4} CASE: My name is Christopher Johnson McCandless, and I am going to the cinema tomorrow at night </blockquote> Desired result: <code>$v1</code>=Christopher Johnson <code>$v2</code>=McCandless <code>$v3</code>=cinema <code>$v4</code>=tomorrow at night Create possible combinations array <pre><code>function get_possible_groups($string_of_words, $groups_count){ $words=explode(' ',$string_of_words); $total=count($words); $group_1=array(array()); $group_2=array(array()); //We can create TOTAL-1 combinations for($i=0;$i<$total;$i++){ $lim=$total-$i-1; for($j=0;$j<$total;$j++){ if($j<$lim){ $group_1[$i][]=$words[$j]; }else{ $group_2[$i][]=$words[$j]; } } } return array($group_1,$group_2); } </code></pre> UPDATE referenced in comments for the ACCEPTED answer <pre><code>$model="Damn you {1}, {2} will kill you. {3}{4}{5}"; //Array => Save how many single placeholders are in each "placeholder block" $placeholder_count{ [0]=1, //first block contains one placeholder [1]=1, //second block contains one placeholder [2]=3 //third block contains three placeholders } //Simplify all blocks into ONE SINGLE regex placeholder $pattern="/Damn you (.*), (.*) will kill you. (.*)/"; //Match in string $string="Damn you Spar, Will will kill you. I Love it man."; preg_match($pattern,$string,$matches); //View in array which placeholders have to be checked $block_0=$matches[1]; //Array shows it was 1 p.holder. No check needed $block_1=$matches[2]; //Array shows it was 1 p.holder. No check needed $block_2=$matches[3]; //It shows it were 3 p.holders. Possible grouping (n=3) //Result $v1=$matches[1]; $v2=$matches[2]; $v3,$v4,$v5=(Result of grouping and querying the $matches[3] with groups_count=3) </code></pre>
Tags
<php><mysql><match>
Title
PHP String Differences and Dynamic Restrictions
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USTaryn
UserOwnerUserId
1. USMark Tower
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
3. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POPHP String Differences and Dynamic Restrictions
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
2. VO
 singulars
 PostPostId
 POPHP String Differences and Dynamic Restrictions
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POPHP String Differences and Dynamic Restrictions
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

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.