Gå til innhold

gjestebok med bruker id

tjumsen

Anbefalte innlegg

Videoannonse

Videoannonse
Annonse
tjumsen

tjumsen

Skrevet
  • Forfatter
Skrevet

jeg har dette gjestebok scriptet som viste under

noen som kan hjelpe meg og skrive om denne slikt at jeg kan bruker user id på gjesteboka ??

 

add_entry.php

 

 

<?php

$dbservertype='mysql';
$servername='localhost';
// username and password to log onto db server
$dbusername='';
$dbpassword='';
// name of database
$dbname='tutorial';

////////////////////////////////////////
////// DONOT EDIT BELOW  /////////
///////////////////////////////////////
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}
?>

<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>Gjestebok</title>
<meta name="GENERATOR" content="Arachnophilia 4.0">
<meta name="FORMATTER" content="Arachnophilia 4.0">
</head>

<body>
<?

$email=$_POST['email'];
$name=$_POST['name'];
$country=$_POST['country'];
$dtl=$_POST['dtl'];


$status = "OK"; // setting the flag for form validation
$msg="";		// error message string is blank
// now let us check email address
if (!stristr($email,"@") OR !stristr($email,".")) {
$msg="<center>Your email address is not correct</center><BR>";
$status="NOT OK";
}
// Now let us check if name is entered or not 
if(strlen($name) < 2 ){  // if name is less than two char length
$msg .="<center>Please enter your name</center><BR>";
$status="NOT OK";
}
if($status<>"OK"){ // if form validation is not passed
echo "<BR><BR>";
echo $msg. "<br><center><input type='button' value='Retry' onClick='history.go(-1)'></center><br><br><br>";
}else{
$tm=time(); // reading the time of entry
// adding data to mysql database
$rt=mysql_query("insert into guest_book(name,email,country,tm,dtl) values('$name','$email','$country','$tm','$dtl')");
echo mysql_error();
echo "<center><font face='Verdana' size='2'>Entry added, Thank YOu. <a href=view_entry.php>Click here to view entries</a>. </font></center><br><br><br>";
}
?>
</body>

</html>

 

 

 

entry.html

 

 

<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>Gjestebok</title>
<meta name="GENERATOR" content="Arachnophilia 4.0">
<meta name="FORMATTER" content="Arachnophilia 4.0">
</head>

<body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080" alink="#ff0000">
<form method=post action=add_entry.php>
<table border='0'  cellspacing='0' cellpadding='0' align=center width=300>
<tr><td><font face='Verdana' size='2'>Your Name *</font><td><input type=text name=name></td></tr>
<tr bgcolor=#f1f1f1><td><font face='Verdana' size='2'>Email *</font><td><input type=text name=email></td></tr>
<tr><td><font face='Verdana' size='2'>Country</font><td><input type=text name=country></td></tr>
<tr bgcolor=#f1f1f1 ><td colspan=2 align=center><textarea name=dtl rows=5 cols=40></textarea></td></tr>
<tr  ><td colspan=2 align=center><input type=submit value='Add Entry'></td></tr>

</table></form>



</body>

</html>

 

 

 

view_entry.php

 

 

<?php
$dbservertype='mysql';
$servername='localhost';
// username and password to log onto db server
$dbusername='';
$dbpassword='';
// name of database
$dbname='tutorial';

////////////////////////////////////////
////// DONOT EDIT BELOW  /////////
///////////////////////////////////////
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}
?>

<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>Gjestebok</title>
<meta name="GENERATOR" content="Arachnophilia 4.0">
<meta name="FORMATTER" content="Arachnophilia 4.0">
</head>

<body>
<?
$query=mysql_query("select * from guest_book order by tm desc");
echo "<table border='0' width='400' cellspacing='0' cellpadding='0' align=center>";

while($nt=mysql_fetch_array($query)){ $dt=date("m/d/y",$nt['tm']); // formating the date 
$dtl=nl2br($nt['dtl']); // this will change  the line breaks to html line breaks
echo "<tr><td><font face='Verdana' size='2'><b>Name</b></font></td><td><font face='Verdana' size='2'>$nt[name]</font></td>";
echo "<td><font face='Verdana' size='2'><b>Email</b></font></td><td><font face='Verdana' size='2'>$nt[email]</font></td></tr>";
echo "<tr bgcolor=#f1f1f1><td><font face='Verdana' size='2'><b>Country</b></font></td><td><font face='Verdana' size='2'>$nt[country]</font></td>";
echo "<td><font face='Verdana' size='2'><b>Date:</b></font></td><td><font face='Verdana' size='2'>$dt</font></td></tr>";
echo "<tr><td colspan=4><font face='Verdana' size='2'>$dtl</font></td></tr>";
echo "<tr><td colspan=4><hr></td></tr>";

}

echo "</table>";

echo "<center><font face='Verdana' size='2'><a href='entry.html'>Add entry</a></center><br><br><br>";

?>
</body>

</html>

 

 

 

 

dump_guest.sql

 

 

CREATE TABLE guest_book 
( entry_id int(3) NOT NULL auto_increment, 
name varchar(50) NOT NULL default '', 
email varchar(50) NOT NULL default '', 
country varchar(50) NOT NULL default '', 
tm varchar(10) NOT NULL default '', 
dtl text NOT NULL, 
UNIQUE KEY entry_id (entry_id) ) TYPE=MyISAM;

 

 

Lenke til kommentar

Opprett en konto eller logg inn for å kommentere

Du må være et medlem for å kunne skrive en kommentar

Opprett konto

Det er enkelt å melde seg inn for å starte en ny konto!

Start en konto

Logg inn

Har du allerede en konto? Logg inn her.

Logg inn nå
Gå til emneliste

  • Hvem er aktive   0 medlemmer

    • Ingen innloggede medlemmer aktive
×
×
  • Opprett ny...