Friday, May 25, 2018

PHP Mail Function Working with Bluehost server

Simple code for sending emails that worked is as follows:



<?php
$emailto = 'to@domain.com';
$emailfrom = 'from@domain.com';
$subject = 'Email Subject';
$messagebody = 'Hello.';
$headers =
'From: ' . $emailfrom.' . "\r\n" .
'Reply-To: ' . $emailto . ' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($emailto, $subject, $message, $headers);
?>
PHP mail code that works with Bluehost



<?php
$emailto = 'to@domain.com';
$toname = 'TO NAME';
$emailfrom = 'from@domain.com';
$fromname = 'FROM NAME';
$subject = 'Email Subject';
$messagebody = 'Hello.';
$headers =
'Return-Path: ' . $emailfrom . "\r\n" .
'From: ' . $fromname . ' <' . $emailfrom . '>' . "\r\n" .
'X-Priority: 3' . "\r\n" .
'X-Mailer: PHP ' . phpversion() .  "\r\n" .
'Reply-To: ' . $fromname . ' <' . $emailfrom . '>' . "\r\n" .
'MIME-Version: 1.0' . "\r\n" .
'Content-Transfer-Encoding: 8bit' . "\r\n" .
'Content-Type: text/plain; charset=UTF-8' . "\r\n";
$params = '-f ' . $emailfrom;
$test = mail($emailto, $subject, $messagebody, $headers, $params);
// $test should be TRUE if the mail function is called correctly
?>

Saturday, May 12, 2018

Download file using - PHP

            $backup = "Your file data";

            $folder = 'assets/db/';

            if (!is_dir($folder))
                mkdir($folder, 0755, true);

            $date = date('m-d-Y-H-i-s', time());
            $file_name = "filename-" . $date . '.sql';
            $file_url = $folder . $file_name;

            $handle = fopen($file_url, 'w+');

            fwrite($handle, $backup);
            fclose($handle);

            header('Content-Type: application/octet-stream');
            header("Content-Transfer-Encoding: Binary");
            header("Content-disposition: attachment; filename=\"" . $file_name . "\"");
            readfile($file_url);

Pagination in codeigniter

public function select_data() {
        $this->config->load('pagination');
        $config = $this->config->item('pagination_config');

        $offset = $this->input->post("p") ? $this->input->post("p") : 1;
        $per_page = $this->input->post("pp") ? $this->input->post("pp") : 10;

        $this->uri->assign_segments(3, $offset);

        $config['base_url'] = site_url('account/select_data');
        $config['total_rows'] = $this->account_model->count_row();
        $config['per_page'] = $per_page;
        $config['uri_segment'] = "3";

        $start = ($offset - 1) * $config['per_page'];

        $this->pagination->initialize($config);

        $data["pagination"] = $this->pagination->create_links();
        $data["total"] = $config['total_rows'];
        $data['start'] = $data["total"] ? $start + 1 : 0;
        $data['end'] = (($start + $config['per_page']) < $config['total_rows']) ? $start + $config['per_page'] : $config['total_rows'];
        $data['account'] = $this->account_model->get_all_account($config['per_page'], $start);
//        $data = $this->account_model->get_account();        
        $this->load->view('account_table', $data);
    }

Image/File Upload Using Ajax

Image Upload HTML

This code shows photo icon in the middle of a preview box and an upload button. On clicking the photo icon a transparent preview of the image will be displayed in the preview box. Then, this image will be uploaded to a folder on clicking the upload button. It shows a window overlay with a loader to represent that the image upload is in progress.
<div class="form-group">
    <label>Logo</label>                               
    <?php $logo = isset($data['logo']) && $data['logo'] ? $data['logo'] : '' ?>
    <div id="uploadImageBox">
        <div id="targetLayer" style="position:relative;display: inline-block">
            <span class="remove_btn <?php echo $logo ? '' : 'hidden'; ?>" onclick="remove_image($(this))">&times;</span>
            <img src="<?php echo $logo ? base_url("assets/upload/customer/$logo") : base_url("assets/admin/img/no_image.jpg"); ?>" style="height:80px; width: 80px;" />
        </div>
        <input type="hidden" name="old_image" id="old_image" value="<?php echo $logo; ?>">
        <input type="hidden" name="remove_image" id="remove_image" value="">
        <div class="icon-choose-image" >
            <input name="userImage" id="userImage" type="file" class="inputFile" onChange="showPreview(this);" />
        </div>
    </div>
    <div class="error text-danger" id='logo_error'></div>
</div>


Uploading Image and Showing Preview using jQuery AJAX
This script contains a jQuery function showPreview(). It will be called when selecting the image file to be uploaded. This function is used to show a transparent preview of the selected image before upload.
<script type="text/javascript">
    var no_img = "<?php echo base_url("assets/admin/img/no_image.jpg"); ?>";
    function showPreview(objFileInput) {
        if (objFileInput.files[0]) {
            var fileReader = new FileReader();
            fileReader.onload = function (e) {
                $("#targetLayer").html('<img src="' + e.target.result + '" width="80px" height="80px" class="upload-preview" />');
                $("#targetLayer").css('opacity', '0.7');
                $(".icon-choose-image").css('opacity', '0.5');
                $("#targetLayer").append('<span class="remove_btn" onclick="remove_image($(this))">&times;</span>');
            }
            fileReader.readAsDataURL(objFileInput.files[0]);
        } else {
            $("#targetLayer").html('<img src="' + no_img + '" width="80px" height="80px" class="upload-preview" />');
        }
    }

    function remove_image(ele) {
        $('#userImage').val('');
        ele.closest('div').find('img').attr('src', no_img);
        ele.closest('#uploadImageBox').find('#remove_image').val(ele.closest('#uploadImageBox').find('#old_image').val());
        ele.closest('#uploadImageBox').find('#old_image').val('');
        ele.remove();
    }
</script>
 On clicking the upload button, it submits the form data to PHP via jQuery AJAX.In PHP code, it uploads the image to the target folder and returns the image HTML as an AJAX response. This AJAX response HTML will be added to the preview box.
<script type="text/javascript">
$(document).ready(function (e) {
 $("#uploadForm").on('submit',(function(e) {
  e.preventDefault();
  $.ajax({
         url: "upload.php",
   type: "POST",
   data:  new FormData(this),
   beforeSend: function(){$("#body-overlay").show();},
   contentType: false,
   processData:false,
   success: function(data){
           $("#targetLayer").html(data);
           $("#targetLayer").css('opacity','1');
           setInterval(function() {$("#body-overlay").hide(); },500);
   },
   error: function(){
   }          
  });
 }));
});
</script>

CSS

            .remove_btn{
                position: absolute;
                right: 0;
                height: 20px;
                width: 20px;
                background: red;
                text-align: center;
                color: #fff;
                font-size: 15px;
                font-weight: 700;
            }

Controller Code
//upload configuration
$upload_path = FCPATH . 'assets/upload/customer/';
$config['upload_path'] = $upload_path;
$config['allowed_types'] = 'gif|jpg|jpeg|png';
$config['max_size'] = 1024;
$this->load->library('upload', $config);
//upload file to directory
if (empty($_FILES['userImage']['name']) || $this->upload->do_upload('userImage')) {
    /*
     * insert file information into the database
     * .......
     */
    $uploadData = $this->upload->data();
    $logo = $uploadData['file_name'];
    $old_image = $this->input->post('old_image') ? $this->input->post('old_image') : '';
    $remove_image = $this->input->post('remove_image') ? $this->input->post('remove_image') : '';
    if ((!empty($logo) && file_exists($upload_path . $old_image)) || ($remove_image && file_exists($upload_path . $remove_image)) ) {
         $old_image  ? @unlink($upload_path.$old_image) : @unlink($upload_path.$remove_image);
    }
   //write hear any database code or anything you need...
} else {
    $result['status'] = 'validation';
    $result['logo'] = $this->upload->display_errors();
}




Friday, May 11, 2018

Database Backup using php Mysql


//Backup Manually
$dbHost = 'localhost';
$dbName = 'billing';
$dbUsername = 'root';
$dbPassword = '';
$tables = '*';
$return = '';
$folder = "db_backup/";

//connect & select the database
$db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);

//get all of the tables
if ($tables == '*') {
    $tables = array();
    $result = $db->query("SHOW TABLES");
    while ($row = $result->fetch_row()) {
        $tables[] = $row[0];
    }
} else {
    $tables = is_array($tables) ? $tables : explode(',', $tables);
}

//loop through the tables
foreach ($tables as $table) {
    $result = $db->query("SELECT * FROM $table");
    $numColumns = $result->field_count;

    $return .= "DROP TABLE IF EXISTS $table;";

    $result2 = $db->query("SHOW CREATE TABLE $table");
    $row2 = $result2->fetch_row();

    $return .= "\n\n" . $row2[1] . ";\n\n";

    for ($i = 0; $i < $numColumns; $i++) {
        while ($row = $result->fetch_row()) {
            $return .= "INSERT INTO $table VALUES(";
            for ($j = 0; $j < $numColumns; $j++) {
                $row[$j] = addslashes($row[$j]);
                $row[$j] = preg_replace("/\n/", "/\\n/", $row[$j]);
                if (isset($row[$j])) {
                    $return .= '"' . $row[$j] . '"';
                } else {
                    $return .= '""';
                }
                if ($j < ($numColumns - 1)) {
                    $return .= ',';
                }
            }
            $return .= ");\n";
        }
    }

    $return .= "\n\n\n";
}

// Create Backup Folder
if (!is_dir($folder))
    mkdir($folder, 0775, true);
//chmod($folder, 0775);

$date = date('m-d-Y-H-i-s', time());
$filename = $dbName . "_" . $date . ".sql";
$path = $folder . $filename;

//save file
$handle = fopen($path, 'w+');
fwrite($handle, $return);
fclose($handle);

if (file_exists($path)) {
    header('Content-Description: File Transfer');
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename="' . basename($path) . '"');
    header('Expires: 0');
    header('Cache-Control: must-revalidate');
    header('Pragma: public');
    header('Content-Length: ' . filesize($path));
    readfile($path);
//            echo $return;
    exit;
}

NOTE: when you import this database into your phpmyadmin at that time uncheck the Enable foreign key checks 

Product Category Demo in laravel

https://drive.google.com/file/d/1kuyeT3LA22IuN3o_kypOyXesEXMLv31e/view?usp=sharing