PHP - Minigame Wont Add Or Subtract Points.

Gud Pm!
Im trying to display a list of years (last year, current year and next year) with these simple code i made..
It displays the current and next year correctly except last year, which gives me "1970".
I don't get why it gives me that since may next year works properly.. 

Code: [Select]
$currentyear = date('Y');
$subtract_year = strtotime(date('Y', strtotime($currentyear)) . '-1 year');
$lastyear = date('Y', $subtract_year);
$addyear = strtotime(date('Y', strtotime($currentyear)) . '+1 year');
$newyear = date('Y', $addyear);
$year_array = array($lastyear, $currentyear, $newyear);
foreach($year_array as $year)
{
echo "<option value='{$year}'>";
echo $year;
echo "</option>";
}

I'm not familiar with dates yet.. so i'm gonna read the manual while w8ting for your kind replies. 

Okay, I'm trying to make it so that when someone levels up in my game, they can use stat bonus points to increase their abilities.

However, there doesn't seem to be a break in there to ensure that someone can't spend points that they don't have. For instance, they get 3 per level, but if they spend 6, the system lets them and shows a -3 in their stat_bonus field.

Any help would be appreciated! Thanks in advance!!


<?php

include("fightfunc.php");
include("lib.php");
//include('cookies.php');
//$link = opendb();
define("PAGENAME", "Stat Bonus");
$player = check_user($secret_key, $db);
$x = $player->username;
if($_SESSION['234asdfas']){$y = $_SESSION['234asdfas'];}else{echo 'Error: You do not have a session variable set'; exit;}

$command = 1;

$choice = $_POST['choice'];
$amount = $_POST['amount'];

if (isset($_POST["statbonus"])) {
       
   include("tmpconfig.php");
$checkquery = $db->execute("SELECT * FROM `users` WHERE `id`=?", $player->id);
//$rec = mysql_fetch_array($checkquery);
extract($_POST);
$errors = 0;
$errorlist = "";
        
if ($errors == 0) { 

$query = $db->execute("UPDATE `users` SET `stat_bonus`=? WHERE `id`=?", array($player->stat_bonus - $amount, $player->id)) or die("querya failed: ". mysql_error());
if($query)
$qry = $db->execute("select * from `users` where `id`=?", array($player->id)) or die("qry failed: ".mysql_error());
$rw = $qry->fetchrow();

if($qry){
$query2 = $db->execute("UPDATE `users` SET `stat_bonus`=?, $choice=$choice+$amount WHERE `id`=?", array($player->stat_bonus - $amount, $player->id)) or die("query2 failed: ". mysql_error());
if($query2){
echo("<br><br>You have successfully used your stat bonus points.<br>");
} elseif  
($amount > $player["stat_bonus"])
{ echo "<font color='red'>Enter an amount higher than 0!</font>"; }
  elseif
  ($amount == 0)
   { echo "<font color='red'>Enter an amount higher than 0!</font>";  }
  elseif
  (!is_numeric($amount)) { 
echo "<font color='red'>Enter an amount!</font.";
        } 
else {
echo "<font color=green><b>You have succesfully spend skill points!</b></font><br /><br />";
}}}}
$player = check_user($secret_key, $db);
?>
<table width="100%">
<tr>
  <td colspan="2"><fieldset>
<form action="" method="post">
<font size='4'><b>Skill points</b></font><br />
Every time you raise a level, you get 3 skillpoints. You can spend them here.
<br />
You currently have <font color=green><b><?=$player->stat_bonus?> Skill Points.</b></font>. Please choose an attribute:<br />
<br />
<INPUT TYPE="radio" NAME="choice" VALUE="strength" CHECKED>Strength<br />
<INPUT TYPE="radio" NAME="choice" VALUE="vitality" >Vitality<br />
<INPUT TYPE="radio" NAME="choice" VALUE="agility">Agility<br />
<INPUT TYPE="radio" NAME="choice" VALUE="wisdom">Wisdom<br />
<br />
How many skill points do you want to spend? (+1 for every skill point): <br /><br />
Amount: <INPUT TYPE="text" NAME="amount" SIZE="8" MAXLENGTH="8">
<INPUT TYPE="submit" NAME="statbonus" VALUE="Submit">
</form></fieldset></td></tr>
    </table>

<?php $totalcreditstd = $row_rsCreditPurchaseMoney['SUM(quantity)']; $totalcreditsdollar = $totalcreditstd * $Mutliplier; echo $totalcreditsdollar; ?>

I'm using the above calculation to display a total amount.
Problem is that if the calculation total is 7.5 I want it to show up as 7.50 I want to force the second number. How can I do that? Thanks.

I have a picture (attached), where I find the coordinates of black points, because I do not remember any point, so you want every point at which I find coordinates with mark a red cross as watermark.

At the coordinates using this script:
<?php

if(isset($_GET["obrazek_x"]))

  file_put_contents("soubor.txt",$_GET["obrazek_x"].",".$_GET["obrazek_y"]."\n",FILE_APPEND);

?> 

Coordinates I save to an external file in this format:

Code: [Select]
602;744
Could you advise me a solution to mark black points?

Hi if i have $date = "12-08-2018" or "2018-08-12"

Need to subtract a month. Could this be done for day and year even?

TIA

Desmond.

P.S.

What I want to do is clear out a database table with records over a month old so today is 27th Jan 2018. I would like to create a date “2018-12-01”

I can then use this in an SQL to delete all before “2018-12-01”

Edited January 27, 2019 by Paul-D

I have a PHP script that downloads a file from a remote server but in order to download the correct file it has to subtract 1 day of the week.  It used to work quite some time ago so I dont know what is going on now.  The section of the script goes like this....

$days = array("sun","mon","tue","wed","thu","fri","sat");
$today = date("w");
$yesterday = $days[$today - 1];

Then it joins the 3 letter version of the day of week with a file name to grab the correct file download.  $yesterday is not returning the correct value instead I am getting an error...

# ./update.php 
PHP Notice:  Undefined offset: -1 in /root/fcc/work/update.php on line 6
fetching l_am_.zip
ncftpget: server said: l_am_.zip: No such file or directory.
PHP Warning:  unlink(counts): No such file or directory in /root/fcc/work/update.php on line 23
data set empty nothing to process 

Sun, 01 February, 2015 6:29:06 PM

So in the above error I can see that $yesterday is "Undefined offset" and because of that the file it tries to download is incorrect, it should have tried to download l_am_sat.zip and it left out the 3 letter date code.
Edited by chadrt, 01 February 2015 - 09:48 PM.

I have the following code:
Code: [Select]
//DETERMINES ASL POLICY
if ($perfRow['ASL']=='ToArrange'){
$ASLdate = $perfRow['startDateTime'];
$ASLconfirm = strtotime($ASLdate-'21 days');
echo "<!--[ASL=ToARRANGE--><p>An ASL Interpreted performance of this event is offered on".date("l, F j",strtotime($perfRow['startDateTime']))." at ".date("g:i a",strtotime($perfRow['startDateTime'])).".<br />Please contact me by ".date("l, F j",strtotime($ASLconfirm))." to confirm this service.</p>";
}What I need is that if the ASL is "To be Arranged" there is a date that lists for $ASLconfirm that is three weeks prior to $ASLdate.
The code above gives me the following:
Quote

An ASL Interpreted performance of this event is offered on Friday, September 28 at 7:30 pm.
Please contact me by Wednesday, December 31 to confirm this service.

As you can see from the output the December date is NOT three weeks prior to the September date.
Where did I go wrong in my coding?

Hello this may sound a little confusing. I recently made a fake website using this phpacademy tutorial I found. Anyways it has an quantity stock what I mean by this is
let's I have 3 copies of a video game an a person set they quantity for 2 of the 3 copies and proceed to the checkout through paypal payment successful okay.

My question is: How can I go about sending the quantity stock back to the database to subtract 2 from 3 to be left with 1 copy of the game in the quantity section after a successful purchase?

Code is below in case I confused someone
 

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////
Maximumize / calling the quantity from Database
/////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if(isset($_GET['add'])){
$quantity = mysqli_query($db_conx,'SELECT id, quantity FROM products WHERE id='.mysqli_real_escape_string($db_conx,(int)$_GET['add']));
while ($row = mysqli_fetch_assoc($quantity)){
if ($row['quantity']!=$_SESSION['cart_'.(int)$_GET['add']]) {
$_SESSION['cart_'.(int)$_GET['add']]+='1';
}
}
header('Location: '.$page);
}

if(isset($_GET['remove'])){
$_SESSION['cart_'.(int)$_GET['remove']]--;
header('Location:' .$page); 
}

if(isset($_GET['delete'])){
$_SESSION['cart_'.(int)$_GET['delete']]='0';
header('Location:' .$page); 
}

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////
Calling all products from Database
/////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
function products($db_conx){
$get = mysqli_query($db_conx,"SELECT id, name, description, price FROM products WHERE quantity > 0 ORDER BY id DESC"); 
if (mysqli_num_rows($get) ==0){
echo "There are no products to display";
}
else {
while ($row = mysqli_fetch_assoc ($get)){
echo '<p>'.$row ['name']. 
'<br/>
<br/>'
.$row ['description']. 
'<br/>
<br/>'
.'&dollar;'.number_format($row['price'], 2).' <a href="cart.php?add='.$row ['id'].'">Add</a></p>';
}
}
}

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////
Paypal Checkout
/////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
function paypal_items($db_conx){
$num = 0;
foreach($_SESSION as $name => $value){
if ($value != 0){
if(substr($name, 0, 5)=='cart_'){
$id = substr($name, 5, strlen($name) -5);
$row = mysqli_query($db_conx,'SELECT id, name, price, shipping FROM products WHERE id ='.mysqli_real_escape_string($db_conx,(int)$id));
while ($query = mysqli_fetch_assoc($row)){
$num++;
echo '<input type="hidden" name="item_number_'.$num.'" value="'.$id.'">';
echo '<input type="hidden" name="item_name_'.$num.'" value=" '.$query['name'].' ">';
echo '<input type="hidden" name="amount_'.$num.'" value=" '.$query['price'].' ">';
echo '<input type="hidden" name="shipping_'.$num.'" value=" '.$query['shipping'].' ">';
echo '<input type="hidden" name="quantity_'.$num.'" value=" '.$value.' ">';
}
}
}
}
}


//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////
Shopping Cart View
/////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
function cart($db_conx) {
foreach($_SESSION as $name => $value) {
if ($value > 0) {
if(substr($name,0 ,5) . 'cart_'){
$id = substr($name, 5, (strlen($name) -5));
$row = mysqli_query($db_conx,'SELECT id, name, price FROM products WHERE id=' .mysqli_real_escape_string ($db_conx,(int)$id));
while ($query = mysqli_fetch_assoc($row)){
$sub = $query['price']*$value;
echo $query['name'].' x ' .$value. ' @ &dollar;' .number_format ($query['price'], 2). ' = &dollar;'.number_format($sub, 2). '<a href="cart.php?remove='.$id.'">[-]</a> <a href="cart.php?add='.$id.'">[+]</a> <a href="cart.php?delete='.$id.'">[Delete]</a> <br/> <br/> ';
}
}
$total += $sub + $shipping;
}
}
if ($total ==0) {
echo "Your cart is empty.";
}
else {
echo 'Total: &dollar;' .number_format($total, 2);
?>
<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_cart">
<input type="hidden" name="upload" value="1">
<input type="hidden" name="business" value="youremail@outlook.com">
<?php paypal_items($db_conx); ?>
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="amount" value="<?php echo $total ;?>">
<input type="image" src="http://www.paypal.com/en_US/i/btn/x-click-but03.gif" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
</form>

<?php

}
}
?>

Edited by mac_gyver, 09 September 2014 - 08:06 PM.
code tags please

Hello, I am learning php in a class for school and I was hoping I could get some help with some code. I am trying to make a game life counter. I just want it to have simple +1, -1 and reset buttons. I have gotten it to add and subtract the first time, but it will not continue adding/subtracting. Thank you for any help you can give. Here is the code I'm having issues with:

<?php
session_start();
?>

<form method="post" action ="">
<input type="submit" name="name" value="Add"/>
<input type="submit" name="name" value="Minus"/>
<input type="submit" name="name" value="Reset"/>
</form>
 
<?
lifeTotal();

function lifeTotal()
{

   $_SESSION['total']=20;

   if($_POST["name"] == 'Add')
   {
      $_SESSION['total']++;
      echo $_SESSION['total'];
   }
   else if($_POST["name"] =='Minus')
   {
      $_SESSION['total']--;
      echo $_SESSION['total'];
   }
}
?>

Hello dear friends,

first of all : merry merry Xmas!!!


i want to parse with the simple Simple HTML DOM Parser,


well i am pretty new to php and to the Simple HTML DOM Parser.

My example: http://schulen.bildung-rp.de/gehezu/startseite/einzelanzeige.html?tx_wfqbe_pi1[uid]=60119

I want to collect the data in the block:

I have investigated the sourcecode - and found out that the attribute of interest should be this one: class="content"div class="content"><!-- TYPO3SEARCH_begin -->


here the code is: - my trails.

 

// inculde the Simple HTML DOM Parser 
include_once('simple_html_dom.php');

// get the file we want to parse right now,create a DOM 
$html = file_get_html('');

// simple_html_dom::find() creates a new 
// simple_html_dom-Objekt, that consists out of
// corresponding childelements 

foreach($html->find('class: content ') as $h3) {

  // simple_html_dom::get the text in a tag
  // den Text innerhalb eines Tags
  if($h3->innertext == 'Text of a H3 Tag') {
    break;
  }
}

// simple_html_dom::next_sibling() gives the
// next   Element
$table = $h3->next_sibling();



but believe me - it  gives me not back what is aimed.

what  have id done wrong...? 

dbone

Im trying to execute an update sql query, but its not working. IDK if I got the right query tho

what i want  to do is, when the form is submitted, subtract 15 from the value 'creditleft'. So say the value is 20 , i want to subtract 15 and get 5.

Here is the sql query im using;
$query2="update userdata set creditleft = - 15 where username = '".$_SESSION['login_name']."'";
mysql_query($query2, $link);
I dont get any errors, just no output

Hello, I am trying to subtract the current time from a list of times in a mysql database. The first page inserts the time into mysql.

<?php
$var_Time = date("h:i:s");
$mysqli = new mysqli('localhost','root','blah','test');
if ($mysqli->connect_error) {
    die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}
$insert_row = $mysqli->query("REPLACE  INTO test_table (id, time)  Values(NULL, '$var_Time')");
if($insert_row){
    while (false);
}else{
    die('Error : ('. $mysqli->errno .') '. $mysqli->error);
}
$mysqli->close();
?>

The second page is supposed to iterate through all of the times in the database and subtract the current time, but i cant figure out how to do it.

<?php
$mysqli = new mysqli('localhost','root','blah','test');
if ($mysqli->connect_error) {
    die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}
$query = "SELECT * FROM `test_table`";
$result = $mysqli->query($query) or die($mysqli->error.__LINE__);
$var_set_time = stripslashes($row['time']);
$var_current_time = date("h:i:s");
$diff = strtotime( $var_current_time .' UTC' ) - strtotime( $var_set_time .' UTC');
echo $diff;
?>

Edited by Ch0cu3r, 09 October 2014 - 01:40 PM.
Added code tags

Code: [Select]

$startdt = $_POST['startdt'].":".$_POST['starttmh'].":".$_POST['starttmm'].":".$_POST['sAMPM'];  // 09/08/2011:11:35:AM
$enddt = $_POST['enddt'].":".$_POST['endtmh'].":".$_POST['endtmm'].":".$_POST['eAMPM']; //09/09/2011:11:35:AM

From the code above I want to subtract 09/08/2011:11:35:AM    from   09/09/2011:11:35:AM and get the total number of hours.

A simple solution would be highly appreciated:

thanks in advance:

I have somewhat of a dilemma.

When someone clicks on a Buy Now button and subsequently follows necessary steps to complete process of purchase, when that transaction is completed, in my product table, I want to subtract 1 from whatever value is in the field.

E.g. say product one is being purchased, prior to purchase in product table, there are 5 product one's in stock, when purchase is complete, subtract 1 from 5 (to get 4).

Here is my code

Code: [Select]
<?php

$title = "Like This Product, Buy It NOW!!!";

require ('includes/config.inc.php');

include ('./includes/header.html');

require (MYSQL);

include ('./includes/main.html');

if($id = isset($_GET['prodID']))
{
$query = "SELECT `prodID`, `product`, `prod_descr`, `image`, `price` FROM product WHERE `prodID`='{$_GET['prodID']}'";
$r = mysqli_query($dbc, $query);

$showHeader = true;
echo "<div id='right'>";

while($row = mysqli_fetch_array($r))
{
if($showHeader)
{
            //Display category header
echo "<h1>" . "<span>" . "# " . "</span>" . $row['product'] .  "<span>" . " #" . "</span>" . "</h1>";

echo "<div id='item'>"; // div class 'item'

echo "<div class='item_left'>";

echo "<p id='p_desc'>";
echo $row['prod_descr'];
echo "</p>";

echo "<p>" . "<span>" . "&pound" . $row['price'] . "</span>" . "</p>";

echo "</div>";

echo "<div class='item_right'>";

echo "<img src='db/images/".$row['image']."' />";
$showHeader = false;

echo "</div>";

?>

<p>
<form target="paypal" action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="7UCL9YCYYXL3J">
<input type="hidden" name="item_name" value="<?php echo $row['product']; ?>">
<input type="hidden" name="item_number" value="<?php echo $row['prodID']; ?>">
<input type="hidden" name="amount" value="<?php echo $row['price']; ?>">
<input type="hidden" name="currency_code" value="GBP">
<input type="image" src="https://www.sandbox.paypal.com/en_US/i/btn/btn_cart_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.sandbox.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>
</p>

<p>
<form name="_xclick" action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="me@mybusiness.com">
<input type="hidden" name="currency_code" value="GBP">
<input type="hidden" name="item_name" value="<?php echo $row['product']; ?>">
<input type="hidden" name="amount" value="<?php echo $row['price']; ?>">
<input type="image" src="http://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
</form>
</p>

<?php 

echo "</div>"; // End of div class 'item'

$strSQL = "SELECT prodID, product, price, image FROM product ORDER BY RAND() LIMIT 1";  
$objQuery = mysqli_query($dbc, $strSQL) or die ("Error Query [".$strSQL."]");

while($objResult = mysqli_fetch_array($objQuery))  
{ 
echo "<div class='love'>";
echo "<h6>Like this......you'll love this!!!</h6>";
echo "<ul>";
echo "<li>" . "<img src='db/images/" . $objResult['image'] . "' width='50' height='50' />" . "</li>";
echo "<br />";
echo "<li>" . "<a href='item.php?prodID={$objResult['prodID']}' title='{$objResult['product']}'>" . $objResult['product'] . "</a>" . " - " . "&pound" . $objResult['price'] . "</li>";
echo "</ul>";
echo "</div>";
}

}
}

?>

<?php

echo "</div>";

}

include ('./includes/footer.html');

?>

How is this achievable please?

I have setup a website that has a shopping basket and it displays the objects ordered in a table before being purchased, i have added a plus and minus button to adjust the quantity using the following code:

$add ="<form action='cart.php' method='post'><input type='hidden' name='additem' value='$id'/><input type='submit' name='itemadd' onclick='CheckQty()' value='+'/></form>";
    $sub ="<form name='sub' action='cart.php' method='post'><input type='hidden' name='subitem' value='$id'/><input type='submit' name='itemsub' value='-'/></form>";

//add to quantity of item
    if (isset($_POST['itemadd'])){
    $additem = $_POST['additem'];
        if ($qty < 5){
        $addqty = $qty + 1;
        $adding = "UPDATE orders SET quantity = '$addqty' WHERE id = '$additem'";
        $add_query = mysqli_query($db_conx, $adding);
        header('Location: http://www.quichlicious.co.uk/cart.php');
        //print $additem;
        exit();
        }
        else
        {
        $usemes = "You have reached maximum quantity";
        }
    }
    //subtract to quantity of item
    if (isset($_POST['itemsub']) && ($_POST['itemsub'] !="")){
    $subitem = $_POST['subitem'];
            if ($qty > 1){
            $subqty = $qty - 1;
            $subing = "UPDATE orders SET quantity = '$subqty' WHERE id = '$subitem'";
            $sub_query = mysqli_query($db_conx, $subing);
            header("location: cart.php");
            exit();
            }
            else
            {
            $usemes = "<font color='red'>Please use delete to remove item</font>";
            }
    }

The issue i have is it works great if just one item is in the basket but if i have more than 1 item in the basket i can only adjust the very last item in the baskets quantity and the others just randomly jump numbers or will not change at all?   $additem gets the item ID from the table.
Edited by mik_se7, 19 November 2014 - 10:14 AM.