使用Actionscript3连接到数据库-UsingActionscript3toconnecttoadatabase

4  

Unless you're running your Actionscript on the server side (I doubt that), connecting to a database directly wouldn't be very smart at all. To connect to a database from client side Actionscript you'd have to open your server to accept database connections from everyone, and you'd have to store access data in your swf files and that would be a disastrous combination in case someone disassembles the swf files.

除非你在服务器端运行你的Actionscript(我怀疑),直接连接到数据库根本不会很聪明。要从客户端Actionscript连接到数据库,您必须打开服务器以接受来自每个人的数据库连接,并且您必须将访问数据存储在swf文件中,如果有人拆解swf,这将是一个灾难性的组合文件。

If the size of the XML is prohibitive, you can always split it somehow, or if it is impossible, you can get the data from the server through PHP or anything else running on the server, for example, you'd give the relevant parameters in the request to the PHP file and the server side script then queries the database, builds XML text (that is a subset of the complete data, based on the given parameters) that can be consumed by the Actionscript.

如果XML的大小过高,您总是可以以某种方式拆分它,或者如果不可能,您可以通过PHP或服务器上运行的任何其他东西从服务器获取数据,例如,您将提供相关参数在对PHP文件和服务器端脚本的请求中,然后查询数据库,构建可以由Actionscript使用的XML文本(基于给定参数的完整数据的子集)。

6  

If you plan to deploy your flash content to a website, you should use some sort of backend - otherwise you would have a potential security problem. I use remoting with AMFPHP, it has worked out really well.

如果您计划将Flash内容部署到网站,则应使用某种后端 - 否则您可能会遇到潜在的安全问题。我使用AMFPHP进行远程处理,效果非常好。

1  

Use a server-side language like PHP w/MySQL to write a text file or XML file that Flash can understand. in turn, when sending variables use ActionScript to send the variables to a PHP form parser that loads it to the server.

使用PHP w / MySQL等服务器端语言编写Flash可以理解的文本文件或XML文件。反过来,当发送变量时,使用ActionScript将变量发送到PHP表单解析器,将其加载到服务器。

I don't have any examples to show you right now, but that would certainly be a workaround to getting FlashCon or some other product, and you can get started right away. Check out some XML and PHP code sites -- you'll probably run into someone who has already solved your problem.

我现在没有任何示例向您展示,但这肯定是获取FlashCon或其他产品的一种解决方法,您可以立即开始使用。查看一些XML和PHP代码站点 - 您可能遇到已经解决了问题的人。

0  

The general practice that I've experienced is that if it's something like a config file or just a really small amount of data then you could probably get away with just having an XML file on the server with your SWF files.

我经历的一般做法是,如果它类似于配置文件或只是非常少量的数据,那么您可能只需在服务器上使用SWF文件获得XML文件即可。

If you want the data to be more dynamic or you anticipate changing it quite often I would definitely do as Nouveau has already said and use PHP or a similiar technology to output database queries into an XML structure for your flash to load.

如果您希望数据更加动态,或者您希望经常更改它,我肯定会这样做,因为Nouveau已经说过并使用PHP或类似技术将数据库查询输出到XML结构中以便加载闪存。

If there is a lot of data however and you are really noticing your program choking or lagging on loading up the XML in that format I would definitely recommend remoting like Kristian has suggested, AMFPHP seems to be one of the more popular choices.

如果有很多数据然而你真的注意到你的程序在以这种格式加载XML时会窒息或滞后我肯定会建议像Kristian建议的那样进行远程处理,AMFPHP似乎是更受欢迎的选择之一。

Check out grapefrukt's answer to another question about flash and database interaction
Does Adobe Flash support databases?

查看grapefrukt对另一个关于flash和数据库交互的问题的回答Adobe Flash是否支持数据库?

0  

just in case someone doesn't know the guys at midnightcoders have also a robust way for remoting in flash

以防万一有人不知道midnightcoders中的人也有一个强大的方法来进行远程处理

0  

you can also use swx format wich is an interesting project to send/receive data using swf's wrapers, i personally prefer amfphp but i just commented here for reference purposes

你也可以使用swx格式,这是一个有趣的项目,使用swf的包装发送/接收数据,我个人更喜欢amfphp但我只是在这里评论以供参考

0  

Don't use client side Actionscript to connect directly to the database, unless you're comfortable with the idea of exposing your connection string to anyone.

不要使用客户端Actionscript直接连接到数据库,除非您对将连接字符串暴露给任何人的想法感到满意。

Use some server side logic to connect to the database instead.

使用某些服务器端逻辑来连接到数据库。