ściągnąłem sobie skrypt do kont, ale coś nie działa
tak to wygląda po wrzuceniu na Server: http://members.lycos.co.uk/damiancieslewicz/b/
Na serwerze są trzy pliki:
1-index.php
<html>
<head>
<title>ttb easy Signup</title>
</head>
<body>
<br><center>
<font face="verdana" size="4" color="#333333">Users:</font><br></center>
<br>
<? require("showuser.php"); ?>
<br>
<br>
<font face="verdana" size="2" color="#333333">Add a user </font><br>
<?
// ttb sign up PHP-script! Realy basic stuff! Can easy be modified! URL: http://ttbsignup.tattarbarn.com/
echo "
<br><font face='verdana' size='1'>
<form action=index.php?action=add method=post><br>
<input type=text name=firstname size=20> <- Name<br>
<input type=text name=surename size=20> <- Surename<br>
<input type=text name=email size=20> <- E-mail<br>
<input type=text name=privatephone size=20> <- Private phone <br>
<input type=text name=workphone size=20> <- Workphone<br>
<input type=text name=homepage size=20> <- Homepage<br>
<input type=text name=urlpic size=20 value=http://www.tattarbarn.com/nopic.gif> <- Picture url (ex: http://yoursite.com/pics/me.jpg)<br>
<select name=born>
<option>1983</option>
<option>1980</option>
<option>1970</option>
<option>1960</option>
<option>1950</option>
<option>1940</option>
<option>1930</option>
</select><- Born<br>
Other info:<br><textarea name=info></textarea><br>
<input type=submit value='Add!'></form> </font>";
if($action=='add')
{
$conn = mysql_connect("database-ip","username","password") or die ("Cant connect to Database"); // Your database settings! Also need to be added to showuser.php
$db = mysql_select_db("databaseNAME") or die ("database gone.");
$sql = "INSERT INTO `ttbsignup` (`firstname`, `surename`, `privatephone`, `workphone`, `homepage`, `email`, `born`, `urlpic`, `info`) VALUES ('$firstname', '$surename', '$privatephone', '$workphone', '$homepage', '$email', '$born', '$urlpic', '$info')"; // This line inserts the user information to the database.
$result = mysql_query($sql) or die ("Not working try again");
if($result)
{
echo "The user $firstname $surename was added.<br>";
echo "<a href=index.php>REFRESH PAGE</a>";
}
}
?>
</body>
</html>
2-showuser.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Show users</title>
</head>
<font face="verdana" size="1">
<?
$conn = mysql_connect("database-ip","database-username","password") or die ("Cant connect to Database.");
$db = mysql_select_db("database-name") or die ("databae gone.");
$result = mysql_query("SELECT * FROM ttbsignup");
while($row = mysql_fetch_array($result)) {
print '<table align="center" width="70%" style="border: #000000 1px dotted"><tr><td class="no_frame">';
print '<font face="verdana" size="1">';
print '<b>Firstname: </b>'.$row['firstname'].'<br>';
print '<b>Surename: </b>'.$row['surename'].'<br>';
print '<b>Privatephone: </b>'.$row['privatephone'].'<br>';
print '<b>Workphone: </b>'.$row['workphone'].'<br>';
print '<b>www: </b><a href="'.$row[homepage].'">'.$row[homepage].'</a><br>';
print '<b>E-mail: </b><a href="mailto:'.$row[email].'">'.$row[email].'</a><br>';
print '<b>Born: </b>'.$row['born'].'<br>';
print '<b>Info: </b>'.$row['info'].'<br>';
print '</tr></td>';
print '<td valign=top align=right>';
print '<img src="'.$row[urlpic].'" width="100"><br>';
print '</td></table><br>';
}
?>
</font>
<body>
</body>
</html>
3-ttbsignup.sql
CREATE TABLE `ttbsignup` (
`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`firstname` varchar( 255 ) NOT NULL default '',
`surename` varchar( 255 ) NOT NULL default '',
`email` varchar( 255 ) NOT NULL default '',
`info` text NOT NULL ,
`homepage` varchar( 255 ) NOT NULL default '',
`privatephone` varchar( 255 ) NOT NULL default '',
`born` varchar( 255 ) NOT NULL default '',
`urlpic` varchar( 255 ) NOT NULL default '',
`workphone` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `id` )
)
###########################################
# http://ttbsignup.tattarbarn.com/ #
# Modify as you please! #
###########################################
Co tutaj jest nie tak???
</span>