PHP/MySQL Database/Table Column

Материал из Web эксперт
Перейти к: навигация, поиск

Reference columns by name

   <source lang="html4strict">
<html>
 <body>
 <?php
 $host="mysql153.secureserver.net";
 $uname="wbex";
 $pass="password";
 $database="wbex";
 $tablename="Employee";
 $connection= mysql_connect ($host, $uname, $pass) or die ("Database connection failed! 
");
 $result=mysql_select_db ($database) or die ("Database could not be selected");
 $query = "SELECT * from ". $tablename;
 
 $result = mysql_query ($query);
echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; while ($row=mysql_fetch_array ($result)) { echo " \n"; echo " "; echo " "; echo " "; } echo "
ID
First Name
Last Name
". $row["ID"]. "". $row["FirstName"]. "". $row["LastName"]. "/td>"; echo "
"; 
 ?>
 </body>
 </html>
          
      </source>


Reference table columns by index

   <source lang="html4strict">

<html> 

 <body>
 <?php
 $host="mysql153.secureserver.net";
 $uname="wbex";
 $pass="password";
 $database="wbex";
 $tablename="Employee";

 $connection= mysql_connect ($host, $uname, $pass) or die ("
Database connection failed! 
");
 $result=mysql_select_db ($database) or die ("
Database could not be selected
");
 $query = "SELECT * from Employee";
 $result = mysql_query ($query);
echo ""; echo "<tr"; echo " \n"; echo " \n"; echo " \n"; 
 echo " </tr>\n";
 while ($row=mysql_fetch_row ($result))
 {
echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "
ID
First Name
Last Name
$row[0] $row[1] $row[2]
\n"; 
 ?>
 </body>
 </html>
          
      </source>
Источник — «http://wbex.ru/index.php?title=PHP/MySQL_Database/Table_Column&oldid=1089»