webspot@blogspot

Suppose you have all countries name in MySQL db table like: and you want to show some specific countries on top of the list and remaining countries will start after them. So this query can do it. SELECT * FROM countries ORDER BY country_name = 'Australia' desc,          country_name = 'United arab emirates' desc,          country_name = 'Pakistan' desc,          country_name = 'United kingdom' desc,          country_name = 'United states' desc,          country_name asc;

Follow this quick video  or At the bottom of the screen, on the left hand side there are 4 virtual buttons, Back, Home, Recent Apps and Menu. Menu is the one with 4 lines. Tap that and then there is an option to Sign Out.

If you try to use unlink in CI as $filestring  =  base_url ( ) . 'uploads/' . $ filename ; unlink  (  $filestring ) ; you will face such error message: A PHP Error was encountered Severity: Warning Message: unlink() [function.unlink]: http does not allow unlinking Filename: controllers/face.php Line Number: 109 because CI does not understand the  path we specified, therefore to remove a file we have to either use: $filestring  =  APPPATH . '../uploads/' . $filename ; unlink ($filestring) ; or   define ( 'PUBPATH' , str_replace ( SELF , '' , FCPATH ));  // in index.php and $filestring  =  PUBPATH . 'uploads/' . $ filename ;    // in controller

$( document ).ready(function() { $('#add').click(function() { return !$('#select1 option:selected').appendTo('#select2'); }); $('#remove').click(function() { return !$('#select2 option:selected').appendTo('#select1'); }); }); <div> Group 1:     <select multiple id="select1">         <option value="1">Ajax</option>         <option value="2">jQuery</option>         <option value="3">JavaScript</option>         <option value="4">Moo Tools</option>         <option value="5">Prototype</option>         <option value="6">Dojo</option>     </select>     <a href="#" id="add">add &gt;&gt;</a> </div> <div> Group 2:     <select multiple id="select2">         <op

Objective: Suppose you are required to create SEO friendly URLs with the merger of WP and CI, WP as front-end and CI as admin panel. You are adding projects with CI and showing detail of that project with WP. Steps: Code in controller (project.php) // create user friendly url string as per project name $pro_name = “new project name”; $pro_url = strtolower(str_replace(' ','-',trim($pro_name))); // insert in to wp_posts table $post = array( 'post_title' => $pro_name, 'post_name' => $pro_url, 'post_type' => 'page' ); $post_id = $this->utility_model->set('wp_posts', $post); // insert in to wp_postmeta table $postmeta = array( 'post_id' => $post_id, 'meta_key' => '_wp_page_template', 'meta_value' => 'project-detail.php' ); $this->utility_model->set('wp_postmeta', $postmeta); /* insert in to

In your email content add this code <img src="http://yourdomain.com/emailreceipt.php?receipt=<receiver_emailid" /> And in emailreceipt.php log it in to a database, although again this is restricted by the email client's ability to show images and sometimes it may even put the mail into junk because it doesn't detect an image... a workaround that would be to actually outputting an image (say your logo) at the end of that script.

Assuming that the attendance table has a date column attendance_date , the below query may give you total time utilized per week in the month: SELECT WEEK (` attendance_date `) ` attendance_week `, SEC_TO_TIME ( SUM ( TIME_TO_SEC (` time_utilize `))) ` attendance_time_utilized ` FROM ` attendance ` GROUP BY ` attendance_week `; In the above query, the attendance_week is calculated as the week of the year, between 1 and 52. Another form of output might be to show weeks as 1,2,3,4. For it, you may try this query: SELECT (` attendance_week ` - ` min_week ` + 1 ) ` att_week `, ` attendance_time_utilized `  FROM (  SELECT WEEK (` ATT `.` attendance_date `) ` attendance_week `,  SEC_TO_TIME ( SUM ( TIME_TO_SEC (` ATT `.` time_utilize `))) ` attendance_time_utilized `,   ` T1 `.` min_week `  FROM ` attendance ` ` ATT `   INNER JOIN ( SELECT MIN ( WEEK (` attendance_date `)) ` min_week ` FROM ` attendance `) T1  GROUP BY ` attendance_week ` ) T2 ;    H