Databases
StackOverflow2013
Postsdbo
POYii and Payfast
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POYii and Payfast
    primarykey
    data
    text
    <p>I'm trying to integrate the Payfast (www.payfast.co.za) with the Yii php framework. Payments are working fine and I get the ITN callback but my database queries have absolutely no effect. I was wondering if it is perhaps some sort of restriction on the Yii famework etc. prohibiting a db query. Does anybody have any insight on this issue?</p> <p>FYI, the request always redirects to payment success page but no database update. I have used the exact same logic with Codeigniter before with success, thus leading me to believe it might be a Yii issue.</p> <p>The code responsible for doing the db query is as follows:</p> <pre><code>// If the transaction was valid if( strcmp( $result, 'VALID' ) == 0 ) { // Process as required switch( $pfData['payment_status'] ) { case 'COMPLETE': // If complete, update your application, email the buyer and process the transaction as paid Order::model()-&gt;updateAll(array('paid'=&gt;1),'reference="'.$pfData['m_payment_id'].'"'); break; case 'FAILED': // There was an error, update your application and contact a member of PayFast's support team for further assistance break; case 'PENDING': // The transaction is pending, please contact a member of PayFast's support team for further assistance break; default: // If unknown status, do nothing (safest course of action) break; } } </code></pre> <p>The problem is that the switch doesn't seem to work? If you'd like to see the full code please see here:<a href="https://www.payfast.co.za/developers/php" rel="nofollow">https://www.payfast.co.za/developers/php</a></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USHerm
    1. USHerm
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. CONope, we'd need more detail / code before we can hazard a guess
      singulars
      1. POYii and Payfast
      1. USacorncom
    2. COHi acorncom. Noted and updated
      singulars
      1. POYii and Payfast
      1. USHerm
    3. COare you sure that pfData is an array and correctly filled. Might not even get to the case statement at all. Log the data or dump it or something to confirm
      singulars
      1. POYii and Payfast
      1. USBlizz
 

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