<?php include("langsettings.php");?>
<html>
<head>
<link href="phonebook.css" rel="stylesheet" type="text/css">
<title><?=$TEXT['phonebook-title']?></title>
</head>
<body>
<?php include("langselect.php");?>
<h1><?=$TEXT['phonebook-head']?></h1>
<p><?=$TEXT['phonebook-text1']?></p>
<?php
if (!($db=sqlite_open('db/phonebook', '0666'))){
echo "<h2>".$TEXT['phonebook-error']."</h2>";
die();
}
?>
<h2><?php echo $TEXT['phonebook-head1']; ?></h2>
<table border="0" cellpadding="0" cellspacing="0">
<tr bgcolor="#f87820">
<td><img src="img/blank.gif" alt="" width="10" height="25"></td>
<td class="tabhead"><img src="img/blank.gif" alt="" width="150" height="6"><br><b><?php echo $TEXT['phonebook-attrib1']; ?></b></td>
<td class="tabhead"><img src="img/blank.gif" alt="" width="150" height="6"><br><b><?php echo $TEXT['phonebook-attrib2']; ?></b></td>
<td class="tabhead"><img src="img/blank.gif" alt="" width="150" height="6"><br><b><?php echo $TEXT['phonebook-attrib3']; ?></b></td>
<td class="tabhead"><img src="img/blank.gif" alt="" width="50" height="6"><br><b><?php echo $TEXT['phonebook-attrib4']; ?></b></td>
<td><img src="img/blank.gif" alt="" width="10" height="25"></td>
</tr>
<?php
$firstname=$_REQUEST['firstname'];
$lastname=$_REQUEST['lastname'];
$phone=$_REQUEST['phone'];
if($firstname!="")
{
sqlite_query($db,"INSERT INTO users (firstname,lastname,phone) VALUES('$firstname','$lastname','$phone')");
echo "<script language='javascript'>location.href='phonebook.php'</script>";
}
if($_REQUEST['action']=="del")
{
sqlite_query($db,"DELETE FROM users WHERE id={$_REQUEST['id']};");
echo "<script language='javascript'>location.href='phonebook.php'</script>";
}
$result=sqlite_query($db,"SELECT id,firstname,lastname,phone FROM users ORDER BY lastname;");
$i = 0;
while($row=sqlite_fetch_array($result)){
if ($i > 0) {
echo "<tr valign='bottom'>";
echo "<td bgcolor='#ffffff' height='1' style='background-image:url(img/strichel.gif)' colspan='6'></td>";
echo "</tr>";
}
echo "<tr valign='middle'>";
echo "<td class='tabval'><img src='img/blank.gif' alt='' width='10' height='20'></td>";
echo "<td class='tabval'><b>".$row['lastname']."</b></td>";
echo "<td class='tabval'>".$row['firstname']."</td>";
echo "<td class='tabval'>".$row['phone']."</td>";
echo "<td class='tabval'><a onclick=\"return confirm('".$TEXT['phonebook-sure']."');\" href='phonebook.php?action=del&id=".$row['id']."'><span class='red'>[".$TEXT['phonebook-button1']."]</span></a></td>";
echo "<td class='tabval'><img src='img/blank.gif' alt='' width='10' height='20'></td>";
echo "</tr>";
$i++;
}
echo "<tr valign='bottom'>";
echo "<td bgcolor='#fb7922' colspan='6'><img src='img/blank.gif' alt='' width='1' height='8'></td>";
echo "</tr>";
sqlite_close($db);
?>
</table>
<h2><?=$TEXT['phonebook-head2']?></h2>
<form action="phonebook.php" method="get">
<table border="0" cellpadding="0" cellspacing="0">
<tr><td><?=$TEXT['phonebook-attrib1']?>:</td><td><input type="text" size="20" name="lastname"></td></tr>
<tr><td><?=$TEXT['phonebook-attrib2']?>:</td><td><input type="text" size="20" name="firstname"></td></tr>
<tr><td><?=$TEXT['phonebook-attrib3']?>:</td><td><input type="text" size="20" name="phone"></td></tr>
<tr><td></td><td><input type="submit" border="0" value="<?=$TEXT['phonebook-button2']?>"></td></tr>
</table>
</form>
<?php include("showcode.php"); ?>
</body>
</html>
phonebook.rar （12个子文件） 
phonebook 
showcode.php 378B phonebook.css 1KB db phonebook 3KB langselect.php 376B langsettings.php 234B img 
blank.gif 43B strichel.gif 61B lang.tmp 2B phonebook.php 4KB lang languages.php 76B zh.php 1KB en.php 1KB资源评论
lxinddd2015-10-12比较乱，看不懂，建议不要下载
