Упражнениe 9. XAMPP: Difference between revisions
From Ilianko
No edit summary |
|||
| Line 52: | Line 52: | ||
<html> | <html> | ||
<head> | <head> | ||
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> | ||
<title>Untitled Document</title> | <title>Untitled Document</title> | ||
</head> | </head> | ||
<body> | <body> | ||
<form action="" method="post"> | <form action="" method="post"> | ||
<table> | <table> | ||
<tr> | <tr> | ||
<td> | <td>nomer</td> | ||
<td><input type="text" name="fakN" value="" maxlength="9" /></td> | <td><input type="text" name="fakN" value="" maxlength="9" /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>ime</td> | <td>ime</td> | ||
<td><input type="text" name="name" value="" maxlength="100" /></td> | <td><input type="text" name="name" value="" maxlength="100" /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td> | <td>familia</td> | ||
<td><input type="text" name="surname" value="" maxlength="100" /></td> | <td><input type="text" name="surname" value="" maxlength="100" /></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>komentar</td> | <td>komentar</td> | ||
<td><textarea rows="3" cols="20" name="comment"></textarea></td> | <td><textarea rows="3" cols="20" name="comment"></textarea></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td colspan="2"><input name="submit" type="submit" value="Submit" /></td> | <td colspan="2"><input name="submit" type="submit" value="Submit" /></td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
</form> | </form> | ||
<?php print $comments ?> | |||
<?php print $comments ?> | </body> | ||
</body> | |||
</html> | </html> | ||
Revision as of 09:27, 22 March 2011
Задача
Използвайте phpMyAdmin за да създадете база данни с две таблици
1. Таблица students
fakN : name : surname : email
2. Таблица comments
id : fakN : comments : time
Полето time да е от тип TIMESTAMP
Създайте форма за качване на коментари
fakN, name, surname, comment Ако вече има писани коментари от този потребител, се добавя само коментара към базата дании.
Изполвайте
<?php
//svyrzvane kym MySQL server
$sql = mysql_connect('localhost', //adres
'root', // potrebitel
'123'); // parola
// Izbor na DB
mysql_select_db('tesss', // ime baza danni
$sql); // pointer kym bazata danni
if( isset($_POST['submit']))
{
$query = "SELECT * FROM students WHERE fakN = $_POST[fakN]"; // zaqvka kym DB server
$result = mysql_query($query); // Izprashtane na zaqvkata
if(mysql_num_rows($result))
{
$query = "INSERT INTO comments (`fakN`, `comments`) VALUES ( $_POST[fakN], '$_POST[comment]')";
$result = mysql_query($query);
}
else
{
$query = "INSERT INTO students (`fakN`, `name`, `surname`) VALUES ( $_POST[fakN], '$_POST[name]', '$_POST[surname]')";
$result = mysql_query($query);
$query = "INSERT INTO comments (`fakN`, `comments`) VALUES ( $_POST[fakN], '$_POST[comment]')";
$result = mysql_query($query);
}
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form action="" method="post">
<table>
<tr>
<td>nomer</td>
<td><input type="text" name="fakN" value="" maxlength="9" /></td>
</tr>
<tr>
<td>ime</td>
<td><input type="text" name="name" value="" maxlength="100" /></td>
</tr>
<tr>
<td>familia</td>
<td><input type="text" name="surname" value="" maxlength="100" /></td>
</tr>
<tr>
<td>komentar</td>
<td><textarea rows="3" cols="20" name="comment"></textarea></td>
</tr>
<tr>
<td colspan="2"><input name="submit" type="submit" value="Submit" /></td>
</tr>
</table>
</form>
<?php print $comments ?>
</body>
</html>
