Đang Thực Hiện

166365 Small Php MySQL job

We have a forum (Php) for our client's school cadets and want to know how to make available in search

cadets in age and gender range.

There is no feild of age in our forum Mysql database. but it out puts age of cadet through a code

which calculates cadet's age from db feilds cadet_birthday,

cadet_birthmonth and cadet_birthyear

and in profile it says


name: lalit

age : 15

gendre : male

class: 9th

you have to make a mysql search code for searching cadets for a particular range like e.g.

search cadets

gender = male/female

age= 10 to 15

and code to safe guard serch and input feilds

form SQL injections.

php code :


$max_results = 10;

$from = (($page * $max_results) - $max_results);

$get_results = mysql_query("SELECT * FROM cadetforum_users WHERE cadet_gender='".$_GET['gender']."' AND cadet_class='".$_GET['class']."' AND cadet_rank='".$_GET['rank']."' AND cadet_section='".$_GET['section']."' AND active_status='".$_GET['online']."' AND cadet_picture='".$_GET['picture']."' LIMIT $from, $max_results");


Kĩ năng: AJAX, Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: serch it, Serch, searching online job, school rank, rank school, rank of school, profile php code, php online job, php mysql job, php form search mysql database, php code search mysql database, php code online, php ajax sql, online job forum, online code school, job serch, job search online, how to search for a job online, how to job search, online mysql database, mysql client, small php, guard, mysql code search, mysql database search form

Về Bên Thuê:
( 0 nhận xét )

ID dự án: #1912558