home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
linuxmafia.com 2016
/
linuxmafia.com.tar
/
linuxmafia.com
/
bale
/
baleeventimport.php
< prev
next >
Wrap
Text File
|
2002-09-24
|
1KB
|
65 lines
<html>
<body>
<?php
/* $Id: ldi_table.php3,v 1.5 1999/04/04 10:30:53 tobias Exp $ */
$db = mysql_connect('localhost', 'root', 'meep');
mysql_select_db('events');
// echo $DOCUMENT_ROOT;
$fname = $DOCUMENT_ROOT . "/" . "eventimport.txt";
// $fp = fopen($fname , "r");
$lines = file($fname);
$n = count($lines);
echo "$n records to add<br>";
for ($i = 0; $i < $n; $i++)
{
$str = $lines[$i];
$fields = explode("|", $str);
$j = $i + 100;
if (strstr($fields[3],"999"))
{
$eventinfo = explode("-", $fields[3]);
$query = "select gnamefrom groups where groupid = 999";
$res = @mysql_query($query);
$groupinfo[0] = @mysql_fetch_row($res);
$groupinfo[1] = $eventinfo[1];
$groupinfo[2] = $eventinfo[2];
echo "$groupinfo[0] $groupinfo[1] $groupinfo[2]<br>";
$fields[3] = "999";
}
else
{
$query = "select gname, gcity, gcounty from groups where groupid = $fields[3]";
$res = @mysql_query($query);
$groupinfo = @mysql_fetch_row($res);
}
$query = "insert into events (eventid, edate, starttime, endtime, egroup, description, ename, ecity, ecounty) values ($j, '$fields[0]', '$fields[1]', '$fields[2]', '$fields[3]', '$fields[4]', '$groupinfo[0]', '$groupinfo[1]', '$groupinfo[2]')";
echo "$query<br><br>";
$res = mysql_query($query);
if ($res == TRUE)
{
echo "event for $fields[0] added successfully!<br>";
}
}
// fclose($fp);
mysql_close();
?>
</body>
</html>