Thursday, March 31, 2016

MySQL Trigger

CREATE TRIGGER `posttrigger` AFTER INSERT ON `posts`
FOR EACH ROW INSERT INTO posts2(postTitle, postBody) VALUES( NEW.postTitle,New.postBody)

Trigger is created on table posts. If data is inserted in posts, some other data (as defined in the trigger) is inserted in 'posts2' table;

Tuesday, March 29, 2016

error 1

ErrorException [ Warning ]: Creating default object from empty value

Probably you are not using Controller_Template

Form Validation

Controller file:project/test.php
======================
url: localhost/project/test/login

public function action_login(){
if($this->request->method()=='POST'){
$validatedData=Validation::factory($_POST)
->rule('password','not_empty')
->rule('password','min_length', array(':value',6));
if($validatedData->check()){
$logged_in=$this->password=$this->request->post('password');
$this->response->body(View::factory('afterlogin'));
}else {
$err= $validatedData->errors('post'); //Capture errors
$user_input=$_POST; //capture user input because we are going to return to the login page retaining the user input
}
}
$this->response->body(View::factory('login')->bind('error',$err)->bind('user_input',$user_input));
}

view file: login.php

==============

<?= Arr::get($error,'Success')?>

<?= Form::open('test/login',array('method'=>'post')); ?>

<hr>

<p>

<?= Form::label('password','Type Password: ',array('class'=>'test')); ?>

<?= Form::input('password',$user_input['password'],array('class'=>'test','type'=>'password')); ?>

<?= Arr::get($error,'password'); ?>

<?= Form::input('submit',NULL,array('type'=>'submit')); ?>

<?= Form::close(); ?>

Miscellaneous

echo URL::base();

Echo in ternary operator

echo isset($logged_in) ? "You have successfully logged in with password <h1>$logged_in</h1>." : "Try Again" ;

Redirect

HTTP::redirect('test');

Here 'test' is the name of the controller.

Validation - min_length

->rule('password','min_length', array(':value',6));

Sunday, March 27, 2016

Kohana Join Query

public function action_joinquery()
{
$data=DB::select('posts.postTitle','posts.postBody','authors.author_name')
->from('posts')
->join('authors')->on('posts.authorId','=','authors.author_id')
->execute();
// echo Debug::dump( $q);
echo View::factory('database')>bind('data',$data);
}

Kohana Query

public function action_query2()
{ $q=DB::select()->from('posts')->execute(); echo Debug::dump( $q);
}

Saturday, March 26, 2016

Kohana config

create a file named whatever you like in Application/config folder with following code:

<?php defined('SYSPATH') or die('No direct script access.');
return array(
'name' => 'William',
'Quote' => "To be or not to be."
);

Create an action method (function) in the controller (test.php) like so:

public function action_configtest()
{
echo Kohana::$config->load('myconfig.name');
}

Hit the url: http://localhost/project/test/configtest. You should see 'William' on the screen.

Like get, you can set a config variable:
public function action_configtest()
{

Kohana::$config->load('myconfig')->set('einstein','e=mc^2');
echo Kohana::$config->load('myconfig')->get('einstein');
}

Hit the url: http://localhost/project/test/configtest. You should see 'e=mc^2' on the screen.

Friday, March 25, 2016

Connecting to database, run a query and view the result

Create a controller file named test.php in the application/classes/controller folder and type the following code:

<?php defined('SYSPATH') or die('No direct script access.');
class Controller_Test extends Controller_Template {

public function action_database()
{
$p = DB::select()->from('posts')->execute();
echo View::factory('database')->bind('data',$p);
}

}

Now we need to create a view file named database.php in the views folder. So, create the database.php file and paste the following code:

<!DOCTYPE html>
<html>
<head>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet" integrity="sha256-7s5uDGW3AHqw6xtJmNNtr+OBRJUlgkNJEo78P4b0yRw= sha512-nNo+yCHEyn0smMxSswnf/OnX6/KwJuZTlNZBjauKhTK0c+zT+q5JOCx0UFhXQ6rJR9jg6Es8gPuD2uZcYDLqSw==" crossorigin="anonymous">

<link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.11/css/jquery.dataTables.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
<script type="text/javascript" src="//cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"></script>
<title><?php echo 'title' ;?></title>
<style type="text/css">
body{
background-color: #eee;
}
</style>
</head>
<body>

<div class="container">
<h2> Table Explorer </h2>
<h4>Pass me all data from a table and I shall show you all fields and its value.</h4>
<code>for example, following code was used in a Controller and then data passed to me:
<br>
$allUsers = DB::select()->from('users')->execute();
<br>
$this->response->body(View::factory('users')->bind('data',$allUsers));
</code>

<table id="mt" class="table table-responsive table-striped">
<?php
$i = 0;
$firstRow=$data[0];
?>
<thead>
<?php
foreach($firstRow as $key => $value):
echo "<th>". $key . "</th>";
endforeach;
?>
</thead>

<?php
foreach($data as $point):
echo "<tr>";
foreach($point as $key => $value):
echo "<td>". $value . "</td>";
endforeach ;
echo "</tr>";
endforeach ; ?>
</table>

</div>
</body>
<style type="text/css">

table{
margin-top: 5%;
background-color: #ddd;
border-radius:2px;
}

</style>

<script>
$(document).ready(function(){
$('#mt').DataTable();
// alert('Google');
});

</script>
</html>

Thursday, March 24, 2016

Creating a Kohana Module

Creating a Kohana module is simple. In this post we shall create a very basic Kohana 3 module, activate it and use it.

Let's say the name of our module is "Olive".

1. Create a folder named 'olive' in the modules folder.
2. Create a folder named 'classes' in 'olive' folder.
3. Create a file named olive.php in the classes folder.

Type the following code in 'olive.php' file:

<?php defined('SYSPATH') or die('No direct script access.');

class Olive {
function index()
{
echo "Hello from Olive Module";
}

static function pickle()
{
return "We have been making and serving Olive Pickles for the world since 1867";

}
static function oil()
{
return "We have been making and serving Olive Oil for the world since 1867";
}
}
?>

Kohana will look for olive.php file in modules/olive/classes folder.

Enable the Olive module in bootsrap.php file:

Now let's use the module in a controller. Create a file named OliveTest.php in application/classes/controller folder and type the following code in that file:

<?php defined('SYSPATH') or die('No direct script access.');
class Controller_OliveTest extends Controller_Template {

public function action_index()
{
echo "<h1>Welcome to Olive Module</h1>";
}

public function action_oil()
{
echo Olive::oil();
}

}

Point your browser to this url: http://localhost/project/olivetest/

You should see:

Welcome to Olive Module

Point your browser to this url: http://localhost/project/olivetest/oil

You should see:
We have been making and serving Olive Oil for the world since 1867

Further Experiment
------------------------
Now create a folder named 'controller' in the classes folder and copy the olive.php file in the controller folder. Add 'Controller_' before 'olive; in the class declaration file so that it looks like this: class Controller_Olive {

Point to url: http://localhost/project/olivetest/oil

You should get a Fatal error:

ErrorException [ Fatal Error ]: Class 'Olive' not found

That is because name of the class is now Controller_Olive. But, in the controller file named test.php, you are calling the controller as 'Olive'. We need to correct this. Go to test.php and edit the action_oil function like so:

public function action_oil()
{
echo Controller_Olive::oil();
}

Point to url: http://localhost/project/olivetest/oil. Everything should be okay.

Tuesday, March 22, 2016

Run MYSQL and import Large Data.

Windows 7
==========
Go to DOS prompt by typing cmd on Windows Start menu

cd C:\xampp\mysql\bin>
mysql

show databases
you are not logged in a administrator. to do so type \q

mysql -u root
show databases

use babycard
source E:\Babytika\windmill_babycard-app.sql

Monday, March 21, 2016

Kohana : PHP to PDF

public function action_PdfDownload()
{
$pdf=new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',16);
$pdf->Cell(40,10,'Hello World!');
$pdf->Output();

}

Kohana - Change Header

$this->response->headers('Content-Type', 'application/pdf');

PHPMailer

public function action_email()
   {
                //Download this PHPMailer module from https://github.com/PHPMailer/PHPMailer

                // mail send process start

                require DOCROOT."modules/PHPMailer/PHPMailerAutoload.php";

                $mail = new PHPMailer;
                $mail->isSMTP();                                   // Set mailer to use SMTP
                $mail->Host = 'dilir.me'; // Specify main and backup SMTP servers
                $mail->SMTPAuth = true;                            // Enable SMTP authentication
                $mail->Username = 'info@dilir.me';                 // SMTP username
                $mail->Password = '***';                  // SMTP password
                $mail->SMTPSecure = '';                            // Enable TLS encryption, `ssl` also accepted
                $mail->Port = 25;                                  // TCP port to connect to

                $mail->setFrom('info@dilir.me', 'Mailer');
                $mail->addAddress('dilir.khan@gmail.com', 'Dilir');     // Add a recipient
                $mail->addReplyTo(dilir.khan@gmail.com', 'Dilir');
                $mail->addCC('cc@example.com');
                //$mail->addBCC('bcc@example.com');

                $mail->addAttachment(DOCROOT . 'documents/title.pdf'); // Add attachments
                $mail->isHTML(true);                                  // Set email format to HTML

                $mail->Subject = 'PHP Mailer Implementation';
                $mail->Body    = 'Yes, I was able to send email using PHPMailer again. Check attachment.';
                $mail->AltBody = 'Yes, I was able to send email using PHPMailer again. Check attachment.';

                if(!$mail->send()) {
                    echo 'Message could not be sent.';
                    echo 'Mailer Error: ' . $mail->ErrorInfo;
                } else {
                    echo 'Message has been sent. Check attachment.';
                }


                // mail sent process end

   }

Add to trusted hosts

 
// application/config/url.php 

return array(

    'trusted_hosts' => array(

        'dilir\.me',

    ),

);

URL troubleshoot

I was not being able to correctly refer to the PHPMailerAutoload.php file. I needed to do this for sending email from my site.

Here is the ultimate solution:
require DOCROOT."modules/PHPMailer/PHPMailerAutoload.php";

Complete Site URL

public function action_site()
    {
        echo URL::base(true);
    }

Output: http://localhost/test/

Sunday, March 20, 2016

Validation Factory - Easy validation

public function action_validate()
{
$name= "Venus";
$id=2;
$validate=Validation::factory(array(
'name'=> "Venus",
'id'=>2
))
->rule('name','not_empty')
->rule('name','in_array',array(':value',array('Sun','Venus','Jupiter')))
->rule('id','not_empty')
->rule('id','is_numeric');

if($validate->check()){
echo "'$name',$id From Dilir Module(Dilir/Dilir/dance)";
}

}

Eliminate the extra index.php from Kohana url

By default you need to add index.php to call a Controller and action method. This becomes painful. The solution is to:

Create .htaccess file with the following content and place it in the root folder of Kohana project

RewriteEngine On

RewriteRule ^(application|modules|system) - [F,L]

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule .* /gppprocess/index.php/$0 [PT,L]

Create an Excel file from PHP

<?php

function toExcel()
{
//Download PZHPExcel from https://phpexcel.codeplex.com/# and make sure you include the PHPExcel.php
include_once "classes/PHPExcel.php" ;
$sheet = new PHPExcel();
$activeSheet= $sheet->getActiveSheet();
$activeSheet->setCellValue("A1","SL#");
$activeSheet->setCellValue("B1","Name");
$activeSheet->setCellValue("C1","Mobile Number");
$activeSheet->setCellValue("D1","Image");

header("Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
header("Content-disposition: attachment; filename='report.xlsx'");
$xlWriter = PHPExcel_IOFactory::createWriter($sheet, 'Excel2007');
$xlWriter->save('php://output');
exit;
}

//Call the function
toExcel();
?>

Printing base64 encoded image

The image get printed because of the HTML code followed by the image.