Within this project i have 3 simple scripts that need some fairly simple modifications.
1. [url removed, login to view] (attached)
This script collects information from imdb, what i want doing is it changed so instead of having to manually input the information onto lines 17&20, it needs to collect the data from a table called series, it needs to go through all the rows.
series table structure.
-- phpMyAdmin SQL Dump
-- version 126.96.36.199
-- [url removed, login to view]
-- Host: localhost
-- Generation Time: Aug 10, 2011 at 03:13 PM
-- Server version: [url removed, login to view]
-- PHP Version: 5.2.9
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- Database: `seany123_series`
-- Table structure for table `series`
CREATE TABLE IF NOT EXISTS `series` (
`name` varchar(255) NOT NULL,
`desc` varchar(255) NOT NULL,
`logo` varchar(255) NOT NULL,
`used_url` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2. getting all tables with "_episodes" into an array.
so basically i dont want to have to manually type the tables in like below:
$tableList = array("24_episodes", "friends_episodes", "heroes_episodes", "house_episodes", "firefly_episodes", "frasier_episodes");
instead i need it to collect all the tables in my database which have "_episodes" in the name and insert them into the array instead.
3. Star Rating system. (attached an example)
I require a star rating system to be created which uses Ajax and mysql,it needs to stop the ability of someone voting on the same thing twice, if the item isnt in the database it has to show (no votes yet) or something similar.
I now also need to imdb scraper modified so it collects all the links from http://www.imdb.com/search/title?sort=alpha&title_type=tv_series
it then needs to check the shows name against rows in my table.. if they are alike, then the imdb/episode URL needs inserting into the row... this needs doing for all the shows, once thats done then the imdb scraper needs to use the URLs to scrape all the episodes etc.
Also this scraper needs to be able to run again and again.
17 freelancers are bidding on average £92 for this job
Coates Technologies, a leading company in Web Design & Development service. We have a group of experienced and energetic professionals and researchers to analyze your projects and accomplish those very professionally.