Get MySQL data from the Web through Access_PHP Tutorial

MySQL is currently the most popular network database, and the reasons include:
It runs fast
It’s free
It runs on Linux and some other platforms
It works with Apache (a popular network server) Perfect combination
Can be perfectly combined with PHP
MySQL has an ODBC interface. If you are operating a web server or MySQL server and want to connect data to a desktop application, using the ODBC interface is a good way to do it. But if you are not operating on the server, the port accessing MySQL is likely to be invalid. At this time, you can only find other methods to operate your data.
Existing problems
The problems mentioned are all for the client. For security reasons, client programs generally select network representatives through a host, thereby avoiding frequent logins to their own systems on the network. Many hosts offer the right conditions and MySQL, scalable FrontPage, CGI and other site creation tools. They can also meet the matching problem of hardware and software. This unique host even provides tools to help you add or delete your MySQL database, but it only does so in the basic MySQL repository format, which cannot be read directly into Access or other desktop programs.
The client program does not want to install MySQL on the server machine in its own unit. It can pass data through my program, as long as MySQL is run on my machine. I can manually fetch the data from the host repository. This process involves loading the data into the database, transferring it to Access via ODBC, and then sending the database contents to the client. I don't mind the work being done, but we should simplify some of the unnecessary work and not rely too much on manual operations.
Let me explain the above process again. First, the host displays the data storage location on the web page. I obtained the database data through simple code and registration. The reason for registration is for security reasons. Now, I use Microsoft's web browser ActiveX control to directly operate the Access database, which allows users to easily go through the registration process, click a button to obtain MySQL data, and then pass the data to the corresponding table in the Access database. As long as the data is in an Access database, users can use ODBC or their preferred method to transfer the data to an ERP system or other specialized system.
Microsoft Access Database
Access database is quite simple. It consists of some data tables that list the data you want to add. In this section, the data table I use is called Sales_Data, which is composed of car purchase data on a virtual website. Similarly, this data table should be exactly the same as the MySQL data table on the host, both in name and structure. In fact, we first need to generate a data table in Access (Figure A), and then transfer the data to MySQL on the local server through ODBC.
Figure A

When the Access application is opened, the web control panel form is also opened. In my routine, the program is registered on my server via PHP.

http://www.bkjia.com/PHPjc/631136.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631136.htmlTechArticleMySQL is currently the most popular network database. The reasons include: It runs fast, is free, and can run on Linux and others. Some platforms work perfectly with Apache, a popular web server...