Jump to content

mat22

New Members
  • Posts

    4
  • Joined

  • Last visited

mat22's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. mat22

    Captcha

    Thanks Eric for the reply. This makes me feel confident in using both of them. What concerned me was i got a guestbook that i made myself, a blog i made myself and other additional features that allows user input such as comments on blog, send blog to a friend etc and the thought i having tons of spam hitting all the forms would be a killer, althou i have some measures in place it is still nice to avoid as much spam as possible. I logged into my Google Webmaster account back last week and noticed someone was linking to my site from an unknown source that i was not aware of, when i checked the site it was a post on a forum which had hundreds of links in the post one of them being a link to my site saying to spam my site etc. I was shocked at what i saw but thankfully no humans came around and spammed my site. But hearing what you have said i feel confident i will be ok with it. Thanks, Mat
  2. mat22

    Captcha

    Hi, Don't mean to hijack. Just want to say thanks to both LSW and Wickham. One my first ever post today on this forum my second question was about how people validate a human is actually a human, currently i use recaptcha which works great but it lacks due to it requires javascript, if disabled it makes your pages look very ugly, secondly althou it comes with audible support i myself who has fantastic hearing cannot understand it or here it clearly and my concern was with people with disability having problems with the recaptcha like seeing the characters etc. Plus lately they have added black background circles etc to the text and the text is also black and i myself have became concerned as i who also have good vision found it hard to understand some of the text. I was going to use the akismet service but felt it was not ideal for me personally. So i thought both your ideas about asking a user a simple math question and the hidden field to be good yet simple ideas. I did think about the question one before but never thought anymore of it, so thanks to you both for your simple ideas, i have added both features to each of my forms. May i ask have you had spam using both methods on a single form? I would be interested to here the statistics. Thanks Mat
  3. Hi, There is no repetition of entries. I just been reading it can take pressure off a table etc. I certainly am no expert but it seems rather logic that it would help splitting profiles on a different table for performance reasons according to everything i have been reading. Thanks for the reply i will still wait to here what others have to say, Thanks Mat
  4. Hello, First i would like to say hello to everyone, i have visited KillerSites several times in the past since learning PHP about 7 months ago, would like to say thanks to Stefan for the great videos and anyone else who may also be helping with videos etc. 1) I created a fully pledged member system as a project to help me learn PHP, infact i love it, i built it with security being my top priority and have extended it since and is coming along great. ... My question is not directly about PHP itself rather than MySQL. I have a table called userinformation which as you probably guessed contains all the information about my users. Currently there are 17 columns for each user, yes i feel bad about it as from what i have learnt this is really bad practice and should be split up into another table. Basically the reason for this is because the profiles for each of my users are on the same table. I decided i want to split up the profiles for users on a seperate table but althou i have searched and red allot of information online i am not sure exactly the best way to deal with it. I know i need to use a join, thing is althou i have been reading and trying to learn about joins i dont know which one i should use. Secondly is there anything via phpmyadmin that i need to do to join the table or do i just use php to query both tables etc? Currently when a user signs up to my site there is an id field that is auto incremented, this is the primary and unique key. Now my problem is when a new user signs up the id is not known by the script so how do i add the user to the profile section when i wont know the id that was created by mysql? obviously to my knowledge the profile table would have the user id aswell so when querying it is a matter of checking id from userinformation with the id in the profiles table. If anyone could really explain this to me, i have been wanting to tackle this now for months and want to do it before my sites gets busy, i am just scared to do it incase i mess it up. Of course i have XAMPP installed for local testing. 2) Currently my website uses Recaptcha which until now has never failed me... i dont mind it, i mean it has audio support for visual impaired and helps digitize books but reading online it seems not very good practice to use captchas althou most places i go use them, personally i dont care if a site has them or not as i understand from a developers point of view why it is implemented into there website. I have been reading about Akismet and it sounds good but not so good. I was thinking about replacing my captchas for this service but wondering what others think i should do use Akismet of stay with Recaptcha. I mean let take for example i implemented it into my site and someone registered and it was suspected spam, would i just not add the user to the database or add them to the database but verify manually? i think the verify manually but again i am not sure if i will be wasting my time when i could be doing other things to enhance my site. Sorry for such a long drag of a post but honestly the 1st question i have is something i been wanting to tackle for some time but am literally scared to even do it. Once i done it once i will use it to it's full advantage and think that was easy but until then i am worried about it. Question 2 is more of an opinion. Thanks for any help/advice you can provide. And thanks for such a great site and extensive amount of useful resources. It has helped me so much in my development. Update Was also meant to say is there a bug in this forum? Reason is when i click on links i right-click on them to open in a new tab in latest version of firefox but if i right-click on any links on this forum the right-click works the same as the left-click meaning it just loads the page requested instead of asking me to open in new window, tab etc.. It is very annoying lol. Regards, Mat
×
×
  • Create New...