Skip to content

Instantly share code, notes, and snippets.

@AlexP11223

AlexP11223/1.php Secret

Last active September 29, 2016 05:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AlexP11223/292ce50ff07e0e8d5dbfc9effcb4e3d9 to your computer and use it in GitHub Desktop.
Save AlexP11223/292ce50ff07e0e8d5dbfc9effcb4e3d9 to your computer and use it in GitHub Desktop.
<?php
require_once 'login.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if (!$db_server) die("Невозможно подключиться к MySQL: " . mysql_error());
mysql_select_db($db_database, $db_server) or die("Невозможно выбрать базу данных: " . mysql_error());
if (isset($_POST['name']) &&
isset($_POST['email']) &&
isset($_POST['text'])) {
$name = ($_POST['name']);
$email = ($_POST['email']);
$text = ($_POST['text']);
$query = "INSERT INTO ot_post VALUES" . "(Null, '$name', '$email', '$text')";
if (!mysql_query($query, $db_server)) echo "Сбой при вставке данных: $query<br>" . mysql_error() . "<br><br>";
}
$query = "SELECT * FROM ot_post";
$result = mysql_query($query);
if (!$result) die ("Сбой при доступе к базе данных: " . mysql_error());
$rows = mysql_num_rows($result);
for ($j = 0; $j < $rows; ++$j) {
$row = mysql_fetch_row($result);
echo 'Отзыв от ' . $row[1] . '<br>';
echo $row[3];
echo "<br><br><br>";
}
echo
<<<_END
<center><form action="index.php" method="post"><pre><table>
<tr><td>Имя</td><td><input type="text" name="name"></td></tr>
<tr><td>E-mail</td> <td> <input type="text" name="email"></td></tr>
<tr><td>Текст сообщения</td><td><textarea cols="40" rows="10" name="text"></textarea></td></tr>
<tr><td><input type="submit" value="Отправить" size="90px"></td></tr>
</pre></table>
</form></center>
_END;
mysql_close($db_server);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment