StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POphp+mysql - Like does not display all values
primarykey
Id
12627423
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
12
CommunityOwnedDate
CreationDate
2012-09-27T18:00:34.950
FavoriteCount
0
LastActivityDate
2012-09-27T19:00:34.203
LastEditDate
2012-09-27T19:00:34.203
LastEditorUserId
1311100
OwnerUserId
1311100
ParentId
0
PostTypeId
1
Score
0
ViewCount
171
LastEditorDisplayName
text
Body
<p>Im making this person search function build up of jquery(json) and php, the from the search bar are sent to the php document but it doesn't behave like i want it to.</p> <p>I don't know if there's problem with the mysql server or the php code, but when i execute my search script it does not return values on (example):"e","s" or "r" but if i type in the whole name of a person, or just an "a" it returns all names with an "a" in it.</p> <p>here is a little snip of my script:</p> <pre><code> $string = trim(mysql_real_escape_string($_POST['string'])); $sql = "SELECT * FROM users WHERE firstName LIKE '%$string%' OR lastName LIKE '%$string%' ORDER BY firstName ASC"; foreach($db->query($sql) as $row) { //usage of $row like: $name = $row['firstName']." ".$row['lastName']; } </code></pre> <p><strong>Update:</strong><br> heres the whole script:</p> <pre><code> $sql = "SELECT * FROM users WHERE firstName like '%$string%' OR lastName like '%$string%' ORDER BY firstName ASC"; foreach($db->query($sql) as $row) { $name = $row['firstName']. " ".$row['lastName'];//combing firstname with lastname //replacing æ,ø,å,Æ,Ø,Å with html friendly charcodes $remove = array("æ", "ø", "å", "Æ", "Ø", "Å"); $with = array("&aelig;", "&oslash;", "&aring;", "&AElig;", "&Oslash;", "&Aring;"); $fname = str_replace($remove, $with, $name); //composing a answer to the user. $stringUser[] = "<li class='searchResultHit'><div class='searchResultLeft'><img src='".$row['picture']."'></div><div class='searchResultCenter'><span class='searchResultContent'><a href='user.php?id=".$row['id']."'>".$fname."</a></span></div></li>"; } </code></pre>
Tags
<php><mysql>
Title
php+mysql - Like does not display all values
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USAnders Fejerskov
UserOwnerUserId
1. USAnders Fejerskov
plurals
PostLinksPostIdRelatedPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
2. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
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.