Question

我将如何利用PHP代码,把一个信息输入一个笼罩上的数据库? 我需要实践利用Sphp来进行数据库电话,但目前,我都能查阅这一卷宗。

Answer 1

仅通过phpmyadmin:

Answer 2

Design Considerations: You probably don t want to load the entire file into memory at once using a function like file_get_contents. With large files this will eat up all of your available memory and cause problems. Instead do like Adam suggested, and read one line at a time.

fgetcsv at php Manual

//Here s how you would start your database connection
mysql_connect($serverName, $username, $password);
mysql_select_db( yourDBName );

//open the file as read-only
$file = fopen("file.csv", "r");

// lineLength is unlimited when set to 0
// comma delimited
while($data = fgetcsv($file, $lineLength = 0, $delimiter = ",")) {
   //You should sanitize your inputs first, using a function like addslashes
   $success = mysql_query("INSERT INTO fileTable VALUES(".$data[0].",".$data[1].")");
   if(!$success) {
     throw new Exception( failed to insert! );
   }
}

Answer 3

利用现成的房贷功能读作特别志愿人员,并撰写一份产出文件。然后,你可以把这套材料输入你的数据库。这应当与任何类型的数据库合作。

不要忘记你正在使用的任何扼杀。在这方面,我利用了诉讼地——替罪羊。

$fd = fopen("mydata.csv", "r");
$fdout = fopen("importscript.sql","w");

while(!feof($fd))
{
    $line = fgetcsv($fd, 1024); // Read a line of CSV

    fwrite($fdout, INSERT INTO mytable (id,name) 
                 . VALUES ( .intval($line[0]).", ".sqlite_escape_string($line[1])." );
";
}

fclose($fdout);
fclose($fd);

友情链接