Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- $dbhost = "localhost";
- $dbuser = "root";
- $dbpass = "qazxswedcvfr";
- $dbname = "info";
- $table_name = "aneks";
- $conn = mysql_connect($dbhost, $dbuser, $dbpass);
- mysql_select_db($dbname);
- $list_f = mysql_list_fields($dbname,$table_name);
- $n1 = mysql_num_fields($list_f);
- // ������� ����� ����� � ������� $names
- for($j=0;$j<$n1; $j ){
- $names[] = mysql_field_name ($list_f,$j);
- }
- mysql_query("SET NAMES 'cp1251';");
- mysql_query("SET CHARACTER SET 'cp1251';");
- mysql_query("SET SESSION collation_connection = 'cp1251_general_ci';");
- $sql = "select * from $table_name ORDER BY RAND( ) LIMIT 0 , 1"; // ������� SQL ������
- $q = mysql_query($sql,$conn) or die(); // ���������
- // ������ �� ������
- $n = mysql_num_rows($q); // ������� ����� ����� ���������
- //������ HTML-������
- echo " <TABLE BORDER=0 CELLSPACING=0 width=90%
- align=center><tr><TD BGCOLOR='#005533' align=center>
- <font color='#FFFFFF'><b>$table_name</b></font></td>
- </tr></TABLE>";
- echo "<table cellspacing=0 cellpadding=1 border=1
- width=90% align=center>";
- // ���������� ������� �����
- echo "<tr>";
- foreach ($names as $val){
- echo "<th ALIGN=CENTER BGCOLOR='#C2E3B6'>
- <font size=2>$val</font></th>";
- }
- // ���������� ������ �����
- echo "</tr>";
- for($i=0;$i<$n; $i ){ // ���������� ��� ������ �
- // ��������� ������� �� ������
- echo "<tr>";
- foreach ($names as $val) { // ���������� ���
- // ����� �����
- $value = mysql_result($q,$i,$val); // �������
- // ������� ���
- echo "<td><font size=2> $value</font></td>";
- // ������ ������� ���
- }
- echo "</tr>";
- }
- echo "</table>";
- mysql_close($conn);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement