hmm, can i ask opinions on this please?

rross46

hi.

i got a script that is sorta like a shop script. it displays items to buy, taken from a db. next to each item is a text box to enter quantities. the text box names r the same, and the are stored in 1 variable... so to get this to work would i have like, say i got 4 items, (this is in pseudocode, not php)

for (count=0;count<4,count++)
{
     if (quantity[counter] >0 )
     {
          if (user_gold>item[counter].cost*quantity[counter])
          {
               add item data to database
               subtract cost*quantity frm user gold
               update othr user stats
          }
          else
          {
               echo'not enough gold';
          }
     }
     else
     {
          echo' quantity must be greater than 0';
     }
}

would something like that work?? if so, i got no idea how that would look in php, any hints?

dewen

If you are using Object, you try with this:

<?php
$ItemProductSelected = new Product($_POST);
foreach ($ItemProductSelected as $Item){
	if ($Item->quantity >0){
		  if ($iUserGold > ($Item->cost * $Item->quantity)){
			/*
			add item data to database
			subtract cost*quantity frm user gold
			update othr user stats
			*/
		} else {
			echo'not enough gold';
		}
	} else {
		echo' quantity must be greater than 0';
	}
}
?>

LoganK

How do you use objects in PHP? I thought it was something like $object->var.

dewen

Sorry, Logan is right, I mixed it with other language

LoganK

Thought so 😃

rross46

i am not using objects. just taking data in frm db in an array. what i wrote, would it work??

if so how would it look in php lol, i got no idea about this, how do i reference the individual fields, like cost for instance?

LoganK

If it's the POST method, then use $POST['field_name']. If it's GET, then $GET['field_name'].

dewen

data in frm db in an array

Can you post the array here so we can help you

rross46

sure mate.

Weapon Type Cost Strength
longsword attack 250 500 aquantity: :

battleaxe attack 400 750 aquantity: :

crossbow attack 100 100 aquantity:

this is gotten by this code-

echo '<table width="95%" cellpadding="0" cellspacing="0" border="0">
       <tr>
             <td align="center"><b>Weapon</b></td>
             <td align="center"><b>Type</b></td>
             <td align="center"><b>Cost</b></td>
             <td align="center"><b>Strength</b></td>
       </tr>
       <form action="index.php?mode=armoury" method="POST">';
while ($armoury = mysql_fetch_array($aresult))
{
        echo '<tr>
             <td align="center">'.$armoury['weapon_name'].'</td>
             <td align="center">'.$armoury['weapon_type'].'</td>
             <td align="center">'.$armoury['weapon_cost'].'</td>
             <td align="center">'.$armoury['weapon_strength'].'</td>
<td align="center">
                aquantity: <input type="integer" name="Quantity" size="10" name="quantity" />:<br />

            <input type="hidden" name="this_mode" value="true" />

<br />
            </tr>';

}
echo '<input type="submit" value="Buy" /></form>';
}

i need to reference the weapon cost when subtracting it from the users gold. therefore i need to reference "aquantity" too. as it is the same name for all the boxes, i figured a loop is the best way to keep em seperate.

then i need to reference weapon strength and multiply it with the quantity and add that to the user table. got no idea how to reference them.

in pascal (lol) it would look like

armoury[counter].cost etc.

no idea for php though lol.

leatherback

Hi,

Not sure what you are trying to get done. To be honest..

Anyway: In your loop while retrieving the data from the database you could e.g.:

$cost['$armoury[weapon_name]'] = $armoury['weapon_cost'];

and now you can refer to it using: echo "Kosten voor wapen zijn: ".$cost['SomeWeaponName'];

dewen

hope it helps. Also what is <input type="integer" ... >

<table width="95%" cellpadding="0" cellspacing="0" border="0"> 
	<tr> 
	<td align="center"><b>Weapon</b></td> 
	<td align="center"><b>Type</b></td> 
	<td align="center"><b>Cost</b></td> 
	<td align="center"><b>Strength</b></td> 
	</tr> 
	<form action="index.php?mode=armoury" method="POST">
<?php
while ($armoury = mysql_fetch_array($aresult)) 
{
?>
<tr> 
	<td align="center"><?php echo $armoury['weapon_name']?></td> 
	<td align="center"><?php echo $armoury['weapon_type']?></td> 
	<td align="center"><?php echo $armoury['weapon_cost']?></td> 
	<td align="center"><?php echo $armoury['weapon_strength']?></td> 
	<td align="center">aquantity: <input type="integer" name="Quantity_<?php echo $armoury['weapon_id']?>" size="10" name="quantity" />:<br /> 
	<input type="hidden" name="this_mode" value="true" /> 
	<br /> 
</tr> 
<?php
} 
	echo '<input type="submit" value="Buy" /></form>'; 
?>


And in the index.php, you may parse the "Quantity_*" variable:
<?php
while ($armoury = mysql_fetch_array($aresult)) 
{
	if (isset($_POST['Quantity_' . $armoury['weapon_id']]) && $_POST['Quantity_' . $armoury['weapon_id']] > 0) {
		if (user_gold > ($armoury['weapon_cost'] * $_POST['Quantity_' . $armoury['weapon_id']]))
		{
			add item data to database
			subtract cost*quantity frm user gold
			update othr user stats
		}
		else
		{
			echo'not enough gold';
		}
	}
}

rross46

rof, the data type of what i needed is an integer, i wasnt sure if that would work putting "interger" in there rofl. i was worried that if the input type was text, then u cdnt do calcs withit.