title: "leaflet" How do I store and retrieve (search for) markers using a MySQL database?
body: <p>I'm having a hard time with this project: <a href="https://groups.google.com/forum/#!topic/leaflet-js/Vl56hyRp1i8" rel="nofollow">https://groups.google.com/forum/#!topic/leaflet-js/Vl56hyRp1i8</a></p>
  
  <p>I hope you guys can help me with this last step.</p>
  
  <p>There will be hundreds of thousands of markers but only the one you search for will be displayed. The content of the tooltips will have to be submitted through a form. I will not know the position for the markers until the mosaic is rendered.</p>
  
  <p>Once the mosaic is rendered we have the position of the markers and I need to be able to search for any marker (by it's ID) and zoom+pan to it while displaying the marker and it's tooltip.</p>
  
  <p>For example if I want to make a mosaic of 500x500 pictures this is what will happen:</p>
  
  <ul>
  <li>we wait for users to submit a picture each until we have 250.000 pictures.</li>
  <li>the tooltip meta content will be submitted along with each picture from the users (1 picture for each user) - this is also when the marker ID will be generated</li>
  <li>now that we have 250k pictures we can render the mosaic, after the mosaic is complete I will have a text file containing the name and location of each individual picture by row+column</li>
  <li>I need to use this file to fill in the position of the marker for each user's picture</li>
  <li>I need to be able after this, to display only markers that you search for</li>
  <li>when you search for a marker it will be by it's ID so it will be accurate and also I need the zoom+pan function here</li>
  <li>when you click on a picture (marker) I need for that marker to appear (unhide the tooltip).</li>
  </ul>
  
  <p>If anybody can help me please, this project is very cool and I would hate to get stuck on it. I will give proper credit and stuff. If you are really good I am even considering monetary rewards.</p>
  
  <p>Thanks.</p>