Hello
I need help.
Well, I did accounting guests but needs to do a lot of changes and Mianowice book that consists ez and from 3 files below.
He wants - add validation e-mail address, because you know with who smoze insert your incorrect - where and how to insert the code should look something like this?
- Do filtering by id, date and email.
- What is the html I learned from the tables shall apply only to the data and the contemporary elements positioned using a div element. - How to convert this god for Divya
Please help me.
guestbook.php
<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><strong>Test Sign Guestbook </strong></td>
</tr>
</table>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form id="form1" name="form1" method="post" action="addbook.php">
<td>
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td width="117">email</td>
<td width="14">:</td>
<td width="357"><input name="email" type="text" id="email" size="40" /></td>
</tr>
<tr>
<td>Temat</td>
<td>:</td>
<td><input name="temat" type="text" id="temat" size="40" /></td>
</tr>
<tr>
<td valign="top">WPIS</td>
<td valign="top">:</td>
<td><textarea name="wpis" cols="40" rows="3" id="wpis"></textarea></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Submit" />
<input type="reset" name="Submit2" value="Reset" /></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><strong><a href="wyswietl.php">Wywietl Ksiazke</a> </strong></td>
</tr>
</table>
addbook.php
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="ryguohdfr"; // Mysql password
$db_name="kg"; // Database name
$tbl_name="ksiega"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");
$datetime=date("y-m-d h:i:s"); //date time
$email=$_POST['email'];
$temat=$_POST['temat'];
$wpis=$_POST['wpis'];
$sql="INSERT INTO $tbl_name(email, data, temat, wpis)VALUES('$email', '$datetime', '$temat', '$wpis')";
$result=mysql_query($sql);
//check if query successful
if($result){
echo "Successful";
echo "<BR>";
// link to view guestbook page
echo "<a href='wyswietl.php'>Wywietl wpisy</a>";
}
else {
echo "ERROR";
}
mysql_close();
?>
wyswietl.php
<?
//Definicja zmiennych (haslo,login,nazwe bazy i hosta)
$haslo='ryguohdfr';
$login='root';
$host='localhost';
$baza='kg';
//logowanie do serwera mysql
@ $bd = mysql_pconnect($host, $login, $haslo);
if (!$bd)
{
echo 'Połączenie z bazą danych jest teraz nie możliwe.';
exit;
}
mysql_select_db($baza);
//wysyłamy zapytanie
$zapytanie = 'SELECT * FROM `ksiega` WHERE 1 LIMIT 0, 100';
$dd = mysql_query($zapytanie);
$bb = mysql_fetch_array($dd);
while($bb)
{
$wpis=stripslashes($bb['wpis']);
$email=stripslashes($bb['email']);
$data=stripslashes ($bb['data']);
$temat=stripslashes ($bb['temat']);
//wyswietlamy wpis
echo '<br>Napisał z adresu: '.$email.'<br>TEMAT:'.$temat.'<br>';
echo 'DATA: '.$data.'<br>TRESC:'.$wpis.'<br>';
echo '--------------------------------- '.'<br>';
$bb = mysql_fetch_array($dd);
}
?>
– Table structure for table ksiega
CREATE TABLE `ksiega` (
`id` int(4) NOT NULL auto_increment,
`email` varchar(252) NOT NULL default '',
`data` timestamp(14) NOT NULL,
`temat` varchar(250) NOT NULL default '',
`wpis` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=37 ;