Необходимо на страницу вывести результат запроса к БД MySQL
CODE (html):
скопировать код в буфер обмена
скопировать код в буфер обмена
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <title>shcode</title>
- </head>
- <body>
- <form action="./index.htm">
- <input type="text" id="shcode" name="shcode" placeholder="shcode" required maxlength="13" />
- <input type="submit" />
- </form>
- <?PHP
- function findeshcode($shcode)
- {
- require 'logsql.php';
- $db_server = mysql_connect($db_hostname, $db_username, $db_password);
- if (!$db_server)
- {
- die("Error connect to MySQL" . mysql_error());
- }
- mysql_select_db($db_database) or die("Error connect to MySQL" . mysql_error());
- mysql_query('SET NAMES utf8 COLLATE utf8_general_ci');
- if ($shcode=="")
- {
- "Enter shcode";
- }
- else
- {
- $result_shcode=mysql_query("SELECT * FROM `price` WHERE shcode='$shcode'ORDER BY date");
- }
- mysql_close($db_server);
- return $result_shcode;
- }
- $result_shcode=findeshcode($_GET["shcode"]);
- while($row=mysql_fetch_array($result_shcode))
- {echo $row['shcode'];}
- ?>
- </body>
- </html>