Wordpress Database Search Engine

Completed Posted Nov 24, 2012 Paid on delivery
Completed Paid on delivery

I have a new website that I’m setting up – I’m using Wordpress as a CMS. It’s a stock install of the current version of Wordpress (3.4.2) plus a couple of plug-ins I’ve installed that are not particularly related to this project.

I’ve created a MySQL table in the Wordpress database for a particular state’s divorce records – it’s in a table in the Wordpress database for the site.

What I want is what I would call a ‘search screen’ or 'search engine' for this data (I’m a Linux application programmer by day and don’t do much if any PHP).

Besides having pages describing where the data comes from and a page about the project the search function is going to be the heart of this website.

Here is the schema for the table from a recent mysqldump:

CREATE TABLE IF NOT EXISTS `divorces` (

`file_number` varchar(20) COLLATE utf8_unicode_ci NOT NULL,

`husbands_name` text COLLATE utf8_unicode_ci NOT NULL,

`husbands_age` varchar(5) COLLATE utf8_unicode_ci NOT NULL,

`wifes_name` text COLLATE utf8_unicode_ci NOT NULL,

`wifes_age` varchar(5) COLLATE utf8_unicode_ci NOT NULL,

`number_of_minor_children` int(11) NOT NULL,

`marriage_date` varchar(20) COLLATE utf8_unicode_ci NOT NULL,

`divorce_date` varchar(20) COLLATE utf8_unicode_ci NOT NULL,

`county_code` varchar(80) COLLATE utf8_unicode_ci NOT NULL,

`county_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

I will provide 50 rows or so of data to the winning bidder (along with the url of my website), but the data in general looks like:

INSERT INTO `divorces` (`file_number`, `husbands_name`, `husbands_age`, `wifes_name`, `wifes_age`, `number_of_minor_children`, `marriage_date`, `divorce_date`, `county_code`, `county_name`) VALUES

('026484', 'ACKERS LARRY DALE ', '30', 'SONDRA IRENE ', '30', 1, '5/8/1964', '11/12/1968', '188', 'POTTER ');

The table at present is about 3 million rows and I’m not done importing the data yet. I expect the table to be double that size before I’m done with my imports.

At present I’m on shared hosting but I’ll probably move this to some kind of VPS or dedicated hosting once I see what the performance is.

You may use any plug-in or custom code you like, but the solution must be safe from SQL injection. Ideally I’d like something that uses a shortcode that I could place on a Wordpress page but that’s not a requirement.

Other observations/possible problems:

I’ve not stated what the form inputs to the search should be – I will leave that to you.

You will notice that I have no indexes on this table yet and not only that but I have nothing that makes a particular row unique. I’ll take suggestions for indexes to speed the search of course.

Also – if I were to search for Sondra Ackers (from the sample data above) I probably wouldn’t find her. Parsing the husbands_name field is likely to be non-trivial since we don’t know where the last name ends and the first name begins.

I am open to datatype changes on the table but I can’t really change the structure because I’m importing tab and fixed-width data into this database. As you may or may not expect I would love to have a field that would uniquely identify a row that I haven’t been able to figure out how to do that and still be able to import my delimited data without writing some code to do the inserts instead of just using a simple command line statement.

Of course I am open to suggestions of course but the solution must fit within my Wordpress website.

If you have any questions please ask before bidding on my project. I think I’ve made this about as clear as I can but you never know.

Deliverables:

The solution in PHP

Instructions on how to install (I have ssh and sftp access)

MySQL PHP WordPress

Project ID: #3980428

About the project

16 proposals Remote project Active Nov 26, 2012

Awarded to:

denisCh

Please check PM

$250 USD in 3 days
(63 Reviews)
7.5

16 freelancers are bidding on average $242 for this job

buraqtech

Check your PMB for details!!!

$250 USD in 7 days
(69 Reviews)
7.6
webedeveloper

Experienced and serious team specializing in open sources like wordpress, joomla, Open Cart, PHP Frameworks like Yii, Zend, CakePHP, CodeIgniter, Seagull, Symfony and more with latest web trends and standards. Our tea More

$250 USD in 15 days
(81 Reviews)
6.8
workon

Hi, I am expertise to fulfill your requirement. Check my reviews.

$250 USD in 5 days
(76 Reviews)
6.0
samzinc

Please check PMB.

$250 USD in 5 days
(59 Reviews)
5.8
shsaad

I have a wordpress solution for this project. Visitor can search the wordpress table per the project description.

$200 USD in 3 days
(62 Reviews)
5.8
scriptphp87

Hello Please read more than private message thank you

$200 USD in 3 days
(38 Reviews)
5.6
webphpguru

we carefully read your needs can be done smoothly you will be satisfied please check our workdone in pmb

$150 USD in 9 days
(23 Reviews)
4.4
ITSoftIndia

Hi, we have read all the requirements and we are very confident to do this project from start till end. We definitely have some questions when we discuss project with u. We shall finish this project in timely manner More

$200 USD in 5 days
(6 Reviews)
0.5
vineeshkc

helo sir am a wordpress developer

$150 USD in 3 days
(0 Reviews)
0.0
AKdM1xF46

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$250 USD in 1 day
(0 Reviews)
0.0
kenrichelx

Our work speaks more you see.

$500 USD in 20 days
(0 Reviews)
0.0