<?php$dbhost = 'localhost';$dbuser = 'root';$dbpass = 'password';$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');$dbname = 'roundcubemail';mysql_select_db($dbname, $conn);echo mysql_errno($conn) . ": " . mysql_error($conn). "\n";///Fin connection$user_id = $_GET['user_id'];$file = $_GET['file'];if($user_id == "" || $file == ""){ echo "You have no user id $user_id<br />OR files";}if($user_id != "" || $file != ""){echo $user_id;echo "<br />$file";$row = 1;$handle = fopen($file, "r");echo "$handle";while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){ echo "<br />"; $row++; $name = $data[0]; $email = $data[1]; echo "<b>Name: </b>" . $name. "\n"; echo "<B>Email:</B> " . $email . "\n"; $query = "INSERT INTO `contacts` ( `contact_id` , `user_id` , `changed` , `del` , `name` , `email` , `firstname` , `surname` , `vcard` ) VALUES ( '', '$user_id', '1985-09-15 00:00:00', '0', '$name', '$email', '', '', '' );"; echo "<br />"; mysql_query($query, $conn); echo mysql_errno($conn) . ": " . mysql_error($conn) . "\n";}fclose($handle);}?>
0: user_id (my emailaddress)file.csvResource id #3Name: Name Name Email: email0:Name: Name Name Email: email0:
0: 1contacts.csvResource id #3Name: Berlin - Michael Email: [email]michael@berlin.de[/email] 0: Name: Dublin - Billy Email: [email]billy@dublin.com[/email] 0: Name: Dublin - William Email: [email]william@dublin.com[/email]