Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    1
    Plugin Contributions
    0

    Default Custom PHP/MySQL Database -- will it integrate?

    I don't necessarily have "products" -- I have a simple PHP/MySQL car database that premium members pay to access with different levels:

    Level 1 - Some people want to purchase one car company (ex: Lexus),
    Level 2 - Some want a segment of car companies (ex: all North American car companies)
    Level 3 - Some want full access (ex: all car companies)

    Can I use Zen Cart to send a token to my PHP scripts after purchasing is complete to say this users is Level 1 or this user is Level 3, etc. and write it to the database?? I am a web developer and am great with PHP/MySQL, im just a noobie to ecommerce.

    If anyone can give me insight on how to send communication back to my PHP script AFTER a payment has been processed and approved that would be great.

    Regards,
    Kevin

  2. #2
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Custom PHP/MySQL Database -- will it integrate?

    Some ideas you might try:

    You could hook into the order.php class and replace the following code with code that writes something to your other database:
    PHP Code:
    /* START: ADD MY CUSTOM DETAILS
     * 1. calculate/prepare custom information to be added to this product entry in order-confirmation.
     * 2. Add that data to the $this->products_ordered_attributes variable, using this sort of format:
     *      $this->products_ordered_attributes .=  {INSERT CUSTOM INFORMATION HERE};
     */

        
    $this->products_ordered_attributes .= ''// $custom_insertable_text;

    /* END: ADD MY CUSTOM DETAILS */ 
    Or you could hook either of these notifier points using the observer/notifier system:
    NOTIFY_ORDER_DURING_CREATE_ADD_PRODUCTS
    NOTIFY_CHECKOUT_PROCESS_AFTER_ORDER_CREATE_ADD_PRODUCTS
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. Replies: 4
    Last Post: 24 Apr 2014, 04:27 PM
  2. integrate/map new Mysql database with existing zencart database
    By omerhanif in forum General Questions
    Replies: 0
    Last Post: 18 Jan 2010, 12:36 PM
  3. Dreaded mYSQL 1064 error when importing MySQL 4 database into MySQL5
    By dml311071 in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Jun 2008, 05:38 AM
  4. Popup box will only let me save or open index.php in Database Settings
    By ---kate--- in forum Installing on a Windows Server
    Replies: 1
    Last Post: 11 Sep 2007, 07:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg