Programming Tutorials On PHP,ASP.NET,AJAX,JQUERY,HTML

Delete duplicate users by Username with this query.. DELETE a FROM tbl_user a INNER JOIN tbl_user b ON a . user_name = b . user_name WHERE a . id <> b . id

Find duplicate users by name with this query.. SELECT a . name FROM tbl_users a INNER JOIN tbl_users b ON a . name = b . name WHERE a . id <> b . id LIMIT 0 , 30

Returning the last row of each GROUP BY in MySQL with WHERE clause: "SELECT * FROM foo WHERE id IN ( SELECT Max ( id ) FROM foo WHERE value = 'XYZ' GROUP BY u_id ) LIMIT 0 , 30"

Simplest way to fetch second max salary & nth salary "select DISTINCT ( salary ) from employee order by salary desc limit 1 , 1"   Note: limit 0 , 1 - Top max salary limit 1 , 1 - Second max salary limit 2 , 1 - Third max salary limit 3 , 1 - Fourth max salary

Include library <script src = "js/jquery.min.js" ></script> <script src = "js/jquery.validate.js" ></script> <?php $_SESSION [ 'code' ]= rand ( 1000 , 2000 ); ?>   <form name = "form-signup" id = "form-signup" method = "post" > <table width = "50%" > <tr> <td> Name </td> <td><input type = "text" name = "name" id = "name" class = "change" ></td> </tr> <tr> <td> Email </td> <td><input type = "text" name = "email" id = "email" class = "change" ></td> </tr> <tr> <td> Username </td> <td><input type = "text" name = "username" id = "username" class = "chan...

PHP REGISTRATION & LOGIN DEMO CODEIGNITER LOGIN & CRUD DEMO CRUD DEMO 2 CI CRUD WITH BOOSTTRAP LARAVEL CRUD CI_LOGIN_CRUD_LATEST EMAIL_SEND_CI

Jquery <script>     jQuery(document).ready(function(e)     {         jQuery(". check_all ").click(function()         {            jQuery(". all_checked ").attr('checked', $(this).is(':checked') ? true : false);         })     }); </script> HTML < input type = "checkbox" class = " check_all " / > < input type = "checkbox" class = " all_checked " / > < input type = "checkbox" class = " all_checked " / > < input type = "checkbox" class = " all_checked " / >  

Dynamic seo friendly url in asp.net Website development in pune

" Drag, Drop, Sort, Save "  Drag & Drop : Move the draggable element by clicking on it with the mouse and dragging it anywhere within the viewport. Sor t: The sort order can be either alphabetic or numeric, and either ascending or descending.       Here we had created demo that allow the user to drag and drop elements and quickly  and save them with PHP + MySQL+ AJAX +JQUERY on the server side. Table of content 1) Drag and drop element on every click 2) Sort data on the server side using PHP+MYSQL 3) Great user interface and  easy to execute with a few lines of code    

        CRUD with image upload is a very common task in web development ( CRUD stands for Create/Read/Update/Delete ). The main purpose of a CRUD is that enables user’s create/read/update/delete data using PHP & MYSQL. Table of Content Create Database Insert Record with image upload Show Record Edit Record Delete Record