Pause and Run button in PHP script - HELP

Discussion in 'PHP' started by bokivaol, Sep 21, 2010.

  1. #1
    Hi guys!
    I need a little help in PHP. I need to put into the PHP code functions which will insert to mysql database "jobs" STATUS=2 for Pause button and STATUS=1 for Run button

    CODE:
    <?php
    include("include/header.php");
    if(!isset($_SESSION["userlogin"])) { header("location: login.php"); exit(); }
    $edit=dbFetchArray(dbQuery("select * from `user_registration` where `email`='".$_SESSION["userlogin"]."'"),MYSQL_BOTH);
    $Id=base64_decode($_REQUEST['Id']);
    $up=mysql_fetch_array(mysql_query("select * from `jobs` where `id`='".$Id."'"));
    $status=stripslashes($up["highlighted"]);
    $name=stripslashes($up["title"]);
    $explode=explode(" ",$name);
    $tit=isset($explode[0])?$explode[0]:'';
    $col=isset($explode[1])?$explode[1]:'';
    $cat=isset($explode[2])?$explode[2]:'';
    
    $user=mysql_fetch_array(mysql_query("select * from `user_registration` where `email`='".$_SESSION["userlogin"]."'"));
    $fullname=stripslashes($user['fullname']);
    $customer_id=$user['id'];
    $current_balence=$user['current_balance'];
    
    if(isset($_POST["Button"])) {
        if(isset($_REQUEST["Available_positions"]))
        {
        $Available_positions=$_POST["Available_positions"];
        if(strpos($Available_positions,'.')===false) {
        $pos=$Available_positions;
        $pos1=0;
        } else {
        $pieces = explode(".", $Available_positions);
        $pos=$pieces[0];
        $pos1=$pieces[1];
        }
    
        $Payment_per_task=$_POST["Payment_per_task"];
    
        $hid=$_REQUEST['hid'];
        if($pos1>0)
        {
        ?>
        <script>
        alert('Job Posting Suspended');
        window.location.href="edit_job.php?Id=<?=base64_decode($hid)?>";
        </script>
        <?
        }
        else
        {
        dbQuery("update `jobs` set `wd2`='".$Available_positions."',`price`='".$Payment_per_task."' where `id`='".$hid."' and `email`='".$_SESSION["userlogin"]."'");
        ?>
        <script>
        window.location.href="employer.php";
        </script>
        <?
        }
        }
        $_SESSION['hid']=$hid;
        if($hid>0) {
        $_SESSION["success"]='';
        } else {
        $_SESSION["error"]='';
        }
    } else if(isset($_POST["Cancel"])) {
    $hid=$_REQUEST['hid'];
    dbQuery("update `jobs` set `status`='3' where `id`='".$hid."' and `email`='".$_SESSION["userlogin"]."'");
    $resJ=dbFetchArray(dbQuery("select * from `jobs` where `id`='".$hid."' and `email`='".$_SESSION["userlogin"]."'"),MYSQL_BOTH);
    
    if($resJ["wd1"]!=$resJ["wd2"]) {
    $CJ= $resJ["wd2"] - $resJ["wd1"];
    $CJFees = $CJ*$resJ["price"];
    dbQuery("insert into `myaccount`(`email`,`amount`,`type`,`createdate`,`jobid`) values('".$_SESSION['userlogin']."','$CJFees','10',NOW(),'".$resJ["id"]."')");
    $rescurbal=dbFetchArray(dbQuery("select * from `user_registration` where `email`='".$_SESSION['userlogin']."'"),MYSQL_BOTH);
    dbQuery("update `user_registration` set `current_balance`='".($rescurbal["current_balance"]+$CJFees)."' where `email`='".$_SESSION['userlogin']."'");
    }
    ?>
    <script>
    window.location.href="employer.php";
    </script>
    <?
    }
    ?>
    PHP:
    ...
    and button code:
    ...
    <br><input type="submit" value="Submit Campaign" <?php if($up["status"]=='3') { echo 'disabled="disabled"';} ?> name="Button">&nbsp;&nbsp;<input type="submit" value="Finished Campaign" <?php if($up["status"]=='3') { echo 'disabled="disabled"';} ?>  name="Cancel"><br />
    Code (markup):
    ...

    I tried to do that, but I always get some error. Please help!
     
    bokivaol, Sep 21, 2010 IP