Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- `
- <div id="pole">
- <input class="name" id="name" type="text" name="name" required placeholder=" " />
- <br />
- <input class="email" id="email" type="text" name="email" placeholder=" " />
- <textarea class="message" id="message" type="text" name="message" required placeholder=" "></textarea>
- <br />`
- <?
- $name = $_POST["name"];
- $email = $_POST["email"];;
- $message = $_POST["message"];
- $date = $_POST["date"];
- $date = date("y.m.d");
- $host = 'localhost';
- $db_user = 'root';
- $db_pass = '';
- $db_name = 'form';
- $connect = mysql_connect($host, $db_user, $db_pass) or die("Ошибка: " . mysql_error());
- mysql_select_db($db_name) or die("Ошибка");
- mysql_set_charset('utf8');
- if (isset($message) && $message != '') {
- $query = 'INSERT INTO messages (name, email, msg, date) VALUES ("' . $name . '", "' . $email . '", "' . $message . '", "' . $date . '")';
- mysql_query($query) or die("Ошибка:" . mysql_error());
- }
- echo '<br />';
- $query = 'SELECT * FROM messages ORDER BY id DESC LIMIT 10';
- $result = mysql_query($query) or die("Ошибка: " . mysql_error());
- while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
- echo '<ol>';
- echo '<li>';
- echo '<div id="com">';
- echo '<div id="name1">';
- echo '<label><h5>' . $row["name"] . '</h5></label>';
- echo '</div>';
- echo '<div id="date" align="right">';
- list($y, $m, $d) = explode ("-", $row['date']);
- echo '<label><h5>' . $d.".".$m.".".$y . '</h5></label>';
- echo '</div>';
- echo '<div id="line">';
- echo '</div>';
- echo '<div id="text1">';
- echo '<label><p>' . $row["msg"] . '</p></label>';
- echo '</div>';
- echo '</li>';
- echo '</ol>';
- }
- mysql_free_result($result);
- mysql_close($connect);
- ?>
Add Comment
Please, Sign In to add comment