[RESOLVED] Incrementing numbers within a function

[bschwartz]

I have this function, and for all intensive purposes its working, however this is going to be called about 10 times, and I need a way to increment all the input fields that I have on this form.

I think the best way to do this would be with an array, but I'm still new to PHP and I'm having trouble with all the syntax. Can someone help me out?!

<?php
function work_order() {
global $var_phase, $phase_query, $array_phase;
print "<tr align='center'>"; 
print "<td>";
print "District: <select name = 'district'>";

	// Using the query as defined in the query section
	if ($var_phase = mysql_query($phase_query)) {
 echo '<option value="">Please select a district</option>'."\r\n";		
		while ($array_phase = mysql_fetch_array($var_phase)) {
			echo '<option value="'.$array_phase['Phase_Code'].'">'.substr ($array_phase['Phase_Code'], 1, -9).'</option>'."\r\n";
		}
	}

print "</select>";
print "</td>";
print "<td>W/O 1: <select name='phase1'>"; 

	// Using the query as defined in the query section
	if ($var_phase = mysql_query($phase_query)) {
 echo '<option value="">Please select a work order</option>'."\r\n";
		while ($array_phase = mysql_fetch_array($var_phase)) {
			echo '<option value="'.$array_phase['Job_Number'].'">'.$array_phase['Description'].'</option>'."\r\n";
	 	}
	}

print "</select>";

print "</td>";
print "<td><input name='cwa1' type='text' size='1' maxlength='4' /></td>";
print "<td><input name='release1' type='text' size='3' maxlength='7' /></td>";
print "<td><input name='desc1' type='text' size='30' maxlength='30' /></td>";
print "<td>";
print "<select name='provider1'>";
print "<option value='2'>AT&T/SBC</option>";
print "<option value='1'>Metro PCS/T-Mobile</option>";
print "<option value='3'>Sprint/Verizon/Nextel</option>";
print "</select>";
print "</td>";
print "<td><input name='site1' type='text' size='15' maxlength='20' /></td>";				
print "<td><input name='phase1_ST' type='text' size='1' maxlength='4' /></td>";
print "<td><input name='phase1_OT' type='text' size='1' maxlength='4' /></td>";
print "</tr>";
}	
?>

[sid]

the quickest would probably a global incrementing variable ($cnt).

<?php
function work_order() {
global $var_phase, $phase_query, $array_phase;

global $cnt;
$cnt++;

print "<tr align='center'>"; 
print "<td>";
print "District: <select name = 'district'>";

	// Using the query as defined in the query section
	if ($var_phase = mysql_query($phase_query)) {
 echo '<option value="">Please select a district</option>'."\r\n";		
		while ($array_phase = mysql_fetch_array($var_phase)) {
			echo '<option value="'.$array_phase['Phase_Code'].'">'.substr ($array_phase['Phase_Code'], 1, -9).'</option>'."\r\n";
		}
	}

print "</select>";
print "</td>";
print "<td>W/O 1: <select name='phase1'>"; 

	// Using the query as defined in the query section
	if ($var_phase = mysql_query($phase_query)) {
 echo '<option value="">Please select a work order</option>'."\r\n";
		while ($array_phase = mysql_fetch_array($var_phase)) {
			echo '<option value="'.$array_phase['Job_Number'].'">'.$array_phase['Description'].'</option>'."\r\n";
	 	}
	}

print "</select>";

print "</td>";
print "<td><input name='cwa" . $cnt . "' type='text' size='1' maxlength='4' /></td>";
print "<td><input name='release" . $cnt . "' type='text' size='3' maxlength='7' /></td>";
print "<td><input name='desc" . $cnt . "' type='text' size='30' maxlength='30' /></td>";
print "<td>";
print "<select name='provider" . $cnt . "'>";
print "<option value='2'>AT&T/SBC</option>";
print "<option value='1'>Metro PCS/T-Mobile</option>";
print "<option value='3'>Sprint/Verizon/Nextel</option>";
print "</select>";
print "</td>";
print "<td><input name='site" . $cnt . "' type='text' size='15' maxlength='20' /></td>";				
print "<td><input name='phase" . $cnt . "_ST' type='text' size='1' maxlength='4' /></td>";
print "<td><input name='phase" . $cnt . "_OT' type='text' size='1' maxlength='4' /></td>";
print "</tr>";
}	
?>

however, i'd consider making the fields array elements like

print "<td><input name='cwa[]' type='text' size='1' maxlength='4' /></td>";

and then reference them via the $_POST array.

hope that helps...

[bschwartz]

OH THAT IS BEAUTIFUL!!!

THANK YOU!!

[NogDog]

Using a [man]static[/man] variable might be a bit more appropriate, unless for some reason you need access to it outside of the function.

[sid]

NogDog wrote:

Using a [man]static[/man] variable might be a bit more appropriate, unless for some reason you need access to it outside of the function.

in fact, NogDog is right (as usual)... for some reason i am so used to static vars from java, etc. that i only think of them instantly in an OO setting...

[bschwartz]

Originally Posted by NogDog
Using a static variable might be a bit more appropriate, unless for some reason you need access to it outside of the function.

So I should be doing this:

static $cnt;
$cnt++;

Instead of this:

global $cnt;
$cnt++;

So that the numbers will continue to increment from where they last stopped if the function was to be called again, correct?

My next step, which I'm not sure how to do yet, is just to create a button that users can push that will keep values entered on the form, call this function, and add a new line to the bottom of the form. Any suggestions on that?

[NogDog]

You will probably want to initialize the value, such as:

static $cnt = 0;
$cnt++;

[bschwartz]

I had another question for you guys on this same subject. I'm still working on my project, but I'm having trouble getting the results back because now when I'm trying to call the variables they are like double variables.

See attached image.

Each column has its own variable name + each row has a $cnt variable.
Like workorder1, cwa1, prime1, workorder2, cwa2, prime2, etc ....

How can I call these variables to post in the table if a user has already submitted values?

I'm trying this a couple of different ways, but I can't get either way to work. Can someone let me know which is best, and what will work.

print "<td><input name=\"release$cnt\" type=\"text\" size=3 maxlength=7 VALUE=\"$release$cnt\"></td>\r\n";

  if ($provider[$cnt] =="") {
	print "<select name=\"provider$cnt\">\r\n";
    print "<option value=''>Select a provider</option>\r\n";
    print "<option value='2'>AT&T/SBC</option>\r\n";
    print "<option value='1'>Metro PCS/T-Mobile</option>\r\n";
    print "<option value='3'>Sprint/Verizon/Nextel</option>\r\n";
	print "</select>\r\n";
	} else {
	print "value=\"$provider$cnt\"";
	}