Concluído

Build one php search page

I need only one php page, with beauty css to search data on datawharehouse

page must have

1) option to serach in two different db schemas (real, test) same tables structure

2) pagination 25/50/100/150/250/500 results

3) all fields searchable with (full match or like clause)

4) all query made by ajax

Tables involved are only 2.

table for "posts" and table for images (joined by [url removed, login to view] = images.ad_id)

page should be:

Search on top

list of results (for each result below text fileds must be visible image gallery of thumbs, on image click, enlarge gallery to full screen)

Schemas are the following

CREATE TABLE `posts` (

`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

`category` text NOT NULL,

`city` text NOT NULL,

`address` text,

`zipcode` text,

`zone` text,

`title` text NOT NULL,

`body` text NOT NULL,

`name` text ,

`age` int(11) DEFAULT NULL,

`phone` text,

`tipology` text,

`publish_date` date DEFAULT NULL,

`unpublish_date` date NOT NULL,

`url` text NOT NULL,

`suffix` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `images` (

`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

`ad_id` int(11) NOT NULL,

`img` longblob NOT NULL,

`cp` tinyint(1) NOT NULL DEFAULT '0'

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

Habilidades: Design Gráfico, HTML, PHP, Design de Sites

Veja mais: search page pagination php jquery, search page customization php, display search results different page ajax php, create search engine like google in php, php search function, php search engine script for mysql database, search engine in php and mysql source code, how to create search engine in php and mysql pdf, simple search engine in php, php search engine source code free download, php search engine open source, php, mysql, ajax, search page using php, search results page mysql php, search php javascript page, current page search php, drupal easy website build, alibaba website build

Acerca do Empregador:
( 6 comentários ) napoli, Italy

ID do Projeto: #14439382

Concedido a:

aryan151

hello sir i am ready to start work right now.............................................................................................................

€18 EUR em 1 dia
(229 Comentários)
6.5

28 freelancers estão ofertando em média €33 para esse trabalho

tarekahmed

On time and On budget I can do all what you want .... I did 311 projects with a rate of 5/5 .... please check https://www.freelancer.com/u/tarekahmed.html Relevant Skills and Experience I have a Professional team for Mais

€18 EUR em 1 dia
(139 Comentários)
7.5
neoconcepts

Hello, As per the requirement mentioned, We are highly desirous to work with you and available to start immediately. I have worked on numerous projects involving website and software. Relevant Skills and Experience i Mais

€29 EUR em 1 dia
(157 Comentários)
7.5
hardcode4u

Woah! Hey there. Happy to have your attention, if only for a brief second. We have gone through your requirement and found able to handle this project. We have an experience of 7 Years in Web designing & developm Mais

€200 EUR in 7 dias
(92 Comentários)
6.7
€18 EUR em 1 dia
(253 Comentários)
6.7
€20 EUR em 1 dia
(23 Comentários)
5.6
Dckumawat

Dear Client, We've gone through project description, As per given description we can do this work and we'll fix all your issues. We are expertise in php, core php, CMS, HTML5, CSS3, bootstrap, WordPress, PSD to H Mais

€30 EUR em 1 dia
(95 Comentários)
5.8
pinkcitysolution

Hi, Pinkcity Solutions is an IT based company located in Jaipur, Rajasthan, India. The company is serving from last 4 years in the Web, Mobile, Graphic and SEO development work. We are complete team of profession Mais

€18 EUR em 1 dia
(29 Comentários)
5.1
€24 EUR em 1 dia
(11 Comentários)
4.9
srsinfosystems

Yes, I can surely help you out with your project. I have read your requirements and understand what exactly you want to do. I'm ready to start the work. Relevant Skills and Experience I am specialist in PHP, Codeignit Mais

€29 EUR em 1 dia
(13 Comentários)
4.6
service2001

Hi, Thanks for the opportunity created. I have gone through your requirement closely. I am an individual developer cum designer having experience in php, mysql, html5, photoshop, wordpress, opencart etc. I have 5+ year Mais

€56 EUR in 3 dias
(40 Comentários)
4.8
Webln

Hello! my name is Viktor. We are IT Company «Webin». We provide website design and web and app development services for organizations, public and government institutions, company or private web-pages. We got acquainte Mais

€17 EUR em 1 dia
(9 Comentários)
4.6
TekpreneurTech

I will create one page one php page. Relevant Skills and Experience 4 years experienced in php Proposed Milestones €8 EUR - Need to disucss Your free time

€8 EUR em 1 dia
(1 Comentário)
4.0
saaz109

Hello, Greetings! I have gone through your requirement you are looking for small website. I have 8 years of experience in web development. Relevant Skills and Experience HTML, MySQL, PHP, Website Design, Magento, word Mais

€50 EUR em 1 dia
(15 Comentários)
4.4
iitsolutions

Hello client, I read out all your requirements and I can provide it in given time and in less budget. I am a php developer, I got a huge experiences in php and HTML Relevant Skills and Experience http://jmdprojectorla Mais

€60 EUR em 1 dia
(10 Comentários)
4.3
imustechsol

Hi, This is Imustech [login to view URL] are very proud and confident about our work. I have seen the details that you have provided regarding your project. Please open conversation for further communication Relevant Skil Mais

€20 EUR in 3 dias
(9 Comentários)
4.0
€18 EUR em 1 dia
(7 Comentários)
4.0
€18 EUR em 1 dia
(16 Comentários)
4.2
€20 EUR em 1 dia
(10 Comentários)
3.5
designncoding

Hey, I have checked job description and quite interested in working with you. I have core expertise in Graphic Design, HTML, PHP, Website Design Relevant Skills and Experience I have 8 years of exp. Proposed Milest Mais

€18 EUR em 1 dia
(6 Comentários)
3.0
€18 EUR em 1 dia
(18 Comentários)
3.8