作者:捕鱼达人2602890295 | 来源:互联网 | 2023-05-18 17:54
ihaveaprojectmadeinflex,usingphpdataservicestoaccessasqlserverdatabase,andineedt
i have a project made in flex, using php data services to access a sql server database, and i need to convert it to mysql, i have changed all my php services from sqlsrv to mysqli.
Something like this:
我有一个flex项目,使用php数据服务访问sql server数据库,我需要将它转换为mysql,我已经将我所有的php服务从sqlsrv更改为mysqli。像这样的东西:
$this->cOnnection= mysqli_connect(SERVER,USERNAME,PASSWORD,DATABASE); // Start Connection
$ssqlstring = "select * from Users";
$runssql = mysqli_query($this->connection, $ssqlstring);
while($user = mysqli_fetch_array($runssql))
{
$users[$user["ID"]] = $user;
}
return $users;
it worked fine on sqlsrv but with mysqli it returns to flex the INT
, BIT
or DATE
values as string
the main Datatypes on mysql are INT
,VARCHAR
,BIT(1)
,DATETIME
,DATE
(same as sqlsrv)
and on the flex the return types are mainly as object[]
它在sqlsrv上工作得很好,但是使用mysqli它返回弹性INT,BIT或DATE值作为字符串mysql上的主数据类型是INT,VARCHAR,BIT(1),DATETIME,DATE(与sqlsrv相同)和flex返回类型主要是作为对象[]
1 个解决方案