单击链接时获取mysql字段数据？ [英] Getting mysql field data when a link is clicked?

问题描述

基本上我有一个main.php包含这个：

  $ sql2 =SELECT projectsid，projectname，description，
 SUBSTRING（description，0,80）FROM projects; 
 $ result2 = mysql_query（$ sql2）; 
 
 while（$ row2 = mysql_fetch_assoc（$ result2））{
 echo< div id = \links\>; 
 echo< ul>; 
 echo< li>< a href = \fullproject.php\> 。 $ ROW2 [项目名称]; 
 $ _SESSION ['projectname'] = $ row2 ['projectname']; 
 echo< em> 。 $ row2 ['description']。 < / EM>< / A>< /锂> 中; 
 echo< / ul>; 
 echo< / div>; 
} 
  

这将显示名称列表和简要说明。

• Proj1
  
  
  
  • 描述
  
  


• Proj2
  
  
  
  • 描述
  
  

我想要做的是显示一个项目的完整内容，如果那个被点击。

fullproject.php

 <？php 
 session_start（）; 
 $ projectname = $ _SESSION ['projectname']; 
 
 //连接到服务器。 
 require（connect.php）; 
 
 $ sql1 =SELECT projectsid，projectname，program，difficult，requirements，
 resources，description，contact，gsize，size 
 FROM projects WHERE projectname ='$ projectname' ; 
 $ result1 = mysql_query（$ sql1）; 
 
 while（$ row1 = mysql_fetch_assoc（$ result1））{
 echoProject Name：。 $ ROW1 [项目名称。 < br />; 
 echoProgram：。 $ row1 ['program']。 < br />; 
 echo困难： $ row1 ['difficult']。 < br />; 
 echo要求：。 $ row1 ['requirements']。 < br />; 
 echo资源：。 $ row1 ['resources']。 < br />; 
 echo说明：。 $ row1 ['description']。 < br />; 
 echo联系人：。 $ row1 ['contact']。 < br />; 
 echo组大小：。 $ row1 ['gsize']。 。 $ row1 ['size']。 < br />; 
 echo< br />; 
} 
  

每当我点击任何项目列表项目，它只显示最后一个项目列表。
我相信这是发生的，因为当while循环结束时，会话变量被设置为最后一个。
有人可以告诉我如何解决这个问题？
谢谢

解决方案

尝试使用GET变量而不是会话

在main.php中使用

  echo< li>< a href ='fullproject.php？projectname = $ ROW2 [项目]'>中; 
  

在fullproject.php中声明一个变量并将其初始化为get变量

  $ projectname = $ _GET ['projectname']; 
  

I'm trying to get data from a database if a link is clicked.

Basically i have a main.php that contains this:

$sql2="SELECT projectsid, projectname, description, 
    SUBSTRING(description,0,80) FROM projects";
$result2=mysql_query($sql2);    

while($row2 = mysql_fetch_assoc($result2)) {
    echo "<div id=\"links\">";
    echo "<ul>";
    echo "<li> <a href=\"fullproject.php\">" . $row2['projectname'];
    $_SESSION['projectname']= $row2['projectname'];
    echo "<em>" . $row2['description'] . "</em></a></li>";
    echo "</ul>";
    echo "</div>";
}

This displays a list of names and a brief description.

• Proj1
  • description
• Proj2
  • description

What i'd like to do is to display the full contents of a project if that one is clicked.

fullproject.php

<?php
session_start(); 
$projectname= $_SESSION['projectname'];

// Connect to server.
require ("connect.php");

$sql1="SELECT projectsid, projectname, programme, difficult, requirements,
    resources, description, contact, gsize, size 
    FROM projects WHERE projectname = '$projectname'";
$result1=mysql_query($sql1);    

while($row1 = mysql_fetch_assoc($result1)) {
echo "Project Name: " . $row1['projectname']. "<br />";
echo "Programme : " . $row1['programme'] . "<br />";
echo "Difficult : " . $row1['difficult'] . "<br />";
echo "Requirements : " . $row1['requirements'] . "<br />";
echo "Resources : " . $row1['resources'] . "<br />";
echo "Description : " . $row1['description'] . "<br />";
echo "Contact : " . $row1['contact'] . "<br />";
echo "Group size : " . $row1['gsize'] . " " . $row1['size'] . "<br />";
echo "<br /> ";
}

Whenever I click any of the project list items, it only displays the last itemin the list. I believe this is happening because when the while loop ends the session variable is set to the last one. Can someone tell me how to fix this? Thanks

解决方案

Try using GET variable instead of session

in main.php use

    echo "<li> <a href='fullproject.php?projectname=$row2[projectname]'>";

in fullproject.php declare a variable and initialize it to the get variable

   $projectname= $_GET['projectname'];

这篇关于单击链接时获取mysql字段数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！