Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>In some or the other way you have to use the form to submit to the paypal url. But there are ways to play smart. I have created this class which is not the best one but still good enough to keep the user away from editing fields.</p> <p><strong>CLASS</strong></p> <pre><code>&lt;?php /* ///// ------------ Author :- Aman Virk //// ------------- Created On :- 2012-02-17 //// ------------- Licensed Under - Open Source //// ------------- Author URI :- http://www.thetutlage.com */ class paypal_class { var $last_error; // holds the last error encountered var $ipn_log; // bool: log IPN results to text file? var $ipn_log_file; // filename of the IPN log var $ipn_response; // holds the IPN response from paypal var $ipn_data = array(); // array contains the POST values for IPN var $fields = array(); // array holds the fields to submit to paypal function paypal_class() { // initialization constructor. Called when class is created. $this-&gt;paypal_url = 'https://www.paypal.com/cgi-bin/webscr'; $this-&gt;last_error = ''; $this-&gt;ipn_log_file = '.ipn_results.log'; $this-&gt;ipn_log = true; $this-&gt;ipn_response = ''; // populate $fields array with a few default values. See the paypal // documentation for a list of fields and their data types. These defaul // values can be overwritten by the calling script. $this-&gt;add_field('rm','2'); // Return method = POST $this-&gt;add_field('cmd','_xclick'); } function add_field($field, $value) { // adds a key=&gt;value pair to the fields array, which is what will be // sent to paypal as POST variables. If the value is already in the // array, it will be overwritten. $this-&gt;fields["$field"] = $value; } function submit_paypal_post() { // this function actually generates an entire HTML page consisting of // a form with hidden elements which is submitted to paypal via the // BODY element's onLoad attribute. We do this so that you can validate // any POST vars from you custom form before submitting to paypal. So // basically, you'll have your own form which is submitted to your script // to validate the data, which in turn calls this function to create // another hidden form and submit to paypal. // The user will briefly see a message on the screen that reads: // "Please wait, your order is being processed..." and then immediately // is redirected to paypal. $paypal_submit_output = "&lt;html&gt;\n"; $paypal_submit_output .= "&lt;head&gt;&lt;title&gt;Processing Payment...&lt;/title&gt;&lt;/head&gt;\n"; $paypal_submit_output .= "&lt;body onLoad=\"document.forms['paypal_form'].submit();\"&gt;\n"; $paypal_submit_output .= '&lt;center&gt; &lt;img src="images/ajax-loader.gif" /&gt; &lt;h4&gt; Please wait we are processing your transaction &lt;/h4&gt; &lt;h5&gt; Do not refresh or press back button &lt;/h5&gt; &lt;center&gt; '; $paypal_submit_output .= "&lt;form method=\"post\" name=\"paypal_form\" "; $paypal_submit_output .= "action=\"".$this-&gt;paypal_url."\"&gt;\n"; foreach ($this-&gt;fields as $name =&gt; $value) { $paypal_submit_output .= "&lt;input type=\"hidden\" name=\"$name\" value=\"$value\"/&gt;\n"; } $paypal_submit_output .= "&lt;center&gt;&lt;input type=\"submit\" value=\"Click Here\"&gt;&lt;/center&gt;\n&lt;br /&gt;"; $paypal_submit_output .= "&lt;/form&gt;\n"; $paypal_submit_output .= "&lt;/body&gt;&lt;/html&gt;\n"; return $paypal_submit_output; } function validate_ipn() { // parse the paypal URL $url_parsed=parse_url($this-&gt;paypal_url); // generate the post string from the _POST vars aswell as load the // _POST vars into an arry so we can play with them from the calling // script. $post_string = ''; foreach ($_POST as $field=&gt;$value) { $this-&gt;ipn_data["$field"] = $value; $post_string .= $field.'='.urlencode(stripslashes($value)).'&amp;'; } $post_string.="cmd=_notify-validate"; // append ipn command // open the connection to paypal $fp = fsockopen($url_parsed[host],"80",$err_num,$err_str,30); if(!$fp) { // could not open the connection. If loggin is on, the error message // will be in the log. $this-&gt;last_error = "fsockopen error no. $errnum: $errstr"; $this-&gt;log_ipn_results(false); return false; } else { // Post the data back to paypal fputs($fp, "POST $url_parsed[path] HTTP/1.1\r\n"); fputs($fp, "Host: $url_parsed[host]\r\n"); fputs($fp, "Content-type: application/x-www-form-urlencoded\r\n"); fputs($fp, "Content-length: ".strlen($post_string)."\r\n"); fputs($fp, "Connection: close\r\n\r\n"); fputs($fp, $post_string . "\r\n\r\n"); // loop through the response from the server and append to variable while(!feof($fp)) { $this-&gt;ipn_response .= fgets($fp, 1024); } fclose($fp); // close connection } if (eregi("VERIFIED",$this-&gt;ipn_response)) { // Valid IPN transaction. $this-&gt;log_ipn_results(true); return true; } else { // Invalid IPN transaction. Check the log for details. $this-&gt;last_error = 'IPN Validation Failed.'; $this-&gt;log_ipn_results(false); return false; } } function log_ipn_results($success) { if (!$this-&gt;ipn_log) return; // is logging turned off? // Timestamp $text = '['.date('m/d/Y g:i A').'] - '; // Success or failure being logged? if ($success) $text .= "SUCCESS!\n"; else $text .= 'FAIL: '.$this-&gt;last_error."\n"; // Log the POST variables $text .= "IPN POST Vars from Paypal:\n"; foreach ($this-&gt;ipn_data as $key=&gt;$value) { $text .= "$key=$value, "; } // Log the response from the paypal server $text .= "\nIPN Response from Paypal Server:\n ".$this-&gt;ipn_response; // Write to log $fp=fopen($this-&gt;ipn_log_file,'a'); fwrite($fp, $text . "\n\n"); fclose($fp); // close file } function dump_fields() { // Used for debugging, this function will output all the field/value pairs // that are currently defined in the instance of the class using the // add_field() function. echo "&lt;h3&gt;paypal_class-&gt;dump_fields() Output:&lt;/h3&gt;"; echo "&lt;table width=\"95%\" border=\"1\" cellpadding=\"2\" cellspacing=\"0\"&gt; &lt;tr&gt; &lt;td bgcolor=\"black\"&gt;&lt;b&gt;&lt;font color=\"white\"&gt;Field Name&lt;/font&gt;&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor=\"black\"&gt;&lt;b&gt;&lt;font color=\"white\"&gt;Value&lt;/font&gt;&lt;/b&gt;&lt;/td&gt; &lt;/tr&gt;"; ksort($this-&gt;fields); foreach ($this-&gt;fields as $key =&gt; $value) { echo "&lt;tr&gt;&lt;td&gt;$key&lt;/td&gt;&lt;td&gt;".urldecode($value)."&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;"; } echo "&lt;/table&gt;&lt;br&gt;"; } } </code></pre> <p><strong>IMPLEMENTATION</strong></p> <pre><code>require_once('paypal.class.php'); $p = new paypal_class; $p-&gt;paypal_url = 'https://www.paypal.com/cgi-bin/webscr'; // $p-&gt;paypal_url = 'https://www.sandbox.paypal.com/cgi-bin/webscr'; $p-&gt;add_field('business',$paypal_id); $p-&gt;add_field('return',$paypal_success_url); $p-&gt;add_field('cancel_return',$paypal_cancel_url); $p-&gt;add_field('notify_url',$paypal_ipn_url); $p-&gt;add_field('item_name',$payment_for); $p-&gt;add_field('amount', $amount); $p-&gt;add_field('custom', $unique_transaction_id); $new_form = $p-&gt;submit_paypal_post(); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POPaypal payments without using hidden fields
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USAman Virk
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPaypal payments without using hidden fields
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload