Wordpress Database Search Engine

Closed

Description

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)

Skills: MySQL, PHP, WordPress

See more: wordpress search database, database search wordpress, search php mysql database wordpress, mysql search engine wordpress, php mysql search engine wordpress, database search engine wordpress, wordpress search engine database, writing from the heart, wordpress notice, wordpress create application, wordpress as a website cms, width first search, what is shared writing, what are the application of data structure, website like custom writing, uses of data structure, the heart place, statement of the problems, sql database programmer, site to find programmer to create something for you, search for solution, search engine questions, search data structure, requirement in wordpress to create a website, questions of data structure

Project ID: #3980428

Awarded to:

denisCh

Please check PM

$250 USD in 3 days
(63 Reviews)
7.5

17 freelancers are bidding on average $239 for this job

buraqtech

Check your PMB for details!!!

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

=====Expertness and honesty our goal . we are small team working good quality and accuracy. Ready to start your project.Please check pm.Thank you===========

$300 USD in 7 days
(129 Reviews)
6.8
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
SRajpurohit

Let me help you sir.Thanks

$250 USD in 7 days
(37 Reviews)
5.6
scriptphp87

Hello Please read more than private message thank you

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

Hi, This is jeni from bistechsupport. Yes we could able to do this project according to your expectations. And we have done lot of sites also we are ready to provide a brief proposal before awarding the project t More

$165 USD in 5 days
(24 Reviews)
4.7
JoomlaVogue

Hello Sir, I have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and I am sure you will not be disappointed if you give us More

$200 USD in 12 days
(7 Reviews)
4.3
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
ssusoftwarelab

SSU's core experience in Web Development, Software Development, Multimedia, Logo And 3D Animation is soo strong that it is capable of providing solutions across any industry segment. In Web Development we are doing e-C More

$250 USD in 10 days
(1 Review)
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
vineeshkc

helo sir am a wordpress developer

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

Our work speaks more you see.

$500 USD in 20 days
(0 Reviews)
0.0