The new and old database connection methods of Tongda oa, and oa database connection

The new and old database connection methods of Tongda oa, and oa database connection

Old connection method:

Include_once ("/inc/conn. php ");
$ Cursor = exequery ($ connection, $ query );

New Connection method:

Include_once ("/inc/utility_all.php ");

$ Cursor = exequery (TD: conn (), $ query );

How does Tongda OA access mysql?

When using the Tongda OA system, many users need to use Mysql Web-based management tools to go to the background database to view data and perform relevant operations. However, most users directly access the background database after installing the tool, which is not safe. So how can we securely use this tool to access the database? The following describes several methods.
Method 1: Set the user name and password to log on to the database. The specific settings are as follows:
1. After installing the mysql database management tool, find the configuration file config. inc. php under the \ webroot \ mysql installation directory of the OA and open it with notepad.
2. Find the row $ cfg ['servers'] [$ I] ['auth _ type'] = 'config'; // Authentication method (valid choices: config, http, HTTP, signon or cookie), change it to $ cfg ['servers'] [$ I] ['auth _ type'] = 'http '; // Authentication method (valid choices: config, http, HTTP, signon or cookie) and save it.
3. After modification, the following window is displayed when you log on to the background database. You must enter the user name and password. Otherwise, you cannot log on. Obviously, this method is more secure than direct logon. Note: The default user name is root and the password is mya888.

Although the security of logging on to the database using the username and password method is enhanced a lot, using the default username and password of the database will obviously reduce the security. So how to make it more secure is to change the password of the mysql database. This is the second method to be introduced.
Method 2: Modify the password of the mysql database to make it more secure to access the database. The password change operation method is not described here. For details, refer to this document: Tongda website/OA Knowledge Base /! Bytes
Note:
1. When installing the mysql Web-based database management tool, the default directory name is mysql. To prevent users from using the tool to intrude into the database system, you can set the directory name to a complex one, for example, mysql23 @ 43 avoids directory name speculation.
2. The use of this management tool requires a certain database base. Do not perform dangerous operations. If you need to operate the database, please note that you must back up the database before the operation, to avoid data loss.

How to access Tongda OA Database

Comprehensive Functions, reasonable cost performance, mature products, and a large number of users. However, the development technology of Tongda is obviously outdated, the interface is relatively rough, and the functions are not perfect. It is only suitable for low-end applications. In contrast, yonyou is the only company I have ever seen that can fully utilize the elements of the WINDOWS standard interface. If the OA of other companies is like the background of a website, their interface is more like a piece of software. The skin includes a Blue classic, deep ocean, vista style, and a challenging apple style. It looks gorgeous and charming. From a professional programmer's perspective, UFIDA makes a reasonable use of the WINDOWS list, top, bottom, and right views, so that all operations are concentrated in a window, which makes people feel very good to use. Yongyou's dual process, shock response, and extensive organization are very distinctive. It is also one of the few companies that integrate management ideas into software. His document flow has not changed much with traditional manual methods, there is no difference between receiving and issuing documents. Conference management and usability are incomparable to other OA systems, and WODR, EXCEL, WPS, and Kingsoft workbooks are supported at the same time. It has complete functions and is easy to use. It is also easy to integrate with Ufida's software. The key price is not expensive, and it is consistent with the standards in the same industry.