PHP with PDO for all database interactions

Logging In

Registered users should be able to login in and out, ideally a facility available from all pages,

though certainly from the front page.

Any one of the three registered users (see the database table ‘subscribers’) should be able to log

in by typing their email and password (their email is also their password, details in the sql script

provided). Note that the passwords are stored on the database in encrypted form.

Once logged in you should ensure persistence of the login state across all pages by using Sessions.

Logging in will mean the user has access to the menus and functionality for saving, retrieving

and deleting saved articles. Logging out should clear all session information.

Front page

Should have its own header which should contain appropriate system titles or images and menu

options and a means of logging in and out.

The channel title, description, copyright and image url should be displayed, but discretely, perhaps

in a floated element to one side of the page.

Show each article item from the xml feed, displaying the title as the hyperlink, with the category

underneath that on its own line, followed by the description.

Ideally the hyperlink to which the title points should, ideally, be to a script of yours which then

displays the retrieved article body ‘inside’ your page so that you can maintain your site look and feel.

Simply displaying the linked article web page would be a second best.

Remember, if the user is logged in, extra menus and functionality are available. Articles can be

saved either once retrieved or by means of appropriate form elements on the front page topic listing.

Also, a listing of any previously saved article can be viewed and deleted.


The two searches you should implement using xpath rather than any other search method

(not iteration and matching for instance).

Saving the Articles

When an article is saved, you should:

! From the xml summary save to the table ‘articles’ the attributes title, link and category into

fields of the same name.

! Retrieve the full article and save it to the field called body

! The subscriber’s email should be saved to the field called ‘subscriberID’ so that each saved

article is linked to the logged in user.

Listing Saved Articles

There should be a menu option, only available to logged in users, that, when chosen, will list the

following detail from the user’s saved articles in the database: title, the first 100 characters from the


Skills: HTML, Javascript, MySQL, PHP, SQL

See more: php database example, php pdo connection, php pdo prepared statements, php pdo mysql example, php pdo database connection class, php pdo port, php pdo database class example, php pdo crud class, the pdo database driver in php 5.2 4 or higher, php pdo database code generator, php delete database item, php form database, php login database, php autosuggest database jquery, simple php mysql database, php test database speed, registration software php login database, web based php sales database, dynamic link php sql database, php display database results

About the Employer:
( 0 reviews ) Taian, China

Project ID: #16633895

31 freelancers are bidding on average £519 for this job


I am php,hml,jQuery expert and very good with pdo db. I can do this job perfectly. and like to discuss this job more

£555 GBP in 7 days
(1127 Reviews)
£555 GBP in 10 days
(38 Reviews)

Bonjour! It is my humble offer to present my services to you for this project. I have passed 15 certifications here (& with 5-star rating) and your project's domain resides in my area of expertise. I have few questio More

£555 GBP in 10 days
(32 Reviews)

Hi, I am interested on your project. We have separate team for PHP development. If you share more details with me i will discuss with you. you can see my profile we have done lot of projects with client s More

£555 GBP in 10 days
(187 Reviews)
£555 GBP in 10 days
(179 Reviews)

Hello, We will design, develop such website for multiple users with all the listed features you've mentioned. Website will be done with modern, professional look, responsive manner, secure back-end with CMS features More

£555 GBP in 15 days
(49 Reviews)

We have knowledge about HTML, JavaScript, MySQL, PHP, SQL. we have read full details of your project. we have few questions to clarify before we start, could you kindly reply so we could ask our questions?

£555 GBP in 10 days
(181 Reviews)
£555 GBP in 10 days
(81 Reviews)

Dear Employer, I can do your job since I have gone through your project requirements in details, I have 7+ years Experience in eCommerce, Graphic Design, PHP,Design, Photoshop, User Experience Design, User Interf More

£500 GBP in 15 days
(75 Reviews)

Hi, Kindly share me more details so that i can give you estimated time and cost. Please check my below work.. 1. Case Management system. [login to view URL] you can crea More

£555 GBP in 10 days
(24 Reviews)

A proposal has not yet been provided

£555 GBP in 15 days
(321 Reviews)

Hi, there. We are a team of 6 engineer members. We've read your project description carefully and I’m interested in your project. We have many good experiences in web development. Major skiils are php, wordpress, c More

£600 GBP in 10 days
(73 Reviews)
£250 GBP in 7 days
(173 Reviews)

Hello, I am Debasish. I can make PHP with PDO for all database interactions. I have more than 5 years of experience in working on professional websites and blog designs as well as on developments which consist of re More

£555 GBP in 10 days
(93 Reviews)

Hello hiring member i am bhavika i have done this types task in my past i have 2.5+years experience in php pdo ,laravel so i can make it sense as per your requirements and i have good team who can make it sense and we More

£250 GBP in 2 days
(110 Reviews)

Hi, PHP is our main expertise - [login to view URL] & we're happy to help you with your project. Can we please discuss more your project in detail? currently, Please check the most recent - [login to view URL], http:/ More

£750 GBP in 15 days
(68 Reviews)

Hello sir I am Hasan Jack and I can help you with all PHP PDO task for all database interactions and I can show you many projects I have done using PDO. Looking forward to hear from you. Best Regards, Hasan Jack

£750 GBP in 10 days
(57 Reviews)

Hello, Please open communication by sending me a message. Thank you. OUR RESUME: [login to view URL] OUR PORTFOLIO: APPLE OSX: SOFTWARE - ENTERPRISE LEVEL https: More

£555 GBP in 10 days
(1 Review)

Description of project----PHP with PDO for all database interactions Dear client, Thank you for allowing me to post the bid on your project. I am ready to start now... I can provide you Great Quality and 100% Comp More

£500 GBP in 10 days
(39 Reviews)
£555 GBP in 10 days
(34 Reviews)