Query Across Pages

timstring

[FONT=Fixedsys][/FONT]Here's what I want to do:

First page:

Open database, table & so on
|
|<<--------------------------------------------------
Select row                                           ^
|                                                    ^
Fold, spindle, mutilate row                          |
|                                                    |
Input form                                           |
|                                                    |
Launch Action File...Pass data to File 2             |
|                                                    |
Process Data    ----------------------------------->>|

What I can't figure out how to do is to go from the action file back to the 'Select' line in the first page, and then get the next row. All the info I've found wants to return to the beginning of the first page. How do I jump back to the middle of the first file and select the next row?

And y'all just thought y'all were rid of me!

"To be is to do."--Socrates
"To do is to be."--Plato
"Doo be doo be doo"--Sinatra

traq

um …loop?

What do you mean by "launch action file"? Are you sending out a [man]curl[/man] request (or similar)? or do you mean you're using [man]include[/man] (or similar)?

If you could encapsulate each of these steps (in a function or class), then you could simply loop through them as many times as you wish. If it's just a collection of procedural code, spread over two files, you'd need to make changes. We'd need to know more more about your actual code before giving a useful answer.

"Scooooo-be doo be doo"--Scooby Doo

NogDog

If you're talking about a sequence of form displays/submissions based on an initial query, then I would think you're either looking at using session data to store the progress through that query and other related process state information; or else handling it mainly on the client side via JavaScript to control the flow through the initial query's data, using AJAX to do each form submission.

Or I'm completely misunderstanding the question.

"Do wah diddy, diddy dum, diddy do."
~ Plato and Socrates just walkin' down the street

timstring

You asked for it:

<?php

$host="127.0.0.1";
$user="root";
$password="g*****89";
$Dbname = "calls_to_dispatch";

$mysqli = new mysqli($host,$user, $password, $Dbname) or die('host doesnt work ' . $mysqli->error);

// Check connection
if ($mysqli->connect_errno) {
    die ("Hey you dolt, Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error);
}


$Quest = "SELECT TechNum, FirstName, LastName, JobDesc, WideSystem FROM TOAWorkOrdersNew WHERE NOT EXISTS 
(
SELECT TechNum
    FROM Techs
    WHERE  ToaWorkOrdersNew.TechNum = Techs.TechNum)
GROUP BY ToaWorkOrdersNew.TechNum";


$SystemResult = $mysqli->query($Quest) or die('can not query');

$row = $SystemResult->fetch_assoc(); 
			 $count++;

	 		$TechNum = $row["TechNum"];
			$FirstName = $row["FirstName"];
			$LastName = $row["LastName"];
			$JobDesc = $row["JobDesc"];
			$WideSystem = $row["WideSystem"];

			$_SESSION['TechNum'] = $TechNum;
			$_SESSION['FirstName'] = $FirstName;
			$_SESSION['LastName'] = $LastName;
			$_SESSION['JobDesc'] = $JobDesc;
			$_SESSION['WideSystem'] = $WideSystem;

			echo $TechNum . ' fn ' . $FirstName . ' ln ' . $LastName . ' ti ' . $JobDesc . ' ws ' . $WideSystem . '<br><br>';
?>

This follows the PHP code:

<html>

<form action="InsertUnique.php" method="post" name="LogIn">
<p><label>Enter Cell Number:  </label><input type="text" name="CellNum" size = "20";/></p><br />

  <input type="submit" value="Go" />
</form>

</html>

Here's the action file:

<?php

session_name("PassTech");
session_start();


$host="127.0.0.1";
$user="root";
$password="g*******9";
$Dbname = "calls_to_dispatch";

$mysqli = new mysqli($host,$user, $password, $Dbname) or die('host doesnt work ' . $mysqli->error);

// Check connection
if ($mysqli->connect_errno) {
    die ("Hey you dolt, Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error);
}


$TechNum = $_SESSION['TechNum'];
$FirstName = $_SESSION['FirstName'];
$LastName = $_SESSION['LastName'];
$JobDesc = $_SESSION['JobDesc'];
$WideSystem = $_SESSION['WideSystem'];
$CellNum = $_POST['CellNum'];

			echo $count . ' tn ' . $TechNum . ' fn ' . $FirstName . ' ln ' . $LastName . ' ti ' . $JobDesc . ' sys ' . $WideSystem . ' cn ' . $CellNum . '<br><br>';

This is as far as I've gotten. I need to go from the "echo" statement back to the "select" statement in the first page. What do I do?

traq

Meaning, go back to that same result set? As in an interactive session?

I'm still not sure what your end goal is (for example, I can't tell what you're actually doing with the cell num), but IIUC, no, php can't do that. You'd have to either retrieve + store all the rows (e.g., in the session), or only retrieve one row at a time and keep track of which row you're on with each request (I vote for the former, unless there are tons of them).

I think @ hit it.

Also,

timstring;11036669 wrote:
"Hey you dolt, …"

Why so hard on urself, bro?

timstring

Stating my goal would be helpful. The query compares two tables and finds the ones that appear in table 1, but not in table 2 Then, the form comes up and asks for the cell phone number, and when I get the return worked out, I'll add some more fields. The action file simply inserts the information into the table 2. After that, I need to return to the query and grab the next row of data.

Is there a way to write a form and have it continue down the file instead of calling the action file? I made a feeble attempt, but did not work.

NogDog

Probably the simplest option is to display a set of form fields for each result row, so the form would be dynamically generated by the PHP script that does that original query. Then the user can enter data for each form row, submit it once, and then the PHP script that form calls would cycle through each set of fields. This is where using a square-bracket array-type name for your form elements can make things easier, giving you an array of $POST data to loop through, e.g.:

<form tag here, then...>
<?php
while($row = $SystemResult->fetch_assoc())
{
    echo "<div><label>Use stuff from \$row to populate stuff here ";
    echo "<input type='text' name='cell_nbr[{$row['techNum']}]' /></label></div>\n";
}
?>
<input type='submit' />
</form>

In this possibly simplistic example, $_POST['cell_nbr'] in the form's action script would be an array of values, with the keys being the related 'techNum' value, which you could then use in your update SQL, probably in a foreach loop on that array of data.

NogDog

PS: If that is not acceptable (having all the update fields on one HTML form), then you'll either need to store the initial query results in $_SESSION, possibly using array_pop() or array_shift() to pull off an entry to display on the form, and when the user submits that, if there is still data in that array, pop/shift the next one and display it, and so forth?

johanafm

NogDog;11036675 wrote:
    echo "<input type='text' name='cell_nbr[{$row['techNum']}]' /></label></div>\n";
In this possibly simplistic example, $_POST['cell_nbr'] in the form's action script would be an array of values, with the keys being the related 'techNum' value, which you could then use in your update SQL, probably in a foreach loop on that array of data.

Just be aware that if anyone changed any of those keys and sent the form to your script, they could alter any other database entries they wanted to, assuming they know or guess cell phone numbers.

If the user is allowed to edit all rows, this obviously is no problem, but otherwise you will have to deal with it.