– That’s it. Regardless of any quety string $currentFile shows you current page name.

Paypal Gateway Integration:

Step 1: Goto developer.paypal.com

Step 2: Signup for an account and I use the following information.

user: jbl.training@gmail.com

pass: trainingcenter

you have to confirm your email address by click the link in mail send by paypal.

Childhood best fr: karamba

Favorite Restaurent: piza

My primary payment solution: Website Payments Standard

Create

Step 3: Create Business Account (I use Preconfigured link)

Saller acc: jbltr1_1268724741_biz@gmail.com

Pass: 268724681

Step 4: Create Personal Account (I use Preconfigured link)

Buyer acc: person_1268889297_per@gmail.com

Pass: 268889126

Step 5: Click API Credentials Link from left menu. API created automatically and you just need to use those. For me here are the info:

Test Account: jbltr1_1268724741_biz@gmail.com Created: Mar. 16, 2010 00:32:27 PDT

API Username: jbltr1_1268724741_biz_api1.gmail.com

Password: 1268724747

Signature: AFcWxV21C7fd0v3bYYYRCpSSRl31AF95j1hyudD2R8r7TVOp6tyt4smZ

Step 6: Now Download sample application from paypal: https://cms.paypal.com/cms_content/US/en_US/files/developer/PP_PHP_NVP_Samples.zip

Extract

Step 7: open PP_PHP_NVP_Samples/constants.php and set up API Credentials Line no: 23, 33, 39.

Step 8: Run http://localhost/PP_PHP_NVP_Samples and click “ExpressCheckout – Sale” Link

Enter your personal account details as:

Email: person_1268889297_per@gmail.com

Pass: 268889126

[Note: Make sure you are signed in at paypal.developer.com For me Login Info: jbl.training@gmail.com / trainingcenter]

You will redirect to your site from paypal. By example, http://localhost/PP_PHP_NVP_Samples/ReviewOrder.php?currencyCodeType=USD&paymentType=Sale&token=EC-9FX13198W32250845&PayerID=JPQWEXV7JKM7C

Click “Buy” button

And finally http://localhost/PP_PHP_NVP_Samples/DoExpressCheckoutPayment.php page shows you Confirmation of your transaction

When come back from paypal (after successful transaction)it comes to

http://localhost/paypal/ReviewOrder.php?currencyCodeType=GBP&paymentType=sale&LastTakewayId=1&token=EC-7SL107200L902835S&PayerID=JPQWEXV7JKM7C

Here LastTakewayId is my variable added paypal/ReviewOrder.php page at $returnURL=urlencode($url.’/ReviewOrder.php?currencyCodeType=’.$currencyCodeType.’&paymentType=’.$paymentType.’&LastTakewayId=’.$_SESSION['LastTakewayId']);

TIPS:

1. Have a look Test Email from the left menu

2. Maximum time I login in an account at developer.paypal.com and use another account’s email and pass while transaction (during purchase)

Enjoy Paypal and Have Fun !!

Md. Aminul Islam

aminulsumon@gmail.com

and search extension=php_curl.dll

remove trailing semicolon from this line

Restart apache. Check CURL enabled or not by echo phpinfo();

Still not enabled :O Don’t worry repeat the same process for D:\xampplite\php\php.ini(the location for you may not be same but open php\php.ini)

That’s IT Man !! Enjoy CURL….

Step 2: httpd.conf-> NEAR line 469

# Virtual hosts

#Include conf/extra/httpd-vhosts.conf

replace by [remove front #]

# Virtual hosts

Include conf/extra/httpd-vhosts.conf

Step 3: Open c:\wamp\bin\apache\apache2.2.*\conf\extra\httpd-vhosts.conf

Step 4: httpd-vhosts.conf-> Remove all text in this file and add following as much as port you like to add

#

# Use name-based virtual hosting.

#

NameVirtualHost *:80

<virtualhost *:80>

ServerName localhost

DocumentRoot “D:\wamp\www”

</virtualhost>

Listen 81

<virtualhost *:81>

ServerName localhost

DocumentRoot “D:\wamp\www\job\public”

</virtualhost>

Step 5: Test by http://localhost:81 you will get job project.

Add new project: Go to httpd-vhost-> add 82 83 84 85 86 and pointing to the

directory where index.php is located

frmNewEmployee newFrm = new frmNewEmployee();
newFrm.Show();
this.Hide();

Topic: Setup Startup Form

=> Open File “Program.cs”. and in main function  set form name as
Application.Run(new frmWelcome());

if we write the configuration in every aspx.cs pages(like above) then later time if we need to change database name then we have to change it over every pages. but we are not stupid. so we must write it in a common place like web.config.
by example,

web.config page contain:
<appSettings>
<add key=”ORACLEConnectionString” value=”Provider=OraOLEDB.Oracle.1;
Persist Security Info=False;Password=blah;User ID=greg;Data Source=sph;” />
<add key=”SQLConnectionString” value=”data source=SQL1;initial catalog=ID_V;
integrated security=SSPI;persist security info=False;workstation id=TH03D374;
packet size=4096″/>
<add key=”accessConnectionString” value=”Provider=Microsoft.Jet.OleDb.4.0; Data Source=|DataDirectory|student.mdb” />
</appSettings>

and aspx.cs file connect db as:
string strConnection = ConfigurationSettings.AppSettings["accessConnectionString"];
using (OleDbConnection con = new OleDbConnection(strConnection))
{
con.Open();
OleDbCommand cmd = new OleDbCommand(“select * from systemusers”, con);
OleDbDataReader rdr = cmd.ExecuteReader();
GridSystemUsers.DataSource = rdr;
GridSystemUsers.DataBind();
}
that’s it. central database configuration. @global file: still i am not good enough to write about.

First tool is Navicat Mysql. this is a very good software which have a lot of features. really powerful and able to handle any kind of request when it’s mysql related. in contrast, navicat is not good to handle oracle or mysql server. although, it have features like, you can convert a mysql database to Ms Access or generate sql script. i am slightly happy but not totally.

Second tool i found is sqldeveloper by oracle. currently analyzing this one. so far i found this is another good tool when target or source database is oracle. but not sufficient enough to convert sql server to mysql or ms access. moreover, this tool don’t have reporting feature itself included. however, this is another powerful tools for database migration.

Thirdly, there are hundreds of free or commercial version softwares who are able to convert from one database to another. but those are really painful to test one by one (due to unstability).

$this->load->dbutil();
$this->load->helper(‘download’);
$this->load->helper(‘file’);

$prefs = array(
‘tables’      => array(),  // Array of tables to backup.
‘ignore’      => array(‘ssc_dakhil_exam’),           // List of tables to omit from the backup
‘format’      => ‘zip’,             // gzip, zip, txt
‘filename’    => ‘mybackup.zip’,    // File name – NEEDED ONLY WITH ZIP FILES
‘add_drop’    => TRUE,              // Whether to add DROP TABLE statements to backup file
‘add_insert’  => TRUE,              // Whether to add INSERT data to backup file
‘newline’     => “\n”               // Newline character used in backup file
);

$backup =& $this->dbutil->backup($prefs);
//write_file(‘c:\mybackup.txt’, $backup);
force_download(‘mybackup.zip’, $backup);

First of all, there are number of different version of Oracle. For example, oracle 8, 9i, 10g etc etc. Again 10g have different versions as well. i start with oracle 10g express edition. In order to download oracle 10g express edition goto OTN(Oracle Technology Network) and search for oracle 10g express edition. Download it from there.

Well, the time when i start learning (weeks back) i have no helper and feel that if someone guide me step by step then it would be helpful for me. From my BEST TEACHER i get an excellent tutorial. it shows me where from start and how to proceed. this tutorial guide me from 10g installation to application building and reporting. here is the link for you all: http://www.tutorialized.com/view/tutorial/Oracle-Database-10g-Express-Edition-Tutorial/37325

Well after gather some basics of oracle, i feel i need a tool to migrate my existing database into oracle. again from my BEST TEACHER i found it at http://www.oracle.com/technology/tech/migration/workbench/index.html

And right now i am Learning oracle. best of luck to me. ha ha