Wilamowski B.M., Irwin J.D. The Industrial Electronics Handbook. Second Edition: Industrial Communication Systems

Подождите немного. Документ загружается.

Development of Interactive Web Pages 62-13

Example: Designing an online conference paper collection and evaluation Web site using PHP and

MySQL:

.In.this.example,.you.will.learn.how.to.design.a.basic.paper.submission.and.evaluation.system.

[5–7].. ree.main.code.modules.for.this.application.are.as.follows:

. a.. Paper.submission

. b.. Paper.evaluation

. c.. Administration

Before

.writing.the.PHP.code,.make.sure.you.have.created.a.database.with.the.following.tables:

Loginaccnt_table

.for.user,.reviewer.and.administrator.with.lastname,.rstname,.userid,.password.

(encrypted).elds;.papers_submitted_table.with.title,.author,.date,.abstract,.le_size,.le,.le_type,.

and.review_ok.elds;.comment_table.with.subject,.name,.date,.status,.and.detail.elds.

. a.. Paper submission:.For.the.convenience.of.designing,.the.following.design.steps.can.be.adapted:

•

. e.user.has.to.login.before.submitting.a.paper.(Figure.62.2)..Required.les:.index.php,.Login.php.

•

. Aer.user.authentication,.the.user.is.directed.to.his.homepage.where.he.can.submit.paper,.

view.reviewed.papers,.view.comments,.etc..For.user.authentication,.login_check.php,.session.

php

.les.are.required.

•

. If.user.ID.and.password.are.not.found.in.the.database,.a.message.is.generated.to.login.again.or.a.

request.to.create.an.account..Required.le:.login_check.php,.user_home.php,.signup.php.

•

. If.user.requests.to.create.an.account,.change.password..Required.les:.signup.php,.signup_

ok.php,

.password_change.php,.password_updated.php.

•

. Aer.user.logins.to.his.homepage,.user.can.submit.a.paper,.view.reviewed.papers,.download.

other.papers,.post.comments.for.papers,.view.papers.that.are.not.yet.reviewed,.update.his.prole..

Main Web page for

users

User authentication

View papers

reviewed

Given specified

field, view available

papers

List of available

papers in the

specified field are

displayed

List of papers

reviewed are

displayed

New paper

submission

Fill in author and

paper details

Confirmation screen

View comments

Comments added

by reviewers and

authors for

particular papers

are displayed

FIGURE 62.2 e.user.view.of.the.paper.evaluation.system.for.user/authors.

62-14 Industrial Communication Systems

Required.les,.submit_paper.php,.submit_paper_check.php,.submit_paper_ok.php,.update_pro-

le.php,

.prole_updated.php,.paper_reviewed.php,.paper_abstract.php,.paper_download.php.

. b.. Paper evaluation:.Aer.the.paper.has.been.submitted.by.the.user,.the.reviewer.receives.an.email.

notication.with.the.user.information.and.the.paper.information.Figure.62.3.

•

. Reviewer.access.is.provided.only.by.the.administrator..Aer.reviewer.logs.in,.he.can.view.

papers. that. were. reviewed,. review. a. paper..Required. les:. reviewer_login.php,. reviewer_

login_check.php,

.paper_reviewed.php,.review_paper.php,.paper_abstract.php.

. c.. Administrator:. Administration. interface. lets. you. add,. delete,. and. update. from. the. database..

Administrator.has.privileges.that.will.allow.him.to.manage.user/reviewer.accounts..Required.

les:. admin_login.php,. manage_content.php,.update_content.php,.add_content.php,.manage_

accounts.php,

.nal_statistics.php.

.Web.site.is.designed.for.Auburn.Microelectronics.Laboratory.at.Auburn.University.using.PHP.and.

MySQL,.which.allows.users.to.access.equipment.in.the.laboratory,.generate.a.log.le.for.a.manufacturing.

process,.calculate.the.cost.to.use.manufacturing.equipment,.etc.. e.administrator.receives.notication.

whenever.a.request.to.use.the.equipment.is.made.and.is.provided.with.necessary.information,.the.admin-

istrator

.allows.access.for.the.user.to.use.the.machinery.

You

.can.visit.the.Web.site.at.http://www.microlab.auburn.edu/NewPage.php.

references

. 1.. L..Welling.and.L.. omson,.PHP.and.MySQL.Web.Development,.Sams.Publishing,.Portland,.OR,.2003.

. 2.. H..E..Williams.and.D..Lane,.Web Database Applications with PHP & MySQL,.2nd.edn.,.O’Reilly.

Media,.Inc.,.Sebastopol,.CA,.May.2004.

. 3.. L..Ullman,.PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide,.Peachpit.Press,.

Berkeley,.CA,.2008.

. 4.. B..M..Wilamowski,.A..Malinowski,.and.J..Regnier,.Internet.as.a.new.graphical.user.interface.for.the.SPICE.

circuit.simulator,.IEEE Transactions on Industrial Electronics, 48(6),.pp..1266–1268,.December.2001.

. 5.. J..W..Regnier.and.B..M..Wilamowski,.SPICE.simulation.and.analysis.through.Internet.and.Intranet.

networks,.IEEE Circuit and Devices Magazine,.pp..9–12,.May.1998.

. 6.. B.. M.. Wilamowski,. Design. of. network. based. soware,. 24th IEEE International Conference on

Advanced Information Networking and Applications 2010,

.pp..4–10,.2010.

. 7.. N..Pham,.H..Yu,.and.B..M..Wilamowski,.Neural.network.trainer.through.computer.networks,.

24th IEEE International Conference on Advanced Information Networking and Applications

2010,

.pp..1203–1209,.2010.

Main Web page for

organizers

Reviewer login

View list of paper’s

reviewed

View list of paper’s

not reviewed

Review paper and

post comments

Manage

user/reviewer

accounts

Add, update, delete, and

manage content

Administrator login

FIGURE 62.3 e.organizer.view.of.the.paper.evaluation.system.for.reviewer/administrator.

63-1

63.1 Introduction

With.the.development.of.Internet.technology,.more.and.more.Web.design.languages.such.as.Javascript,.

PHP,.and.CGI.are.deve

loped

.to.sati

sfy

.vari

ous

.onli

.serv

ices.

.In.this.chapt

er,

.an.open

-source

.Web.

appl

ication

.fram

ework,

.Djan

go,

.whic

.is.deve

loped

.in.Pyth

on,

.will.be.intr

oduced

.for.data

base-driven

Web.site.desi

gn.

63.1.1 Python

Python.supports.multiple.programming.paradigms,.such.as.object.oriented,.imperative,.and.functional.

[F02

.Pyth

.feat

ures

.a.full

.dyna

mic-type

.syst

.and.autom

atic

.memo

.mana

gement.

.From.the.

poin

.of.func

tions,

.pyth

.has.very.simil

.synt

.to.Perl

.but.it.is.simpl

ied

.and.more.read

able.

.Pyth

is.also.exi

ble

.for.prog

ramming,

.incl

uding

.both.comm

and

.line.styl

.such.as.in.MATA

•

,.and.script.

styl

.suc

.as.in.Per

.a.high

-level

.lang

uage,

.Pyth

.can.be. oper

ated

.on.many.die

rent

.oper

ating

.syst

ems,

.such. as.

Windo

ws,

.MacO

.Unix

.and.OS/2

. e.Pyth

.sow

are

.can.be.free

.down

loaded

.and.used

.or.can.

be.incl

uded

.in.appl

ications.

.Pyth

.can.also.be.free

.modi

ed

.and.redi

stributed,

.since.the.lang

uage

.is.

copy

righted

.und

.an.ope

n-source

.lic

ense.

63.1.2 Django

Django.is.a.high-level.Python.Web.framework.that.encourages.rapid.development.and.clean,.pragmatic.

desi

.[HM0

9].

.It.was.orig

inally

.deve

loped

.to.ease.the.crea

tion

.of.comp

lex

.data

base-driven

.Web.

site

.in.2005

.Usin

.Pyth

.as.a.scri

.lang

uage,

.Djan

.focu

ses

.on.auto

mation

.as.much.as.poss

ible.

Interactive Web

Site Design Using

Python Script

63.1. Introduction.....................................................................................63-1

Python. •. Django

63.2. Soware.Installation.......................................................................63-2

63.3

. Data

base-Driven

.Web.Sit

.Desi

gn................................................63-2

Create.a.Project. •. Run.the.Project. •. Setup.Database. •. .

CreateModel. •. Activate.Model. •. Activate.the.AdminSite. •. .

Addthe.Application. •. Customize.the.Admin.Site

63.4. Conclusion........................................................................................63-7

References.....................................................................................................63-8

Hao Yu

Auburn University

Michael Carroll

Auburn University

63-2 Industrial Communication Systems

It.adheres.to.the.DRY.principle,.which.means.“don’t.repeat.yourself.”.Django.also.provides.optional.

admi

nistrative

.“cre

ate,

.read

.upda

te,

.and.dele

te”

.(CRU

.inte

rface

.temp

lates,

.whic

.are.gene

rated

dyna

mically

.thro

ugh

.intr

ospection

.and.con

gured

.via.admi

.mode

ls.

63.2 Software Installation

Both.Python.and.Django.are.required.for.setting.up.the.programming.environment..Python.can.be.

free

.down

loaded

.from.http

://www.python.org.

.Vers

ions

.2.4.to.2.6.are. reco

mmended

.(Dja

ngo

.is.

not.prop

erly

.comp

atible

.with.Pyth

.3.0)

. e.shel

.inte

rface

.of.Pyth

.aer.inst

allation

.is.show

.in.

Figu

.63.1

Django

.can. be. down

loaded

.from. http

://www.djangoproject.com/download/

.as. a. pack

. le,. like.

“Dja

ngo-[version

.numbe

r].tar.gz.”

.Aer.unpa

cking

.the.le,.in.comm

and

.prom

.mode

.the.curr

ent

dire

ctory

.shou

.be.set.as.wher

.the.Djan

.les.were.rele

ased

.(by.cd [di

rectory]).

. en.the.com-

and

.setu

p.py install

.can.be.ente

red

.for.inst

allation.

.Aer.inst

allation,

.ente

.impo

rt django

in.the.shel

.inte

rface

.of.Pyth

on;

.if.ther

.is.no.erro

.info

rmation,

.it.mean

.Djan

.is.succ

essfully

.inst

alled

and.bon

ded

.wit

.Pyt

hon

.(Fi

gure

.63.

2).

For

.data

base

.deve

lopment,

.at.leas

.one.data

base

.serv

er,

.Post

greSQL,

.MySQ

.or.Orad

.is.requ

ired

.to.

be.inst

alled

.in.the.serv

er.

.If.Djan

.is.used.on.a.prod

uction

.site,.Apac

.with.mod_

wsgi

.is.requ

ired

.for.

serv

.con

guration

.[A0

8].

63.3 Database-Driven Web Site Design

In.order.to.introduce.how.to.use.Django.for.database-driven.Web.site.design,.let.us.have.a.simple.example..

 e.purp

ose

.is.to.buil

.an.onli

.data

base

.with.basi

.“CRU

D”

.oper

ations.

63.3.1 Create a Project

 e.project.can.be.auto-generated.by.Django,.and.the.important.part.

is.to.set.a.prop

.inst

ance,

.incl

uding

.data

base

.con

guration,

.Djang

specic

.opti

ons

.and.appl

ication-specic

.setti

ngs

.[B08

.whol

.proc

ess

.is.show

.in.Figu

.63.3

.Firs

.of.all,.copy.the.le.

djan

go-admin.py

.to.the.plac

.wher

.the.proj

ect

.will.be.buil

.then.

loca

.into.the.dire

ctory

.by.cd.in.comm

and

.prom

.mode

.Aer.that

FIGURE 63.1 Shell.interface.of.Python.

FIGURE 63.2 Successful.instal-

lation.of.Dja

ngo.

Interactive Web Site Design Using Python Script 63-3

execute.the.command.django-admin.py startproject paper _ system..Four.les.will.be.auto-

matically

.gen

erated

.and.the

.are

.man

age.py,

.set

tings.py, urls.py,

.and.__ i

nit __ .py,

.eac

.of.

whic

.has.spe

cied

.fun

ctions:

•

. man

age.py:

. is.is.a.com

mand

.lin

.tha

.can.hel

.to.int

eract

.wit

.the.Dja

ngo

.pro

ject

.in.var

ious

.way

in.for

mat:

.man

age.py <subcommand> [options].

.For.exa

mple,

.man

age.py runserver

is.use

.to.sta

.runn

ing

.the.ser

ver.

•

. set

tings.py:

. is.le.is.use

.to.set

/congure

.the.Dja

ngo

.pro

ject

.inf

ormation,

.suc

.as.use

nam

.pa

ssword,

.an

.lo

cations

.of.th

.te

mplate

.re

sources.

•

. url

s.py:

. e.UR

.de

clarations

.of.th

.Dj

ango

.pr

oject.

•

. __ init __ .py:.An.empty.le.specifying.that.the.current.directory.should.be.considered.as.a.

Pyt

hon

.pa

ckage.

63.3.2 run the Project

 e.work.above.can.be.veried.by.running.the.project:.(1).cd.to.the.directory.of.the.project.and.(2).run.

com

mand

.man

age.py runserver.

.If.the.pro

ject

.is.succ

essfully

.cre

ated,

.the.res

ult

.is.sho

.as.in.

Fig

ure

.63.

Now

.the.ser

ver

.is.run

ning

.and.it.can.be.loc

ally

.visi

ted

.by.htt

p://localhost:8000/

.wit

.the.bro

wser.

Fig

ure

.63

.sh

ows

.th

.We

.sit

.in

formation.

.lin

.add

ress

.and.por

.can.be.mod

ied

.usin

.com

mands

.suc

.as.man

age.py runserver

131.204.222.54:80.

FIGURE 63.3 e.process.of.creating.a.project.

FIGURE 63.4 Result.of.running.the.project.

63-4 Industrial Communication Systems

63.3.3 Setup Database

 e.database.information.is.congured.in.the.le.setting.py.. ere.are.very.detailed.instructions.

abo

.ea

.pa

rameter

.in.th

.l

.In.th

.ex

ample,

.le

.us.fu

lll

.th

.ba

sic

.se

ttings

.as.fo

llows:

DATABASE _ ENGINE = 'sqlite3'

DATABASE _ NAME = 'C:/paper _ system/sqlite3.db'

.rs

.par

ameter

.ind

icates

.tha

.SQL

ite

.dat

abase

.(in

cluded

.in.the.sta

ndard

.Pyt

hon

.lib

rary)

.stor

all.the.inf

ormation

.in.a.sing

.le.on.the.com

puter,

.whi

.the.sec

ond

.par

ameter

.spe

cies

.the.loc

ation

.of.

SQL

ite

.da

tabase

.l

Aer

.the.con

guration

.of.le.set

ting.py,

.ent

.the.com

mand

.man

age.py syncdb

.to.cre

ate

.the.

dat

abase

.an

.re

gister

.a.su

per-user

.fo

.th

.au

.sy

stem.

.Se

.Fi

gure

.63

.6.

63.3.4 Create Model

So.far,.a.project.has.been.set.up..In.the.following,.the.document.database.is.going.to.be.built.based.on.

the.pro

ject.

.Not

ice

.tha

.Dja

ngo

.sup

ports

.mul

tiple

.app

lications,

.whi

.mea

.a.pro

ject

.can.hav

.mul

tiple

app

lications

.an

.an.ap

plication

.ca

.be.in.mu

ltiple

.pr

ojects.

.ent

ering

.the.com

mand

.man

age.py startapp documents,

.a.dir

ectory

.nam

.docu

ments

is.cr

eated

.wi

.fo

.l

.in

side:

.__

init __ .py,

.mo

dels.py,

.te

sts.py,

.an

.vi

ews.py.

.le.mod

els.py

.is.use

.to.bui

.the.mod

el.

.In.thi

.exa

mple,

.a.Docu

ment

.mod

.wil

.be.des

cribed

in.doc

uments/models.py

.l

.as

FIGURE 63.5 Web.site.of.the.server.

FIGURE 63.6 Database.setup.

Interactive Web Site Design Using Python Script 63-5

from django.db import models

class Document(models.Model):

document _ name = models.CharField(max _ length=500);

document _ auth = models.CharField(max _ length=200);

sub _ date = models.DateTimeField('date submitted');

.the.cod

..Ch

arField

.is.used.to.cre

ate

.a.cha

racter

.el

..Da

teTimeField

.is.used.to.cre

ate

.a.tim

el

. is.Doc

ument

.mod

.con

sists

.of.thr

.par

ameters:

.the.nam

.of.the.doc

ument

.(wi

.max

imum

len

gth

.500)

.the.nam

.of.the.aut

hor

.(wi

.max

imum

.len

gth

.200

.and.the.dat

.of.sub

mitting

.the.doc

ument.

63.3.5 activate Model

Models.need.to.be.activated.for.application..In.this.example,.the.steps.are

. 1..Add.an.ele

ment

.'pa

per _ system.documents'

.to.lis

.INS

TALLED _ APPS

.in.set

ting.

.l

. 2.. Ent

.co

mmand

.ma

nage.py sql documents,

.an

.th

.re

sult

.is.as.sh

own

.in.Fi

gure

.63

.7.

Aer

.act

ivating

.the.mod

els,

.mod

.tab

les

.(co

ntaining

.mod

.inf

ormation)

.nee

.to.be.upd

ated

.in.the.

dat

abase,

.usi

.co

mmand

.ma

nage.py syncdb.

63.3.6 activate the admin Site

 e.Django.admin.site.is.not.activated.using.default.settings;.it.can.be.activated.in.three.steps:

. 1..Add.'d

jango.contrib.admin'

.to.th

.IN

STALLED _ APPS

.se

tting

.in.se

tting.py

.l

. 2.. Run.ma

nage.py syncdb

.to.up

date

.th

.da

tabase

.ta

bles.

. 3..Edi

.th

.l

.pa

per _ system/urls.py

.li

.th

from django.conf.urls.defaults import *

from django.contrib import admin

admin.autodiscover()

urlpatterns=patterns('

',(r

'ˆadmin/',include(admin.site.urls)

) )

Aft

.act

ivating

.the. adm

.sit

. the. lin

.htt

p://localhost:8000/admin/

.bec

omes

.ava

ilable,

.see.

Fig

ure

.63.

Using

.the.adm

inistrator

.use

.nam

.and.pas

sword,

.whi

.wer

.con

gured

.in.Sec

tion

.63.

3.3,

.one.can.

log.in

.an

.fo

llow

.wi

.th

.ad

ministration

.ma

nagement

.sit

.se

.Fi

gure

.63

.9.

FIGURE 63.7 Model.creation.and.activation.

63-6 Industrial Communication Systems

63.3.7 add the application

 e.previous.step.activated.the.default.administration.site,.but.without.the.required.application..In.

ord

.to.add.the.Doc

ument

.mod

ule

.int

.the.app

lication,

.a.le.nam

.adm

in.py

.nee

.to.be.cre

ated

in.\pa

per _ system\documents

.dir

ectory

.and.the.cod

.ins

ide

.cou

.be

om paper _ system.documents.models import Document

from django.contrib import admin

admin.site.register(Document)

.up

dated

.We

.sit

.is.sh

own

.in.Fi

gure

.63

.10.

FIGURE 63.8 Activated.admin.site.

FIGURE 63.9 Default.administration.management.site.

FIGURE 63.10 Administration.management.site.with.Document.module.

Interactive Web Site Design Using Python Script 63-7

63.3.8 Customize the admin Site

 e.application.already.has.the.basic.functions.of.a.database,.such.as.add,.change,.and.delete..But.it.is.

not.goo

.eno

ugh

.for.app

lication.

. e.fol

lowing

.ste

.wil

.mak

.the.dat

abase

.muc

.mor

.pow

erful:

. 1..Add.the.Pyth

.code.belo

.into.the.mode

ls.py

.le.. is.will.use.the.docu

ment

.name

.as.the.

link

.to.visi

.the.rel

ated

.doc

uments.

def __ unicode __ (self):

retu

rn self.document _ name

. 2.. Edit.the.admi

n.py

.le.using.the.code.belo

. is.will.list.all.the.docu

ment

.info

rmation

.row.by.

row..In.the.tabl

.all.the.docu

ment

.info

rmation

.can.be.orde

red

.by.eith

.docu

ment

.name

.auth

name

.or.sub

mission

.dat

from

paper _ system.documents.models import Document

from

django.contrib import admin

clas

s DocumentAdmin(admin.ModelAdmin):

list

_ display = ('document _ name','document _ auth','sub _ date')

admin.site.register(Document, DocumentAdmin)

. 3..Add.code.belo

.to.admi

n.py

.le.. is.will.crea

.sideb

.used.to.lte

.the.list

.docu

ment

info

rmation

.by.spe

cied

.dat

list

_ filter = ['sub _ date']

. 4.. Add.code.below.to.admin.py.le.. is.will.add.a.search.box.at.the.top.of.the.document.list,.

whic

.can.be.use

.to.sea

rch

.doc

ument

.inf

ormation

.by.aut

hor

.nam

sear

ch _ fields = ['document _ auth']

. 5..Add.cod

.bel

.to.adm

in.py

.le

. is.wil

.add.hie

rarchical

.nav

igation

.by.sub

mission

.dat

date _ hierarchy = 'sub _ date'

. With.all.the.abo

.cus

tomization,

.the.new.adm

inistration

.Web.site.is.as.sho

.in.Fig

ure

.63.

11.

63.4 Conclusion

 e.above.example.built.a.framework.for.a.database-driven.Web.site.server..It.includes.interface.design.

and.basic.SQL.oper

ations,

.such.as.crea

te,

.sear

ch,

.add,.and.dele

te.

.As.one.may.noti

ce,

.the.enti

.proje

is.don

.in.a.con

siderably

.lim

ited

.tim

.and.wit

.ver

.few.cod

es.

.con

clusion,

.the.majo

.fea

tures

.of.Dja

ngo

.can.be.des

cribed

.as.fol

lows

.[B0

8]:

•

. Objec

t-relational

.mapp

er:

.By.den

ing

.the.data.mode

.in.Pyth

on,

.Djan

.can.oer.an.eci

ent

and.dyn

amic

.dat

abase

.acc

ess

.API

.for.fre

•

. Autom

atic

.admi

.inte

rface:

.Djan

.does.all.the.work.of.crea

ting

.inte

rfaces

.autom

atically,

.avoi

ing

.ted

ious

.and.dup

licated

.cod

ing.

FIGURE 63.11 Customized.administration.Web.site.

63-8 Industrial Communication Systems

•. Elegant.URL.design:.Django.can.design.very.neat.URLs.with.no.framework-specic.limitations,.

as.e

xible

.as.po

ssible.

•

. Tem

plate

.sys

tem:

.Dja

ngo

.sep

arates

.the.des

ign,

.con

tent,

.and.Pyt

hon

.cod

.by.the.pow

erful,

.ext

ensible,

and.des

igner-friendly

.tem

plate

.lan

guage.

•

. Int

ernationalization:

.Dja

ngo

.has.ful

.sup

port

.for.mul

tilingual

.app

lications,

.whi

.mak

.it.eas

.to.

spe

cify

.tr

anslation

.st

ring

.an

.pr

oviding

.ho

oks

.fo

.la

nguage-specic

.fu

nctionality.

All

.the.fea

tures

.ill

ustrate

.the.ec

iency

.and.eas

.usa

.of.Dja

ngo

.for.Web.desi

gn,

.and.mak

.it.str

ong

in.co

mpeting

.wi

.va

rious

.ot

her

.We

.pr

ogramming

.too

ls.

references

[A08].M..Alchin,.Pro Django..Apress,.Lansing,.MI,.2008.

[B08]

.J..Benn

ett,

.Pr

actical Django Projects.

.Ap

ress,

.Ber

keley,

.CA,.2008.

[F02]

.C..Fe

hily,

.Py

thon.

.Pe

achpit

.pr

ess,

.Ber

keley,

.CA,.2002.

[HM09]

.Adri

.Holo

vaty,

.Jacob.Kap

lan-Moss,

.e D

enitive Guide to Django: Web Development Done

Right

.(2nd.ver

sion).

.Sp

ringer

.pr

ess,

.Ne

.Yo

rk,

.2009.