Codesign House Blog

02

Jan

HSBC - MIGS Payment Gateway Integration - PHP

When you receiving the set of document from the HSBC for the MIGS payment gateway you will feel OMG!!!

But after gone through them and had a very tough time to integrate this to one of the site. but finally when we look at that it looks like a very easy one.

So i thought to share it with all to make your life Easy.

here is the source :
________________________________________________________________
$testarr = array(
"vpc_Amount" => $finalprice*100,//Final price should be multifly by 100
"vpc_AccessCode" => "1234ABCD",//Put your access code here
"vpc_Command"=> "pay",
"vpc_Locale"=> "en",
"vpc_MerchTxnRef"=> "CLI".$session_id, //This should be something unique number, i have used the session id for this
"vpc_Merchant"=> "TEST111111111111",//Add your merchant number here
"vpc_OrderInfo"=> "XXX".$session_id,//this also better to be a unique number
"vpc_ReturnURL"=> "http://mysite.com/response.php",//Add the return url here so you have to code here to capture whether the payment done successfully or not
"vpc_Version"=> "1");

ksort($testarr); // You have to ksort the arry to make it according to the order that it needs

$SECURE_SECRET = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX";//Add the secure secret you have get

$securehash = $SECURE_SECRET;
$url = "";
foreach ($testarr as $key => $value)
{
$securehash .= $value;
$url .= $key."=".urlencode($value)."&";
}

$securehash = md5($securehash);//Encoding
$url .= "vpc_SecureHash=".$securehash;

header("location:https://migs.mastercard.com.au/vpcpay?$url");
_____________________________________________________________

That's it guyz..

Post By Charitha Ranasingha, HSBC

31

Aug

How to import a very large MySQL DB to local phpmyadmin (Wamp + Windows)

Unlike in linux OS sometimes you may feel very hard to import a big sized mysql backup to your local machine. So here is an one workaround for that.

First find the config.inc.php file located in the phpmyadmin directory. In my case it is located here:
C:\wamp\apps\phpmyadmin3.5.1\config.inc.php
Find the line with $cfg['UploadDir'] on it and update it to: $cfg['UploadDir'] = 'upload'; (Sometimes if you search for the $cfg['UploadDir'] by ctrl+f in that file you may not see it, Just scroll down and find it. Check the image below.
Create a directory called ‘upload’ within the phpmyadmin directory. (C:\wamp\apps\phpmyadmin3.5.1\upload\)
Then place the large sql file that you are trying to import into the new upload directory.
Now go the phpmyadmin of your machine (localhost/phpmyadmin or 127.0.0.1/phpmyadmin/) and go to the db import page
You will notice a new drop down is created there and you can select the placed DB from that drop down (Check the image below).
And then click on GO at the bottom of the import page

That's it guyz :)

Post By Charitha Ranasingha, MySQL

27

Jun

ORDER BY Problem in UNION Query

Sometimes when you are doing query you may need to UNION 2 queries and order the results by one column. We cannot do that with the column name

Wrong way

SELECT name,city FROM students where age > 10
UNION
SELECT name,city FROM teachers where age > 20
ORDER BY city

Correct way

SELECT name,city FROM students where age > 10
UNION
SELECT name,city FROM teachers where age > 20
ORDER BY 2

From number 2 we are mentioning the position of the required column that needs to be order

Post By Charitha Ranasingha, SQL

06

May

To check whether a field contain duplicate values in the database via sql query

Using below queries you can get the duplicate name field details of names table

SELECT id, name, COUNT( name)
FROM names
GROUP BY name
HAVING (
COUNT( name) >1
)

Post By Charitha Ranasingha, SQL

04

Mar

Replace a text with something else by a SQL Query

Syntax :

UPDATE Table SET Column = Replace(Column, 'find value', 'replacement value') WHERE xxx

Example :

UPDATE `links` set url = replace (url,'http://www.google.com','http://www.yahoo.com') where url != ''

Post By Charitha Ranasingha, SQL

06

Dec

Automatic form submission after specified time using javascript

Put following code after your form closing tag

<script language="Javascript">
function doSubmit() {
//asubmit is the name of the SUBMIT button in the form
document.yourForm.asubmit.click();
}
//auto submit after 5 second
setTimeout("doSubmit()",5000);
</script>

Post By Charitha Ranasingha,

21

Nov

How to get an image width and height by giving a url or relative path using PHP

Sometimes there can be a requirement to get an images' width and height, may be to re-size them accordingly or whatever, you can use the getimagesize function of php, you can pass the URL of the image (If the image is not in your site) or you can give the relative path (if you want to get the sizes of an image of your site), here how

By URL

list($width, $height, $type, $attr) = getimagesize(http://www.blogger.com/img/blogger-logo-small.png");
$image_width = $width;
$image_height = $height;

By Relative Path

list($width, $height, $type, $attr) = getimagesize(img/blogger-logo-small.png");
$image_width = $width;
$image_height = $height;

Post By Charitha Ranasingha, File Handling

21

Sep

Integrate PayPal Pro with PHP

Here is a link with all the details http://net.tutsplus.com/tutorials/php/how-to-process-credit-cards-with-paypal-payments-pro-using-php/

Post By Charitha Ranasingha, Payment Gateway

31

May

Make the url from http to https using htaccess file

You have to upload a .htaccess file to the root of your web site with following code

<IfModule mod_rewrite.c>

RewriteEngine on

RewriteCond %{SERVER_PORT} ^80$

RewriteRule .* https://%{SERVER_NAME}%{REQUEST_URI} [R,L]

</IfModule>

Post By Charitha Ranasingha, htaccess

29

May

Cannot query inside the while loop in PHP ? Here is the solution

Here is the solution

$sql = "select id from student where classId = 5";
$view = mysql_query($sql);

while($row = mysql_fetch_array($view))
{
$array[] = $row;
}

foreach($array as $arow)
{

$sqli = "insert into course (studentId,course) values (".$ arow ["id"].",'".Maths.'")";
mysql_query ($sqli);

}

Post By Charitha Ranasingha, Common Tricks

26

Mar

How to increase the size of tinymce applied textarea

Go to tiny_mce/tiny_mce.js and find for o.deltaHeight||0 and change that line to acccording to the height you want like below

h=Math.max(parseInt(h)+(o.deltaHeight||0),100); Usual line, 100 is the default height, you can change it as you want like

h=Math.max(parseInt(h)+(o.deltaHeight||0),300);

Post By Charitha Ranasingha, Javascript

08

Feb

Good script to get the db backup using php

I think this is better to let run as a cron job (Automated Process) server daily to get the daily backups

backup_tables('localhost','username','password','database');

/* backup the db OR just a table */
function backup_tables($host,$user,$pass,$name,$tables = '*')
{

$link = mysql_connect($host,$user,$pass);
mysql_select_db($name,$link);

//get all of the tables
if($tables == '*')
{
    $tables = array();
    $result = mysql_query('SHOW TABLES');
    while($row = mysql_fetch_row($result))
    {
      $tables[] = $row[0];
    }
}
else
{
    $tables = is_array($tables) ? $tables : explode(',',$tables);
}

//cycle through
foreach($tables as $table)
{
    $result = mysql_query('SELECT * FROM '.$table);
    $num_fields = mysql_num_fields($result);

    $return.= 'DROP TABLE '.$table.';';
    $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
    $return.= "\n\n".$row2[1].";\n\n";

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

//save file
$handle = fopen('db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql','w+');
fwrite($handle,$return);
fclose($handle);
}

?>

Post By Charitha Ranasingha,

07

Feb

Nice Jquery Media Gallery

Post By Charitha Ranasingha,

31

Jan

Opencart - How to add a new column or a tab to product page

Post By Charitha Ranasingha, Opencart

24

Jan

Nice Date time pickers with different modes

Click Here
Click Here

Post By Charitha Ranasingha, Datetime picker

11

Jan

Effective Jquery Pagination and slide shows

Post By Charitha Ranasingha, Jquery

10

Jan

Multiple File Uploading Script - Very Nice One

Go to this link

Post By Charitha Ranasingha, File Upload

28

Dec

Easy way to put Popup Messages / Tooltips

Post By Charitha Ranasingha, CSS

23

Dec

Why wasting time on validation? Easy and proper way to validate your forms by spry validation option in Dreamviewer CS5

Is it a hectic to implement validations on your html forms ? here is a good solution for it, anyone can do this even you do not have the any knowledge on Javascript. watch below video.. cheers

Post By Charitha Ranasingha, Dreamviewer

16

Nov

WYSIWYG Editor with image upload function for FREE !!!!!

Hey Guyz,

As we all know there's a one problem in free WYSIWYG editors (like Tiny MCE, etc) that do not have the image uploading facility.

normally what we are doing is giving the user to upload the file to server then copy the link and put it as the image url.

Here i have found a solution to upload the file within the WYSIWYG.

First download the OPEN WYSIWYG from http://www.openwebware.com/

Then download the file upload add-on to OPEN WYSIWYG Editor from here : http://www.gallagherwebsitedesign.com/scripts/openwysiwyg-file-upload-addon/

And follow the instructions mentioned in the above link.

Post By Charitha Ranasingha, Common Tricks

10

Oct

How to insert data using query in command prompt - Oracle

Post By Charitha Ranasingha, Oracle

12

Sep

Export / Import a Perticular table / database in Oracle using command prompt

Export:

To export, type this command in cmd:
>> exp user/[email protected]
It will show many questions, leave it with default answer using hit enter. But, there are the important question, such as:
- (2)U(sers), or (3)T(ables): (2)U >
2 : to export all database under user that mentioned above
3 : to export selected tables only. If 3 choosed, it will appear question what tables that will be exported
- Export grants (yes/no): yes > (type Y or N)
- Export table data (yes/no): yes > (type Y or N)
- Compress extents (yes/no): yes > (type Y or N)

In the rest, make sure that appear message Export terminated successfully without warnings.

Import:

To import full dmp file type this command in cmd:
>> imp user/[email protected] file=emp.dmp log=imp.log full=yes

To import dept table alone type this command in cmd:
>> imp user/[email protected] file=emp.dmp log=imp.log fromuser=user touser=user tables=dept

FROMUSER and TOUSER clause are optional. But in case if used, then create a user in the destination database that is mentioned in TOUSER clause then try importing the dmp file.

In the rest, make sure that appear message Export terminated successfully without warnings.

Post By Charitha Ranasingha, Oracle

08

Sep

HSBC Payment Gateway Integration

Post By Charitha Ranasingha,

15

Aug

When typing in a text box automatically generate a list from database

Post By Charitha Ranasingha, Ajax

19

Jul

Get the value of a radio buttton group using javascript

for (index=0; index < document.form1.del_add_choice.length; index++) {
if (document.form1.del_add_choice[index].checked) {
var radioValue = document.form1.del_add_choice[index].value;
break;
}

}
alert(radioValue);
return false;

Post By Charitha Ranasingha,