Fauxzen.com | Tag Archive

I recently was hit with an issue where I had to import about 500 employees into a database and having each one added to multiple departments. With the use of an array I was able to write up some pretty simple code to import a CSV file that simply contained “username, realname” into the database. Thought I would post it in case anyone ever needed to do something along these lines.

&lt;?php
include('../config.php');
$departments = array(&quot;department1&quot;, &quot;department2&quot;, &quot;department3&quot;, &quot;department4&quot;);
mysql_connect(&quot;$dbhost&quot;, &quot;$dbuser&quot;, &quot;$dbpass&quot;) or die(mysql_error());
mysql_select_db(&quot;$dbase&quot;) or die(mysql_error());
$handle = fopen(&quot;employees.csv&quot;, &quot;r&quot;);
while (($data = fgetcsv($handle, 5000, &quot;,&quot;)) !== FALSE) {
    foreach ($departments as &amp;$value) {
        $query = &quot;INSERT INTO employees (`id`, `name`, `realname`, `tickets`, `dept`) VALUES (NULL, '$data[0]', '$data[1]', '0', '$value')&quot;;
        $result = mysql_query($query) or die(mysql_error());
        echo $data[1] . ' successfully added to ' . $value . ' department&lt;br&gt;';
    }
}
unset($value);
?&gt;

<?php

include('../config.php');

$departments = array("department1", "department2", "department3", "department4");

mysql_connect("$dbhost", "$dbuser", "$dbpass") or die(mysql_error());

mysql_select_db("$dbase") or die(mysql_error());

$handle = fopen("employees.csv", "r");

while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {

foreach ($departments as &$value) {

$query = "INSERT INTO employees (`id`, `name`, `realname`, `tickets`, `dept`) VALUES (NULL, '$data[0]', '$data[1]', '0', '$value')";

$result = mysql_query($query) or die(mysql_error());

echo $data[1] . ' successfully added to ' . $value . ' department<br>';

}

unset($value);

Archives For php

APC on a WHM/CPanel Server

Adding users from a CSV file to a MySQL database

Minify WordPress Plugin