[不是问题]未定义的索引：第22行的id [英] [Not a question] undefined index: id on line 22

问题描述

session_start（）;

include（'includes / header.html'）;

include（'dbcon.php'）;





$ query =SELECT

employee.fname

，employee.lname

，employee.adays

，employee.mdays

，employee.cdays

，employee.ccdays

，employee.pdays

，employee.nsdays

，employee.mcdays

FROM

ccse.employee，

ccse.leaves





WHERE（employee.eid = leaves.eid）和employee.eid = '$ _GET [id]';







$ result = @mysql_query（$ query） ;







if（$ result）{

echo< br>; echo

;

echo'

';



$ bg = '#eeeeee';

while（$ row = mysql_fetch_array（$ result，MYSQL_ASSOC））{

$ bg =（$ bg =='#eeeeee'？''＃ ffffff'： '#eeeeee'）;



echo'';

}

echo'

您的当前余额/离开权利
员工姓名	年假（天）	部长假（天）	体恤假（天）	育儿假（天）	陪产假/产假（天） ）	国民服务（天）	MC /医院休假（天）
'。$ row ['fname']。''。$ row ['lname ']。'	'。$ row ['adays']。'	'。$ row ['mdays']。'	'。$ row ['cdays']。'	'。$ row ['ccdays']。'	'。$ row ['pdays ]。'	'。$ row ['nsdays']。'	'。$ row ['mcdays']。'

';

mysql_free_result（$ result）;



} else {

echo'

'。mysql_error（）。'

查询：'。$ query。'

session_start();
include('includes/header.html');
include('dbcon.php');


$query = "SELECT
employee.fname
, employee.lname
, employee.adays
, employee.mdays
, employee.cdays
, employee.ccdays
, employee.pdays
, employee.nsdays
, employee.mcdays
FROM
ccse.employee,
ccse.leaves


WHERE (employee.eid = leaves.eid) and employee.eid='$_GET[id]'";



$result = @mysql_query($query);



if($result){
echo "
";echo "
";
echo '
';

$bg = '#eeeeee';
while($row=mysql_fetch_array($result, MYSQL_ASSOC)){
$bg = ($bg == '#eeeeee' ? '#ffffff' : '#eeeeee');

echo '';
}
echo '

Your Current Balance/Leave Entitlement
Employee Name	Annual Leave (Days)	Ministry Leave (Days)	Compassionate Leave (Days)	Childcare Leave (Days)	Paternity/Maternity Leave (Days)	National Service(Days)	MC/Hospital Leave (Days)
'.$row['fname'].' '.$row['lname'].'	'.$row['adays'].'	'.$row['mdays'].'	'.$row['cdays'].'	'.$row['ccdays'].'	'.$row['pdays'].'	'.$row['nsdays'].'	'.$row['mcdays'].'

';
mysql_free_result($result);

}else{
echo '

'.mysql_error().'

Query:'.$query.'

推荐答案

query =SELECT

employee.fname

，employee.lname

，employee.adays

，employee.mdays

，employee.cdays

，employee.ccdays

，employee.pdays

，employee.nsdays

，employee.mcdays

来自

ccse.employee，

ccse.leaves





WHERE（ employee.eid = leaves.eid）和employee.e id ='

query = "SELECT
employee.fname
, employee.lname
, employee.adays
, employee.mdays
, employee.cdays
, employee.ccdays
, employee.pdays
, employee.nsdays
, employee.mcdays
FROM
ccse.employee,
ccse.leaves


WHERE (employee.eid = leaves.eid) and employee.eid='

_GET [id]';

_GET[id]'";

result = @mysql_query（

result = @mysql_query(

这篇关于[不是问题]未定义的索引：第22行的id的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！