jeudi 9 février 2017

Matching selected value from dropdown option to mysql databse

I'd created a criteria in a form of select option for different places/addresses then whatever selected will be compared to the lat and long in the database.Any idea on how to compare or maybe converting it first then if there is a match..I will grab its value.

Step 1.I have a database table with columns lat and long that i want to retrieve.

Step 2.After retrieving, i want it to be converted into string.How to implement it in laravel?

Step 3.The result of the conversion is use to compare my input string address from the view.

Step 4.If my input is London,it will compare to the converted lat long(which already a string),if the word is found within the string.I will get the values of the whole row.Anyone knows how to implement it in laravel?

Its kinda hard to me since i dont have any idea how to convert it.

//sample 
    <div class="form-group">
          <label>Select Province:</label>
          <select class="form-control">
            <option>Cebu</option>
            <option>Bacolod</option>
            <option>Naga</option>
          </select>
     </div>


    scholar_table
    id   name           gender          lat                 long
    1    John           Male        10.295866           123.889362
    2    Joseph         Male        10.352621           123.914448
    3    Genrevel       Female      10.331987           123.91059989999997



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2lrHnV0
via IFTTT

Aucun commentaire:

Enregistrer un commentaire