PHP Coding
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Codewalkers ForumsPHP RelatedPHP Coding

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
Old April 8th, 2010, 10:42 AM
sdavies1 sdavies1 is offline
Registered User
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2010
Posts: 1 sdavies1 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 37 m 14 sec
Reputation Power: 0
PHP Query Search - birthday match

I've got a site thats been made in Joomla with Jomsocial. I have a module that you enter an age range and it searches the MySQL database for users ages and gives the results in a list.

I need it changing to be a field that you enter your birthday (day and month) and it searches the MySQL database and presents users who have the same birthday. It is probably quite a simple search query but i'm no programmer.

The module i'm using is on the jomsocial website under add-ons (a Google search for "Jomsocial Dating Search" brings it up).

.....but it might be easier to write this from scratch (not sure).

There are loads of PHP examples that show birthdays coming up but not a searchable field for any users who have the birthday you type in.

Any help greatly appreciated.

Reply With Quote
Old April 8th, 2010, 04:40 PM
MatthewJ MatthewJ is offline
Contributing User
Codewalkers Beginner (1000 - 1499 posts)
 
Join Date: May 2007
Location: Davenport, Iowa
Posts: 1,021 MatthewJ User rank is Lance Corporal (50 - 100 Reputation Level)MatthewJ User rank is Lance Corporal (50 - 100 Reputation Level)MatthewJ User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Week 6 Days 12 h 13 m 18 sec
Reputation Power: 9
There's sort of a lot wrapped into that question

You're going to need to do a few things,

1. create the form that will submit the date to search for (in the format you want). Usually, I let a user enter the date a few different ways, then reformat it before I work with it (i.e. 09/18/1975 or 9.18.1975 or 9-18-1975 etc.).

2. Format the date entered so it matches the birth date field from the database so you can compare them properly.

3. Then it's a pretty straight forward query to get the people where the dates match.

There is a decent amount of ground between where you're at and where you want to go though.

that should at least give you an idea of where to start. If you would like some coding help, post the code you want to incorporate this into.

Reply With Quote
Reply

Viewing: Codewalkers ForumsPHP RelatedPHP Coding > PHP Query Search - birthday match


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

© 2003-2014 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap