php-windows Digest 26 Apr 2012 15:00:50 -0000 Issue 4031
Topics (messages 30849 through 30850):
Re: Function assistance
30849 by: Paul Vatta
Alternative to captcha - using JQuery and ajax to 'time' form input
30850 by: Jacob Kruger
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
Could it have come down to a simple typo. Checking the table name, do you
have a table with the name "memeber" or "member"?
On 10 April 2012 02:20, Gavin <gavin.chalk...@gmail.com> wrote:
> Hi Suman,
>
> Yes the variables are containing data. vcode is randomly generated,
> loginName, and email come in from a form.
>
> I have used var_dump, and also print on the variables, and data is there.
>
> Best Regards,
>
> Gavin Chalkley
>
> [image: MSTC WES7]
>
>
> On 09/04/2012 17:14, madavapeddi suman wrote:
>
> hi,
>
> Trying seeing whether $vcode ,$loginName and $email variables contains
> the values?
>
> /Suman
>
> On Mon, Apr 9, 2012 at 11:44 AM, Gavin <gavin.chalk...@gmail.com> wrote:
>
>> All,
>>
>> I am having a small issue which is making me bang my head against a wall.
>>
>> I am running XAMMP with PHP 5.4 installed and this worked before
>> uploading to my live dev site.
>>
>> The part of the function that doesn't seem to be working is :
>>
>> $pdo = $this->connection();
>> $sql = "UPDATE `memeber` SET `vcode`=:vcode WHERE
>> `loginName`=:loginName and `email`=:email";
>> $q = $pdo->prepare($sql);
>> $q->execute(array(':vcode' => $vcode, ':loginName' => $loginName,
>> ':email' => $email));
>>
>> I have tried the SQL statement direct into PHPMyAdmin, replacing the
>> :name holders with true data, and it worked.
>>
>> But trying the above script fails to update. Am i missing something
>> completely here?
>> --
>>
>> Best Regards,
>>
>> Gavin Chalkley
>>
>> [image: MSTC WES7]
>>
>>
>
--- End Message ---
--- Begin Message ---
Opinions/thoughts?:
http://docs.jquery.com/Tutorials:Safer_Contact_Forms_Without_CAPTCHAs
Basically it pulls the server time in background using an ajax call, and
implements an MD5 encrypted value in a hidden field, and then you can double
check the timing of form input to sort of verify that it was real time, and not
a form of automated process, by a spambot/robot as such.
Only real issue here is it would require user to have cookies and javascript
enabled, but anyway..?
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
--- End Message ---
