Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = "localhost";
- $dbuser = "Логин";
- $dbpassword = 'Пароль';
- $dbname = "vladiksan1998";
- $sname = $_POST['sname'];
- $fname = $_POST['fname'];
- $score = $_POST['score'];
- $link = mysql_connect($dbhost, $dbuser, $dbpassword);
- if (false === $link)
- die ('Error database connect');
- $select_result = mysql_select_db($dbname, $link);
- if (false === $select_result)
- die ('Error database select<');
- $query = "INSERT INTO records VALUES('$fname','$sname','$score')";
- $query_result = mysql_query($query, $link);
- if (false === $query_result)
- die ('Error database SQL query');
- $close_result = mysql_close($link);
- if (false === $close_result)
- die ('Error database close');
- ?>
- <?php
- $link = mysql_connect('localhost', 'login', 'pass')
- or die('Не удалось соединиться: ' . mysql_error());
- mysql_select_db('vladiksan1998') or die('Не удалось выбрать базу данных');
- $query = 'SELECT fname, sname, score FROM records';
- $result = mysql_query($query) or die('Запрос не удался: ' . mysql_error());
- echo "<table>n";
- while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
- if($line['score'] != 0){
- echo "t<tr>n";
- echo "tt<td>" . $line['fname'] . "</td>n";
- echo "tt<td>" . $line['sname'] . "</td>n";
- echo "tt<td>" . $line['score'] . "</td>n";
- echo "t</tr>n";
- }
- }
- echo "</table>n";
- mysql_free_result($result);
- mysql_close($link);
- ?>
- $query = "INSERT INTO records VALUES('$fname','$sname','$score')";
- $query_result = mysql_query($query, $link);
- if($score != 0)
- {
- $query = "INSERT INTO records VALUES('$fname','$sname','$score')";
- $query_result = mysql_query($query, $link);
- }
- $query = 'SELECT fname , sname , score FROM records WHERE score != 0';
Add Comment
Please, Sign In to add comment