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 [login to view URL] = 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;