想要将上传的csv文件插入数据库.它说“未选择数据库"，我错过了什么? [英] want to insert uploaded csv file into database. it says 'no database selected' what did i miss?

问题描述

<?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>";
    }

?>

推荐答案

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

应该在建立连接后立即运行

That should be run soon after the connection has been made

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

Though note the big red box on the page, You should look at upgrading to Mysqli or PDO.

这篇关于想要将上传的csv文件插入数据库.它说“未选择数据库"，我错过了什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！