Backup Software Enterprise

A brief history of external storage devices - from floppy disk to the hard disk -

From the beginning of the personal computer (PC) people need external memory. In the following material we will discuss the start of the external storage (floppy disk) to current technologies. PC At the beginning there were only floppy disk drives that were 5 1/4 "wide. The operating system and the applications needed to be loaded into the floppy drive just to run the computer in the early 1980. The hard disk of computer allowed the applications to be loaded into the computer without the floppy drive. During this time, people could store information about these floppy disks and keep it connected to be refueled in the computer later.

l 'original 5 1/4 "floppy required 0KB (kilobytes) of data, but quickly improved to 360KB. To put this in perspective 1 KB is about half of a page of text. Floppy drives were made from a vinyl as a disk that had tracks where the data was stored. The 5 1/4 "Drive topped out at 1.2 MB (megabytes) but were still contained in the fragile disc that was prone to environmental contamination. The format next to come out were 3 1/2" floppy. These were not only smaller but had a plastic case that protects them. Although it began holding only 720KB of data, they were soon able to hold 1.44MB of data and were much easier to store in the cases and out of the site. By the end of 1980 the 5 1/4 "floppy disks were replaced by 3 1/2" format.

During the same period in 1980, the internal hard drive was becoming a standard for the PC as well. There are clear differences between the hard drive storage (think library of information) and memory (RAM - random access memory), and the floppy drive (used to take the information with you). Hard drives started in 5 1/4 "format to store 5 MB (megabytes) of constantly growing data in the course of 1980 until the units Quantum 1.28GB. To put this in perspective 1GB is about 250 MP3 songs . Unlike floppy disks, hard disks have been installed inside the computer. hard drives have continued to make progress reducing their form factor to 3 1/2 "in 190. These hard drives were listed as half a unit height. By 190, the hard drives are rapidly growing from about 40 GB (gigabytes) of total space all the way up to units 3 TB (terabytes) of today.

hard drives continue to shrink with laptop models standardize on 2 1/2 "form factor. The hard drives inside an outer casing, while technically around for some time, were becoming available in the consumer market in standard formats such as USB (Universal Serial Bus), FireWire, and SATA (Serial Attached to), even though the 00 these new formats allowed these fences to be portable enough with a standardized interface (like USB) that allows you to connect to another system painlessly USB. provides a plug and play more generic enabling the system to identify the unit as soon as you connect it. there are few fences on market which can contain multiple drives and even offer RAID (Redundant Array of Inexpensive Disks) capabilities. RAID provides the ability to mirror data from one hard drive to another or distance (strip) data on the drives you have. This provides an error proof in the case where a hard disk is lost due to a failure to the computer will not notice any difference in the access to the data as the other hard drives take over.

Although the disks were standardized by the complete (height or half-height form factor) the diversified floppy drive in a full range of products, including USB drives today. At the end of 1980 there was a new format called CD (compact disk) which offered the data stored on a plastic disc with reflective support. These CD drives were 5 1/4 "form factor and fit easily into existing expansion slots in the PC. CD started 680MB of data storage holds about 74 minutes of music and have topped out at 700MB of data. CD became the standard format for removable storage and are still widely used today. in the early 190 Iomega came to the market with the Iomega Zip drive. This external storage device started to 100MB and has grown to 750MB density. cartridge was based continuing "3 1/2 floppy innovation. This new type of storage has several connections to the PC.

In principle the connection was SCSI (Small Computer System Interface), but later developed into a (Universal Serial Bus) USB connection. In 1995 SmartMedia had arrived on the scene Toshiba Corporation. SmartMedia was a small (45 mm) plastic card with a flash memory module that allows direct 2MB of storage, but this quickly grew to 64 MB / 128 MB. These cards were used in digital cameras and other devices which can remove the storage and reading on a PC. Today you can find various sizes up to 32 GB on a single card. Unlike older technologies these new devices were much more robust than the floppy drive, and much more portable. During this same period of time the DVD (digital video disc) has come to the market to replace the CD. This format provided 4.7GB (8.5G Double Layer) of storage space on the same optical disc format that CDs are based. As the density increases Blu-Ray DVD arrived to provide 50GB of storage space with double layer disc is the most common. Blu-Ray offers the best video format high-density now commercially available with 100GB of data that are the standard.

to today as the hard drives and portable external storage have progressed to SSD Flash technology forward (Solid State Disk). This portable storage transformed in view of the ubiquitous USB flash drives people carry around with them. internal hard drives based on SSD technology allow you to use SATA to connect the indoor unit to your PC or laptop. SATA is the common standard for connecting hard drives. These units are more durable and have lower access time. How new emerging technologies such as cloud computing come there will be less demand for portable storage and hard drives. Cloud computing allows you to run the application on the web, while data resides elsewhere (the cloud). Make no mistake the data is stored, not only to the hard disk or floppy.

CSV vs JSON vs. XML - which is the best format for response data? -

If you are building a thin client (web application) or at some point thick client (client-server), you are probably making requests to a Web server, and they need a good size data for the answers. To date, there are three main data formats used to transmit data from a Web server to a client: CSV, XML, and JSON. In order to develop an application with a robust architecture, it is a good idea to understand the differences between each format and know when to use them. The purpose of this post is to define each data format, lay out the pros and cons of each, and find out which situations work best with each format.

CSV

CSV stands for "comma separated values". As the name suggests, this data format is basically a list of items separated by commas. Let's say that the answer is sending back a list of people in a particular family. The format would look like this:

Eric, Andrea, Kusco

Pros - This format is the most compact of all three formats. In general, CSV formats are about half the size of XML and JSON formats. This is the main advantage of CSV, because it can help reduce the bandwidth

Cons - This format is the least versatile of all three formats. This is because a homemade parser is required to convert the CSV data into a native data structure. Therefore, if the data structure changes, there is an associated overhead of having to change or even redesign your parsers. Moreover, since the creation program CSV and CSV parser reside on different machines (remember that we are passing data from one machine to another), then both programs must be updated simultaneously to prevent the program of crash reception. Otherwise, the interruption is required to update both programs individually to avoid incompatibility problems.

Finally, CSV actually does not support data hierarchies. What if you wanted to return the attributes for each person in every family? You would then need to design a complex parser that knows which parts of the CSV refer to elements of a family, and which parts refer to elements of each person. One way to solve this problem is to use another delimiter such as ";" to separate the attribute of each person

Eric; male; 26, Andrea; female; 26, Kusco; male; 8

The problem with the creation of custom sizes, however, is that it incurs an overhead of maintaining a more complex parser.

XML

XML stands for "Extensible Markup Language". XML was designed in 1996 and officially became a W3C standard in 1998. It 'was created to better represent data formats with a hierarchical structure. The format is similar to the following:

<Person> <name> Eric <!-- name--> <age> 26 <!-- age--> <!-- person--> <person> <name> Andrea <!-- name--> <age> 26 <!-- age--> <!-- person--> <person> < name> Kusco <!-- name--> <age> 8 <!-- age--> <!-- person-->

Pros - This data format fully supports hierarchical data structures and it is very appropriate when you receive complex data as a response. It is also very readable. Most browsers have built in XML readers that allow you to inspect the XML file. Since XML was the first of the series of hierarchical data format, most APIs have built in function to automatically convert the XML data flows in structures of native data as objects.

Cons - This data format is about three times larger than CSV. This is because each data element has an opening tag and closing associated parameter.

JSON

stands for JSON (JavaScript Object Notation). E 'was invented in 01 and became popular as Yahoo and Google in 05 and 06. It' was created as an alternative to XML. XML, however, is hierarchical data with the use of commas, braces and brackets. An example of JSON is similar to the following:

{ "name": "Eric", "age": "26"},
{ "name": "Andrea", "age": "26"},
{ "name": "Kusco", "aged", "8"}

pro - This format data supports hierarchical data while being smaller in size than XML. As the name suggests, it was also created to analyze more easily the data in native JavaScript objects, making it very useful for web applications. JSON is the best of both worlds with respect to CSV and XML. It 'simple and compact like CSV, but supports hierarchical data as XML. A difference of XML, JSON formats are only about twice as large as CSV.

Cons - This data format has a little 'less XML support. Since JSON is relatively recent than XML, fewer APIs exist to automatically convert JSON to native data structures. However, this is changing rapidly, because the API and the latest plugins are supporting both XML and JSON.

Conclusions

As a general rule, JSON is the best format for data exchange to date. It is lightweight, compact and versatile. CSV to be used only if you are sending huge amounts of data and if the bandwidth is an issue. Today, XML should not be used as a format for exchange of data, because it is more suitable for markup documents.

How quickly make a bootable USB stick with FreeBSD -

Installing FreeBSD, or use an existing FreeBSD installation, and proceed as follows:

1) First, you to prepare and format the USB stick:

-BI fdisk / dev / da0
disklabel -B w da0s1
-O1 newfs -U / dev / da0s1a
boot0cfg -v -B da0
( "U -O1" [ "O" like in Olympus, not zero] is for UFS1 that provides copying much faster than UFS2, if you decide to UFS2, type "U -O2" - but expect that the copy will be slower)

2) mount it: mount / dev / da0s1a / USB
3) copy all directories (FreeBSD) for the stick
4) After copying, change the /usb/boot/loader.conf (explained below)
5) in the / boot directory on your USB stick is required MFS (Memory File System - mfsroot.gz), which will (instructions are below)
6) Change / etc / fstab in MFS and put the following line (only) here:
/ dev / md0 / ufs rw 0 0
7) After you start your computer with the stick, you will be in the environment from which MFS you want to mount the USB stick with mount_nullfs (described below)

Change the /boot/loader.conf the USB stick

You must have the following lines in your /boot/loader.conf (some lines are optional):

mfsroot_load = "YES"
mfsroot_type = "mfs_root"
mfsroot_name = "/ boot / mfsroot "
nullfs_load =" YES "
splash_bmp_load =" YES "
vesa_load =" YES "
geom_uzip_load =" YES "
geom_label_load =" YES "
bitmap_load =" YES "
bitmap_name = "/ boot / splash.bmp"
snd_driver_load = "YES"
kern.maxfiles = "25000"
kern.maxusers = "64"
= vfs.root.mountfrom " / dev / md0 "

# More filesystem driver

udf_load =" YES "
linux_load =" YES "
fuse_load =" YES "
ntfs_load =" YES "
ext2fs_load =" YES "
reiserfs_load =" YES "

Make your own MFS

FreeBSD, after booting the kernel, you can use the root file system in memory (mfsroot_load = "sI" command in /boot/loader.conf will do the trick). To build such a memory file system, type the command:
dd if = / dev / zero of = mfsroot bs = 1024k count = 42

will be created mfsroot file of about 40 MB. You need to format it, mount it and copy the most important files in it from the FreeBSD system (/ bin, / sbin, / etc, / root ....):

MDConfig -a -f mfsroot md0
newfs / dev / md0
mount / dev / md0 / mnt

once copied, you need to take it apart and gzip: gzip mfsroot

Alternatively, you can chroot it to see if everything works, then copy the mfsroot.gz a / usb / boot on your USB flash drive (or disk). If you think that might be a problem to choose the most important files for your MFS (from your FreeBSD installation), the search for mfsbsd in Google and use his image only MFS (contained in the downloadable ISO mfsbsd) toolset or.

After booting from USB stick (you jump into MFS), it is necessary to fit the physical USB key:

/ sbin / mount -o ro / dev / da0s1a / USB
/ sbin / mount_nullfs / usb / boot / boot
/ sbin / mount_nullfs / usb / usr / usr

the above commands will help you use the large / usr directory on the USB stick instead of / usr dir MFS. mount_nullfs / usb / boot / boot is optional, as in MFS / boot directory only the following files are required for the small MFS to boot (/ boot / kernel MFS): geom_label.ko, geom_uzip.ko, zlib.ko to their debug symbols (zlib.ko.symbols, etc.). By mounting the / usb / boot dir mount_nullfs via the / boot directory in your MFS you will be able to load kernel modules.

How Safe Deposit Boxes Cost? -

If you have some valuables you want to keep as money, jewelry, insurance policies, original works, titles, mortgages, etc., you may find yourself heading to a local bank to get a safe box. The acquisition of a safe deposit box is reasonably priced at many banks. Safe deposit boxes are a must have for storing important documents that you might need in an emergency.

The rent per year for a safe deposit box charges for the size and the number available at any office of the bank. Most banks fees are in the same range. You should check with your bank for sizes, fees and readiness of the box. Most banks require that you go in the same branch to get quotes on the box.

There are many different sizes that you can get with a bank. Listed here is the average cost of a box across several banks.

• According to the research, the normal load of the safety deposit box costs from $ 30 to $ 75 per year.
• Bank of America charges $ 10 to $ 0 for a size of 17x15, $ 30 for a size of 2x5 and has the same charges for 10x10 box.
• Chase Bank has more than a lot of formats to choose from. A 2 × 5 can cost $ 60 to $ 65 per year.
• For Citibank, a box of size 2 × 5 is $ 20 for an annual fee and a fee of $ 3,320 for a size of 24 × 48 is like an annual fee.
• Wells Fargo also has various sizes to choose from. For a 2 × 5, this is $ 40 a year, while their 10 × 10 is $ 0 per year

Where are the safe deposit boxes find?

The safes are usually found in the section bank vaults. This time it is made of concrete and steel. When you rent a safe deposit box, you are issued two keys that fit only to your safety deposit box. Each key should be stored in a safe place which is separate. Some banks may oblige a key deposit fee. This application fee can cost $ 10 to $ 30. If you lose the key in the long run, you will have to pay a locksmith fee, or a fee that the bank chooses.

If you are planning to have one for your home, the SentrySafe H2300 can cost anywhere from $ 40 to $ 60. There are many other different brands and models that can be in this price range.

6 reasons to cancel or reschedule a part -

Canceling or rescheduling of a party is a very unfortunate event, but often occurs as the result of uncontrollable circumstances. Knowing how to deal with the situation is of uttermost importance.

party cancellation is disappointing and difficult to manage, but a variety of reasons require it, regardless of your will. Here are a number of reasons for the cancellation or rescheduling of a party and some information on how to deal with guests and delete the label.

People can not Make It

you will have to reschedule or cancel your party if too many guests are able to participate. Everyone wants to share great events and memorable moments of life with close friends. If these people have difficulty making it to the party, choosing another date will surely be the wisest move.

You may consider informing people about the change in person. Calling all and you can also inquire about another date for the party to be held.

A Storm is Coming Up

Weather can play a trick on you. It can interfere with your party planning efforts. You should reprogram your party if you plan a severe storm or other type of disaster weather - heavy rain or snow storms. Certainly it is wiser to organize the party in the future to put at risk the health and lives of your guests.

Personal Tragedies

a personal tragedy that you or one of your close friends have experienced is another reason for the cancellation of a celebration. Postpone the party in case of death or illness of family members. It will be appropriate to have fun while you care for someone cries or unwell.

that the major event

A major event that takes place on the date when you plan to have your party will be yet another reason for the cancellation. Returning party if someone else is going to get married on that date or if it is the anniversary of a pair you love.

most important city events - concerts, meetings or sports finals may have you thinking about moving the party to another date, as well.

disease

Cancel the party, in the case of an illness or a medical condition. This is another unexpected and uncontrollable factor that can interfere with your plans and the process of organizing.

could be a personal or a disease that affects someone you love and respect. You should better to have the party after the person gets better - this way you will have two reasons to bring people together and to celebrate.

The reason Celebrate disappeared

Sometimes, things fail to go according to plan. Such sudden changes and twists may request the deletion of a party.

A baby shower will certainly be canceled in the event of a miscarriage. This huge, personal tragedy changed plans and rapid response requirements.

Party planners should always have a backup plan. Very often, life is concerned surprising that we find it difficult to cope. Part cancellation or rescheduling can be difficult but it is certainly necessary in many cases. Ability to be flexible will help you manage the situation.

One short-term memory problems, and look how it affects Learning -

of short-term memory problems can significantly affect the learning of new information or maintain new events in a life person. The ability to function in the present and future can be drastically altered if a person has severe limitations in short-term memory. The question is what, if anything, can be done to help a person with short-term memory loss.

How do you get the short-term memory loss can vary greatly. For some it is due to aging. For others it could be the side effect of various medications they are using. Head injuries, stress and depression also reduce the short-term recall and cognitive function. Stroke can damage the brain involved in memory sections as well.

Extreme short term memory loss is usually the result of head trauma or a progressive disease such as Alzheimer's or dementia. There have also been cases in which the radical brain surgery has removed the ability of a patient to hold in the short term memory information, but these cases are rare.

studies on memory and learning show that the short-term memory problems may be a factor in a person's ability to learn new things. The short-term memory is usually the starting point for the elaboration of information, events, etc. in our long-term memory. If a person has problems using short-term memory, then you often have problems with learning facts, names, figures, etc.

Diagnosis short-term memory problems can be difficult. It usually involves both physical and psychological tests to determine the root cause. As you get the short-term memory loss is important in the way that is treated to whether the treatment is still possible.

Obviously if the root cause for the short-term memory problems a person faces are due to side effects of medications or stress then switching drugs or reducing stress is likely to bring an improvement in recall and a boost in learning .

If the root causes is injury or trauma then usually only have time and let the body heal itself will determine if any ability to remember is recovered or maintained. Learning new things will probably be a struggle during this process until the brain adjusts and is able to either heal or adapt to the damage ... assuming it is not too serious.

Extreme loss of short term memory will usually inhibit the process of lifelong learning. There are some medications that can help with recall problems caused by Alzheimer's disease or dementia, but often have troubling side effects of their own. Some natural supplements containing things like Ginkgo, Ginseng, huperzine A and B-complex vitamins have shown some promising results in recent studies. In fact some studies directed towards natural remedies and treatment of Alzheimer's have determined that some supplements geared for memory protection and enhancement work as well as prescription drugs in some patients, but no similar side effects.

Studies have also shown that supplements may help with the issue of how you get the loss of short term memory. They noted that the use of some herbal remedies can help stimulate the production of neurotransmitters, as well as the protection of these chemicals in the brain from age-related decline. Herbals have also demonstrated the ability to maintain the function of memory and protect nerve cells from damage due to free radicals and helps regulate the brain of stress without reduction function.

those who complete 's For of short-term memory problems result from injury or trauma using color aids memory: that color: how to write things or using the repetition can help to compensate for the reduction of call, provided that the person who keeps at least some function. This can help people continue to learn and retain information, while injured, but it requires more time making the slower than normal learning process.

Depending on the cause of the recall problem, there is hope for a bit 'that learning can continue. The brain is a mysterious organ though and much more needs to be discovered about how it works. Continuous research on brain function and remedies for memory loss are helping to fill this gap, but it is still a long way.

A simple application E-Shop with PHP and MySQL -

SPECIFICATION:

Write a simple application E-shop with PHP and MySQL *. This can be a library, music store, clothing store, or whatever you want. There should be a "user interface" to allow customers to select and purchase items (do not worry about the payment side of things). Ideally there should also be a password protected "owner" interface, to allow the operator E-shop to view pending orders / stock and change.

The exercise is deliberately "tough", given the short-term, and I do not expect that all need to complete to perfection. This will be taken into account in the marking.

mark system:

[A 5%] Ability to write work HTML code (the code that creates markup success of a browser window). **

[B 5%] Ability to publish an HTML web page on a server so that it is visible on the World Wide Web. ***

[C 10%] Ability to make an HTML form to communicate with a PHP script. **

[D 10%] Ability to make a PHP script to interact with a MySQL database. **

[E 40%] Functionality (the extent to which the operation of the software conforms - or exceeds- original specifications).

[F 10%] Ease of use (the extent to which the browser displays are clear and self-explanatory).

[G 10%] Presentation. (This could include appropriate use of images, color, text fonts, style sheets and dynamic HTML functions.)

[H 10%] The clarity and readability of the code and documentation ( for example the use of comments, etc. appropriate indentation)

Notes:

* If you want to use different web-based technologies (such as ASP, JSP, Pearl) please do it. However, please do not use high-level software packages that require programming skills (such as "WYSIWYG" HTML editor), as these rather defeat the purpose of taking this form.

** In categories A to D, the signs are allocated in a "binary" (ie the student receives either the entire mark weighting or zero). So the 30% can be achieved simply by demonstrating a basic knowledge of HTML, PHP and MySQL. The remaining categories are marked in a "continuous" (that is to say any number of frames between zero and the weighting value can be assigned).

*** In case of a server failure (or other unsolvable technical difficulties) Category B will be removed and the weights of the other categories in scale accordingly.

SOLUTION:

My application electronics store is for the sale of books and other assorted item sold by the Wandle Industrial Museum.

This development is a logical extension of an existing static website. The data and the basic layout of my question are derived from this pre-existing work.

The main interface:

The initial screen, not counting the original frames used in the Museum's website. Most of the content in the upper and lower frames is not functional and is included for completeness, this also helps demonstrate dynamic HTML code that has provided secondary navigation structures.

This screen shows the main body of the store information and functions of "shopping cart" to the button. This page provides access to:

1) The full list of "catalog" on-line;

2) A subset of the catalog listed by product category;

3) A subset of the catalog based on user-defined search terms;

4) More detailed information about an item;

5) Ability to add items to a basic session "shopping cart";

6) Capacity is registered users to write reviews of books;

If a user is new to the application, he / she will see the message "Welcome. Already a customer? Click here to access", otherwise they see their user name and a button to the right called " my account ", which allows them to edit their information. This information is stored in a client-side cookie that is maintained for 30 minutes.

About viewing SUMMARY:

The synthesis of the elements shows the level of object code, title, price, description and inventory of all items. The display also includes two additional further options, 1 items that are sold out are show in red. 2 items that are not sold through the online store are "gray-out" the "buy" button in both cases is removed from all the displays for a specific item.

BASKETBALL:

The carriage Initially there shopping basket until the user adds an item, until the time by clicking the "View button cart shows a default screen.

When you add an item, its quantity is set to a default one, this can be both increased with the addition of new the same item to the basket or by clicking the increment button on the screen basket shown here. once a basket has been created and the user enters the system are available under the product description of the following options:

1) Delete spending

;

2) Continue;

3) Checkout;

If the item is de-incremented to zero then it is removed from the basket

basket is based on sessions PHP and, unlike the identity of users, which is braked for. 30 minutes, not persist after the instance of the browser is closed.

If the user is not known to the application when he / she tries to complete the transaction, they will be asked to log in, if the user has an account he / she can login and continue with the operation.

If the user does not have his / her account must register before you can end up buying anything.

items to the shopping basket:

The elements can be added to the cart or from any summary list, or a description page.

A summary page displays basic element of information in a tabular format whithout images, like the one on the right by clicking on the "buy" button on the left on the voice line.

This can also be done from the item page detail, which is displayed by clicking the element code shown on the left of the summary display.

Each item detail page also includes a "buy" button, as well as other shopping basket instruments "These are the summary page, but basically so require scrolling

The database supports two types of voices, "books", as shown above, including specific information for reading materials, and "assets" which include only information basic product, item number, title and. price

where AE images a replacement is not available is automatically set up when the administrator specifies a real image

user :.

If the user is unknown to the application when he / she tries to complete the transaction, they will be asked to log in, if the user has an account he / she can login and continue with the operation

If the user does not have an account yet he / she must register before you can end up buying anything. Here we see the effect of an invalid attempt to register a new account. The user is given a text description and suspicious entities are culminating in sequence until all errors have been resolved.

After the user has recorded / she is asked to print out the form for his / her reference. Then he entered and I can bypass authentication at the time of purchase.

The application has been hard coded with an administrative account, the user name is "system" and the password is "God" Note there is currently no way to change this.

The display board allows users to:

1) define new types of elements;

2) Edit and delete users;

3) add, edit and delete categories;

This screen allows the user to modify both an existing data item in a specific category identified by its product code, or create a new item on the product. The application includes a specific set of validation criteria as shown in the next image. Items are listed in numerical alpha, from left to right.

Here we see the result of a failed input operation of the data indicated with crosses to indicate the invalid entries or missing for certain fields, also a check mark indicates that the field is valid.
E 'possible to have a correct entry - for example vacuum, if there are no images these boxes should be left clear.

The question mark is to double check the intention to leave blank, in some cases

This screen shows that theadministrator chose to remove a user account from the database - the edit and delete functions use the same display, except the edit function does not show the elimination of warning

interface image shows the home screen (welcome), excluding the frame used in the site Museum.

This screen shows the main body of the information store and the "shopping cart" function at the top and the button. This page provides access to:

1) The full list of "catalog" on-line;

2) A subset of the catalog listed by product category;

3) Ability to order a catalog listed by product code, price or title, in order to membership;

4) A subset of the catalog based on user-defined search terms;

5) More detailed information about an item;

6) Ability to add items to a basic session "shopping cart";

If a user is new to the application, he / she will see the message "Welcome. Already a customer? Click here to access", otherwise they see their user name and a button to the right called " my account ", which allows them to edit their information. This information is stored in a client-side cookie that is maintained for 30 minutes.

The display board allows users to:

1) define new types of elements;

2) Edit and delete users;

3) add, edit and delete categories;

4) Add, edit, move and delete products;

5) Change the information and add help;

6) Create and restore dumps of tables;

dictionary database:

A data dictionary defines common terms, codes and conventions used. Here are the search tables of the database required for the application of the store databases.

 Table: bookinfo: 
 Comments: Book-specific metadata. Null default field type of 
 code varchar (5) No No 
 author varchar (50) No Unknown varchar 
 poster (100) No Unknown 
 ISBN varchar (15) No None 
 illustrations varchar (15) Yes Yes - gray 
 Yes NULL date 
 size varchar (100) No unknown 
 No text summary 
 varchar (16) no 
 
 Table: categories: 
 Comments: the product metadata Null default field type 
 id int (3) No 
 name varchar (50) No 
 etype int (1) No 2 
 Keywords varchar (100 ) n 
 
 Table: customer: 
 Comments: customer billing information. Null default field type 
 uname varchar (15) No 
 FIRST_NAME varchar (25) No 
 name varchar (25) No 
 phone varchar (20) No 
 email varchar (50) No 
 zip varchar (10) No 
 city varchar (50) No 
 country_code int (2) No 0 
 bill_address varchar (0) No 
 changed timestamp (14) Yes NULL 
 
 Table: orderdata: 
 Comments: customer order field type Null default information 
 ORDERNUMBER int (5) No 0 
 itemcode varchar (5) title varchar (100) n 
 int amount (3) No 0 
 total float No 0 
 int status (11) No 0 
 timestamp stamp (14) NULL 
 
 Table: orders: 
 Comments: data customers refferance order. Null default field type 
 uname varchar (15) No 0 
 ORDERNUMBER int (5) No 
 int status (1) No 0 
 Yes NULL Date 
 
 Table: Reviews : 
 Comments: user book reviews and rations. Default Field Type Null 
 uname varchar (15) No 0 
 int (1) No 
 Rating int (1) No 0 
 timestamp stamp (14) Yes NULL 
 review text No 
 
 Table: product: 
 comments Table: primary product data. Null default field type 
 code varchar (5) No 
 category_id int (3) No 1 
 title varchar (100) n 
 Keywords varchar (255) n 
 small_image varchar (15 ) No nopic.jpg 
 large_image varchar (15) No nopic.jpg 
 No description 
 price decimal (5.2) n 00:00 
 DATE_MODIFIED No date 0000-00-00 
 int status (1) No. 1 
 Table: purchase: 
 Comments: data of primary products. Null default field type 
 code varchar (5) No 
 timestamp Date (14) Yes NULL 
 stock int (3) n> 15 
 decimal cost (5.2) n 00:00 
 
 Table: PWL: 
 Comments: User password information / access. Default Field Type Null 
 uname varchar (15) No 
 upass varchar (100) No 5d2e19393cc5ef67 
 created timestamp (14) Yes NULL 
 
 Table: syshelpindex: 
 Comments: Support system object index.Field default type Null 
 cat int (2) No 0 
 subject varchar (30) No 
 
 Table: syshelpinfo: 
 Comments: help system information.Field type null default 
 cat int (3) No 0 
 title varchar (30) No 
 No information text 
 image varchar (20) No 
 int (1) No 0 

FILE STRUCTURE:
application is the electronic store for the sale of books and other assorted item sold by the Wandle industrial Museum. This development is a logical extension of an existing static website.

application files are stored in subdirectory 9. These are as follows:
../ htdocs / order.htg / This is the root of web application, which contains all the resources related to the website. All generic files and accessories elements are stored at this level. (3.74MB 263 files)

• continfo.php - Ordering contacts and information (PHP 4.01kb).
• create_db.sql - the database structure (SQL dump 5.82kb).
• credit-cards.gif - used types of credit cards (image 2.02kb).
• cvc.jpg - Clarify where to find a value of CVC (6.0kb image).
• dictionary.txt - MySQL Data Dictionary (2.85kb text).
• discount.gif - Animalised 10% discount for Members to note (111.kb image).
• discount1.gif - Advertising a discount of 10% for members (53.6kb image).
• avicon.ico - Representation of a simple water wheel (318B icon).
• index.htm - Custom Error 404 page site (HTML 1.76kb).
• new_ani.gif - An animation of the word 'new' (image 1.66kb).
• offers.gif - graphic text 'control these specials' (picture 1.77).
• pleasenote.gif - searing An animation of the text 'remembers' (image 14.7kb).
• reset.gif - graphic reset input form button (image 1.28kb).
• shop.gif - small photograph of the actual shop museum (image7.31kb).
• submit.gif - the submit button graphic input module (image 1.18kb).

../ htdocs / order.htg / common.htg / This directory contains all common utility scripts , and other resources that the web application depends on. (185KB 50 files)

• about0.gif - graphic text 'homepage' (image 0.98kb).
• alart.gif - Animalised rotating red warning light bulb (image 2.04kb).
• alert.gif - A human skull with the word 'warning' (3.39kb).
• archive0.gif - graphic text (image 970b) 'archive'.
• backg.jpg - design wallpaper depicting a water mill, as a watermark (image 13.6kb).
• background.jpg - Wallpaper with a type of marble stone effect (image 4.59kb).
• basic.css - Website formatting and formatting descriptions (of 7.53kb style sheet).
• brics.gif - Animalised circuits exposed in a wall behind the wallpaper (image 7.46kb).
• caurtion.gif - Animalised rotation caution sign on the road (image 6.53kb).
• cnote.htm - Site copyright and attribution information (HTML 1.95kb).
• constants.inc - Application of global data values ​​(PHP includes 161b).
• contact0.gif - graphic text (976B image) 'contacts'.
• db_lib.php - access to the common database functions and utilities (PHP 25.2kb
• disclaimer.gif - .. Animalised blinking text 'disclaimer' (graphic image 4.57kb)
• email2.gif -. Drawing of a mail box outside the post on a globe (image 1.12kb)
• fax.gif -. Drawing a basic fax (231B image)
• feed0. gif -. graph of the text 'feedback' (image 90B)
• focus.js - script to put attention on a hidden pop-up window (javascript 165b)
• home0 .gif -. graph of the text 'general' (image 967b)
• iiv.gif -. clear graphic of the Investing in volunteers logo (image 2.63kb)
• iiv.fpg -. graphic matt Investing in volunteers the logo (image 4.49kb)
• index.htm - .. custom error page 404 site (HTML 1.76kb)
• info.gif - transparent museum with logo contact information (image 2/31).
• jfooter.js - code to dynamically generate the footer information of the page (javascript 2.41kb)
• letter.gif - two simple letters design (image 698b).
• linksb.jpg - A spider in a spider web on a small representation of a browser (1.18.kb image).
• linkware.gif - transparent graphical text 'all the material on this site have ware Connection' (picture 1.56).
• map0.gif - text graphic 'site' (image 989b).
• members0.gif - graphic text (984B image) 'members'.
• misc.inc - Freeola SQL authentication data access to the service (PHP includes 144b).
• news0.gif - graphic text 'News Letter' (image 947b).
• l_misc.inc - SQL authentication data to my server (PHP includes 144b).
• nopic.jpg - Notice of there being no photos available (5:40 picture).
• order0.gif - graphic text 'Mail Order' (image 0.96kb).
• phone.gif - Transparent graphic of a red phone (281KB image).
• print.css - the screen formatting descriptions (of 3.65kb style sheet).
• registered.gif - Opaque graphic of the registered museums logo (image 428b).
• registered3.gif - clear graphic of the registered logo Museums (picture 2.80b).
• resize.js - code to dynamically change a window to the image size (javascript 1.05kb).
• search.gif - search graphic '(image 108b).
• sqldumper.inc - code to dynamically create a SQL dump files (PHP includes
• stop.gif -. Transparent graphic of a red hand (image 2.64kb)
• .js time - code to dynamically display a countdown (javascript 591b)
• toc.js -. code to dynamically display a navigation structure (javascript 3.34kb)
• wandlemuseu.gif - transparent animated graphics of the text 'the Wandle industrial Museum' (image 42.3kb)
• webbo.gif - .. transparent graph of webbo head (image 1.16kb)
• webo1.gif - graphic clear of webbo (image 3.81kb)
• wimlogo.gif -. matte graphic museum logo waterwheel (417B image)

../ htdocs / order.htg / DATA_BACKUP / this directory is used to store SQL the file dump .. (242KB file 3)
../ htdocs / order.htg / help / this directory is used to store the graphics help the desktop database. (336KB 26 files)
../ htdocs / order.htg / images.htg / This directory is used to store the graphic for the store database. (2.41MB 91 files)

../ htdocs / order.htg / mysqlsnips This directory contains a number of texts files related to commands such as SQL.

../ htdocs / order.htg / shop.htg / This directory contains all the source files relative to public areas of the store database utility scripts and other resources that model the web application depends. (85.1kb 20 files)

• basket.php - Create and maintain a commercial basis basked (PHP 9.29bk) session.
• book_detail.php - block of code to display detailed information for a selected book (PHP 2.41kb).
• buttons.inc - block of code for displaying the bottoms of action relating to product information (including 2.43kb).
• catalog.php - Generates view primary catalog interface users (PHP 6.63kb).
• checkout.php - Script to update the product and order database (PHP 5.02kb).
• help.php - user interface view Show help desk system (PHP 6.71kb).
• login.php - Scripts for the users and access database administration tasks (PHP 7.91).
• old login.php - script of obsolete access (PHP8.99kb).
• orderend.php - block of code for displaying the basket buttons (PHP 1.36kb).
• ordertop.php - block of code for the display of information shot and primary controls (PHP5.73kb).
• pagefoot.inc - block of code to create the structure of the final HTML page (Includes 801B).
• pagehead.inc - block of code to create the HTML page starting structure (Include 854b).
• product_detail.php - block of code for displaying detailed product information (PHP 1.15kb).
• product_list.php - block of code to display summary information object (PHP 3.07kb).
• product_show.php - code block that displays the alternative synthesis information (PHP3.16).
• prompt.inc - block of code for displaying a message to the user (including 897B).
• signin.php - Display simple to access the login screen. (PHP 3.08kb).
• terms.php - terms and viewing conditions (PHP 5.83kb).
• terms2.php - terms and conditions by far display a secondary window (PHP 5.75kb).
• thankyou.php - display the final confirmation screen (PHP 3.28kb).

../ htdocs / order.htg / update.htg / This directory contains all the source files related to store database administration areas and other utility scripts. (240kb 34 files)

• addcat.php - Add additional categories of entry to the database (PHP 2.18kb).
• addproduct.php - Add additional elements to the database (PHP 6.30kb).
• admin.php - web content management interface (PHP 65.9kb).
• backup.php - generates the database dump file (PHP 5.21kb).
• berror_form.inc - current errors to the new elements of the book database (Includes PHP 3.0kb).
• bookinfo.inc - code block for entering the book data (Include 6.64kb).
• bookup.inc - Display editable book information (Includes 10.2kb).
• buttons.inc - block of code to create the edit control buttons (Include 4.41kb).
• change.php - The source code for the update confirmation messages (PHP14.4kb).
• edithelp.php - Allows editing and creation of information help desk (PHP14.0kb).
• entbuttons.inc - code block for data entry of forms control buttons (Include 1.21kb).
• error.gif - Transparent graphic of a cartoon cross (image 118b).
• fine.gif - transparent graphical fo a cartoon checkmark (image 126b).
• help.php - the interface view display help desk system administrators (PHP 6.22kb).
• index.php - administrative access to the database editing functionality (PHP 12.5kb)
• invoice.php - generate invoices customer display for printing (PHP 5.33kb).
• mysqlsend.php - Enables the user to execute custom SQL statements (PHP 4:59)
• newcat_form.inc - The new event the correction of the name of the category errors (Includes 773B).
• newname_table.inc - Display new product entry form (Include 438b).
• newproduct.php - update / delete data from the inventory database (781kb PHP).
• newtypeform.inc - Viewing new category entry form (Include 563KB).
• note.inc - Show information messages system (Includes 524B).
• oldorders.php - the display summary data for closed orders (PHP 3.22kb).
• orders.php - View selected random order (PHP 7.77kb).
• perror_form.inc - Display the errors Product Information (Includes 1.99).
• productinfo.inc - input form displays the product (Includes 3.68).
• productup.inc - Display the editable product (Include 7.02kb).
• quest.gif - transparent graphical fo a question mark (image 114b).
• stock.php - Administrative summary data warehouse (PHP 9.07).
• upload.jpg - Upload button graphics (image 1.84kb).
• upload.php - copy images in images.htg directory on the server (PHP 5.40kb).
• userorders.php - user viewing order history (PHP 2.36kb).
• users.php - Display editable user access information (PHP10.04kb).