\n";
$db->query($sql);
$db->next_record();
if($db->num_rows()==1)
{
if($insert || $nostatus)
{
reset($updatename);
$sql="update general SET ";
$sql="$sql ". key($updatename). "=". current($updatename);
unset($updatename[key($updatename)]);
unset($insertname[key($updatename)]);
next($updatename);
while(list($key,$val)=each($updatename))
{
$sql="$sql, $key=$val";
unset($updatename[$key]);
unset($insertname[$key]);
}
$sql="$sql where id='".$db->f("id")."'";
# print "sql=$sql
\n";
$db->query($sql);
} else
{
$sql="delete from general where id='".$db->f("id")."'";
print "Deleted Entry ".$db->f("last_name").", ".$db->f("first_name")." ".$db->f("middle_initial")."
\n";
$db->query($sql);
$deleteTotal++;
}
} elseif($insert || $nostatus) {
reset($insertname);
$sql="insert into general (" . key($insertname);
$num_elements=count($insertname);
for($i=1;$i<$num_elements;$i++)
{
next($insertname);
$sql="$sql, ". key($insertname);
}
reset($insertname);
print "Inserted Entry $insertname[last_name], $insertname[first_name] $insertname[middle_initial]
\n";
$sql="$sql) values(". current($insertname);
unset($insertname[key($insertname)]);
unset($updatename[key($insertname)]);
for($i=1;$i<$num_elements;$i++)
{
$sql="$sql, ". next($insertname);
unset($insertname[key($insertname)]);
unset($updatename[key($insertname)]);
}
$sql="$sql)";
$db->query($sql);
$insertTotal++;
}
}
}
fclose($file);
print "Total Inserted : $insertTotal
\n";
print "Total Deleted : $deleteTotal
\n";
}
function upload_dialog()
{
print "
";
print "";
print "";
}
function excel2txt($file,$file_name)
{
global $DOCUMENT_ROOT, $PHP_SELF;
$dest = "$DOCUMENT_ROOT/".dirname($PHP_SELF)."/uploads/directory.txt";
if(file_exists("$dest"))
{
unlink($dest);
}
if(eregi(".xls$",$file_name))
{
exec("xlHtml -fw -asc -dp $file",$AllOutput,$ReturnValue);
if(eregi("Page:(.*) Name:(.*) MaxRow:(.*) MaxCol:(.*)",$AllOutput[1],$regs))
{
exec("xlHtml -fw -asc -xp:0 -xr:0-$regs[3] -xc:0-$regs[4] $file >$dest");
} else {
print "Invalid Excel File";
exit;
}
} elseif(eregi(".txt$",$file_name))
{
if(@exec("cp $file $dest")!=0)
{
echo "Unable to create $dest - check permissions
\n";
exit;
}
} else {
print "Invalid File
\n";
}
unlink($file);
}
function export()
{
$db = new DB_Phonebook;
$metadata=$db->metadata("general",1);
$num_fields=$metadata["num_fields"];
print "Select the fields you wish to export\n";
print "\n";
}
if($mode=="New")
{
if($option=="Create")
{
update('insert');
print "Created Successfully\n";
}
admin(0,"New");
} elseif($mode=="Edit")
{
if($option=="Delete")
{
delete($id);
unset($offset);
unset($id);
print "Deleted Successfully$id
\n";
} elseif($option=="Update")
{
update('update');
print "Updated Successfully
\n";
}
if(!isset($offset))
{
$offset=0;
}
if(isset($id))
{
searchBar($SearchBy,$SearchByValue,$offset);
} else {
$id=searchBar($SearchBy,$SearchByValue,$offset);
}
if($id==0)
{
print "
Nothing Found\n";
} else {
admin($id,"Edit");
}
} elseif($mode=="Import")
{
if($option=="Next")
{
excel2txt($file,$file_name);
parse_import();
} elseif($option=="Finish")
{
import_data($fields,$insertonly);
} elseif($option=="Cancel")
{
?>