Monday, January 3, 2011

2nd heighest Salary

CREATE TABLE IF NOT EXISTS `employee` (
  `Eid` int(11) DEFAULT NULL,
  `Name` varchar(10) DEFAULT NULL,
  `Salary` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Employee`
--

INSERT INTO `Employee` (`Eid`, `Name`, `Salary`) VALUES
(1, 'harry', '3500'),
(2, 'jack', '2500'),
(3, 'john', '2500'),
(4, 'xavier', '5500'),
(6, 'susana', '2400'),
(0, 'hgfgn', '3500'),
(8, 'hh', '3400'),
(9, 'hgfgn', '3500'),
(10, 'hh', '3500');


QUERY

SELECT *
FROM Employee
WHERE salary = (
SELECT Salary
FROM Employee
ORDER BY salary DESC
LIMIT 1 , 1 )


Output




1 harry 3500


0 hgfgn 3500



9 hgfgn 3500



10 hh 3500


 

Tuesday, September 21, 2010

send mail with attachment in php

<?php
 $fname = $cust_info['customers_firstname'] ;
 $lname = $cust_info['customers_lastname]'];
 $email = $cust_info['customers_email_address'];
 $address = $cust_info['customers_default_address_id'];
 $phone  = $cust_info['customers_telephone'] ;
 $fax = $cust_info['customers_fax'];
$body = "Name: $fname $lname\nPhone: $phone \nE-mail: $email \nFax: $fax ";
 $to=$_POST['admin_email'];
  $subject="Print Request ".$fame." ".$lname;
$from = $email;
 $mime_boundary="==Multipart_Boundary_x".md5(mt_rand())."x";
       // now we'll build the message headers
      $headers = "From: $from\r\n" .
       "MIME-Version: 1.0\r\n" .
          "Content-Type: multipart/mixed;\r\n" .
          " boundary=\"{$mime_boundary}\"";
       // here, we'll start the message body.
       // this is the text that will be displayed
       // in the e-mail
       $message=$body;
       // next, we'll build the invisible portion of the message body
       // note that we insert two dashes in front of the MIME boundary
       // when we use it
       $message = "This is a multi-part message in MIME format.\n\n" .
          "--{$mime_boundary}\n" .
          "Content-Type: text/plain; charset=\"iso-8859-1\"\n" .
          "Content-Transfer-Encoding: 7bit\n\n" .
       $message . "\n\n";
     foreach($_FILES as $userfile)
       {
          // store the file information to variables for easier access
          $tmp_name = $userfile['tmp_name'];
          $type = $userfile['type'];
          $name = $userfile['name'];
          $size = $userfile['size'];
          //echo $tmp_name."\n\n";
          // if the upload succeded, the file will exist
          if (file_exists($tmp_name))
          {
             // check to make sure that it is an uploaded file and not a system file
             if(is_uploaded_file($tmp_name))
             {
                // open the file for a binary read
                $file = fopen($tmp_name,'rb');
                // read the file content into a variable
                $data = fread($file,filesize($tmp_name));
                // close the file
                fclose($file);
                // now we encode it and split it into acceptable length lines
                $data = chunk_split(base64_encode($data));
             }
             // now we'll insert a boundary to indicate we're starting the attachment
             // we have to specify the content type, file name, and disposition as
             // an attachment, then add the file content.
             // NOTE: we don't set another boundary to indicate that the end of the
             // file has been reached here. we only want one boundary between each file
             // we'll add the final one after the loop finishes.
            $message .= "--{$mime_boundary}\n" .
                "Content-Type: {$type};\n" .
                " name=\"{$name}\"\n" .
                "Content-Disposition: attachment;\n" .
                " filename=\"{$fileatt_name}\"\n" .
                "Content-Transfer-Encoding: base64\n\n" .
             $data . "\n\n";
          }
       }
    // here's our closing mime boundary that indicates the last of the message
 /*     $message.="--{$mime_boundary}--\n";
       // now we just send the message
       if (@mail($to, $subject, $message, $headers))
       {
    ?>
<script>
        alert("Mail Sent Successfully.");
     //document.location = "index.php";
       document.prints1.submit();
     </script>
<?php }
  else
   {
   ?>
<script>
     alert("Message Not Sent, Please Try Again.");
      document.location = "index.php";
      </script>
<?
}
*/

Thursday, September 16, 2010

php script to get alexa rank of your website

 <?php
function alexaRank($domain){
    $remote_url = 'http://data.alexa.com/data?cli=10&dat=snbamz&url='.trim($domain);
    $search_for = '<POPULARITY URL';
    if ($handle = @fopen($remote_url, "r")) {
        while (!feof($handle)) {
            $part .= fread($handle, 100);
            $pos = strpos($part, $search_for);
            if ($pos === false)
            continue;
            else
            break;
        }
        $part .= fread($handle, 100);
        fclose($handle);
    }
    $str = explode($search_for, $part);
    $str = array_shift(explode('"/>', $str[1]));
    $str = explode('TEXT="', $str);

    return $str[1];
}
echo alexaRank('www.cyfuture.com');
?>

Wednesday, September 15, 2010

Get all form element through JS

//call the ocg function with inout field action with str = this.form
function ocg(str){
var fname= str.name;
 var elem = str//document.getElementById('str').elements;

 var str1="";
 for(var i = 0; i < elem.length; i++)
 {

 if((elem[i].type=='radio'))
 {
 if(elem[i].checked){
 str1 += elem[i].name;
 str1 +=  elem[i].value ;
 str1 += "##";
  }
  }
  //selected value of select box
if(elem[i].type=='select-one'){
  //str1 +=  elem[i].type ;
  str1 += elem[i].name;
  str1 +=  elem[i].value ;
  str1 += "##";
  }
 }


if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","get.php?q="+escape(str1),true);
xmlhttp.send();
}


place the get.php at right location and print str in it

Tuesday, September 14, 2010

Date and Time handling in PHP/MySQL

Date and time can be inserted into mysql table in specific format only. But php will support different types of date and time formats.

So, we should convert the date and time from php into specific format before inserting the value into mysql table.

We can use the date() and strtotime() functions of the php to do it.

MySQL table will store and datetime correctly only when it is formatted as Y-m-d H:i:s.

(i-e) 4 digit year-2 digit month - 2 digit day blankspace 24hours hour:minute:seconds.

Refer the below sample code used for inserting datetime into mysql table.

- Assume that Date and time values are stored in two different variables($dateinput,$timeinput) in php.
- First we need to concatenate both date and time to get single string.
- Then use strtotime() to convert this single string into time data which can be formatted using date() function to get required format.

$dateinput="02/14/2009";
$timeinput="10:30 pm";
$dt1=date( "Y-m-d H:i:s",strtotime($dateinput. " ".$timeinput));

$sql="insert into test (sttime) values ('$dt1')";
if (mysql_query($sql))
{
echo "successfully inserted";
}
else
{
echo mysql_error();
}

Similary strtotime() can be used to get previous and next days/weeks/months/years also.

For example below code will get the previous 1 week.

$fromDate=date("Y-m-d",strtotime($displayDate."-1 week"));