PHP - Mysql Affiliate Callback With Incentives

I'm working on a web project where I need to generate something similar to affiliate links. For example, someone signs up and he/she gets a unique link (http://www.site.com/6372) and later I can display data according to the user's unique affiliate link.  I can't find any good info about this..  Does anyone know how affiliate programs work in general?

Hi everyone,

I'm developing an affiliate tracking process and after a lot of thought, I was wondering if someone might be able suggest if I'm on the right track.  I'm trying to get away from the usual ...?id=135845 type of links.  I was thinking about two possibilities:

1.  (I don't know if this is possible), but to generate a subdomain with php at the time an affiliate signs up and then track them by extracting the subdomain to identify the affiliate, or

2.  Somehow, maybe using a mod rewrite, using the affiliate username at the end of a url, ex. www.website.com/username  , you can see that there is no extension, but when a person comes to that url, it will display the contents of www.website.com and I'd extract the username 'username' from the url and query the database to identify the affiliate.

Any thoughts on how this can be done?

Hi everyone,   I have just created this affiliate sub-page where I compare webhosting providers in Denmark.   Page: Sammenligning af webhoteller   All links for all hosting providers are affiliate links.   Do you think this is a good approach and is the text ok? (use google translate)   In other words, do you think people will click and possibly ean me a comission?   Thanks for the feedback!
Edited by Stiver112, 21 July 2014 - 03:30 PM.

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=311981.0

Is it possible to pass a callback function to other class's method?   Is what I am attempting to do a bad idea?   Thanks

<?php
class validate
{
    public function __construct($data,$callback)
    {
        //A bunch of script goes here, and I don't want to duplicate it
        if($callback) {
            //Use $callback function to modify $data
        }
    }
}

class controller
{
    public function savePage()
    {
        //A bunch of script goes here, and I don't want to duplicate it
        $validate=new validate(array('hello'),$this->callback);
    }
}

class controller_page1 extends controller
{
    public function callback()
    {
        //script which will be used to modify future $data
    }
}
?>

Hello there

I was wondering if anyone could help me with this problem

See

I running a site where people can log in, and everytime they log in, a cookie is set, based on their username.

so when a user complete a offer, my website send a link to a Network. (example: www.Network.com/offer=9384736)

When the Network has receive the link with the offer (offer=9384736) , then they will do a postback call to my website.

Example my site is www.mywebsite.com/PB.php/offer=9384736


Then my postback script will get the offer and check for the cookie when a postback call is made from the network to my script.


So what i want is when someone giving me a postback call, a script will check for the cookie ( the user who have complete a offer)

I was just think just to put this in echo $_COOKIE["user"];, but that dident work, because it was the network who called my postback.


So have anyone any idea how i can do this?




Would really appericate if someone could help me out

Thanks!

I have a file I'm trying to split up to separate some HTML from PHP code. Everything works fine when all of the code is together but when I split it into two files the two call back functions in the html form will not work. No errors and when I view the page source my file is included with the form. Any help would be appreciated.
Here is the file that has the include statement.
add_action('admin_menu', 'sampleoptions_add_page_fn');
// Add sub page to the Settings Menu
function sampleoptions_add_page_fn() {
    add_options_page('Options Example Page', 'Options Example', 'administrator', __FILE__, 'options_page_fn');
}
function options_page_fn() {
?>
<?php include('options_form.php'); ?>
<?php
}

Here is the options_form.php file code.
Code: [Select]
<div class="wrap">
        <div class="icon32" id="icon-options-general"><br></div>
        <h2>My Example Options Page</h2>
        Some optional text here explaining the overall purpose of the options and what they relate to etc.
        <form action="options.php" method="post">
        <?php settings_fields('plugin_options'); ?>
        <?php do_settings_sections(__FILE__); ?>
        <p class="submit">
            <input name="Submit" type="submit" class="button-primary" value="<?php esc_attr_e('Save Changes'); ?>" />
        </p>
        </form>
    </div>
I'm guessing that it may have to do with this line of code, due to the page parameter but I don't know that much about that area.
<?php do_settings_sections(__FILE__); ?>
Thanks in advance

 <td> <button onclick="alertdialog()"><span class="glyphicon glyphicon-trash"> </span></button></td>
<script>
function alertdialog(){
    window.confirm("Are you sure you want to delete this post?");
}
</script>   This is my code. I need to have a callback to a PHP script when a user decides to delete a post. I think html POST is the most unobtrustive way to do this. What's the easiest / most robust way to send data to a script when the user clicks OK?   Appreciated. Mark  

Probably missing something really stupid here. My usort function:
private function compareLastName($x, $y) {
if($x['Name'] == $y['Name']) {
return 0;
} elseif ($x['Name'] < $y['Name']) {
return -1;
} else {
return 1;
}
}
is being called in this function, same file:
public function loadAll() {
//various SQL stuff
$arrayNoNulls = $stmt->fetchAll();
//various SQL stuff
$arrayNulls = $stmt->fetchAll();

$arrayAll = array_merge($arrayNoNulls, $arrayNulls);
usort($arrayAll, "compareLastName");
                print_r($arrayAll);
}
The page outputs the unsorted array, preceded by the warning. What am I missing?

I am getting

 

set_exception_handler() expects the argument (static BugReporter::exception_handler) to be a valid callback in ....

 

 

The line is

set_exception_handler(array('static BugReporter', 'exception_handler'));

BugReporter is a class - eg

 

class BugReporter {

 

}

 

 

exception_handler is a function withing the class

 

 

I have no idea what is wrong. I haven't come across set_exception_handler() before

 

 

Can anyone see what is wrong - Thanks

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=343702.0

I have a listener which executes a HTTP request to a remote API before the User entity is persisted and uses the response to set one of the entity's properties.  It will also listen for update and remove and will make the appropriate HTTP request to the API but will not modify the entity.  All works as desired... Almost.  If when persisting the entity, I have some error, the remote API and my application become out of sync.  I wish to change my application to perform a second call to the API if an error occurs and reverse the previous call.  My thoughts on how to implement a

Place a try/catch block when executing the query.  Don't like this approach. Add an ExceptionListener which somehow retrieves the entity and makes the applicable changes.  Maybe part of the solution, but too complicated to be the full solution. When adding, updating, or deleting a user from the remote API under UserListener's three methods, adding a callback which gets executed upon a PDOException.  I think this is the best approach and expanded my thoughts below.

 

<?php

namespace App\EventListener;

use Doctrine\Persistence\Event\LifecycleEventArgs;
use App\Service\HelpDeskClient;
use App\Entity\AbstractUser;

final class UserListner
{
    private $helpDeskClient;

    public function __construct(HelpDeskClient $helpDeskClient)
    {
        $this->helpDeskClient = $helpDeskClient;
    }

    public function prePersist(AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->addUser($user);   //$user will be updated with the HTTP response
    }

    public function preUpdate(AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->updateUser($user);
    }

    public function preRemove (AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->deleteUser($user);
    }
}

Okay, how do I actually do this?  Was thinking of modifying UserListner as follows:

//...
use Symfony\Component\HttpKernel\KernelEvents;

final class UserListner
{
    // ...
    
    public function prePersist(AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->addUser($user);
        
        $event->getObjectManager()->getEventManager()->addEventListener(KernelEvents::EXCEPTION, function($something) use($user) {
            // Use $this->helpDeskClient to reverse the changes
        });
    }
    
    // Similar for update and remove
}

 

But when trying this approach, I get a PDOException, but my callback never gets excecated.  I've also tried replacing KernelEvents::EXCEPTION with '\PDOException' (note the quotes) with no success.

Any ideas what I should be doing differently?

Maybe some totally different approach?  I suppose I could make the request to the API after the DB query is complete for updating and deleting, but not for adding.

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that

Hello everyone,

Sorry if this has been answered but if it has I can't find it anywhere. So, from the begining then.  Lets say I had a member table and in it I wanted to store what their top 3 interests are.  Their$ row has all the usual things to identify them userID and password etc.. and I had a further 3 columns which were labled top3_1 top3_2 & top3_3 to put each of their interests in from a post form.

If instead I wanted to store this data as a PHP Array instead (using 1 column instead of 3) is there a way to store it as readable data when you open the PHPmyadmin?

At the moment all it says is array and when I call it back to the browser (say on a page where they could review and update their interests) it displays 'a' as top3_01 'r' as top3_02 and 'r' as top3_03 (in each putting what would be 'array' as it appears in the table if there were 5 results. Does anyone know what I mean?

For example -

If we had a form which collected the top 3 interests to put in a table called users,

Code: [Select]
<form action="back_to_same_page_for_processing.php" method="post" enctype="multipart/form-data">
   
    <input name="top3_01" type="text" value="enter interest number 1 here" />
    <input name="top3_02" type="text" value="enter interest number 2 here" />
    <input name="top3_03" type="text" value="enter interest number 3 here" />
    <input type="submit" name="update_button" value=" Save and Update! " />

   
    </form> // If my quick code example for this form is not correct dont worry its not the point im getting at :)
And they put 'bowling' in top3_01, 'running' in top3_02 and 'diving' in top3_03 and we catch that on the same page with some PHP at the top -->

Code: [Select]
        if (isset($_POST)['update_button']) {
   
    $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
    $top3_02 = $_POST['top3_02']; // i.e, 'running'
    $top3_03 = $_POST['top3_03']; // i.e, 'diving'

With me so far? If I had a table which had 3 columns (1 for each interest) I could put something like -

  Code: [Select]
   include('connect_msql.php');
   
    mysql_query("Select * FROM users WHERE id='$id' AND blah blah blah");
   
    mysql_query("UPDATE users SET top3_01='$top3_01', top3_02='$top3_02', top3_03='$top3_03' WHERE id='$id'");


And hopefully if ive got it right, it will put them each in their own little column. Easy enough huh? But heres the thing, I want to put all these into an array to be stored in the 1 column (say called 'top3') and whats more have them clearly readable in PHPmyadmin and editable from there yet still be able to be called back an rendered on page when requested.

Continuing the example then, assuming ive changed the table for the 'top3' column instead of individual colums,  I could put something like this -


Code: [Select]
            if (isset($_POST)['update_button']) {
       
        $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
        $top3_02 = $_POST['top3_02']; // i.e, 'running'
        $top3_03 = $_POST['top3_03']; // i.e, 'diving'
   
    $top3_array = array($top3_01,$top3_02,$top3_03);
   
    include('connect_msql.php');
   
    mysql_query("UPDATE members SET top3='$top3_array' WHERE id='$id' AND blah blah blah");
But it will appear in the column as 'Array' and when its called for using a query it will render the literal string. a r r in each field instead.  Now I know you can use the 'serialize()' & 'unserialize()' funtcions but it makes the entry in the database practically unreadable. Is there a way to make it readable and editable without having to create a content management system?

If so please let me know and I'll be your friend forever, lol, ok maybe not but I'd really appreciate the help anyways.  The other thing is, If you can do this or something like it, how am I to add entries to that array to go back into the data base?

I hope ive explained myself enough here, but if not say so and I'll have another go.  Thanks very much people,  L-PLate (P.s if I sort this out on my own ill post it all here)