In Progress

A script that do a Mysql query (every 45 minutes) based on data RSS feeds

RESUME:

I need a script (that has to be run by a cron job every 45 minutes) that look for RSS feed from a list (a file in the server that will have a list of RSS feeds), get its new items, check if they are already added to the database and if not add them filling all the values of a database table (using some data from the RSS item, some predefined values and some random values, here [url removed, login to view] says what the script will have tu put to complete the database table).

DETAIL:

I need a script (that has to be run by a cron job every 45 minutes) that looks in a file on the server that will list some RSS feeds, the RSS list (in a file) will be like this:

1) [url removed, login to view], category=1, votes=1,20, karma=1, 45

2) [url removed, login to view], category=3, votes =1,34, karma=5, 35

3) [url removed, login to view] , category=5, votes =1,24, karma=1, 25

(is important that the script looks in the file because I will add/delete more RSS feeds on the future, you can change the list format if you need to)

The script will have to enter to each of this RSS feeds, see if there is any new item (from the last time the script was run) and if it is get the item link, search in a server database to see if that link was already added to the database and if it wasn´t do a query to add it to the database, to do this query it has to use some data from the RSS element, some predefined values and some random values. You can see here [url removed, login to view] the table format and what the script has to put on it to make the query and add the element to the database. This function ( checking if the link was added to the database and if not add it) has to be done with each new item of each RSS feed.

If the RSS item has any [CDATA[ values or some[ on their link, description or title, they have to be deleted before adding them to the database (I mean if the title is “[CDATA[El Palacio Colón cumple un siglo en un rincón olvidado de la Ciudad Vieja]]” the title added to the database has to be “El Palacio Colón cumple un siglo en un rincón olvidado de la Ciudad Vieja”

Skills: Javascript, MySQL, PHP

See more: put resume, script resume, n query, job resume format, el espectador, link karma, mysql mean, javascript data format, query table, mysql query, every, data query, agro, checking element php script, mysql delete, format rss php, delete element javascript, mysql search table, mysql delete using, feeds search, check table mysql script, mysql search database table, random data, cron delete table php, script php random link

About the Employer:
( 10 reviews ) Montevideo, Uruguay

Project ID: #2583872

Awarded to:

siddhu1986

Hi, experienced Web Developer. Kindly check PMB. Regards.

$60 USD in 0 days
(114 Reviews)
6.4

13 freelancers are bidding on average $54 for this job

inspire007

Quick professional help. Please check PMB for details. Thanks

$60 USD in 1 day
(72 Reviews)
6.0
leomedina01

Hi sir, I have all of this already done with me, we just need to modify a few things to your needs. Please check your inbox(PMB) for further details. I'm an experienced Web Developer having worked for 4+ years with More

$60 USD in 2 days
(56 Reviews)
5.8
angelmiks2007

Hello Sir Gabriel, 100% COMPLETION RATE. Definitely not a time waster and above all I am a highly knowledgeable programmer both in MySQL & PHP programming. I am very confident that I can do this for you but I will let More

$99 USD in 1 day
(39 Reviews)
5.8
phpprogramming

please check PM for details

$60 USD in 1 day
(44 Reviews)
5.7
hemantrps

Hello, I have over 7 years of development experience. I would like to discuss your requirements in further details. Please check your PM. Cheers, Hemant

$30 USD in 1 day
(18 Reviews)
5.6
Softanz

Professional developer here. I am 6+ years experience in HTML, PHP5, CSS ,MySQL, Ajax, Jquery, JavaScript, Wordpress. I have already work on this type of project . Please view my PMB for more details. Thank you

$45 USD in 0 days
(32 Reviews)
5.1
realestateweb

Hola hermano uruguayo. Tengo bastante experiencia en conectividad de datos, como puedes chequear en mi perfil. Me interesa el trabajo y me gustaría saber para cuando necesitarías tenerlo listo, pues vengo de una fieb More

$50 USD in 7 days
(20 Reviews)
5.1
explore1

Hi, I can work on this. Thanks

$50 USD in 1 day
(5 Reviews)
4.0
thinhnp

Hi Sir. I'm ready for this project. I've done many projects with PHP,MySQL and RSS Feeds

$60 USD in 1 day
(8 Reviews)
4.0
scriptzguru

Hello sir/ma'am , Interested and ready to start right away !. Kind regards.

$40 USD in 2 days
(3 Reviews)
3.5
JimMackin

Hi, I'm a competent PHP and MySQL programmer and can write the RSS cron script. Thanks, Jim

$50 USD in 2 days
(1 Review)
1.8
phpvncoder

Hello sir, I can do that for you, thanks

$40 USD in 2 days
(5 Reviews)
1.6