Loading A Table From An Uploaded .csv File
<?php
include_once('config.php');
//----- CONNECT TO DATABASE -----
mysql_connect("localhost", $songs_db_username, $songs_db_password, $songs_db_name) or die("cannot connect");
mysql_select_db($songs_db_name) or die(mysql_error()); //Select the database so it doesn't need to be specified in mysql functions
if ( (isset($_POST['action'])) && ($_POST['action'] == "uploading_all_songs_file") )
{
//----------------------------------------
//----- UPLOADING NEW ALL SONGS FILE -----
//----------------------------------------
if ($_FILES[csv][size] > 0)
{
//get the csv file
$file = $_FILES[csv][tmp_name];
$handle = fopen($file,"r");
//Delete the existing records in table
$result = @mysql_query("TRUNCATE TABLE all_songs");
//Loop through the csv file and insert into database
do {
if ($data[0])
{
$track_name_search_by = trim(@mysql_real_escape_string($data[0]));
if (strlen($track_name_search_by) > 254)
$track_name_search_by = substr($track_name_search_by, 0, 254);
$track_name = trim(@mysql_real_escape_string($data[1]));
if (strlen($track_name) > 254)
$track_name = substr($track_name, 0, 254);
$artist = trim(@mysql_real_escape_string($data[2]));
if (strlen($artist) > 254)
$artist = substr($artist, 0, 254);
mysql_query("INSERT INTO all_songs (track_name_search_by, track_name, artist) VALUES
(
'".addslashes($track_name_search_by)."',
'".addslashes($track_name)."',
'".addslashes($artist)."'
)
");
}
} while ($data = fgetcsv($handle,1000,",","'"));
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Upload Page</title>
</head>
<body>
<div style="padding-top: 20px;"></div>
<h2>Upload New all_songs.csv File</h2>
<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
Choose your file: <br />
<input name="csv" type="file" id="csv" />
<input name="action" type="hidden" value="uploading_all_songs_file" />
<input type="submit" name="Submit" value="Submit" />
</form>
<div style="padding-top: 20px;"></div>
<h2>All Songs</h2>
<?php
$randomiser_counter = 0;
$query1 = @mysql_query("SELECT * FROM all_songs ORDER BY track_name_search_by ASC");
echo 'Total Number Of All Song Results: ' . mysql_num_rows($query1);
if (@mysql_num_rows($query1) == 0)
{
echo "<div style=\"text-align: center;margin-top: 30px;margin-bottom: 30px;\">";
echo "<p>None found</p>";
echo "</div>";
}
else
{
while ($result1 = @mysql_fetch_array($query1))
{
?>
<div>
<?php echo $result1['track_name'] . ' by ';?>
<?php echo $result1['artist'];?><br />
</div>
<?php
}
}
?>
</body>
</html>
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.