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
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.