Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm not that familiar with PHP, but this generally seems like you are unclear on the concepts. Note to readers: lack of response often indicates an unclear formulation of the question. </p> <p>Correct me if I'm wrong, but here is how I understand the problem from your description:</p> <ol> <li>You have a CSV of &lt;restaurant>,&lt;cuisine> pairs.</li> <li>You have an omnibox on a web page where a user can enter restaurant or cuisine.</li> <li>You want the omnibox to autocomplete based on the CSV.</li> <li>You want to use the jQuery autocomplete widget to help with this.</li> </ol> <p>The code you have presented tells a different story. The PHP code seems to be doing pretty much nothing. It stuffs a lot of data from a file into a <code>data[]</code> and then does nothing with it. I have no idea what that function produces.</p> <p>Setting that aside, the HTML you present is a <code>&lt;body&gt;</code> block that contains an input type and a label for that type. (That's okay for this kind of discussion.) </p> <p>The JavaScript/jQuery, however, is barely related. I don't see why UI items are expected to have a <code>label</code> and an <code>actor</code>. The general display of the auto-complete suggests you want to keep the restaurant and cuisine together and show them as a single selector but you want to have them select on either. This is not something the widget provides "straight out of the box" but it has hooks where you can add code to accomplish what you want. </p> <p>A good place to start is to realize that while the widget is helpful, it is not meant to deal with multivalued objects. You're going to have to do some significant customization. </p>
    singulars
    1. This table or related slice is empty.
    1. POjQuery UI autocomplete using csv with two fields
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USOld Pro
    1. USOld Pro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COI understand your points, but as it is, I have been given this situation to solve. I am required to make a functional jQuery UI autocomplete populated from a csv file with a specific format using PHP to server the data to the JS. By the way, if my question is unclear and no one is answering because of that, then at the very least the readers who required more info to answer perhaps should have let me know that. Maybe I could have had this solved a lot sooner if they had. ;)
      singulars
      1. PO
      1. USmarky
    2. COIt doesn't seem to me you understand my points. We are all volunteers here with way more questions to answer than we have time for; it is up to the asker to make their question clear enough and interesting enough for someone to want to answer it. Your description is vague, your code doesn't match your description, and it is obvious that you need a lot more education and training that we can provide here. SO is about providing education by answering well-defined questions of general interest. This question reads more like 'please write code for me because I am in over my head'.
      singulars
      1. PO
      1. USOld Pro
    3. COFor an example of a well-asked question, see http://stackoverflow.com/q/16435428/712765
      singulars
      1. PO
      1. USOld Pro
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload