Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #----------------- mySQL Verbindung -----------------#
- $db_host = "localhost";
- $db_user = "humfred";
- $db_password = "";
- $db_name = "humfred_de_db";
- $conn = mysql_connect($db_host,$db_user,$db_password) or die (mysql_error());
- mysql_select_db($db_name, $conn) or die (mysql_error());
- $datum = date("d.m.Y"); # Das aktuelle Datum für den Eintrag wird hier erstellt
- $zeit = date("H:i"); # Die aktuelle Zeit für den Eintrag wird hier erstellt
- #----------------------------------------------------------#
- $sql = "SELECT * FROM gaestebuch ORDER BY id desc LIMIT 5";
- $result = mysql_query($sql);
- while($row = mysql_fetch_array($result))
- {
- echo '<br/>';
- echo '<u>Name:</u> ';
- echo($row['name']);
- }
- "INSERT INTO gaestebuch (id, Name, Mail, Text, date, time)
- VALUES ('','$Name','$Mail','$Text','$datum', '$zeit')";
- $result = mysql_query("SELECT * FROM gaestebuch WHERE name LIKE '".$_REQUEST['suchen']."'");
- if(mysql_num_rows($result) == 0){
- echo 'Fehler';
- }
- else
- {
- while($row = mysql_fetch_array($result))
- {
- echo($row['name']);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement