Telefoon Boek (Voorbeeld tbv PHP+SQLite)

Een erg simpel telefoonboek script. Maar geimplementeerd met een erg modern en up-to-date technologie: SQLite, de SQL database zonder server.

Mijn telefoonnummers

	Achternaam	Voornaam	Telefoonnummer	Opdracht

Voeg entry toe

SOURCE CODE

<html>
<head>
<title>XAMPP phonebook</title>
<link href="xampp.css" rel="stylesheet" type="text/css">
</head>

<?=$TEXT['phonebook-text1']?><p>
<?=$TEXT['phonebook-text2']?><p>

//    Copyright (C) 2003 Kai Seidler, oswald@apachefriends.org
//
//    This program is free software; you can redistribute it and/or modify
//    it under the terms of the GNU General Public License as published by
//    the Free Software Foundation; either version 2 of the License, or
//    (at your option) any later version.
//
//    This program is distributed in the hope that it will be useful,
//    but WITHOUT ANY WARRANTY; without even the implied warranty of
//    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//    GNU General Public License for more details.
//
//    You should have received a copy of the GNU General Public License
//    along with this program; if not, write to the Free Software
//    Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

if(!($db=sqlite_open('sqlite/phonebook', '0666')))
	{
		echo "<h2>".$TEXT['phonebook-error']."</h2>";
		die();
	}
?>

<?
	if($firstname!="")
	{
		sqlite_query($db,"INSERT INTO users (firstname,lastname,phone) VALUES('$firstname','$lastname','$phone')");
	}

if($action=="del")
	{
		sqlite_query($db,"DELETE FROM users WHERE id=$id;");
	}

$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 background='img/strichel.gif' colspan=6><img src=img/blank.gif width=1 height=1></td>";
			echo "</tr>";
		}
		echo "<tr valign=center>";
		echo "<td class=tabval><img src=img/blank.gif 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></td>";
		echo "</tr>";
		$i++;

}

echo "<tr valign=bottom>";
        echo "<td bgcolor=#fb7922 colspan=6><img src=img/blank.gif width=1 height=8></td>";
        echo "</tr>";

sqlite_close($db);

</table>

<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>
<p>
<? if ($source=="in")
		{ include("code.php"); $beispiel = $SCRIPT_FILENAME; pagecode($beispiel);} 
		else
		{ print("<p><br><br><h2><U><a href="$PHP_SELF?source=in">".$TEXT['srccode-in']."</a></U></h2>");} ?> 
</body>
</html>

Achternaam:
Voornaam:
Telefoonnummer: