1

I have been working on Pset 8 Mashup, and have so far completed the first two parts of the eight-part assignment, but I have come to the Search part, and do not understand. Firstly, what am I supposed to add to the SQL data table? And can someone explain what I am supposed to do for the function specifically?

Thanks in advance for your help!

0

You are supposed to add a FULLTEXT index to multiple columns of the database. If the instructions in the problem specification are too vague, try searching Google for "MySQL FULLTEXT Search".

EDIT:

These web tutorials should help you to get started.

By the way, my personal advice is not to get bogged down too much in this section. Once you have defined a FULLTEXT index on the tables you want to search, just pass the value of $_GET['geo'] to your query and focus on getting to the point where you have pins in your map.

Once you have a minimally-functional app, you can come back and get lost in the intricacies of MySQL Natural Language Searches and Boolean Full-text Searches until your search is working the way you want it to.

By the way, if this answers your question, be sure to accept it by clicking the green check mark. Otherwise, it will haunt the forums forever as a zombie unanswered question!

EDIT2: How do you define a FULLTEXT index? Well, there is a way to do it with phpMyAdmin, which you can discover by trial and error (or via Google). But the tutorials I linked to above will explain how to do it using mysql50 shell interface, like a real Database Administrator would.

To get started, type the following commands in a new ide50 Terminal tab:

mysql50 shell
USE `pset8`;
SHOW TABLES;

Then you could use either the ALTER TABLE table_name ADD FULLTEXT (column_one, column_two) syntax or the CREATE FULLTEXT INDEX index_name ON table_name(column_one,column_two) syntax to add a FULLTEXT index for the specified tables.

3
  • 1
    Thanks for your answer! How can I add an index to an already existant row? (assuming that is what needs to happen.) When I try to edit the column, it does not have a box for the index.
    – user11799
    Aug 22 '16 at 23:28
  • See above for my latest edit! :) Aug 23 '16 at 2:25
  • What does it mean for a FULLTEXT index to be defined jointly in multiple columns, and how do you do it?
    – user11799
    Sep 4 '16 at 22:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .