Awesome Work Bro!! Need a small help

[arunbabucode]

This is the best API builder I tried. Good Work.. Keep it up.

Any way can you help me to sort out the values. say, I have a column named 'price' which contains integers. Suppose it contains values 100, 20, 10, 23, 250 , 500 , 1000. I want to sort the values and show only values greater than 200. is such a classification is possible?

Thanks

[brannondorsey]

Thanks much @sphirelabs!

I haven't touched this code in quite a while, but if my memory serves me correctly those kinds of comparisons aren't actually possible through the url parameters. If I were to revisit this project there are quite a few things that I would change, and they way that I handle integer compares would certainly be one of them.

Is it possible for you to fetch all of the values from the API and then perform those queries on your front end?

[MechTrigger]

Class 'mysqli' not found in....api_builder_includes/class.Database.inc.php on line 25. Wow banging my head on this, can't seem to find out why its not recognizing the instance. Anyone come across this? Probably a silly error on my part...

[brannondorsey]

Hm... Can't think of what that might be off the top of my head other than the fact that your version of PHP doesn't support mysqli.

[MechTrigger]

Hey thanks for responding! I figured it out I think mysqli needs to be explicitly enabled in the phpmyadmin in the cpanel of the hosting server, at least that's eat conclusion i came to after some googling. I used pdo instead and that works fine. Nice work on that api though, I'm going to save it for future projects. I am a .net developer so when I work with php it seems a little foreign. Thanks again! On Feb 17, 2016 8:09 PM, "Brannon Dorsey" [email protected] wrote:

Hm... Can't think of what that might be off the top of my head other than the fact that your version of PHP doesn't support mysqli.

— Reply to this email directly or view it on GitHub https://github.com/brannondorsey/apibuilder/issues/6#issuecomment-185509464 .