php查询数据库表问题-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

php查询数据库表问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 23, 2016 pm 02:09 PM

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>学生课题查询</title><style type="text/css"><!--.STYLE1 {font-size: 14px}--></style></head><body><?php//######################学生查询所选课题########################## include "config.php"; include "header.php";?> <?if($search){  if ($xuehao=="")  {	echo"<p align=\"center\"><font color=\"#FF0000\"><b><big>请填写您的学号！</big></b></font></p>";	echo "<meta http-equiv=\"refresh\" content=\"1;url=query.php\">";	exit;	 }    $query="select * from $student_table where xuehao='$xuehao'"; mysql_query("set names 'gb2312'"); $result=mysql_query($query); $row=mysql_fetch_array($result); if($row==0) {	echo"<p align=\"center\"><font color=\"#FF0000\"><b><big>你还没有注册,或者你的输入有误，请重新输入！</big></b></font></p>";	echo "<meta http-equiv=\"refresh\" content=\"2;url=query.php\">";    exit; }  $query="select id as sm from $student_table where xuehao='$xuehao'"; mysql_query("set names 'gb2312'"); $result=mysql_query($query); $row=mysql_fetch_array($result); if($row[sm]==0) {	echo"<p align=\"center\"><font color=\"#FF0000\"><b><big>你还没有选择课题，请去选题！</big></b></font></p>";	echo "<meta http-equiv=\"refresh\" content=\"2;url=keti_list.php\">";    exit; } ?><table width="700" border="0" cellspacing="1" cellpadding="0" bgcolor="#333333" align="center">  <tr>   <td width="78" height="30" bgcolor="#FFFFFF">       <div align="center" class="text">         <p class="STYLE1">学生学号</p>      </div>    </td>    <td width=97 height="30" bgcolor="#FFFFFF">       <div align="center" class="STYLE1">学生姓名</div>    </td>    <td width="329" height="30" bgcolor="#FFFFFF">     <div align="center" class="STYLE1"> 课题名称 </div>    </td>    <td width=106 height="30" bgcolor="#FFFFFF">       <div align="center" class="STYLE1">指导教师</div>    </td>    <td width=84 height="30" bgcolor="#FFFFFF">     <div align="center" class="STYLE1">职称</div>    </td>  </tr>   <?   $n=0;    $query=mysql_query("select * from $jiaoshi_table,$student_table where $jiaoshi_table.id=$student_table.id and $student_table.xuehao='$xuehao'");   mysql_query("set names 'gb2312'");   while($row=mysql_fetch_array($query)){        if(($n%2)!='0'){ 	  echo "<tr bgcolor=#FFFFff>";}	  else{	  echo "<tr bgcolor=#E4E4E4>";	  }     echo"	 <td   height='22' class='STYLE1'> <div align='center'>".$row['xuehao']."</div></td>	 <td   height='22'> 		<div align='center' class='STYLE1'>".$row['name']."</div></td>    <td   height='22' class='STYLE1'> <div align='center'>".$row['subject']."</div></td>    <td   height='22' class='STYLE1'> <div align='center'>".$row['teacher']."</div></td>	<td   height='22' class='STYLE1'> <div align='center'>".$row['zhicheng']."</div></td>  </tr> ";   $n++;   } ?></table> <p> </p><?php include "foot.php";?>

当我输入学号查询的时候，运行结果却是一堆乱七八糟的东西。。。
注：我的表名叫做teacher,student

回复讨论(解决方案)

你截的图看看　　　　

你截的图看看　　　　
哇塞，版主亲自回复。偶表示好激动地说。

你没开启段标签
改成

你代码到91行之前都在执行，你就不能开全了吗
$n=0; $query=mysql_query("select * from $jiaoshi
这里还有一个，你没改成

你代码到91行之前都在执行，你就不能开全了吗
$n=0; $query=mysql_query("select * from $jiaoshi
这里还有一个，你没改成<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>学生课题查询</title><style type="text/css"></style></head><body><?php//######################学生查询所选课题########################## include "config.php"; include "header.php";?><?phpif($search){ if ($xuehao=="") { echo"<p align=\"center\"><font color=\"#FF0000\"><b><big>请填写您的学号！</big></b></font></p>"; echo "<meta http-equiv=\"refresh\" content=\"1;url=query.php\">"; exit; } $query="select * from $student_table where xuehao='$xuehao'"; mysql_query("set names GB2312"); $result=mysql_query($query); $row=mysql_fetch_array($result); if($row==0) { echo"<p align=\"center\"><font color=\"#FF0000\"><b><big>你还没有注册,或者你的输入有误，请重新输入！</big></b></font></p>"; echo "<meta http-equiv=\"refresh\" content=\"2;url=query.php\">"; exit; } $query="select id as sm from $student_table where xuehao='$xuehao'"; mysql_query("set names 'GB2312'"); $result=mysql_query($query); $row=mysql_fetch_array($result); if($row[sm]==0) { echo"<p align=\"center\"><font color=\"#FF0000\"><b><big>你还没有选择课题，请去选题！</big></b></font></p>"; echo "<meta http-equiv=\"refresh\" content=\"2;url=keti_list.php\">"; exit; } ?><table width="700" border="0" cellspacing="1" cellpadding="0" bgcolor="#333333" align="center"> <tr> <td width="78" height="30" bgcolor="#FFFFFF"> <div align="center" class="text"> <p class="STYLE1">学生学号</p> </div> </td> <td width=97 height="30" bgcolor="#FFFFFF"> <div align="center" class="STYLE1">学生姓名</div> </td> <td width="329" height="30" bgcolor="#FFFFFF"> <div align="center" class="STYLE1"> 课题名称 </div> </td> <td width=106 height="30" bgcolor="#FFFFFF"> <div align="center" class="STYLE1">指导教师</div> </td> <td width=84 height="30" bgcolor="#FFFFFF"> <div align="center" class="STYLE1">职称</div> </td> </tr> <?php $n=0; $query=mysql_query("select * from $jiaoshi_table,$student_table where $jiaoshi_table.id=$student_table.id and $student_table.xuehao='$xuehao'"); mysql_query("set names GB2312"); while($row=mysql_fetch_array($query)){ if(($n%2)!='0'){ echo "<tr bgcolor=#FFFFff>";} else{ echo "<tr bgcolor=#E4E4E4>"; } echo" <td height='22' class='STYLE1'> <div align='center'>".$row['xuehao']."</div></td> <td height='22'> <div align='center' class='STYLE1'>".$row['name']."</div></td> <td height='22' class='STYLE1'> <div align='center'>".$row['subject']."</div></td> <td height='22' class='STYLE1'> <div align='center'>".$row['teacher']."</div></td> <td height='22' class='STYLE1'> <div align='center'>".$row['zhicheng']."</div></td> </tr> "; $n++; } ?></table> <p> </p><?php include "foot.php";?>

if($search)
{

这个if没有关闭，即少了 } 号

if($search)
{

这个if没有关闭，即少了 } 号好，我看看

if($search)
{

这个if没有关闭，即少了 } 号是加在48行后吗？我加了以后就变成这样了

是加在48行后吗？
我不知道你的逻辑，你自己应该很清楚啊。

$search 和 $xuehao 你在哪定义的？

是加在48行后吗？
我不知道你的逻辑，你自己应该很清楚啊。

$search 和 $xuehao 你在哪定义的？不太清楚啊，因为这个代码老师给的让做修改……

最后缺了个分号

}
include "foot.php";?>

最后缺了个分号

}
include "foot.php";?> 有分号啊

…… 楼主这错误看着太头晕，建议你用eclipse什么的去检查一下，丢的东西有点多啊

…… 楼主这错误看着太头晕，建议你用eclipse什么的去检查一下，丢的东西有点多啊说我的最后一行是语法错误，unexpected 'EOF'这是什么意思？

最后缺了个分号

}
include "foot.php";?> 有分号啊

你上面贴的代码里没有

…… 楼主这错误看着太头晕，建议你用eclipse什么的去检查一下，丢的东西有点多啊说我的最后一行是语法错误，unexpected 'EOF'这是什么意思？

你那少了一个括号的括回，仔细检查一下代码吧。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What is the difference between unset() and session_destroy()?May 04, 2025 am 12:19 AM

Thedifferencebetweenunset()andsession_destroy()isthatunset()clearsspecificsessionvariableswhilekeepingthesessionactive,whereassession_destroy()terminatestheentiresession.1)Useunset()toremovespecificsessionvariableswithoutaffectingthesession'soveralls

What is sticky sessions (session affinity) in the context of load balancing?May 04, 2025 am 12:16 AM

Stickysessionsensureuserrequestsareroutedtothesameserverforsessiondataconsistency.1)SessionIdentificationassignsuserstoserversusingcookiesorURLmodifications.2)ConsistentRoutingdirectssubsequentrequeststothesameserver.3)LoadBalancingdistributesnewuser

What are the different session save handlers available in PHP?May 04, 2025 am 12:14 AM

PHPoffersvarioussessionsavehandlers:1)Files:Default,simplebutmaybottleneckonhigh-trafficsites.2)Memcached:High-performance,idealforspeed-criticalapplications.3)Redis:SimilartoMemcached,withaddedpersistence.4)Databases:Offerscontrol,usefulforintegrati

What is a session in PHP, and why are they used?May 04, 2025 am 12:12 AM

Session in PHP is a mechanism for saving user data on the server side to maintain state between multiple requests. Specifically, 1) the session is started by the session_start() function, and data is stored and read through the $_SESSION super global array; 2) the session data is stored in the server's temporary files by default, but can be optimized through database or memory storage; 3) the session can be used to realize user login status tracking and shopping cart management functions; 4) Pay attention to the secure transmission and performance optimization of the session to ensure the security and efficiency of the application.

Explain the lifecycle of a PHP session.May 04, 2025 am 12:04 AM

PHPsessionsstartwithsession_start(),whichgeneratesauniqueIDandcreatesaserverfile;theypersistacrossrequestsandcanbemanuallyendedwithsession_destroy().1)Sessionsbeginwhensession_start()iscalled,creatingauniqueIDandserverfile.2)Theycontinueasdataisloade

What is the difference between absolute and idle session timeouts?May 03, 2025 am 12:21 AM

Absolute session timeout starts at the time of session creation, while an idle session timeout starts at the time of user's no operation. Absolute session timeout is suitable for scenarios where strict control of the session life cycle is required, such as financial applications; idle session timeout is suitable for applications that want users to keep their session active for a long time, such as social media.

What steps would you take if sessions aren't working on your server?May 03, 2025 am 12:19 AM

The server session failure can be solved through the following steps: 1. Check the server configuration to ensure that the session is set correctly. 2. Verify client cookies, confirm that the browser supports it and send it correctly. 3. Check session storage services, such as Redis, to ensure that they are running normally. 4. Review the application code to ensure the correct session logic. Through these steps, conversation problems can be effectively diagnosed and repaired and user experience can be improved.

What is the significance of the session_start() function?May 03, 2025 am 12:18 AM

session_start()iscrucialinPHPformanagingusersessions.1)Itinitiatesanewsessionifnoneexists,2)resumesanexistingsession,and3)setsasessioncookieforcontinuityacrossrequests,enablingapplicationslikeuserauthenticationandpersonalizedcontent.

See all articles