我有以下代码,它根据用户的登录详细信息从表中获取数据
//==========================================
// CONNECT TO THE LOCAL DATABASE
//==========================================
$user_name = "xxxx";
$pass_word = "xxxxx";
$database = "xxxx";
$server = "xxxxxx";
$db_handle = mysql_connect($server, $user_name, $pass_word);
$db_found = mysql_select_db($database, $db_handle);
if ($db_found) {
$SQL = "SELECT * FROM students WHERE L1 = '$uname' AND L2 = '" .md5 ($_POST['password'])."'";
$result = mysql_query($SQL);
$num_rows = mysql_num_rows($result);
//====================================================
// CHECK TO SEE IF THE $result VARIABLE IS TRUE
//====================================================
if ($result) {
if ($num_rows > 0) {
$color="1";
$result = mysql_query("SELECT * FROM entry, students WHERE entry.studentName = students.studentName AND students.L1='$uname' ") or die(mysql_error());
echo "<p>Welcome "; echo $row[studentName];
echo "<p>You records as of ";
echo date('l jS \of F Y h:i:s A');
echo "<table border='1' cellpadding='2' cellspacing='0'>";
echo "<tr> <th>Date</th><th>Student Name</th> <th>Tutor name</th> <th>Procedure name</th> <th>Grade</th><th>Student Reflection</th><th>Tutor Comments</th><th>Professionalism</th> <th>Communication</th> <th>Alert</th> <th>Dispute</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
if($color==1){
echo "<tr bgcolor=#DDD ><td>".$row['date']."</td><td>".$row['studentName']."</td><td>".$row['tutorName']."</td><td>".$row['procedureName']."</td><td>".$row['grade']."</td><td>".$row['studentReflection']."</td><td>".$row['tutorComments']."</td><td>".$row['professionalism']."</td><td>".$row['communication']."</td><td>".$row['alert']."</td><td>".$row['dispute']."</td></tr>";
// Set $color==2, for switching to other color
$color="2";
}
// When $color not equal 1, use this table row color
else {
echo "<tr bgcolor='#CCC'><td>".$row['date']."</td><td>".$row['studentName']."</td><td>".$row['tutorName']."</td><td>".$row['procedureName']."</td><td>".$row['grade']."</td><td>".$row['studentReflection']."</td><td>".$row['tutorComments']."</td><td>".$row['professionalism']."</td><td>".$row['communication']."</td><td>".$row['alert']."</td><td>".$row['dispute']."</td></tr>";
// Set $color back to 1
$color="1";
}
}
echo '</table>';
}
我想做的是在表上方回显或打印出用户名,但我很难这样做。我唯一想让它工作的是将它添加到while循环中,但是它会打印出用户有记录的次数。
你能帮忙吗?
最佳答案
您需要获取第一行才能访问用户信息。这意味着您必须在循环之前调用mysql_fetch_array
一次。
这会给你带来麻烦,因为你还需要在循环中调用它。您可以使用各种布尔标志或行的副本来绕过它,但最好的方法是稍微更改代码的结构。
使用do-while loop
,结合if statement
。这允许您首先获取一行,如果找不到任何行,则执行特殊操作。之后,您将得到一个循环,它将执行现在的操作,只检查迭代之后是否有下一行,而不是之前,否则将跳过表输出中的第一行。
if ($row = mysql_fetch_array( $result )) {
// Print user info
// Print table header
do {
// Print table row
} while ($row = mysql_fetch_array( $result ));
// Print table footer
}
else
{
// User not found. Print error or whatever.
}
关于php - PHP和mysql查询以检索名称,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/13032169/