I'm trying to get data from a SharePoint list from my PHP website, which contains a MySQL database. The list contains data which can be stored in the MySQL database.
我正在尝试从我的PHP网站获取SharePoint列表中的数据，该网站包含一个MySQL数据库。该列表包含可以存储在MySQL数据库中的数据。
Here are 2 solutions I thought of, but I'm also unsure of their possibility:
以下是我想到的两种解决方案，但我也不确定它们的可能性：
-
Using a webservice to reach the SharePoint list from PHP.
使用Web服务从PHP访问SharePoint列表。
-
Connecting PHP's MySQL database with SharePoint's list so that they communicate with one another. But I don't know how to go about doing this solution.
将PHP的MySQL数据库与SharePoint的列表连接起来，以便它们相互通信。但我不知道如何去做这个解决方案。
Does anyone know how to improve on the above mentioned solutions? Or provide any alternatives?
有谁知道如何改进上述解决方案？或提供任何替代方案？
1 个解决方案
#1
0
Look into the Business Connectivity Service. It allows you to configure a database table as an external list. To the user's they will be working with a SharePoint list but behind the scenes, the list is actually a representation of the database table with direct crud functionality.
查看Business Connectivity Service。它允许您将数据库表配置为外部列表。对于用户来说，他们将使用SharePoint列表，但在幕后，该列表实际上是具有直接crud功能的数据库表的表示。
#1
0
Look into the Business Connectivity Service. It allows you to configure a database table as an external list. To the user's they will be working with a SharePoint list but behind the scenes, the list is actually a representation of the database table with direct crud functionality.
查看Business Connectivity Service。它允许您将数据库表配置为外部列表。对于用户来说，他们将使用SharePoint列表，但在幕后，该列表实际上是具有直接crud功能的数据库表的表示。