Q01: What is the construction of the database? Q02: How can I manage the site in accordance to my data? Q04: How the site works? A01: The variable elements of the website get data from one database. This database is consisting by the following tables. 1. Table of general information of the website. The administrator can insert, erase or modify the following fields: - Title of the website. The title is presented in the header of each web page. (max. 50 characters). - Image of the website. This image is presented only in the homepage. The name of file of the image including the path to the file must be less than 250 characters. The image should be compressed as web image, to be of jpg type, and to have dimensions 746x341 px. The height of picture can be bigger or smaller, but this fact shall move the remainder page down or up, respectively. - Description of the website. It is the text that is presented under the image (banner) of the first page. It can have up to 200 characters. It must be considered that as long as the text grows, the remainder page is moved down. - The fields address, city, zip, province and country can have up to 50 characters. This information is presented in the web page Contact. - The fields, telephone and fax can have until 12 characters. The information of these fields is presented in the ‘contact’ page. - The field email can have up to 50 characters. In ‘contact’ page this field is a link that the visitor can use in order to send message to the administrator. - The field URL can have up to 50 characters. It is presented in the ‘contact’ page as a link to the site. - The field contact name can have up to 50 characters. - To finish, the field description of the website, can have up to 2000 characters. This field is presented in the page about. All the fields are optional. However is some of them are not entered then in the corresponding fields of the pages shall be presented as voids, fact that can disturb the appearance of the pages. If there is only one record then the fields will be fixed. When there is more than one record, then the fields will be presented randomly, each time the page is opened. 2. Table of texts of the site. In the left column of each page is presented a group of three paragraphs with their titles and three thumb images with their title too. The administrator can insert, modify or delete the following fields: - Titles of paragraphs 1, 2 and 3. The titles can have up to 50 characters. - Paragraphs 1,2 and 3. These texts can have up to 500 characters. - Thumb images 1, 2 and 3. The total of characters of the path of the files should not exceed the 250 characters. The thumb images pictures should be compressed as web images, having width of 160px. The group of these records is showing randomly each time where the page opens. In the case where exists only a record then this record is presented fixed in each page. 3. Table of insertion of items (goods or products). This is the main table where are registered items, goods, products etc. The administrator can insert, update or delete the following fields: - Title of item like book, song or anything that can characterize the item. Max allowed characters 50. - Name of Item. Max allowed characters 50. - Category of item. Max allowed characters 50. - Title of short description. It can be `short description' or anything else which can suit better to the item. Max allowed characters 50. - Short description of item. Max allowed characters 500. - Title of description of item like ‘description’. Max allowed characters 1000. - Thumb image of the item. Max allowed characters of the path of file 250. - The date of publication is registered automatically and has the form YYYY-MM-DD. - Price of the item can have up to 50 characters. Alphanumeric characters are allowed. - Notes for the item, up to 50 characters. - In the catalogue page the registered items are presented randomly. All the fields are presented in the detail page of the item as also in the update page. In the result page of the search a narrower group of fields is represented. 4. Table of email configuration. The information of this table is used for the recovery of the information of log in for the authorized users, via email. - Field of email address, up to 50 characters. It has the known form ‘yourname@yoursite.com’. This address must be configured in accordance with the server which hosts site. You can ask your provider who host your site how to configure your email or you can ask other services through internet. - The field server name, up to 50 characters. Usually it has the form ‘mail.yoursite.com’ or you can leave it empty. - The field return path can also be empty. Usually it is the same with the email address, ‘yourname@yoursite.com’. - The field sender implies the sender of the message which is sent to the person who has asked the log in information. The information that needs for the configuration of the email is related with server which hosts the website. This table allows only one record. When the table is empty then it is allowed the insertion of one record. Afterwards it is allowed only the updating of the existing record. 5. Table of internal mail. This table is useful for the communication of the visitors with the administrator. In the page ‘contact request’, the visitor supplements the contact form and dispatches it. The administrator can get a list of the entering messages; he can open the messages and delete it. The form allows the attachment of one file of any type. - Field `name of sender’ up to 50 characters. - Email of sender, up to 50 characters. - Date of post, it is inserted automatically. - Subject, up to 50 characters. - Comments, free text - Attachment, up to 100 characters. - Table of users. The table is used for the registration of persons who can have access in administrator’s pages. Initially only the administrator has access, using as user ‘administrator’ and password also ‘administrator’. The administrator must be logged in first before he can access the administrator pages. After the ‘log in’ the link ‘administrator’, which is in the footer of each page, it opens the administrator control panel page. - The link `register' gives the possibility of registration of a new user-administrator by the ‘administrator’. - The link `edit profile' it is for the updating or modification of the information elements of the users who are already registered. The administrator can change also his own information. The administrator must not forget his own data and he must keep his `user level' as level `1'. Otherwise he will not have access in the control panel. In case where the administrator has forgotten his log in information or he has changed his user level to another number other than ‘1’, then the recovering of the administrative rights can become within the intervention in the my SQL database in server. The fields of table are: - Name of user, 50 characters. - Email address, is the address where shall be sent the messages for the recovering of the log in information. This email can be you personal email or the email which is declared in you server. - Field `user’s level' fixes the rights of access of the registered users. The level `1', gives the all the privileges that is it gives the right of access in the page of administrator, from where the content of the website is controlled. A02: The management of the website includes the following operations. - Form of insert of data in each table of the database. - Form of updating and modification of the data of each table. In the form are presented the existing data and images. - Form of search. When the form remains empty, then all data of the table are listed. The search can be limited using more specific criteria. - List of results of search with links to the page of the details, to the page of updating as also to the page of deletion. - Page of details. - Page of deletion. A03: The website is consisting from at group of files which must be transported to the server. It is supposed therefore that before you must be subscribed to a host which runs php and mySQL. The files of the site must be transferred to the server using a FTP program which must be installed in your computer. Afterwards the installation of the files in the server it must be created a database. The file that will create the database is included in the files. However you must open mySQL, where you must create a base with the name demosite2. After you must run the sql file in order to create the necessary tables with their basic structure and data. The installation is the only field that requires certain knowledge. If you do not have the technical knowledge to do this job, then you can ask for help from your host provider or somebody else. If you wish my own services and help then you can contact me. The required work is not much and consequently the cost is small. Alternatively you initially install the files in a localhost, like XAMPP and run the program in your computer. This gives you the possibility to modify your website easier and faster. When you finish the main job you can transfer your site to the server to be available in Internet. If you have knowledge you can process the files and to make changes. A04: This web site is adapted for the promotion of products of various categories. The pages are dynamic and draw their data from various tables of a data base. The administrator of web site can change the title of the web site, the main picture of the first page, the texts and the pictures of the left column of the web pages etc. The administrator can import products and services that he wants to be shown or he can modify or even delete records. The information that concerns the web site and the activities of the administrator can also be modified easily with the use of the ‘administrator control panel’. The visitor of the website can search the products using different criteria; he can see the list of the results of his search and to visit the detail page. Also the visitor can contact the web site using the contact form. |