NULL In MYSQL
SELECT * FROM `team_master` WHERE `reason` IS NULL SELECT id,first_name,last_name,IFNULL(phone,‘N/A’)phone FROM leads;
How To Use multiple JQuery On Same Page with Same Object Names
<script src=”https://code.jquery.com/jquery-1.12.4.js”></script> <script> var $jq = jQuery.noConflict(); </script> <script src=”https://code.jquery.com/ui/1.12.1/jquery-ui.js”></script> <script> var $jqui = jQuery.noConflict(); </script>
Update column if column have value less than query else keep old one
update table set column= case when column <’10’ then ’10’ ELSE column end where id=’2′
Call a Web service from android
package com.example.root.myapplication; import android.support.v7.app.ActionBarActivity; import android.os.Bundle; import android.util.Log; import android.view.Menu; import android.view.MenuItem; import android.view.View; import android.widget.Button; import android.os.AsyncTask; import android.widget.TextView; import org.apache.http.HttpResponse; import org.apache.http.NameValuePair; import org.apache.http.client.HttpClient; import org.apache.http.client.entity.UrlEncodedFormEntity; import org.apache.http.client.methods.HttpPost; import org.apache.http.entity.StringEntity; import org.apache.http.impl.client.DefaultHttpClient; import org.apache.http.message.BasicNameValuePair; import org.apache.http.util.EntityUtils; import org.json.JSONObject; import java.util.ArrayList; import java.util.List; public class MainActivity extends ActionBarActivity { @Override protected void onCreate(Bundle savedInstanceState)…
CodeIgniter htaccess and URL rewrite issues
RewriteEngine on RewriteCond $1 !^(index\.php|resources|robots\.txt)RewriteCond%{REQUEST_FILENAME}!-f RewriteCond%{REQUEST_FILENAME}!-d RewriteRule^(.*)$ index.php/$1 [L,QSA]
Call a PHP Webservice from android by post method
package com.example.root.myapplication; import android.support.v7.app.ActionBarActivity; import android.os.Bundle; import android.util.Log; import android.view.Menu; import android.view.MenuItem; import android.view.View; import android.widget.Button; import android.os.AsyncTask; import android.widget.TextView; import org.apache.http.HttpResponse; import org.apache.http.NameValuePair; import org.apache.http.client.HttpClient; import org.apache.http.client.entity.UrlEncodedFormEntity; import org.apache.http.client.methods.HttpPost; import org.apache.http.entity.StringEntity; import org.apache.http.impl.client.DefaultHttpClient; import org.apache.http.message.BasicNameValuePair; import org.apache.http.util.EntityUtils; import org.json.JSONObject; import java.util.ArrayList; import java.util.List; public class MainActivity extends ActionBarActivity { @Override protected void onCreate(Bundle savedInstanceState)…
Android with node.js server
package com.github.nkzawa.socketio.androidchat; import android.content.Intent; import android.support.v7.app.ActionBarActivity; import android.os.Bundle; import android.util.Log; import android.view.Menu; import android.view.MenuItem; import android.view.View; import android.widget.Button; import android.widget.Toast; import com.github.nkzawa.emitter.Emitter; import com.github.nkzawa.socketio.client.IO; import com.github.nkzawa.socketio.client.Socket; import org.json.JSONException; import org.json.JSONObject; import java.net.URISyntaxException; public class GameActivity extends ActionBarActivity{ private Socket mSocket; { try { mSocket = IO.socket(“http://6trix.com:8598/”); } catch (URISyntaxException e) { throw new RuntimeException(e); }…
if exists update else insert in mysql
insert into leaderboard(`user_name`,`score`) values(‘uspmca’,200) on DUPLICATE KEY update `score` = `score`+10 user_name needs to unique.
How to Change PHPMYADMIN Password
1- open terminal login as root 2-if already password then mysql -h your_host -u root -p else mysql -h your_host -u root 3- SET PASSWORD FOR root@localhost = PASSWORD(‘yourpassword’);
split string after x characters
// split a string from a number public function split_on($string, $num) { $length = strlen($string); $output[0] = substr($string, 0, $num); $output[1] = substr($string, $num, $length ); return $output; }