mysql - PHP: How to check if ID in database exists -

-

Why will not this send the user to user.php if the ID is not present in the table? 

  & lt ;? Php included 'db_connect.php'; $ Id_exists = false; $ Url_id = mysql_real_escape_string ($ _GET ['id']); $ Sql ​​= "Selection ID from members where id = '$ url_id'"; $ Result = mysql_query ($ sql); If ($ result == $ url_id) {$ id_exists = true; } And if ($ result! = $ Url_id) {$ id_exists = false; Header ("location: user.php"); Go out(); }? & Gt;   
 Thx in advance!   
 
 
  $ url_id = mysql_real_escape_string ($ _elected ['id']); $ Sql ​​= "Selection ID from members where id = '$ url_id'"; $ Result = mysql_query ($ sql); If (mysql_num_rows ($ result) & gt; 0) {// found} else {// not found}   
 try something like that :).

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