how to swapping update query table row 0 to 1 and 1 to 0



mysql update query 1 to 0 and 0 to 1 single statement using query
update users set banned= case  when banned= "0"  then 1 when banned= "1"  then 0 end

Comments

Post a Comment

Popular posts from this blog

how to check ban-word user in put using php

function banned_words_chk($phrase) { global $conn, $config; $query = "SELECT word from bans_words"; $executequery = $conn->Execute($query); $bwords = $executequery->getarray(); $found = 0; $words = explode(" ", $phrase); foreach($words as $word) { foreach($bwords as $bword) { if($word == $bword[0]) { $found++; } else { $pos2 = strpos($word, $bword[0]); if($pos2 !== false) { $found++; } } } } if($found > 0) { return true; } else { return false; } } ------------------------------------------------------------- if you helpful my code please donate some few amount to developing and free to post. -------------------------------------------------------------
Read more

Create a simple Web Service Using PHP, MySQL,JSON, and , XML

Web services are taking over the world. I credit Twitter's epic rise to the availability of a simple but rich API. Why not use the same model for your own sites? Here's how to create a basic web  service that provides an XML or JSON response using some PHP and MySQL. The PHP / MySQL copy /* require the user as the parameter */ if ( isset ( $_GET [ 'user' ] ) && intval ( $_GET [ 'user' ] ) ) { /* soak in the passed variable or set our own */ $number_of_posts = isset ( $_GET [ 'num' ] ) ? intval ( $_GET [ 'num' ] ) : 10 ;   //10 is the default $format = strtolower ( $_GET [ 'format' ] ) == 'json' ? 'json' : 'xml' ;    //xml is the default $user_id = intval ( $_GET [ 'user' ] ) ; //no default /* connect to the db */ $link = mysql_connect ( 'localhost' , 'username' , 'password' ) or die ( 'Cannot  connect to the DB' ) ; mysql_select_db...
Read more

Difference between session_register and $_SESSION[] in phpsession_register and $_SESSION[] in php

We can use either   session_register   or $_SESSION for registering session variable in php. Find below the difference between both of them.   session_register () is a   function   and   $_SESSION   is a superglobal   array . session_register() is used to register a session variable and it works only when register_globals is   turned on . ( Turning ON register_globals will create mesh-ups, but some applications (e.g OScommerce) requires turning ON of register_globals) But $_SESSION works even when register_globals is turned off. If   session_start()   was not called before   session_register()   is called, an implicit call to session_start() with no parameters will be made. But $_SESSION requires session_start() before use. session_register function returns boolean value and $_SESSION returns string value session_register() function has been DEPRECATED as of PHP 5.3.0 and REMOVED as of PHP 6.0.0. We know that Webpages ar...
Read more