Re: bucle while for to msqyl

From: Date: Sun, 16 Sep 2012 22:08:20 +0000
Subject: Re: bucle while for to msqyl
References: 1 2 3 4 5 6 7 8 9  Groups: php.general 
Request: Send a blank email to php-general+get-319102@lists.php.net to get a copy of this message
<? $conexion = mysql_connect("localhost", "usuario", "123456"); mysql_select_db("probando", $conexion); function updateNumero() { $queEmp = "SELECT n FROM numero WHERE n LIKE 1"; $resEmp = mysql_query($queEmp, $conexion) or die(mysql_error()); $totEmp = mysql_num_rows($resEmp); if ($totEmp> 0) { while ($rowEmp = mysql_fetch_assoc($resEmp)) { $numero = $rowEmp['n']; } } return $numero; } ?> in this way? I do not understand is where the loop would do, what I need to remember is that if it is "true" to repeat the condition and if false stops. Thanks! 2012/9/16 Serge Fonville <serge.fonville@gmail.com> > If you wrap the query inside your while loop at the point where you want >> to check for a change of the value it will change at every iteration. > > > For ease of use, it would be better to create a function around the data > gathering part, i.e. > >> function updateNumero() { >> >> $queEmp = "SELECT n FROM numero WHERE n LIKE 1"; >> $resEmp = mysql_query($queEmp, $conexion) or die(mysql_error()); >> $totEmp = mysql_num_rows($resEmp); >> if ($totEmp> 0) { >> while ($rowEmp = mysql_fetch_assoc($resEmp)) { >> $numero = $rowEmp['n']; >> } >> } >> return $numero; >> } > > > Kind regards/met vriendelijke groet, > > Serge Fonville > > http://www.sergefonville.nl > > Convince Microsoft! > They need to add TRUNCATE PARTITION in SQL Server > > > https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table > > > > 2012/9/16 El Ale... <alexissaucedo@gmail.com> > >> How could I?, should use another command? I need to do that if the value >> of the script is the same as the database and repeat but stops. >> >> greetings! >> >> >> 2012/9/16 Serge Fonville <serge.fonville@gmail.com> >> >>> Since the value is never changed inside the loop, it will run >>> indefintely or stop immediately. >>> >>> You need to re-request the value from the database to change $numero to >>> a possible other value. >>> >>> Kind regards/met vriendelijke groet, >>> >>> Serge Fonville >>> >>> http://www.sergefonville.nl >>> >>> Convince Microsoft! >>> They need to add TRUNCATE PARTITION in SQL Server >>> >>> >>> https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table >>> >>> >>> >>> 2012/9/16 El Ale... <alexissaucedo@gmail.com> >>> >>>> yes it 1 = 1 its (true) bucle's run, but! if 1 is not same 1 bucle >>>> break. >>>> when consulted database and this value is 1, the loop continues, but >>>> when changing the value of the database for example "value 2", the loop >>>> should stop because 1 is not equal to 2 but not Doing so ignores it and >>>> segue running as if the value is one, that's the problem >>>> >>>> Thank you! >>>> >>>> >>>> 2012/9/16 Serge Fonville <serge.fonville@gmail.com> >>>> >>>>> Also, if $numero equals 1, it always prints 1. >>>>> Is that the expected behaviour? >>>>> >>>>> When it does not match 1, it does nothing except it echos 1 twice, >>>>> first in the conexion.php and second in the first iteration of the >>>>> while loop >>>>> >>>>> Kind regards/met vriendelijke groet, >>>>> >>>>> Serge Fonville >>>>> >>>>> http://www.sergefonville.nl >>>>> >>>>> Convince Microsoft! >>>>> They need to add TRUNCATE PARTITION in SQL Server >>>>> >>>>> >>>>> https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-tableÔ¨�‡EHÊ >>>>> Ë÷²„²í >>>>> >>>>> >>>>> >>>>> 2012/9/16 El Ale... <alexissaucedo@gmail.com> >>>>> >>>>>> >>>>>> >>>>>> 2012/9/16 El Ale... <alexissaucedo@gmail.com> >>>>>> >>>>>> Im sorry "reset;" is not, this is: >>>>>>> >>>>>>> <? >>>>>>> include("conexion.php"); >>>>>>> >>>>>>> do { >>>>>>> >>>>>>> >>>>>>> echo "$numero"; >>>>>>> sleep(1); >>>>>>> >>>>>>> >>>>>>> if ($numero == 1) >>>>>>> >>>>>>> continue; >>>>>>> break; >>>>>>> } while (true); >>>>>>> >>>>>>> ?> >>>>>>> >>>>>>> Thanks! >>>>>>> >>>>>>> >>>>>>> 2012/9/16 Serge Fonville <serge.fonville@gmail.com> >>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> if ($numero == 1) >>>>>>>>> reset; >>>>>>>>> continue; >>>>>>>>> break; >>>>>>>>> } while (true); >>>>>>>> >>>>>>>> >>>>>>>> If the $numero is equal to 1 reset seems odd >>>>>>>> reset is a function.and requires an array >>>>>>>> Based on your code, this would run indefintely >>>>>>>> Since there are no braces after the if statement, only the first >>>>>>>> statement is executed when $numero equals 1 >>>>>>>> >>>>>>>> Also, is this your actual code? >>>>>>>> >>>>>>>> If not and possible please add that >>>>>>>> >>>>>>>> HTH >>>>>>>> >>>>>>>> Kind regards/met vriendelijke groet, >>>>>>>> >>>>>>>> Serge Fonville >>>>>>>> >>>>>>>> http://www.sergefonville.nl >>>>>>>> >>>>>>>> Convince Microsoft! >>>>>>>> They need to add TRUNCATE PARTITION in SQL Server >>>>>>>> >>>>>>>> >>>>>>>> https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> 2012/9/16 El Ale... <alexissaucedo@gmail.com> >>>>>>>> >>>>>>>> hi! im new in this forum, i not speak very good english, apologise >>>>>>>>> im >>>>>>>>> spanish. >>>>>>>>> I have a problem, need one infinit bucle to mysql only >>>>>>>>> "true" if >>>>>>>>> "false" >>>>>>>>> break this, for example: >>>>>>>>> >>>>>>>>> prueba.php: >>>>>>>>> >>>>>>>>> <? >>>>>>>>> include("conexion.php"); >>>>>>>>> >>>>>>>>> do { >>>>>>>>> >>>>>>>>> >>>>>>>>> echo "$numero"; >>>>>>>>> sleep(1); >>>>>>>>> >>>>>>>>> >>>>>>>>> if ($numero == 1) >>>>>>>>> reset; >>>>>>>>> continue; >>>>>>>>> break; >>>>>>>>> } while (true); >>>>>>>>> >>>>>>>>> ?> >>>>>>>>> >>>>>>>>> ############################################################3 >>>>>>>>> >>>>>>>>> connect to mysql >>>>>>>>> >>>>>>>>> conexion.php: >>>>>>>>> >>>>>>>>> <? >>>>>>>>> >>>>>>>>> $conexion = mysql_connect("localhost", >>>>>>>>> "alexis", "123456"); >>>>>>>>> mysql_select_db("probando", $conexion); >>>>>>>>> $queEmp = "SELECT n FROM numero WHERE n LIKE 1"; >>>>>>>>> $resEmp = mysql_query($queEmp, $conexion) or >>>>>>>>> die(mysql_error()); >>>>>>>>> $totEmp = mysql_num_rows($resEmp); >>>>>>>>> if ($totEmp> 0) { >>>>>>>>> while ($rowEmp = mysql_fetch_assoc($resEmp)) { >>>>>>>>> $numero = $rowEmp['n']; >>>>>>>>> >>>>>>>>> } >>>>>>>>> echo "$numero"; >>>>>>>>> } >>>>>>>>> mysql_close($conexion); >>>>>>>>> ?> >>>>>>>>> >>>>>>>>> What I do is to run the loop as long as the value "$ >>>>>>>>> number" is >>>>>>>>> equal to >>>>>>>>> "1" in mysql I have a single field called >>>>>>>>> "n" with the value "1" >>>>>>>>> and runs, >>>>>>>>> now the problem is the next, I run the loop with the value >>>>>>>>> "1" in >>>>>>>>> mysql and >>>>>>>>> it runs fine but when I go to mysql and change the value to >>>>>>>>> "2" >>>>>>>>> (which >>>>>>>>> would be an incorrect and should leave) the loop ignores him >>>>>>>>> and >>>>>>>>> continues >>>>>>>>> running, I was reading a lot about the loops but I can not make >>>>>>>>> it >>>>>>>>> work in >>>>>>>>> this way could you please give me a hand with this? or if >>>>>>>>> I'm >>>>>>>>> wrong What >>>>>>>>> else I can do an infinite command if it fulfills a function and >>>>>>>>> if >>>>>>>>> they do >>>>>>>>> not?. >>>>>>>>> >>>>>>>>> Best regards >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >

« previous php.general (#319102) next »