gpt4 book ai didi

php - 尝试使用 php 从存储在 phpmyadmin 中的数据库中选择数据时出错

转载 作者:太空宇宙 更新时间:2023-11-03 11:52:25 24 4
gpt4 key购买 nike

<分区>

谁能告诉我这段代码中的错误在哪里,因为我试图从我在 phpmyadmin 中创建的数据库中选择数据,但输出是:注意: undefined variable :C:\xampp\htdocs 中的 POST\php\browsestudents.php 第 25 行。数据库正常工作。这是我的代码:

<html>
<head>
<title>Online Jobs
</title>

</head>
<body>

<form action="browsestudents.php" method="POST">
<?php
print("Kerko studentet ne varesi te pozicionit te aplikuar te punes:
<form><select name='position'>
<option value='it'>IT</option>
<option value='a'>a</option>
<option value='b'>b</option>
</select>
<input type='submit' value='Search'/>
</form>");

if( !($database=mysql_connect("localhost","root",""))||!(mysql_select_db("st_login",$database)) )
print("Could not connect");


if(isset($_POST['position'])&&!empty($_POST['position'])){
$position=$POST['position'];
if($position=='a'||$position=='b'||$position=='it')
{
$query="SELECT `firstname`,`lastname`,`cv`,`position` /*shto listene notave ne fund*/
FROM `login`
WHERE `position`='$position' /*AND food LIKE 'P%' */
ORDER BY `id`";


if($result=mysql_query($query,$database))
{

if(mysql_num_rows($result)==NULL){//nr i rreshtave te query qe kemi kerkuar esht NULL
echo"no result found";
}
else

while($query_row=mysql_fetch_assoc($result))//krijon nje vektor
//query_row te cilit i asocion te dhenat e query
{
$firstname=$query_row["firstname"];//query_row esht vektor associativ qe i vendoset vlera e food
$lastname=$query_row["lastname"];
$cv=$query_row["cv"];
$position=$query_row["position"];
echo $firstname."<br/> Here is his cv".$cv."and position".$position;
}



}
else
echo mysql_error();

}
}
?>
</body>
</html>


24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com