{"id":1238,"date":"2018-01-19T19:22:36","date_gmt":"2018-01-19T19:22:36","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/best-practices-sessions\/"},"modified":"2018-01-19T19:24:38","modified_gmt":"2018-01-19T19:24:38","slug":"best-practices-sessions","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/best-practices-sessions\/","title":{"rendered":"Best practices: Sessions"},"content":{"rendered":"
\n
\n
By Paul Booker<\/div>\n
on August 19, 2002<\/div>\n<\/p><\/div>\n
\n
\nIt is the intention of this article to discuss and generate further debate surrounding best practices
\nin developing database driven, session orientated dynamic websites and to present some adopted styles
\nand conventions. The ideas and approaches that are developed here could be realised with almost any
\ncombination of server side scripting language and relational database.<\/div>\n
\nSessions and relational databases both offer the opportunity of storing information server side.
\nSessions can help to maintain state while you navigate an internet website and relational databases
\noffer a medium for the permanent storage of information in a logical and consistent manner which
\nallows for structured queries to be carried out against that stored information.<\/div>\n
\nDuring the design process the dilemmas that are often encountered are deciding how information should
\nbe stored in a database and what information should be registered to the session. <\/div>\n
\nWhat I would like to demonstrate now is a framework of cooperation between relational databases and
\nsessions which is both aesthetically appealing as well as productive this will be done by examining
\nfeatures of a secure website.<\/div>\n
\n First of all I would like to discuss in simple terms what it means for a table to be normalised.
\n A table is considered normalised if information is organised logically without inconsistencies and
\n there is minimal redundancy an example will help to demonstrate.<\/div>\n
\nConsider the following simple normalised table called security, this table stores sensitive
\ninformation and is queried against to gain authorisation to a secure website.<\/div>\n
\n
\n   username     password     access_level  screen_name   security_id\n\n\n   rstallman     r5y8jv5f8      U            richard         1\n\n   billgates     8yc2d42f5      X            bill            2\n\n   linustorvalds h89x35f56      P            linus           3\n\n<\/pre>\n<\/div>\n
\nNotice that this security table encapsulates all that is security related there is no redundancy,
\nthat is no unnecessary repetition and if you had to update a username or a password you have only to
\nmake a single change somewhere. This is normalisation.Also note that all records here in the security
\ntable have a unique identifier called security_id this in a important field called a “primary key”.<\/div>\n<\/div>\n
<\/p>\n
\n
1<\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
It is the intention of this article to discuss best practices in developing database driven, session orientated dynamic websites and to present<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1238","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1238"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1238\/revisions"}],"predecessor-version":[{"id":3139,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1238\/revisions\/3139"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}