为 Joomla 或 PHP 网站准备 Mysql 数据库
我有一个包含 500 多个房地产列表的 Mysql 数据库，我希望将其加载到一个空的 Joomla 扩展中（这可能适用于任何 PHP 脚本）。
我复制了扩展使用的每个表的结构和约定 - 其想法是导出或简单地删除原始表并用我的表替换它们。
在测试这个概念时，我最终得到了一个完全混乱的结果 - 我的猜测是，在通过 Java 或 PHP 更新其他表之前，某些表需要存储信息。
例如; Client_Info 表必须在 Property_ Info 之前保存。
PHPAdmin 没有向我显示扩展表关系（连接、查询等），我认为它们是通过 Javascript 或 PHP 处理的。
我的问题是我需要执行哪些步骤来填充扩展数据库。
几个月来，扩展提供商一直表示他们将提供此流程。
如果问题太宽泛，我会对一些链接或关键字感到满意，这样我就可以掌握该主题。
I have a Mysql database of 500+ Real Estate Listings which I am looking to load into an empty Joomla Extension (this may apply to any PHP Script).
I have copied the structure and convention of each table the extension uses - with the idea of either exporting or simply deleting the original tables and replacing them with mine.
Upon testing this concept I end up with a complete mess - My guess is that some of the tables need to have information stored in them before updating others either by Java or PHP.
For example; Client_Info table has to be saved before Property_ Info.
PHPAdmin does not show me the extensions table relationships ( joins, queries etc) I presume they are dealt with through Javascript or PHP.
My Question is what steps do I need to perform to populating the extensions Database.
The extension provider has been saying for months that they were going to provide this process.
If the question is too broad I would be satisfied either with some links or keywords so I can get a handle on the topic.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我将如何尝试解决这个问题：
How I would try to solve this:
如果是 joomla 那么肯定是 php。您需要做的是浏览该 joomla 组件的发布过程文件，并查看必须输入哪些内容以及填充哪些表格。然后您将了解创建导入脚本的步骤。
If it's joomla than it's definitely php. What you need to do is get through the posting procedure files of that joomla component and see what must be entered and what tables get filled. And then you'll have steps for creating an import script.