Database with PHP, XML, Javascript

**? There are about? 10 pages in this project that you will be working on but? some of them simple works.? 1.? ? ** **Main Default page? : the work is creating a list of table to seperate Local News, World News, Video News, and others. ** **2. Education Page: Layout should be without? left menu on this page. Mostly on this page will have link of many pages as it grows for education with same format. 3. Mutual Fund page: No left menu, it will have information current mutual stock and Treasure bond retrieve from database table 4.? Dividendsplit page: it will store dividend information like cash and bonus stock, and AGM meeting. Most important to run query highest percentage of dividends. 5. Conferencecallpage: It will store and display General Meeting, time, Date and place and also link for? listening the meeting. 6. Market capitalization: The layout needs to be used without? left menu on this page. It is just graphs of DSE, DSI, CASP and also Market capitalization. 7. Earning page: it will display earning information as a specific format. Make sure that I can update earnings news and display date, title and earning news. 8. Feedback page: the current need to be modified and two box of comments with suggestion and complain. 9. Videspodcast Page: please check the design page. No left menu for this page. People can update videos with caption and filter those porpno 10. CSE & DSE News page: No left menu on this page It will DSE & CSE News page, Commentary Page and Blogs.? Please check design page. It needs comments and recommendatin trac option. Please let me know if you any question.** ? ? ? ? ? ? ## Deliverables June Project 2009: 1.? ? ? ? ? ? **Main Default page:** Page 1:? <[login to view URL]>. This page will be default page as <[login to view URL]> a.? ? ? ? ? ? There will be at least 5 separate tables like Local news, Market news, World news, News Videos and so on underneath of ? “ **Effort continues to bring more people under taxnet: Saifur?? they will be separated by title like Article or Market Commentary.** b.? ? ? ? ? There is a white gap at the top on the right which needs to be minimized. 2.? ? ? ? ? ? **Education Page 2**: <[login to view URL]>,? Design Page: <[login to view URL]> a.? ? ? ? ? ? This page will be repeated as page 1, page 2, page 3, page 4 and so forth with same format and same size. Those pages link will be listed at the top. b.? ? ? ? ? Layout should be using one of CSE one with CSE ticker running without left menu. ? **3. Mutual fund page:? Design Page: <[login to view URL]>** a.? ? ? ? ? ? This page contains with Mutual fund and Treasury Bonds lists into two different tables. In Treasure Bond list, database table should be created as ? | Stock Symbol | Duration | Coupon | Issue date | Maturity Date | Current Price | Yield | ? Contact Info | b.? ? ? There are 13 or more mutual funds listed in the market and they have been currently storing in our database. It just needs to display as. I will give list of those stock symbols for mutual funds. 4. **Dividend Split Page:** <[login to view URL]> , Please look at the design page to view the tables. Design page: <[login to view URL]> a. It will have two sections. One is to display most current cash and bonus dividend information with General meeting and so on. Data will be extracted from two sites <[login to view URL]> and <[login to view URL]>. You can see there is no dividend payment date and ex-divided date. Some of AGM shows dividend open date or book open ( from ) date that consider as Ex Dividend and Close or To date can consider Record Date. Otherwise payment date and ex-dividend date need to be stored as NA. b.? ? ? It will display current dividends information after storing data. c.? ? ? It should also have option to run query at the bottom of the page for highest percent of dividend payment for each year according to design page. ? **5. Conference-call page:** <[login to view URL]> **Design page:** <[login to view URL]> Data will be extracted from ? <[login to view URL]> and store data according to design page. After storing the data it will display as calendar events as it showed currently. It will display details information one clicks on the events. a.? ? ? Keep the Google calendar but display data from database after extracting. 6. **Market Capitalization page:** <[login to view URL]> Data will be extracted from <[login to view URL]>. Design page: [login to view URL] a.? ? ? From a drop down box, one should be able to select graph 30 days, 90 days, 1 year, 3 years of graphs such as? total market capital ( Total market capital (mill)), DSI, DSE, CASPI and CSCX index. The way you have in 52 week page. b.? ? ? Second half the page, it should have moving average chart. I will show you how to calculate. c.? ? ? There should be another table to store Monthly record information according to this link Extract Data <[login to view URL]>. Let me if it is possible. ? **? ? ? ? ? ? ? ? ? ? ? 7. Earnings page:** <[login to view URL]>[ ][1] Design Page: [[login to view URL] ? ? ? ? ? ? ? ? ? ? a. It should? have multiple rows to have multiple earning news listed. Make sure it has column to add Title bar, time for news update, and description, Please check the design page.? It does not need to have comment box or login option.][2] ? **8. Feedback Suggestion page**: <[login to view URL]> a. ? ? ? ? ? ? ? ? ? ? ? all the suggestions and complain need to be stored in database with their name and email address. Those ideas and complain need to be displayed from database table. b. ? ? ? ? ? ? ? ? ? ? one should be providing new ideas or suggestions for BDStock or DSE/CSE market ? improvements. c.? ? ? ? ? ? ? ? ? ? ? ? Another one should be like complain issue about Bangladesh Market process.? Here the link to have some ideas ? <[login to view URL]> **9. Podcast/Videos page**: <[login to view URL]> Design page: [login to view URL] a. One must login to account in order to upload a video file onto this site.? Parson name, videos caption name and description box need to be added in order to upload a video file.? b.? ? ? ? ? Only specific videos or size of the videos for restriction. In order filter porno I will have access to permit displaying videos. ? **10. Todaysnews:** <[login to view URL]> [][3]Design page of Market commentary, Blogs, and DSE and CSE News <[login to view URL]> <[login to view URL]>[? ][4] a. In this page, there are three links , one page is for CSE & DSE News, second is for ? Market Commentary, and then Blogs. b. CSE & DSE News will be extracted from DSE and CSE market and stored to database table with date, stock symbol and description news. In same page, DSE news at the top and CSE news at the bottom will be displayed. It does not comments or recommendation tracking. c. Blogs and Commentary will have same format of comments box, picture box if available and in order to add comments one has to login to account. It will also store blogs and commentary? in News table with date, title and authors name. Blogs an commentary pages need comment box and recommend box option. ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? * * *This broadcast message was sent to all bidders on Thursday Jul 16, 2009 6:42:11 PM: Although there are 10 pages, first two pages are done almost. You can work on rest of those pages. Let me know if you can work on this project.