Fermé

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.

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.

Compétences : HTML, Javascript, MySQL, PHP, SQL

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) China

Nº du projet : #16633895

32 freelance font une offre moyenne de £520 pour ce travail

rinsadsl

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(1106 Commentaires)
8.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(173 Commentaires)
7.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(36 Commentaires)
7.4
AzzkaNoor

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(25 Commentaires)
7.0
virals2583

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(49 Commentaires)
7.0
kalidass678

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(187 Commentaires)
7.2
techwelfare

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?

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(180 Commentaires)
7.2
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(81 Commentaires)
6.9
lavizsolutions

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(24 Commentaires)
6.8
nishthamarwaha

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(70 Commentaires)
6.6
shihan033010

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(321 Commentaires)
6.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(171 Commentaires)
6.6
rinkul123

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(93 Commentaires)
6.8
bjrupani

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(86 Commentaires)
6.0
protovosolutions

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:/ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(61 Commentaires)
5.9
hasanjack

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(56 Commentaires)
6.2
CrazyWebGuru

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(53 Commentaires)
5.8
MilesChino

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: Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(1 Évaluation)
6.5
Amitkumar1806

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(39 Commentaires)
5.6
somdeb1987

Hello, Thanks for the opportunity to take part biding on your project. I am Somdeb with 350+ website development experienced with all GREAT REVIEW by my previous employers. Please have a look on my profile here: Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(14 Commentaires)
4.9