第一回做项目——跪求各路高手指导
第一次做项目——跪求各路高手指导
自学了一段时间的html、php和mysql,第一次做项目。
大概需求是这样:
1、数据导入功能(excel)
2、特殊日期的设计与修改
3、数据统计
首先实现数据的查询功能,并依据查询结果给基本的描述性统计参数。查询内容主要包括:
(1)特殊日期
(2)选定的日期段
(3)选定的周几到周几
(4)选定的时段
4、数据的绘图
首先实现数据的查询功能,并依据查询结果绘图。
(1)静态2D、3D
(2)动态的绘图
因为之前没有项目实战的经验,但是已经下定决心以后要往这方向发展,对于这个项目,本人初步还没有什么比较好的思路,请各位高手不吝赐教!非常感谢~~~
------解决方案--------------------
excel导入很简单,
日期到网上找个JS日期控件,
特殊日期不知道你指什么,
图表也到网上找个好用的,
所以最终问题主要还是数据库设计和数据查询,
不过这个项目对第一次的新手来说确实是难度高了。
------解决方案--------------------
1.设计数据库,这是首要。数据库的设计优劣直接影响后面的查询效率。
2.实现EXCEL读取内容。
3.实现读取的内容存入到数据库中(增)。
4.实现查询功能。(查)
5.特殊显示,2D/3D,估计要用到JS插件了,推荐使用armcharts,下载网址:http://www.amcharts.com/download/
所以说,还是很简单的。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











HTML, CSS and JavaScript are the core technologies for building modern web pages: 1. HTML defines the web page structure, 2. CSS is responsible for the appearance of the web page, 3. JavaScript provides web page dynamics and interactivity, and they work together to create a website with a good user experience.

In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.

SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.

Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.

AI can help optimize the use of Composer. Specific methods include: 1. Dependency management optimization: AI analyzes dependencies, recommends the best version combination, and reduces conflicts. 2. Automated code generation: AI generates composer.json files that conform to best practices. 3. Improve code quality: AI detects potential problems, provides optimization suggestions, and improves code quality. These methods are implemented through machine learning and natural language processing technologies to help developers improve efficiency and code quality.

MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.

MySQL is suitable for rapid development and small and medium-sized applications, while Oracle is suitable for large enterprises and high availability needs. 1) MySQL is open source and easy to use, suitable for web applications and small and medium-sized enterprises. 2) Oracle is powerful and suitable for large enterprises and government agencies. 3) MySQL supports a variety of storage engines, and Oracle provides rich enterprise-level functions.
