You are here: Re: [PHP] Refresh (F5) adds another SQL record. « PHP « IT news, forums, messages
Re: [PHP] Refresh (F5) adds another SQL record.

Posted by Mukasa Assey Alfred on 10/01/36 11:16

Sorry for that....., i miss read that.. sorry, thought he wanted a php
function to
refresh the browser.

Assey.

On Wed, 18 May 2005, M. Sokolewicz wrote:

> Next time, Mukasa, try reading... Robert clearly states that he'd like a PHP
> function which TELLS him if the page has been refreshed or not (thus,
> "resent"). There are headers sent out that indicate this, and thus a function
> like refreshed() would be a shortcut to getting to know if it has.
>
> He doesn't ask to FORCE a refresh, or to even execute PHP in a browser (what?
> how did you get to this...??)
>
> Mukasa Assey Alfred wrote:
>>
>>
>> On Tue, 17 May 2005, Robert Meyer wrote:
>>
>>> As a last resort, I may have to do that, but that is by no means the
>>> preferred method. I want to keep database access to a minimum.
>>>
>>> I thought by this time this problem would have had a standard solution.
>>> It
>>> would be nice if PHP had a function like refreshed() so one could do ...
>>> if
>>> (!refreshed()) { ... } ..., but I guess not.
>>>
>>
>> PHP is a server-side programming language, the problem you are facing is a
>> client-side problem. PHP thus would not be able to do browser refreshes!
>> sorry! Unless of course you have a PHP enabled browser :-)
>>
>> Your browser caches the information sent from the form and so long as the
>> page is not reloaded..., the variables are still set and submition of data
>> may continue indefinately.
>>
>> Two options,
>>
>> You may use the php header() funtion for redirection,
>> or
>> Resort to a client-side reload using a scripting language like
>> javascript..., "document.location.href='....';
>>
>> Assey.
>>
>>> Thanks for your input.
>>>
>>> Regards,
>>>
>>> Robert
>>>
>>> "Marcus Joyce" <newsletters@online-obsession.com> wrote in message
>>> news:428A7964.5000905@online-obsession.com...
>>>
>>>> Why dont you check that data isnt being duplicated?
>>>>
>>>> $query = "SELECT auto_col FROM table where col1 = $var1 & col2 = $var
>>>> 3.............";
>>>> $call_query = mysql_query($query,.......
>>>> $query_data = mysql_assoc($call_query);
>>>>
>>>> if(!$query_data) { do form }
>>>>
>>>> else echo "information already exists in database";
>>>>
>>>>
>>>> Pierce
>>>>
>>>> Robert Meyer wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>> Scenario:
>>>>> 1) User is presented a blank form.
>>>>> 2) User fills in form.
>>>>> 3) User submits form.
>>>>> 4) Record is added to database.
>>>>> 5) Back to 1).
>>>>> All is fine to here.
>>>>> 6) User clicks refresh.
>>>>> 7) Another record is added, same data except auto-increment field.
>>>>> How do I prevent these last two steps, or at least prevent a record
>>>>> from being added when refresh is clicked?
>>>>>
>>>>> Regards,
>>>>>
>>>>> Robert
>>>>>
>>>
>>> --
>>> PHP General Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация