Re: bucle while for to msqyl
| From: | Serge Fonville | Date: | Sun, 16 Sep 2012 21:21:36 +0000 |
| Subject: | Re: bucle while for to msqyl | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-319099@lists.php.net to get a copy of this message | ||
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
>>
>>
>>
>> 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
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>