E foi por isso que eu resolvi fazer essa Lista de Endereços.
Nesse código esta incluso o config.php e o css.css que é pra não ficar zuado as tabelas.
Aqui vai ele:
config.php
<?php $host = ''; $banco = ''; $user = ''; $pass = ''; ?>fim do config.php
css.css
body { font-family: Verdana; color: black; font-size: 12px; } tr, td { font-family: Verdana; color: black; font-size: 12px; } a:link { font-family: Verdana; color: black; font-size: 12px; text-decoration: none; } a:hover { font-family: Verdana; color: #4c4c4c; font-size: 12px; text-decoration: none; } a:visited { font-family: Verdana; color: black; font-size: 12px; text-decoration: none; }fim do css.css
mysql.sql
CREATE TABLE lista( ID int primary key auto_increment, nome varchar(100), endereco varchar(255), tel varchar(20), email varchar(100) );fim do mysql.sql
index.php
<html> <head> <title>Lista de Endereços</title> <link href="css.css" rel="stylesheet" type="text/css"> <script> function excluir(id) { if (confirm("Tem certeza que quer deletar?")) location.href="index.php?deletarID=" + id; } </script> </head> <body> <?php include("config.php"); mysql_select_db("$banco", mysql_connect("$host", "$user", "$pass")); if ($deletarID) { mysql_query("DELETE FROM lista WHERE ID = " . $deletarID); print "<script language=JavaScript> if (window.parent.location == document.location) { location.replace('index.php'); } </SCRIPT>"; } function lista() { $consulta = "SELECT * FROM lista ORDER BY nome"; $resultado = mysql_query($consulta); $return = '<table width="780" border="0" cellpadding="2" cellspacing="2">'; $return .= '<tr><td width="150" bgcolor="#efefef" align="center" valign="top">Nome:</td>'; $return .= '<td width="230" bgcolor="#efefef" align="center" valign="top">Endereço:</td>'; $return .= '<td width="70" bgcolor="#efefef" align="center" valign="top">Telefone:</td>'; $return .= '<td width="200" bgcolor="#efefef" align="center" valign="top">E-mail:</td>'; $return .= '<td width="65" align="center"></td>'; $return .= '<td width="65" align="center"></td>'; $return .= '</tr>'; while ($objeto = mysql_fetch_object($resultado)) { $return .= '<tr><td width="150" valign="top">' . $objeto->nome . '</td>'; $return .= '<td width="230" valign="top">' . $objeto->endereco . '</td>'; $return .= '<td width="70" valign="top">' . $objeto->tel . '</td>'; $return .= '<td width="200" valign="top"><a href="mailto: ' . $objeto->email . '">' . $objeto->email . '</td>'; $return .= '<td width="65" align="center" valign="top"><a href="lista.php?editarID=' . $objeto->ID . '">Editar</a></td>'; $return .= "<td width=65 align=center valign=top><a href=javascript:excluir(" . $objeto->ID . ");>Deletar</a></td>"; $return .= '</tr>'; } $return .= '</table>'; print $return; } print lista(); print '<table width="380" border="0" cellpadding="2" cellspacing="2">'; print '<tr><td width="150" bgcolor="#efefef" align="center"><font color="write"> </font></td>'; print '<td width="230" bgcolor="#efefef" align="center"></td>'; print '</tr><tr>'; print '<form method="post" action="busca.php">'; print '<td width="150"><a href="lista.php">Criar novo Endereço</a></td>'; print '<td width="230"><input name="palavra">'; print '<input type="submit" value="Buscar">'; print '</td></form></tr></table>'; ?> </body> </html>fim do index.php
lista.php
<html> <head> <title>Lista de Endereços</title> <link href="css.css" rel="stylesheet" type="text/css"> </head> <body> <?php include("config.php"); mysql_select_db("$banco", mysql_connect("$host", "$user", "$pass")); $consulta = "SELECT * FROM lista"; $resultado = mysql_query($consulta); if ($editarID) { if ($salvarID) { mysql_query("UPDATE lista SET nome = '$nome' WHERE ID = " . $salvarID); mysql_query("UPDATE lista SET endereco = '$endereco' WHERE ID = " . $salvarID); mysql_query("UPDATE lista SET tel = '$tel' WHERE ID = " . $salvarID); mysql_query("UPDATE lista SET email = '$email' WHERE ID = " . $salvarID); print "<script language=JavaScript> if (window.parent.location == document.location) { location.replace('index.php'); } </SCRIPT>"; } $consulta = "SELECT * FROM lista WHERE ID = " . $editarID; $resultado = mysql_query($consulta); $objeto = mysql_fetch_object($resultado); $return = '<table width="650" border="0" cellpadding="2" cellspacing="2">'; $return .= '<tr><td width="150" bgcolor="#EFEFEF" align="center">Nome:</td>'; $return .= '<td width="230" bgcolor="#EFEFEF" align="center">Endereço:</td>'; $return .= '<td width="70" bgcolor="#EFEFEF" align="center">Telefone:</td>'; $return .= '<td width="200" bgcolor="#EFEFEF" align="center">E-mail:</td>'; $return .= '</tr>'; $return .= '<form method="post" action="lista.php?editarID=' . $editarID . '&salvarID=' . $editarID . '">'; $return .= '<tr><td width="150"><input name="nome" value="' . $objeto->nome . '" size="20"></td>'; $return .= '<td width="230"><input name="endereco" value="' . $objeto->endereco . '" size="30"></td>'; $return .= '<td width="70"><input name="tel" value="' . $objeto->tel . '" size="10"></td>'; $return .= '<td width="200"><input name="email" value="' . $objeto->email . '" size="25"></td>'; $return .= '</tr>'; $return .= '<tr><td>'; $return .= '<input type="submit" value="Salvar Dados">'; $return .= '</td></tr>'; $return .= '</table>'; print $return; } if ($criar) { mysql_query("INSERT INTO lista(nome, endereco, tel, email) VALUES ('$nome', '$endereco', '$tel', '$email')"); print "<script language=JavaScript> if (window.parent.location == document.location) { location.replace('index.php'); } </SCRIPT>"; } elseif (!$editarID && !$salvar) { $return = '<table width="650" border="0" cellpadding="2" cellspacing="2">'; $return .= '<tr><td width="150" bgcolor="#EFEFEF" align="center">Nome:</td>'; $return .= '<td width="230" bgcolor="#EFEFEF" align="center">Endereço:</td>'; $return .= '<td width="70" bgcolor="#EFEFEF" align="center">Telefone:</td>'; $return .= '<td width="200" bgcolor="#EFEFEF" align="center">E-mail:</td>'; $return .= '</tr>'; $return .= '<form method="post" action="lista.php?criar=sim">'; $return .= '<tr><td width="150"><input name="nome" size="20"></td>'; $return .= '<td width="230"><input name="endereco" size="30"></td>'; $return .= '<td width="70"><input name="tel" size="10"></td>'; $return .= '<td width="200"><input name="email" size="25"></td>'; $return .= '</tr>'; $return .= '<tr><td>'; $return .= '<input type="submit" value="Criar Endereço">'; $return .= '</td></tr>'; $return .= '</table>'; print $return; } ?> </body> </html>fim do lista.php
busca.php
<html> <head> <title>Lista de Endereços</title> <link href="css.css" rel="stylesheet" type="text/css"> </head> <body> <?php include("config.php"); mysql_select_db("$banco", mysql_connect("$host", "$user", "$pass")); $consulta = "SELECT * FROM lista WHERE nome LIKE '%$palavra%'"; $resultado = mysql_query($consulta); $return = '<table width="780" border="0" cellpadding="2" cellspacing="2">'; $return .= '<tr><td width="150" bgcolor="#efefef" align="center" valign="top">Nome:</td>'; $return .= '<td width="230" bgcolor="#efefef" align="center" valign="top">Endereço:</td>'; $return .= '<td width="70" bgcolor="#efefef" align="center" valign="top">Telefone:</td>'; $return .= '<td width="200" bgcolor="#efefef" align="center" valign="top">E-mail:</td>'; $return .= '<td width="65" align="center"></td>'; $return .= '<td width="65" align="center"></td>'; $return .= '</tr>'; while ($objeto = mysql_fetch_object($resultado)) { $return .= '<tr><td width="150" valign="top">' . $objeto->nome . '</td>'; $return .= '<td width="230" valign="top">' . $objeto->endereco . '</td>'; $return .= '<td width="70" valign="top">' . $objeto->tel . '</td>'; $return .= '<td width="200" valign="top"><a href="mailto: ' . $objeto->email . '">' . $objeto->email . '</td>'; $return .= '<td width="65" align="center" valign="top"><a href="lista.php?editarID=' . $objeto->ID . '">Editar</a></td>'; $return .= "<td width=65 align=center valign=top><a href=javascript:excluir(" . $objeto->ID . ");>Deletar</a></td>"; $return .= '</tr>'; } $return .= '</table>'; print $return; ?> </body> </html>fim do busca.php
E ai o que acharam???