插入数据与数组表 [英] Inserting data into a table with arrays

问题描述

我使用的阵列将数据插入到一个名为tPerson表。如果脚本成功地在它的作用，它会回应：

I am using arrays to insert data into a table named tPerson. If the script succeeded in its role, it would echo:

SQL：
  INSERT INTO tPerson（称呼，名字，姓氏，CompanyID）VALUES（先生，莫里斯，麻雀，4）（夫人玛丽，哈斯利特，2）（MS，吉尔，亨纳，1）

SQL: INSERT INTO tPerson ( Salutation, FirstName, LastName, CompanyID )VALUES ( Mr, Morris, Sparrow, 4 )( Mrs, Mary, Haslett, 2 )( Ms, Gill, Hennesey, 1 )

是成功的。

它不会在它的工作取得成功，并呼应了：

It doesn't succeed in its job and echoes out:

SQL：
  INSERT INTO tPerson（称呼，名字，姓氏，CompanyID）VALUES（先生，莫里斯，麻雀，4）（夫人玛丽，哈斯利特，2）（MS，吉尔，亨纳，1）

SQL: INSERT INTO tPerson ( Salutation, FirstName, LastName, CompanyID )VALUES ( Mr, Morris, Sparrow, 4 )( Mrs, Mary, Haslett, 2 )( Ms, Gill, Hennesey, 1 )

失败。

我的code是如下：

$hostname = "localhost";
$username = "root";
$password = "";

$databaseName = "alphacrm";

$dbConnected = @mysql_connect($hostname, $username, $password);
$dbSelected = @mysql_select_db($databaseName, $dbConnected);

$dbSuccess = true;
if ($dbConnected) {
    if (!$dbSelected) {
        echo "DB connection FAILED<br><br>";
        $dbSuccess = false;
    } else {
        echo "DB connection SUCCESSFUL<br><br>";
    }
} else {
    echo "MySql connection FAILED<br><br>";
}
}

// Execute code ONLY if connections were successful

if ($dbSuccess) {

{ // setup ARRAY of field names

    $personField = array(
        "Salutation" => "Salutation",
        "FirstName" => "FirstName",
        "LastName" => "LastName",
        "CompanyID" => "CompanyID"
    );
}

{ // setup ARRAY of data ROWS

    $personData[0] = array("Mr","Morris","Sparrow","4");
    $personData[1] = array("Mrs","Mary","Haslett","2");
    $personData[2] = array("Ms","Gill","Hennesey","1");

    $numRows = sizeof($personData);
}

{ // SQL statement with ARRAYS

    //Fieldnames part of INSERT statement

    $person_SQLinsert = "INSERT INTO tPerson (
        ".$personField["Salutation"].",
        ".$personField["FirstName"].",
        ".$personField["LastName"].",
        ".$personField["CompanyID"]."
        )";

// VALUES part of INSERT statement

$person_SQLinsert .= "VALUES ";

$indx = 0;
$person_SQLinsert .= "(
    ".$personData[$indx][0].",
    ".$personData[$indx][1].",
    ".$personData[$indx][2].",
    ".$personData[$indx][3]."
    )";

$indx++;
$person_SQLinsert .= "(
    ".$personData[$indx][0].",
    ".$personData[$indx][1].",
    ".$personData[$indx][2].",
    ".$personData[$indx][3]."
    )";

$indx++;
$person_SQLinsert .= "(
    ".$personData[$indx][0].",
    ".$personData[$indx][1].",
    ".$personData[$indx][2].",
    ".$personData[$indx][3]."
    )";

}

{ // Echo and execute the SQL and test for success

    echo "<strong><u>SQL:<br></u></strong>";
    echo $person_SQLinsert."<br><br>";

    if (mysql_query($person_SQLinsert)) {
        echo "was SUCCESSFUL.<br<br>";
    } else {
        echo "FAILED.<br><br>";
    }
}
} // END ($dbSuccess)

?>

所有的帮助都将是AP preciated，因为我很为难，为什么我的脚本不能正常工作。

All help at all will be appreciated as I am quite stumped as to why my script is not working.

推荐答案

就像用于@mysql_query代替本该的mysql_query @mysql_select_db。
还检查了你的mysql连接和数据库连接成功。

Just like that @mysql_select_db used for @mysql_query instead of this mysql_query. Also checked your mysql connection and database connection successful.

您为多行的查询必须在此格式
INSERT INTO表（列1，列2）VALUES（值1，值2），（值1，值）;

Your query for multiple row must be in this format "INSERT INTO Table ( Column1, Column2 ) VALUES( Value1, Value2 ), ( Value1, Value2 );"

打印您的查询，使用此语法检查。

Print your query and check it with this syntax.

这篇关于插入数据与数组表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！