php - 想要将上传的 csv 文件插入数据库。它说 'no database selected' 我错过了什么？

Question

<?php
    //connection to database
    include("sql/connect2DB.php"); 

    if (isset($_POST['submit'])) {
        if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
            echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "</h1>";
            echo "<h2>Displaying contents:</h2>";
            readfile($_FILES['filename']['tmp_name']);
        }

        //Import uploaded file to Database

        $handle = fopen($_FILES['filename']['tmp_name'], "r");

        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
            $import="INSERT into user(username,password, user_type) values('$data[0]','$data[1]', '$data[2]')";
            mysql_query($import) or die(mysql_error());
        }

        fclose($handle);

        print "Import done";

        //view upload form

    }
    else {
        print "Upload new csv by browsing to file and clicking on Upload<br />\n";
        print "<form enctype='multipart/form-data' action='test.php' method='post'>";
        print "File name to import:<br />\n";
        print "<input size='50' type='file' name='filename'><br />\n";
        print "<input type='submit' name='submit' value='Upload'></form>";
    }

?>

Answer 1

您正在寻找http://uk1.php.net/mysql_select_db

连接建立后应立即运行

尽管注意页面上的大红色框，您应该考虑升级到 Mysqli 或 PDO。