MySQL query inside query while loop not working (PHP)

Question

BIG EDIT: I've trimmed the code as much as possible while getting the same notice. So I'm trying to use the variable $tour which is defined in the first if(isset.... This if creates a second submit that when pressed should print the value $tour but I get the following output:

Notice: Undefined variable: torneo in /home/user/public_html/edit/file.php on line 19
1
before loop

Notice: Undefined variable: torneo in /home/user/public_html/edit/file.php on line 21

The trimmed code is:

<form method="POST">
TORNEO: <select name="torneo">
            <option value="DSHN ADULTO">DSHN ADULTO</option>
            <option value="NFL">NFL</option>
        </select>
<br />
<input type="submit" value="ELEGIR" name="input1"/>
<br />
<?php
ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(-1);
if(isset($_POST['input1'])){
    $torneo = $_POST['torneo'];
    echo $torneo;
    echo "<br><input type='submit' name='input2' value='CREAR'/>";
}     
if(isset($_POST['input2'])){
    echo $torneo."1";
    echo "<br>before loop<br>";
    while ($torneo){
        echo "Updated! ".$torneo."<br>";        
    }
}  
?>
</form>

Thanks for the help!

Are you connecting with mysqli?Also in your query shouldn't be WHERE WEEK(DATE)=.... AND YEAR(DATE)=..? — Mihai
– Mihai, Commented Jan 15, 2014 at 20:40
@Mihai Yes I am. Ive been cpnnecting with the same script for a long time and never got any issue though. — Enric Grau-Luque
– Enric Grau-Luque, Commented Jan 15, 2014 at 20:46
Check to see if your query actually returned some rows. Run the query directly on the database (ie, command line, MySql Workbench). Print out $query to be sure it's the proper format. — dar7yl
– dar7yl, Commented Jan 15, 2014 at 22:51
@LightnessRacesinOrbit thank you for the advice. Now I did trim the code desently (I believe). So its not about the connection. I just cant get the variable through the second submit... Thanks! — Enric Grau-Luque
– Enric Grau-Luque, Commented Jan 16, 2014 at 13:57
@EnricTomás: Yes! Woohoo!! This is now a perfect testcase. :D Excellent work. Hopefully you can now see the extreme value in doing this. — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Jan 16, 2014 at 15:01

dar7yl · Accepted Answer · 2014-01-15 22:45:46Z

1

echo "</form>";
mysqli_close($db);

... mysqli_close($db);

You have an extraneous close, before the second part of your script.

answered Jan 15, 2014 at 22:45

dar7yl

3,78728 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dar7yl Over a year ago

I see you open the database again.. Why not keep it open and close it at the end (you can test if it is opened).

Enric Grau-Luque Over a year ago

I tried keeping it open from the very beginning and closing it at the end and still no loop. Tried different combinatios and the nothind :(

Community · Accepted Answer · 2017-05-23 12:05:41Z

1

The answer to my problem is here:

Why do I keep losing variable values when submitting a second form on the same page

Thanks everyone who helped, Im really very thankful to all!

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Jan 16, 2014 at 14:04

Enric Grau-Luque

12411 bronze badges

1 Comment

rm-vanda Over a year ago

You may also benefit from switching your while() loop to a foreach() loop --

Collectives™ on Stack Overflow

MySQL query inside query while loop not working (PHP)

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related