mysql query with filters

₹600-1500 INR

Dokončeno

Zveřejněno

před více než 5 roky

₹600-1500 INR

Zaplaceno při doručení

I want to make below sql injection proof mysql query. It's rough outline is given below <?php $sizes=$_GET['sizes']; $prices=$_GET['prices']; $type=$_GET['type']; //TYPE MAY BE 1 OR 1,2, OR NOTHING // PRICE MAY BE RANGE 0-25, OR 0-25,25-50, OR NOTHING // SIZE MAY BE 1, OR 1,2,3, OR NOTHING $host = ""; $username = ""; $password = ""; $db = ""; // CONNECT TO DATABASE $query = "SELECT * from zonez WHERE " if(isset($_POST["zonesize"])){ $filter = //comma seperated string of values $query .= " AND zonesize IN('".$filter."')"; } if(isset($_POST["zoneprice"])){ $filter = //comma seperated string of values $query .= " AND zoneprice IN('".$filter."')"; } if(isset($_POST["zonetype"])){ $filter = //comma seperated string of values $query .= " AND zonetype IN('".$filter."')"; } AND GROUP THESE ABOVE RESULTS BY webname fetchAll(PDO::FETCH_ASSOC); RESULTS HERE FETCH wename here ?> Code must be complete from connecting to database and producing required result along with sql injection proof.

MySQL

PHP

IČ projektu: 18395543

O projektu

5 nabídky

Vzdálený projekt

Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@NexisInfotech

Hello Sir, We have expert web developer .someone have more than 5 year experience. I read your requirement & we are able to complete your task on time. I promise quick turnaround times, unlimited revisions, great customer service and 100% quality work. please message me for more discussion about task. Thank You Nexis Infotech.

₹1 200 INR v 1 dni

5,0

(1 recenze)

0,5

5 freelanceři nabízejí v průměru ₹1 410 INR za tuto práci

@infobeckons

Hello Sir, I have read your job description regarding mysql query with filters. I have 6+ year of experience in MySQL, PHP. I have strong expertise to accomplish this project in decided time frame. Lets discuss in detail so that we never skip basic thing during project implementation. Thanks & Regards

₹1 300 INR v 1 dni

4,9

(22 recenze)

4,6

@Intranetman

HI, I AM A PHP PROGRAMMER AND WEB DEVELOPER. I HAVE A LOT OF EXPERIENCE IN PHP CODING AND DIFFERENT KINDS OF SCRIPTING LANGUAGES. I HAVE DEVELOPED MANY DYNAMIC WEBSITES USING PHP AND MYSQL. I CAN MAKE SURE WHAT YOU NEED. PLEASE SHARE FURTHER INFORMATION. THANKS

₹1 300 INR v 1 dni

5,0

(5 recenze)

2,2

@Chandel2007

Dear employer, I have seen your specific requirement regarding the SQL and filters. I would like to offer my service for the same as I found this well within my capabilities. I have a vast experience of about 10 plus years total in web development field as PHP my SQL and WordPress developer. Further come on chat to discuss more regarding your requirement. Thanks

₹1 750 INR v 1 dni

5,0

(2 recenze)

1,2

@salleks

Im professional with mysql and i can fix this code. Your code will be complete from connecting to database and producing required result along with sql injection proof.

₹1 500 INR v 1 dni