⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 afisare_n.php

📁 some php and html pages with the most important mysql functions.
💻 PHP
字号:
🔍 
<html>

<head>
</head>
						
<div align="center">

<hr>
<TABLE BORDER="1" CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
	<TR ALIGN="center" VALIGN="middle">
	<TD ALIGN="left" VALIGN="middle"><FONT SIZE="3" COLOR="000000">ID</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="000000">Nume</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="000000">Prenume</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="000000">Adresa</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="000000">Telefon</TD>

	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="000000">Mobil</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="000000">Proba 1</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="000000">Proba 2</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="000000">Proba 3</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="000000">Media</TD>

	</TR>
	<TR ALIGN="center" VALIGN="middle">
	<TD ALIGN="left" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>

	<TD ALIGN="left" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>
	<TD ALIGN="center" VALIGN="middle"><FONT SIZE="3" COLOR="FFFFFF">s</TD>

	</TR>
</font>	
				
<?php

mysql_connect("localhost", "madalina", "madapoli") or die(mysql_error());
mysql_select_db("concurs") or die(mysql_error());

$query = "SELECT * FROM `candidati` ORDER BY `nume`"; 
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{
		?>
		<TR ALIGN="center" VALIGN="middle">
			<TD ALIGN="left" VALIGN="middle"><FONT COLOR = "FF0000">
		<?php
			echo "". $row['id'] ."";
		?>
			</TD>
			<TD ALIGN="center" VALIGN="middle"><FONT COLOR="FF0000">
		<?php
			echo "". $row['nume'] ."";
		?>
			</TD>
			<TD ALIGN="center" VALIGN="middle"><FONT COLOR="FF0000">
		<?php
			echo "". $row['prenume'] ."";
		?>
			</TD>
			<TD ALIGN="center" VALIGN="middle"><FONT COLOR="FF0000">
		<?php
			echo "". $row['adresa'] ."";
		?>
			</TD>
			<TD ALIGN="center" VALIGN="middle"><FONT COLOR="FF0000">
		<?php
			echo "". $row['telefon'] ."";
		?>
			</TD>
			<TD ALIGN="center" VALIGN="middle"><FONT COLOR="FF0000">
		<?php
			echo "". $row['mobil'] ."";
		?>
			</TD>
			<TD ALIGN="center" VALIGN="middle"><FONT COLOR="FF0000">
		<?php
			echo "". $row['proba1'] ."";
		?>
			</TD>
			<TD ALIGN="center" VALIGN="middle"><FONT COLOR="FF0000">
		<?php
			echo "". $row['proba2'] ."";
		?>
			</TD>
			<TD ALIGN="center" VALIGN="middle"><FONT COLOR="FF0000">
		<?php
			echo "". $row['proba3'] ."";
		?>
			</TD>
			<TD ALIGN="center" VALIGN="middle"><FONT COLOR="FF0000">
		<?php
			echo "". $row['media'] ."";
		?>
			</TD>
			</TR>
		<?php
}
?>
</TABLE>
<p></p>
</FONT>
<hr>
</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -