Tuesday 30 June 2015

Send Mail From Localhost Using Codeigniter

To Send Mail From Localhost Using Codeigniter follow the steps

First:

Create a file named as "email.php" in "application/config" (to autoload the file)

<?php
    $config['protocol'] = 'smtp';
    $config['smtp_host'] = 'ssl://smtp.gmail.com';
    $config['smtp_port'] = '465';
    $config['smtp_user'] = 'yourmail@gmail.com'; //change this
    $config['smtp_pass'] = 'yourmailpassword'; //change this
    $config['mailtype'] = 'html';
    $config['charset'] = 'iso-8859-1';
    $config['wordwrap'] = TRUE;
    $config['newline'] = "\r\n"; //use double quotes to comply with RFC 822 standard
?>


Second:


Create a controller file named as "Sendmail" in controller folder and paste the following code;

<?php

 class Sendmail extends CI_Controller {

      function index()
      {
        $configs = array(
                'protocol'  =>  'smtp',
                'smtp_host' =>  'ssl://smtp.gmail.com',
                'smtp_user' =>  'yourmail@gmail.com',
                'smtp_pass' =>  'yourmailpassword',
                'smtp_port' =>  '465'
            );
        $this->load->library("email", $configs);
        $this->email->set_newline("\r\n");
        $this->email->from('yourmail@gmail.com', 'Bharat Prajapat');
        $this->email->to('yourmail@gmail.com');       
        $this->email->subject("This is Test Subject.");
        $this->email->message("Body of the Message");
        if($this->email->send())
        {
            echo "Done!";  
        }
        else
        {
            echo $this->email->print_debugger();   
        }
      }
 }
?>


It's Done check you mail

Thursday 4 June 2015

How to Reload Page on Anchor or label click ??

How to Reload Page on click??



Html Code:

<div id="test">
    <p>this is test.</p>
    <p id="closeAuction">Reload Page<p>
</div>




Jquery Code:

 $(document).ready(function() {
         $('#closeAuction').click(function() {
        location.reload();    
     });   
   });  




For Live Demo Click Here Live Demo 



How to Generate Serial Number or Complaint Number in Series ??

How to Generate Serial Number or Complaint Number in Series ??

Like:   

A000000000     A000000001    A000000002    A000000003    A000000004    A000000005   A000000006    A000000007    A000000008    A000000009    A000000010    A000000011   A000000012    A000000013    A000000014    A000000015    and so on

Html:


<form method="post" action="serialnumber.php">
    Name : <input type="text" name="name" value="" />
    <input type="submit" value="Save" name="save" />
</form>


Php Code:


<?php
    $con=mysql_connect('localhost','root','');
    mysql_select_db('serialnumber_db',$con);
   

    if(isset($_POST['save']))
    {
        $qr="select sn from serialnumber";
       
        $result=mysql_query($qr);
        if(mysql_num_rows($result)<=0)
        {
            $serialNo='A000000000';
        }   
        else
        while($data=mysql_fetch_array($result))
        {
            $cur_ser=$data['sn'];
            if($cur_ser=='')
            {
                $serialNo='A000000000';
            }
            else
            {
                $serialNo=++$cur_ser;
            }
        }
        $name=$_POST['name'];
        $sql="INSERT INTO `serialnumber`(`name`, `sn`) VALUES ('$name' , '$serialNo')";
        $res=mysql_query($sql);
        if($res)
        {
            echo "Saved";
            $query="select * from serialnumber";
            $res=mysql_query($query);
            if($res)
            {
                echo "<table><tr><th>S.no.</th><th>Name</th></tr>";
                while($data=mysql_fetch_array($res))
                {
                    echo "<tr><td>$data[sn]</td><td>$data[name]</td></tr>";
                }
                echo "</table>";
            }
        }
        else
        {
            die (mysql_error());
        }
    }
?>



Database Table:

First create New Database with "serialnumber_db" Name

Second Create table as :

CREATE TABLE IF NOT EXISTS `serialnumber` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `sn` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;



So it will result as :



S.no.Name
A000000000ajay
A000000001amar
A000000002amit
A000000003vikas
A000000004madhuri
A000000005mayak
A000000006avinash
A000000007durgesh
A000000008charu
A000000009aman
A000000010vijay
A000000011rohit
A000000012ritesh
A000000013raman
A000000014prachi
A000000015manish