CN105405064A - PHP- and MYSQL-based campus energy-saving platform implementation method - Google Patents
PHP- and MYSQL-based campus energy-saving platform implementation method Download PDFInfo
- Publication number
- CN105405064A CN105405064A CN201510726690.3A CN201510726690A CN105405064A CN 105405064 A CN105405064 A CN 105405064A CN 201510726690 A CN201510726690 A CN 201510726690A CN 105405064 A CN105405064 A CN 105405064A
- Authority
- CN
- China
- Prior art keywords
- mysql
- php
- energy
- campus
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/20—Education
Abstract
The invention relates to a PHP- and MYSQL-based campus energy-saving platform implementation method. The method is characterized by comprising the following steps: creating an MySQL database for storing campus electric energy parameter website interaction data, installing an intelligent electric meter in each building of a campus to read power utilization information, transmitting correlation data into the MySQL database by utilizing data collectors and transfer stations, and designing a PHP program interface. A campus energy-saving website platform is developed on the basis of PHP and MYSQL technologies. The platform adopts a B/S (browser/server) structure and an APACHE server, and, by utilizing MySQL management software phpMyAdmin, the platform manages electric energy parameters, which are acquired from the various building of the campus, after processing.
Description
Technical field
The invention belongs to computing machine front end development field, colleges and universities' energy efficiency supervision platform is set up mainly for campus energy consumption problem, for simplifying the complex process of labor management energy data, PHP and MYSQL is utilized to design dynamic website, by analytic system framework, database design, the design of website framework and content, realizes campus electrical energy parameter monitoring analysis.
Background technology
Energy problem has become one of problem paid close attention to the most in the whole world, and power consumption is the major reason causing energy problem, and therefore using electricity wisely has great importance.Campus is power consumption rich and influential family, but because a variety of causes also exists various serious electricity consumption wasting phenomenon in reality.Therefore, by building colleges and universities' energy efficiency supervision platform, exploitation power quality parameter monitoring website, also becomes more important to the process of electricity consumption data analysis.
Summary of the invention
The technical problem to be solved in the present invention is: the complex process simplifying labor management energy data, improves the efficiency to electric energy managing power consumption.
In order to solve the problems of the technologies described above, technical solution of the present invention there is provided the implementation method of the energy-conservation platform in a kind of campus based on PHP and MYSQL, it is characterized in that, comprises the following steps:
Step 1, creating MySQL database for storing electrical energy parameter website, campus interaction data, in the Mei Dong building in campus, intelligent electric meter being installed and reading power information, utilizing data acquisition unit and terminal by related data transmission in MySQL database;
Step 2, design PHP program interface:
Realize user's login interface, different users arranges different data and checks authority, plans page layout by CascadingStyleSheets, makes any browser all accept instruction, knows this how display element and content;
Step 3, between server and PC, adopt B/S framework, the browser be positioned on PC sends request to server, for PHP routine call, server returns to browser the result of PHP program with html format, PHP routine package is contained on Web server, MYSQL database then operates on database server, is undertaken alternately between the PHP program of database server and Web server by a series of MYSQL function.
Preferably, described MySQL database comprises basic information database, energy consumption data storehouse, distribution substation management database, then newdata table in these databases, comprises user message table, energy-saving mechanism admin table, architecture information table, facility information table, energy data table, distribution substation data Real-Time Monitoring table and failure logging table.
Preferably, in described step 2, webpage comprises following navigation module: transformer substation foundation data module, electricity consumption enquiry module, data analysis module, real-time monitoring module, device control module, priority assignation module and Reports module.
The present invention is based on PHP and MYSQL technology, exploitation campus energy-conserving website platform.This platform adopts B/S (browser/server) framework, adopts APACHE server, utilizes the MySQL management software phpMyAdmin management electrical energy parameter that each building collects from campus after treatment.
Website platform of the present invention is by setting up exclusive multi-energy data warehouse, the business of multi-energy data is changed, analysis mining and value data mining, realize the visualized management of energy consumption data, be presented to client with various ways such as form, curve map, histogram, pie chart and scatter diagrams by WEB Information issued mode.The school managerial personnel having mandate at different levels, the network of school can be utilized check by PC, not only can view the year of school, monthly total energy consumption, each branch campus, the energy resource consumption rank of Secondary College, energy consumption cost can also be checked, by the mode excavated layer by layer, view certain energy resource consumption and cost.Information platform can and formulate examination, management system, for keeper provides data foundation according to these branch schooles results.
Accompanying drawing explanation
Fig. 1 is campus energy conserving system structure;
Fig. 2 is the PHP+MYSQL+APACHE course of work;
Fig. 3 is website operational flow diagram.
Embodiment
Below in conjunction with specific embodiment, set forth the present invention further.Should be understood that these embodiments are only not used in for illustration of the present invention to limit the scope of the invention.In addition should be understood that those skilled in the art can make various changes or modifications the present invention, and these equivalent form of values fall within the application's appended claims limited range equally after the content of having read the present invention's instruction.
In the present invention, first, in the Mei Dong building in campus, intelligent electric meter is installed and reads power information, utilize data acquisition unit and terminal by related data transmission in database.As shown in Figure 1, wherein the data summarization of multiple collector is responsible for by terminal, PC by the information displaying in database on browser related web page.In the selection of system architecture, because the energy-conservation platform in this campus needs to show energy information on a web browser, consider the situations such as the maintenance of later stage platform, native system will adopt B/S framework simultaneously.
In the present invention, browser sends request to server, it is generally PHP routine call, server returns to browser the result of PHP program with html format, PHP is included on Web server, MYSQL database operates on database server, and the PHP program of database server and Web server is carried out alternately.
Below patent working scheme of the present invention is described in further detail:
(1) MySQL database for storing electrical energy parameter website, campus interaction data is created
MYSQL is a quick and healthy and strong relational database management system.This database will allow you to store efficiently, search for, sort and retrieve data.The access that MYSQL server will control data, thus guarantee that multiple user can use it concomitantly, provide fast access simultaneously and guarantee to only have the user by checking to obtain data access.Here management tool PHPMYADMIN building database can be utilized, comprise basic information database, energy consumption data storehouse, distribution substation management database, then newdata table in these databases, comprise user message table, energy-saving mechanism admin table, architecture information table, facility information table, energy data table, distribution substation data Real-Time Monitoring table and failure logging table etc.
(2) PHP's and MYSQL is mutual
Composition graphs 2, how utilizing PHP by the information displaying that stores in database in Web site, is also one of gordian technique of the energy-conservation platform in exploitation campus.Numerous data shows, mutual mainly by a series of MYSQL function between PHP and MYSQL, comprises connections, disconnection and Query Database, and data processing and error handle.First, PHP must connect database server, could operate MYSQL database, after end of operation, disconnect the connection with database, with free system resources.
(3) PHP interface
First realize user's login interface, different users arranges different data and checks authority, plans page layout by CascadingStyleSheets, makes any browser all accept instruction, knows this how display element and content.Campus energy-conservation platform homepage mainly comprises following navigation module: transformer substation foundation data module, electricity consumption enquiry module, data analysis module, real-time monitoring module, device control module, priority assignation module and Reports module.Utilize XAMPP software package to install APACHE server, zendstudio software programming PHP code, produces the dynamic web page that user browses.Website needs with PHP design and operation status surveillance figure, the running status picture of other needs display that this running state monitoring figure is divided into main wiring diagram (total picture, split screen), load chart, wave form analysis figure and user to propose.
The concrete enforcement of this patent of invention mainly needs a PC, and APACHE server, MYSQL database, PHP, and HTML+CSS (static page design) and related software thereof.
Claims (3)
1., based on an implementation method for the energy-conservation platform in campus of PHP and MYSQL, it is characterized in that, comprise the following steps:
Step 1, creating MySQL database for storing electrical energy parameter website, campus interaction data, in the Mei Dong building in campus, intelligent electric meter being installed and reading power information, utilizing data acquisition unit and terminal by related data transmission in MySQL database;
Step 2, design PHP program interface:
Realize user's login interface, different users arranges different data and checks authority, plans page layout by CascadingStyleSheets, makes any browser all accept instruction, knows this how display element and content;
Step 3, between server and PC, adopt B/S framework, the browser be positioned on PC sends request to server, for PHP routine call, server returns to browser the result of PHP program with html format, PHP routine package is contained on Web server, MYSQL database then operates on database server, is undertaken alternately between the PHP program of database server and Web server by a series of MYSQL function.
2. the implementation method of the energy-conservation platform in a kind of campus based on PHP and MYSQL as claimed in claim 1, it is characterized in that, described MySQL database comprises basic information database, energy consumption data storehouse, distribution substation management database, then newdata table in these databases, comprises user message table, energy-saving mechanism admin table, architecture information table, facility information table, energy data table, distribution substation data Real-Time Monitoring table and failure logging table.
3. the implementation method of the energy-conservation platform in a kind of campus based on PHP and MYSQL as claimed in claim 1, it is characterized in that, in described step 2, webpage comprises following navigation module: transformer substation foundation data module, electricity consumption enquiry module, data analysis module, real-time monitoring module, device control module, priority assignation module and Reports module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510726690.3A CN105405064A (en) | 2015-10-30 | 2015-10-30 | PHP- and MYSQL-based campus energy-saving platform implementation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510726690.3A CN105405064A (en) | 2015-10-30 | 2015-10-30 | PHP- and MYSQL-based campus energy-saving platform implementation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105405064A true CN105405064A (en) | 2016-03-16 |
Family
ID=55470533
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510726690.3A Pending CN105405064A (en) | 2015-10-30 | 2015-10-30 | PHP- and MYSQL-based campus energy-saving platform implementation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105405064A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109557821A (en) * | 2018-11-23 | 2019-04-02 | 陕西师范大学 | A kind of energy efficiency supervision plateform system |
| CN115984056A (en) * | 2023-01-10 | 2023-04-18 | 成都卡德智能科技有限公司 | Method and system for energy-saving management of smart campus |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102509162A (en) * | 2011-11-18 | 2012-06-20 | 深圳市科陆电子科技股份有限公司 | Intelligent resident electricity utilization management method and management system |
| US20130067253A1 (en) * | 2010-05-25 | 2013-03-14 | Mitsubishi Electric Corporation | Electric power information management apparatus, electric power information management system, and electric power information management method |
| CN103679476A (en) * | 2013-12-03 | 2014-03-26 | 大连大学 | Intelligent campus electronic commerce system based on WAMP framework and use method thereof |
-
2015
- 2015-10-30 CN CN201510726690.3A patent/CN105405064A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130067253A1 (en) * | 2010-05-25 | 2013-03-14 | Mitsubishi Electric Corporation | Electric power information management apparatus, electric power information management system, and electric power information management method |
| CN102509162A (en) * | 2011-11-18 | 2012-06-20 | 深圳市科陆电子科技股份有限公司 | Intelligent resident electricity utilization management method and management system |
| CN103679476A (en) * | 2013-12-03 | 2014-03-26 | 大连大学 | Intelligent campus electronic commerce system based on WAMP framework and use method thereof |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109557821A (en) * | 2018-11-23 | 2019-04-02 | 陕西师范大学 | A kind of energy efficiency supervision plateform system |
| CN115984056A (en) * | 2023-01-10 | 2023-04-18 | 成都卡德智能科技有限公司 | Method and system for energy-saving management of smart campus |
| CN115984056B (en) * | 2023-01-10 | 2023-08-29 | 成都卡德智能科技有限公司 | Intelligent campus energy-saving management method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105574652A (en) | Planning big data management and control system of smart power distribution network and method | |
| CN102969796B (en) | Near-real-time electric quantity monitoring and dispatching management system for rural power grid | |
| CN101996271B (en) | Software interface for automatically generating simulation calculation model of PSCAD power system | |
| CN1680817A (en) | Metering and charging system of electric energy amount | |
| CN102562451B (en) | System and method for real-time monitoring of ten-million-kilowatt large wind farm | |
| CN105469188A (en) | Distribution network planning data online intelligent analysis system and distribution network planning data online intelligent analysis method | |
| CN107590749A (en) | A kind of processing method and system with electricity consumption data | |
| CN109783556A (en) | Power quality controlling equipment on-line monitoring system and construction method based on Hadoop and SSM framework | |
| CN112434924B (en) | Risk inspection monitoring platform based on cloud platform under full-electric-network multi-source data | |
| CN103914500B (en) | A kind of online methods of exhibiting of configuration based on time series data | |
| CN103489139A (en) | Comprehensive analysis and management system for urban distribution network planning | |
| CN102509198A (en) | Method and system for monitoring low-voltage power grid equipment | |
| CN106055629A (en) | Single well information management system | |
| CN110599124A (en) | Integration-oriented engineering data center | |
| CN110119272A (en) | A kind of human-machine interface configuration design method and device | |
| CN105405064A (en) | PHP- and MYSQL-based campus energy-saving platform implementation method | |
| CN104299170B (en) | Intermittent energy source mass data processing method | |
| CN105653523A (en) | Energy consumption supervise network of things basis platform system building method | |
| CN205176932U (en) | Data collection and transmission system for intelligence measurement platform | |
| Duan et al. | Intelligent Monitoring System of Electronic Equipment Based on Wireless Sensor | |
| CN202611992U (en) | Real-time monitoring system for ten-million-kilowatt large wind farm | |
| Dongjiang et al. | Design and implementation of water well monitoring system based on GPRS | |
| Zhao et al. | Development and Application of Real-Time Monitoring System for Energy Consumption and Carbon Emission in Construction Group Based on Internet of Things | |
| Wang et al. | Architecture of Distribution Network Operation Analysis System Based on Mobile Information Extraction Method | |
| Zhu et al. | Research on the management and control information system and function design of overhead transmission line construction based on B/S architecture |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160316 |