如何使用phpnjson数据创建公共函数插入mysql?

ghhaqwfi  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(139)
function insert_data($data, $table, $action )
{
    include "connect.php";

    $columnnvalues = json_decode(json_encode($data), true);

    $columns = array ();
    $values = array();
    foreach($columnnvalues as $key=>$col)
    {
        foreach($col as $keyval=>$val)
        {
            array_push($columns, $col);
            array_push($values, $val);
        }
    }

    $sql = "INSERT INTO " .$table. " (" .implode(", ", $columns).") VALUES (".implode(", ", $values). ")";
    echo $sql;
    $stmt = mysqli_prepare($con,$sql);
    if($stmt)
    {
        mysqli_stmt_execute($stmt);
        $result["success"] = true;
    }
    else
    {
        $result["success"] = false;
        $result["error"] = 1;
    }
    echo  json_encode($result);

}

样本数据

$datas = Array ("name"=>"sample", "permanentaddress"=>"add", "contact"=>"aaaa", "status"=>"Active");
insert_data($datas, "customers", "add" )

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题