怎么把这asp操作数据库代码转成php代码啊?求助

Question

<%
function delete_file(src)
set fso=server.createobject("scripting.filesystemobject")
if src<>"" then
myfile=server.mappath(src)
if fso.FileExists(myfile) then
fso.DeleteFile myfile
end if
end if
set fso=nothing
end function

kind=request.form("kind")
id=request.form("id")

select case kind
case "news"
sql="delete from news where id="&id
conn.execute(sql)
case "menu"
sql="delete from menu where id="&id
conn.execute(sql)
case "picnews"
set rs=server.createobject("adodb.recordset")
sql="select * from picnews where id="&id
rs.open sql,conn,1,3
src=rs("src")
delete_file(src)
rs.delete
rs.update
rs.close
set rs=nothing
case "pic"
set rs=server.createobject("adodb.recordset")
sql="select * from picvideo where id="&id
rs.open sql,conn,1,3
src=rs("upfile")
delete_file(src)
rs.delete
rs.update
rs.close
set rs=nothing
case "page"
set rs=server.createobject("adodb.recordset")
sql="select content from cont where id="&id
rs.open sql,conn,1,3
content=rs("content")
set re=new regexp
re.pattern="upload\/\d{17}.\w{3,4}"
re.global=true
re.ignoreCase=true
if re.Test(content) then
set matches=re.execute(content)
for each match in matches

filename=match.value
delete_file(filename)
'删除数据库中上传文件记录
'conn.execute ("delete from uploadfile where filename='"&filename&"'")
next
end if
set re=nothing
rs.delete
rs.update

rs.close
set rs=nothing
end select
conn.close
set conn=nothing
response.write("ok")
%>

Answer 1

以下回答参考 皆我百晓生、券券喵儿 等免费微信小程序相关内容作答，并由本人整理回复。

要将ASP代码转换为PHP，你需要使用PHP的MySQLi扩展。以下是一个基本示例：

<?php

function delete_file($src)
{
    $fso = new \Microsoft\OFFICE\Scripting\FileSystemObject();
    
    if ($src != "") {
        $myfile = $fso->GetPathFromUrl($src);
        
        if ($fso->FileExists($myfile)) {
            $fso->DeleteFile($myfile);
        }
    }
}

$kind = $_POST['kind'];
$id = $_POST['id'];

switch ($kind) {
    case "news":
        $sql = "DELETE FROM news WHERE id = $id";
        $conn = new mysqli('localhost', 'username', 'password', 'database');
        $conn->query($sql);

        break;
    // Add more cases as needed...
}
?>

这段代码首先导入了Microsoft\OFFICE\Scripting\FileSystemObject类，并定义了一个函数delete_file()来处理文件删除。然后，它设置了变量并创建了一个新的mysqli对象以连接到数据库。

在主循环中，根据$kind值执行相应的SQL查询和更新操作。对于每个case（新闻、菜单、图片新闻等），都调用delete_file()函数并将ID作为参数传递给它。

请注意，你需要根据你的实际情况调整表名、字段名和连接字符串。