这是PHP主要的代码段:
<?php
//包含类文件
include("drawDataGrid.class.php");if (isset($_REQUEST['editTbl']))
{
$editTbl = $_REQUEST['editTbl'];
}
else
{
$editTbl=0;
}if (isset($_REQUEST['newTbl']))
{
$newTbl = $_REQUEST['newTbl'];
}
else
{
$newTbl=0;
}
if (isset($_REQUEST['rowNo']))
{
$rowNo = $_REQUEST['rowNo'];
}
else
{
$rowNo=0;
}if (isset($_REQUEST['curpage']))
$curpage = $_REQUEST['curpage'];
else
$curpage=0;if ($curpage == 0)
{
$curpage = 1;
}
$db_conn=mysql_connect("localhost","root","123456");
mysql_select_db("php",$db_conn);
$query = "select * from logins";
$result=mysql_query($query,$db_conn);
$num_rows = mysql_num_rows($result);$rowLower = 0;
$rowUpper = $num_rows;
$colLower = 0;$fields = mysql_list_fields("php", "logins", $db_conn);
$columns = mysql_num_fields($fields);$colUpper = $columns + 2 ;$updateImg = true;
$deleteImg = false;
?><HTML>
<HEAD>
<title>PHP DATAGRID - by Bala</title>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<link rel="stylesheet" href="stylesheet.css" type="text/css">
<script>function cancel()
{ document.tmpFrm.rowNo.value = 0;
document.tmpFrm.editTbl.value = 0;
document.tmpFrm.newTbl.value = 0; document.tmpFrm.submit(); }//end of checkfunction check(i)
{
document.tmpFrm.rowNo.value = i;
document.tmpFrm.newTbl.value = 0; document.tmpFrm.submit();
}//end of checkfunction checkNew(i)
{
document.tmpFrm.rowNo.value = 0;
document.tmpFrm.editTbl.value = 0; document.tmpFrm.submit();
}//end of checkfunction deleteYesNo(i)
{
var ok;
ok = confirm("Are you sure you want to delete this record?");
if(ok)
{
document.dgridFrm.del.value = i;
//val.value = i;
//alert(val.value);
document.dgridFrm.action = "delete.php";
document.dgridFrm.submit();
}//end if
}//end of deleteYesNo()
function newRecord()
{
if(document.dgridFrm.item(1).value == "")
{
alert("Please enter User Name!")
document.dgridFrm.item(1).focus();
}//end if
else
{
if(document.dgridFrm.item(2).value == "")
{
alert("Please enter Password!")
document.dgridFrm.item(2).focus();
}//end if
else { document.dgridFrm.action = "save.php";
document.dgridFrm.submit();
}//end else }//end else }//end of deleteYesNo()</script>
</HEAD>
<BODY>
<?php
//包含类文件
include("drawDataGrid.class.php");if (isset($_REQUEST['editTbl']))
{
$editTbl = $_REQUEST['editTbl'];
}
else
{
$editTbl=0;
}if (isset($_REQUEST['newTbl']))
{
$newTbl = $_REQUEST['newTbl'];
}
else
{
$newTbl=0;
}
if (isset($_REQUEST['rowNo']))
{
$rowNo = $_REQUEST['rowNo'];
}
else
{
$rowNo=0;
}if (isset($_REQUEST['curpage']))
$curpage = $_REQUEST['curpage'];
else
$curpage=0;if ($curpage == 0)
{
$curpage = 1;
}
$db_conn=mysql_connect("localhost","root","123456");
mysql_select_db("php",$db_conn);
$query = "select * from logins";
$result=mysql_query($query,$db_conn);
$num_rows = mysql_num_rows($result);$rowLower = 0;
$rowUpper = $num_rows;
$colLower = 0;$fields = mysql_list_fields("php", "logins", $db_conn);
$columns = mysql_num_fields($fields);$colUpper = $columns + 2 ;$updateImg = true;
$deleteImg = false;
?><HTML>
<HEAD>
<title>PHP DATAGRID - by Bala</title>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<link rel="stylesheet" href="stylesheet.css" type="text/css">
<script>function cancel()
{ document.tmpFrm.rowNo.value = 0;
document.tmpFrm.editTbl.value = 0;
document.tmpFrm.newTbl.value = 0; document.tmpFrm.submit(); }//end of checkfunction check(i)
{
document.tmpFrm.rowNo.value = i;
document.tmpFrm.newTbl.value = 0; document.tmpFrm.submit();
}//end of checkfunction checkNew(i)
{
document.tmpFrm.rowNo.value = 0;
document.tmpFrm.editTbl.value = 0; document.tmpFrm.submit();
}//end of checkfunction deleteYesNo(i)
{
var ok;
ok = confirm("Are you sure you want to delete this record?");
if(ok)
{
document.dgridFrm.del.value = i;
//val.value = i;
//alert(val.value);
document.dgridFrm.action = "delete.php";
document.dgridFrm.submit();
}//end if
}//end of deleteYesNo()
function newRecord()
{
if(document.dgridFrm.item(1).value == "")
{
alert("Please enter User Name!")
document.dgridFrm.item(1).focus();
}//end if
else
{
if(document.dgridFrm.item(2).value == "")
{
alert("Please enter Password!")
document.dgridFrm.item(2).focus();
}//end if
else { document.dgridFrm.action = "save.php";
document.dgridFrm.submit();
}//end else }//end else }//end of deleteYesNo()</script>
</HEAD>
<BODY>
<input type="hidden" name="editTbl" value="1">
<input type="hidden" name="newTbl" value="1"> <input type="hidden" name="rowNo">
</form>
<form name="dgridFrm" method="post" action="update.php">
<input type="hidden" name="del">
<table width="60%" border="0">
<?
if (isset($_POST['mess']))
{
?>
<tr>
<td align="center">
<?
echo "<font color=\"red\" face=\"verdana\">".$_POST['mess']."</font><br>";
?>
</td>
</tr>
<tr>
<td> </td>
</tr>
<?
}
?>
<tr>
<td align="center">
<?$tblWidth = 100;
$tblBorder = 0;$title = array(1=>"ID",2=>"Password",3=>"Email");$dgrid = new drawDataGrid; //创建类实例$dgrid->TableStart($tblWidth);
$dgrid->RowStart(0);for ($i=0; $i <= mysql_num_fields($result); $i++) //Table Header
{
if ($i ==0)
{
$dgrid->mainCellStart(5);
echo "<a href='JavaScript:cancel();'><img src='recycle.gif' border='0' alt='Cancel'></a>";
$dgrid->mainCellEnd();
}
else
{
if (($i ==2)||($i ==3))
{
$dgrid->mainCellStart(0);
echo "<b>".ucfirst(mysql_field_name($result, $i-1))."</b>";
$dgrid->mainCellEnd();
}
else
{
$dgrid->mainCellStart(5);
echo "<b>".ucfirst(mysql_field_name($result, $i-1))."</b>";
$dgrid->mainCellEnd();
}
}
}
$dgrid->mainCellStart(5);
echo " ";
$dgrid->mainCellEnd();
$dgrid->mainCellStart(5);
echo " ";
$dgrid->mainCellEnd();$dgrid->RowEnd(); for ($r = $rowLower; $r < $rowUpper; $r++)
{
$row = mysql_fetch_array($result);
$dgrid->RowStart($r);
for ($c = $colLower; $c <= $colUpper; $c++)
{
if ($c ==$colLower)
{ $dgrid->mainCellStart(0);
echo " ";
$dgrid->mainCellEnd();
}
else
{
if ($row[0]==$rowNo)
{
if ($c <= $columns)
{
$dgrid->CellStart();
echo "<input type='text' name='".mysql_field_name($result, $c-1)."' taborder='0' value='".trim($row[$c - 1])."'>";
$dgrid->CellEnd();
}
else if ($c==$columns + 1)
{
$dgrid->CellStart();
echo "<a href='JavaScript:document.dgridFrm.submit();'><img src='save.gif' border='0' alt='Save'></a>";
$dgrid->CellEnd();
}
else
{
$dgrid->CellStart();
echo " ";
$dgrid->CellEnd();
}
}
else
if ($c <= $columns)
{
$dgrid->CellStart();
echo trim($row[$c - 1]);
$dgrid->CellEnd();
}
else
if ($c==$columns + 1)
{
$dgrid->CellStart();
echo "<a href='JavaScript:check(".$row[$c - 4].
");'><img src='edit.gif' border='0' alt='Edit'></a>";
$dgrid->CellEnd();
}
else
{
$dgrid->CellStart();
echo "<a href='JavaScript:deleteYesNo(".$row[$c - 5].");'><img src='delete.gif' border='0' alt='Delete'></a>"; $dgrid->CellEnd();
}
}
}
$dgrid->RowEnd();
}if ($newTbl == 0)
{
$dgrid->RowStart($num_rows);
$dgrid->mainCellStart(0);
echo "<a href='JavaScript:checkNew(".($r + 1).");'><img src='add.gif' border='0' alt='New Record'></a>";
$dgrid->mainCellEnd();
// echo $colLower." ".$colUpper;
for ($c = $colLower; $c < $colUpper; $c++)
{
$dgrid->CellStart();
if ($c==$colLower)
echo " ";
else
echo " ";
$dgrid->CellEnd();
}
$dgrid->RowEnd();
}if ($newTbl == 1)
{
$dgrid->RowStart($num_rows + 1);
$dgrid->mainCellStart(0);
echo " ";
$dgrid->mainCellEnd();
for ($c = $colLower; $c < $colUpper; $c++)
{ if ($c==0)
{
$dgrid->CellStart();
mysql_data_seek($result, $num_rows-1);
// $row = mysql_fetch_array($result);
$row = mysql_fetch_row($result);
echo $row[0]+1;
$dgrid->CellEnd();
}
else if (($c) < $columns)
{
$dgrid->CellStart();
echo "<input type='text' name='".mysql_field_name($result, $c-1)."' taborder='0'>";
$dgrid->CellEnd();
}
else if ($c==$columns)
{
$dgrid->CellStart();
echo "<a href='JavaScript:newRecord();'><img src='save.gif' border='0' alt='Save'></a>";
$dgrid->CellEnd();
}
else
{
$dgrid->CellStart();
echo " ";
$dgrid->CellEnd();
}
}
$dgrid->RowEnd();
}$dgrid->TableEnd();
?>
</td>
</tr>
</table></form>
</BODY>
</HTML>
请问应该在上面代码的什么位置添加,还有要在哪些地主做相应的修改
多谢了!!!!