Simple PHP/mySQL query? -

-

मेरे पास डेटाबेस है जो उपयोगकर्ता नाम, नंबर और वाहक को user नामक तालिका में संग्रहीत करता है ।

मुझे यह जानने की आवश्यकता है कि कैसे एक प्रश्न लिखना है कि यदि मेरा मान नाम के बराबर है - तो उस नाम से जुड़े संख्या और वाहक को मिलेगा मैं इसे php में लिख रहा हूं और यदि आवश्यक हो तो जावास्क्रिप्ट का उपयोग करेगा।

मुझे आपको "SELECT * से उपयोगकर्ता कहां नाम की तरह '{$ value}' का उपयोग करना चाहिए ' क्योंकि = का उपयोग सटीक मूल्य के लिए खोज करेगा उदाहरण के लिए: अगर डेटाबेस में मान है जॉन और यू को जॉन के लिए खोजा तो यह नतीजे प्रदर्शित नहीं करेगा, लेकिन अगर आप पसंद करते हैं तो यह सभी संबंधित परिणामों जैसे जॉन, जॉन, जॉन, जॉन आदि।

आपको धन्यवाद, मेघा

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

ruby on rails - Convert a Activerecord result with has_one associations into a single hash per record -

-
If I have any results from the Active Records, then I have an array of hashes, if I have a reliable load, then every Each organization hash in record hash has a nested hash of its associated records My question is, is there a quick rail system that allows you to merge these nested hashes into a hash per record? An analogy will be changing the records table rows Another resemblance will be converted into a hash at one level of nested hashes. approach 1: select them in the section Include class user has_one: profile end is for square profile: user # street 1, street 2, city etc. end profile = profile.junks (user :). Selection ("User. *, Profile. *") All profiles. First.login Approach 2: Use delegation for class profiles : User # Street 1, Road 2, City etc. Representative: Name ,: name =,: email,: email = ,: from = to & gt; : End of user
Read more

javascript - Read complete data from stream from onMessage -

-
How to read event.data from a web site entirely using javascript ? On Message: Function (Event) {var msg = event.data; Warning (msg); } In the above code, variable msg shows only partial data How to obtain complete data from websicet server? event.data contains complete information; It depends only on your output how much you will see. A warning box only contains a special number of characters, because more characters do not fit in the warning box only. Warning ing is not a good practice to display large data. A more convenient way to save the length and to check that, for example: On Message: Function (Event) {var msg = event.data; Warning (msg.length); } The length should be just the right length, that is the length of the characters you sent.
Read more