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.cssmysql.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.phplista.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.phpbusca.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.phpE ai o que acharam???
