PDF parsing using pdfparser

PdfParser, a standalone PHP library, provides various tools to extract data from a PDF file.
Currently, secured documents are not supported.

This Library is still under active development. As a result, users must expect BC breaks when using the master version.

Prerequisites

This library requires PHP 5.3.
PDFParser is built on top of TCPDF parser.
This library will be automatically downloaded through Composer command line.

Installation

Using Composer

Add PDFParser to your composer.json file :

{
    "require": {
        "smalot/pdfparser": "*"
    }
}

Now ask for composer to download the bundle by running the command:

$ composer update smalot/pdfparser

As standalone library

First of all, download the library from Github by choosing a specific release or directly the master.

Once done, unzip it and run the following command line using composer.

composer update

This command will download any dependencies (Atoum library) and create the 'autoload.php' file.

Now create a new file with this content, in the same folder :

<?php

// Include 'Composer' autoloader.
include 'vendor/autoload.php';

// Your code
// ...

?>

Unit tests with Atoum

Run Atoum unit tests (with code coverage - if xdebug installed) :

$ vendor/bin/atoum -d vendor/smalot/pdfparser/src/Smalot/PdfParser/Tests/

Once this command is ended, the folder "coverage/" will contain html pages with a code coverage summary.

Use

This sample will parse all the pdf file and extract text from each page.

<?php

// Include Composer autoloader if not already done.
include 'vendor/autoload.php';

// Parse pdf file and build necessary objects.
$parser = new \Smalot\PdfParser\Parser();
$pdf    = $parser->parseFile('document.pdf');

$text = $pdf->getText();
echo $text;

?>

You can too extract text from each page handly or for a specific page.

Download demo here

How do I enable functions, procedures, and triggers for my Amazon RDS MySQL instance?

Issue

I need to enable functions, procedures, and triggers for an instance of MySQL on Amazon RDS. How can I do this?

Short Description

To use functions, procedures, or triggers when binary logging is enabled requires the MySQL SUPER privilege, which is restricted for RDS MySQL DB instances.

You can can enable functions, procedures, and triggers when binary logging is enabled without the SUPER privilege by setting thelog_bin_trust_function_creators parameter to true for the DB parameter group that you create for your MySQL instance(s).

Note
A default DB parameter group is created if you create a DB instance without specifying a DB parameter group that you create. This group contains database engine defaults and Amazon RDS system defaults based on the engine, compute class, and allocated storage of the instance. You cannot modify the parameter settings of a default DB parameter group; you must create your own DB parameter group to change parameter settings from their default value. Note that not all DB engine parameters can be changed in a DB parameter group that you create.

Resolution

1. Create a DB parameter group for your MySQL instance:

1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/
2. In the navigation pane, choose Parameter Groups.
3. Choose Create Parameter Group. The Create Parameter Group window appears.
4. For Parameter Group Family, choose the parameter group family.
5. For Group Name, type the name of the new DB parameter group.
6. For Description, type a description for the new DB parameter group.
7. Choose Create.

Important
After you create a DB parameter group, you should wait at least 5 minutes before creating your first DB instance that uses that DB parameter group.

For more information about creating a DB parameter group, see Working with DB Parameter Groups - Creating a DB Parameter Group.

2. Modify the newly created parameter group and set the following parameter:

1. In the navigation pane, choose Parameter Groups. The available DB parameter groups appear in a list.
2. In the list, select the parameter group you want to modify.
3. Choose Edit Parameters and set the following parameter to the specified value:
       log_bin_trust_function_creators = 1
4. Choose Save Changes.

Important
After you modify a DB parameter group, you should wait at least 5 minutes before creating your first DB instance that uses that DB parameter group.

For information about modifiying a DB parameter group, see Working with DB Parameter Groups - Modifying Parameters in a DB Parameter Group.

3. Associate your RDS DB instance with the new or modified DB parameter group:

1. In the navigation pane, choose Instances.
2. Select the DB instance you want to associate with a DB parameter group.
3. On the Instance Actions menu, choose Modify.
4. In the Modify DB Instance dialog box, under Database Options, choose the parameter group you want to associate with the DB instance. Changing this setting does not result in an outage. The parameter group name changes immediately, but the actual parameter changes are not applied until you reboot the instance without failover.
5. Apply changes by rebooting the instance.

Keywords

Amazon RDS, MySQL, error 1419, create functions, super privilege, CURRENT_USER, stored procedure, DB parameter group, triggers, binary logging

PayUMoney payment gateway integration in php

Hello friends...

In this post i am going to explain how to setup PayUmoney payment gateway in your web application. Integration of PayU gateway is little confusing for first time and also some of my reader request me for this tutorial. Most of thing are  already in PayU documentation i am just going to explain it in step so you will easily integrate without reading whole document.

Steps for integration PayUMoney gateway.

Step 1. Go to https://test.payumoney.com/ and sign up as a merchant account.

Step 2. At time of sign up use your valid email.

Step 3. Fill all required business details. Use this details for PAN no. ABCDE1234F and DOB – 01/04/1990 .

Step 4. Add your bank detail, note you can add whatever bank name and details use this IFSC – ALLA0212632 in place of IFSC.

Step 5. Don’t worry about bank details verification this is your test account.

Step 6. Once your required steps are completed your account is live if not then write mail to support team : techsupport@payumoney.com

Step 7. Now once above steps are complete you can get your key go to Manage Account ⇒ My Account ⇒ Merchant -Key Salt copy your key and paste in your code.

Once you follow above step your setup for PayUMoney is complete.

Sample Code

index.php

<?php

// Merchant key here as provided by Payu

$MERCHANT_KEY = "hDkYGPQe";

// Merchant Salt as provided by Payu

$SALT = "yIEkykqEH3";

// End point - change to https://secure.payu.in for LIVE mode

$PAYU_BASE_URL = "https://test.payu.in";

$action = '';

$posted = array();

if(!empty($_POST)) {

    //print_r($_POST);

  foreach($_POST as $key => $value) {    

    $posted[$key] = $value; 

  }

}

$formError = 0;

if(empty($posted['txnid'])) {

  // Generate random transaction id

  $txnid = substr(hash('sha256', mt_rand() . microtime()), 0, 20);

} else {

  $txnid = $posted['txnid'];

}

$hash = '';

// Hash Sequence

$hashSequence = "key|txnid|amount|productinfo|firstname|email|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10";

if(empty($posted['hash']) && sizeof($posted) > 0) {

  if(

          empty($posted['key'])

          || empty($posted['txnid'])

          || empty($posted['amount'])

          || empty($posted['firstname'])

          || empty($posted['email'])

          || empty($posted['phone'])

          || empty($posted['productinfo'])

          || empty($posted['surl'])

          || empty($posted['furl'])

 || empty($posted['service_provider'])

  ) {

    $formError = 1;

  } else {

    //$posted['productinfo'] = json_encode(json_decode('[{"name":"tutionfee","description":"","value":"500","isRequired":"false"},{"name":"developmentfee","description":"monthly tution fee","value":"1500","isRequired":"false"}]'));

$hashVarsSeq = explode('|', $hashSequence);

    $hash_string = '';

foreach($hashVarsSeq as $hash_var) {

      $hash_string .= isset($posted[$hash_var]) ? $posted[$hash_var] : '';

      $hash_string .= '|';

    }

    $hash_string .= $SALT;

    $hash = strtolower(hash('sha512', $hash_string));

    $action = $PAYU_BASE_URL . '/_payment';

  }

} elseif(!empty($posted['hash'])) {

  $hash = $posted['hash'];

  $action = $PAYU_BASE_URL . '/_payment';

}

?>

<html>

  <head>

  <script>

    var hash = '<?php echo $hash ?>';

    function submitPayuForm() {

      if(hash == '') {

        return;

      }

      var payuForm = document.forms.payuForm;

      payuForm.submit();

    }

  </script>

  </head>

  <body onload="submitPayuForm()">

    <h2>PayU Form</h2>

    <br/>

    <?php if($formError) { ?>

      <span style="color:red">Please fill all mandatory fields.</span>

      <br/>

      <br/>

    <?php } ?>

    <form action="<?php echo $action; ?>" method="post" name="payuForm">

      <input type="hidden" name="key" value="<?php echo $MERCHANT_KEY ?>" />

      <input type="hidden" name="hash" value="<?php echo $hash ?>"/>

      <input type="hidden" name="txnid" value="<?php echo $txnid ?>" />

      <table>

        <tr>

          <td><b>Mandatory Parameters</b></td>

        </tr>

        <tr>

          <td>Amount: </td>

          <td><input name="amount" value="<?php echo (empty($posted['amount'])) ? '' : $posted['amount'] ?>" /></td>

          <td>First Name: </td>

          <td><input name="firstname" id="firstname" value="<?php echo (empty($posted['firstname'])) ? '' : $posted['firstname']; ?>" /></td>

        </tr>

        <tr>

          <td>Email: </td>

          <td><input name="email" id="email" value="<?php echo (empty($posted['email'])) ? '' : $posted['email']; ?>" /></td>

          <td>Phone: </td>

          <td><input name="phone" value="<?php echo (empty($posted['phone'])) ? '' : $posted['phone']; ?>" /></td>

        </tr>

        <tr>

          <td>Product Info: </td>

          <td colspan="3"><textarea name="productinfo"><?php echo (empty($posted['productinfo'])) ? '' : $posted['productinfo'] ?></textarea></td>

        </tr>

        <tr>

          <td>Success URI: </td>

          <td colspan="3"><input name="surl" value="<?php echo (empty($posted['surl'])) ? '' : $posted['surl'] ?>" size="64" /></td>

        </tr>

        <tr>

          <td>Failure URI: </td>

          <td colspan="3"><input name="furl" value="<?php echo (empty($posted['furl'])) ? '' : $posted['furl'] ?>" size="64" /></td>

        </tr>

        <tr>

          <td colspan="3"><input type="hidden" name="service_provider" value="payu_paisa" size="64" /></td>

        </tr>

        <tr>

          <td><b>Optional Parameters</b></td>

        </tr>

        <tr>

          <td>Last Name: </td>

          <td><input name="lastname" id="lastname" value="<?php echo (empty($posted['lastname'])) ? '' : $posted['lastname']; ?>" /></td>

          <td>Cancel URI: </td>

          <td><input name="curl" value="" /></td>

        </tr>

        <tr>

          <td>Address1: </td>

          <td><input name="address1" value="<?php echo (empty($posted['address1'])) ? '' : $posted['address1']; ?>" /></td>

          <td>Address2: </td>

          <td><input name="address2" value="<?php echo (empty($posted['address2'])) ? '' : $posted['address2']; ?>" /></td>

        </tr>

        <tr>

          <td>City: </td>

          <td><input name="city" value="<?php echo (empty($posted['city'])) ? '' : $posted['city']; ?>" /></td>

          <td>State: </td>

          <td><input name="state" value="<?php echo (empty($posted['state'])) ? '' : $posted['state']; ?>" /></td>

        </tr>

        <tr>

          <td>Country: </td>

          <td><input name="country" value="<?php echo (empty($posted['country'])) ? '' : $posted['country']; ?>" /></td>

          <td>Zipcode: </td>

          <td><input name="zipcode" value="<?php echo (empty($posted['zipcode'])) ? '' : $posted['zipcode']; ?>" /></td>

        </tr>

        <tr>

          <td>UDF1: </td>

          <td><input name="udf1" value="<?php echo (empty($posted['udf1'])) ? '' : $posted['udf1']; ?>" /></td>

          <td>UDF2: </td>

          <td><input name="udf2" value="<?php echo (empty($posted['udf2'])) ? '' : $posted['udf2']; ?>" /></td>

        </tr>

        <tr>

          <td>UDF3: </td>

          <td><input name="udf3" value="<?php echo (empty($posted['udf3'])) ? '' : $posted['udf3']; ?>" /></td>

          <td>UDF4: </td>

          <td><input name="udf4" value="<?php echo (empty($posted['udf4'])) ? '' : $posted['udf4']; ?>" /></td>

        </tr>

        <tr>

          <td>UDF5: </td>

          <td><input name="udf5" value="<?php echo (empty($posted['udf5'])) ? '' : $posted['udf5']; ?>" /></td>

          <td>PG: </td>

          <td><input name="pg" value="<?php echo (empty($posted['pg'])) ? '' : $posted['pg']; ?>" /></td>

        </tr>

        <tr>

          <?php if(!$hash) { ?>

            <td colspan="4"><input type="submit" value="Submit" /></td>

          <?php } ?>

        </tr>

      </table>

    </form>

  </body>

</html>

success.php

<?php

$status=$_POST["status"];

$firstname=$_POST["firstname"];

$amount=$_POST["amount"];

$txnid=$_POST["txnid"];

$posted_hash=$_POST["hash"];

$key=$_POST["key"];

$productinfo=$_POST["productinfo"];

$email=$_POST["email"];

$salt="yIEkykqEH3";

If (isset($_POST["additionalCharges"])) {

       $additionalCharges=$_POST["additionalCharges"];

        $retHashSeq = $additionalCharges.'|'.$salt.'|'.$status.'|||||||||||'.$email.'|'.$firstname.'|'.$productinfo.'|'.$amount.'|'.$txnid.'|'.$key;

        

                  }

else {  

        $retHashSeq = $salt.'|'.$status.'|||||||||||'.$email.'|'.$firstname.'|'.$productinfo.'|'.$amount.'|'.$txnid.'|'.$key;

         }

$hash = hash("sha512", $retHashSeq);

 

       if ($hash != $posted_hash) {

      echo "Invalid Transaction. Please try again";

  }

  else {

              

          echo "<h3>Thank You. Your order status is ". $status .".</h3>";

          echo "<h4>Your Transaction ID for this transaction is ".$txnid.".</h4>";

          echo "<h4>We have received a payment of Rs. " . $amount . ". Your order will soon be shipped.</h4>";

           

  }         

?>

failure.php

<?php

$status=$_POST["status"];

$firstname=$_POST["firstname"];

$amount=$_POST["amount"];

$txnid=$_POST["txnid"];

$posted_hash=$_POST["hash"];

$key=$_POST["key"];

$productinfo=$_POST["productinfo"];

$email=$_POST["email"];

$salt="yIEkykqEH3";

If (isset($_POST["additionalCharges"])) {

       $additionalCharges=$_POST["additionalCharges"];

        $retHashSeq = $additionalCharges.'|'.$salt.'|'.$status.'|||||||||||'.$email.'|'.$firstname.'|'.$productinfo.'|'.$amount.'|'.$txnid.'|'.$key;

        

                  }

else {  

        $retHashSeq = $salt.'|'.$status.'|||||||||||'.$email.'|'.$firstname.'|'.$productinfo.'|'.$amount.'|'.$txnid.'|'.$key;

         }

$hash = hash("sha512", $retHashSeq);

  

       if ($hash != $posted_hash) {

      echo "Invalid Transaction. Please try again";

  }

  else {

         echo "<h3>Your order status is ". $status .".</h3>";

         echo "<h4>Your transaction id for this transaction is ".$txnid.". You may try making the payment by clicking the link below.</h4>";

} 

?>

<!--Please enter your website homepagge URL -->

<p><a href=http://localhost/testing/success_failure/PayUMoney_form.php> Try Again</a></p>

Above code is also available in sdk you download from PayUMoney you need to replace key with your key. To test this code you can fill form and after that when you redirects to PayUMoney Payment gateway select debit card and enter bellow details in it:

Test Card Number: 5123456789012346
Test CVV: 123
Test Expiry: May 2017

Hope this help you. :)