Jump to content

Incrementing Form Names


AltarofScience

Recommended Posts

IronMineList.php:

<?php include('buildingfile.php'); ?>
<?php
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$dbname = 'aosdb';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query="SELECT * FROM IMPrints";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
$n=1;
$j=0;
$b=1;
while($i<$num) {
$name = mysql_result($result, $i, 'name');
$work = mysql_result($result, $i, 'workers');
$effi = mysql_result($result, $i, 'efficiency');
$cost = mysql_result($result, $i, 'cost');
$iron = mysql_result($result, $i, 'iron');
$copp = mysql_result($result, $i, 'copper');
$silv = mysql_result($result, $i, 'silver');
$titan = mysql_result($result, $i, 'titanium');
$gold = mysql_result($result, $i, 'gold');
$uran = mysql_result($result, $i, 'uranium');
$plat = mysql_result($result, $i, 'platinum');
$diam = mysql_result($result, $i, 'diamonds');
$oil = mysql_result($result, $i, 'oil');
$water = mysql_result($result, $i, 'water');
include('Iron.php'); 
$i++;
$b++;
$j++;
$n++;
}
?>

 

Iron.php:

<?php 
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$dbname = 'aosdb';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$queryj = "SELECT name FROM IMPrints";
$resultj = mysql_query($queryj);
$Column = mysql_result($resultj, $j);
$queryp = "SELECT * FROM IMBuilt WHERE idcol = $idcol";
$resultp = mysql_query($queryp);
$Base = mysql_fetch_row($resultp);
if(isset($_POST[""])) {
if($_POST[""]) {
$Badd = $Base[$b]+$_POST[""];
$queryi="UPDATE IMBuilt SET $Column=$Badd WHERE idcol = $idcol";
mysql_query($queryi);
}
}
$queryf = "SELECT * FROM IMBuilt WHERE idcol = $idcol";
$resultf = mysql_query($queryf);
$Basic = mysql_fetch_row($resultf);
echo $i;
?>
<p class="bd" id="built">| Built: <?php echo $Basic[$n]; ?> |</p>
<form class="bd" method="post" action="IronMineList.php"><input type="text" name='[]'><input type="submit" value="Build"></form>

 

What those 2 php documents do is display a list of iron mines a player in my game can build.

It is supposed to create 1 form for each blueprint so that a player can add only to the number of that blueprint on their colony.

The displays work perfectly. It creates 1 div that properly displays the stats of each mine in the database table. It also creates one form for each div.

 

The problem I have is, I can only make the forms add 1 to all the buildings on a colony.

The name='' value of the form and the $_POST[''] values do not increment with the rest of the code. I need a way to make each form apply only to the div which displays a specific mine.

So where $i=0 the first form should only alter the value in imbuilt for the stats that are displayed by the rest of the div created for $i=0.

Link to comment
https://forums.phpfreaks.com/topic/247976-incrementing-form-names/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.