首页 > 解决方案 > 通过c#表单使用php脚本插入数据库

问题描述

我正在尝试通过C#from 但使用php位于服务器上并包含查询的脚本在数据库中添加项目。是这样的:

<?php
include_once("databaseconn.php");

$sActionID="";
if(isset($_POST['action_id']))
{
    $sActionID=$_POST['action_id'];
}

switch ($sActionID) 
{
    case 'add_item':
        $sQuery = "INSERT INTO Table (id, first_name, last_name) VALUES (:id, :first_name, :last_name)";
        $oData = array(
         'id' => $_POST['id'],
         'first_name' => $_POST['first_name'],
         'last_name' => $_POST['last_name']
        );
        try
        {
            $oStatement=$oDbConnector->prepare($sQuery);
            $oStatement->execute($oData);
        }
        catch(PDOException $error)
        {
            echo $error;
            echo 0;
        }       
    break;
}
?>

这是我通过以下方式直接插入数据库C#

public void AddItem(Item item)
{
    using (DbConnection oConnection = new SqlConnection(connectionString)) using (DbCommand oCommand = oConnection.CreateCommand())
    {
        oCommand.CommandText = "INSERT INTO Table (id, first_name, last_name) VALUES('" + item.id + "', '" + item.first_name + "', '" + item.last_name + "')";
        oConnection.Open();
        using (DbDataReader oReader = oCommand.ExecuteReader())
        {

        }
    }
}

C#有没有办法与之交流script

标签: c#php

解决方案


推荐阅读