PHP with PDO for all database interactions
£250-750 GBP
Pagato alla consegna
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.
Searching
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
body.
Rif. progetto: #16633895
Info sul progetto
28 freelance hanno fatto un'offerta media di £525 per questo lavoro
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
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 Altro
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?
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
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 Altro
Hi, Your job post seems interesting to me and I could not stop myself to bid on this job because of the skills that this job required. I am the best for this job due to my experience in development. I have more than Altro
Can we have a quick discussion on the same? We represent Perscitus Solutions Private Limited, an IT firm based in Pune, India dealing into IT services & products. We at Perscitus Solutions, believe in providing a co Altro