";
$rowquery = "SELECT * FROM resources";
$result = mysql_query($rowquery) or die ("Invalid query");
//loop through all returned records and print out the entry
while ($queryrow = mysql_fetch_row($result))
{
print "Entry ID: $queryrow[0]
";
print "Resource name: $queryrow[1]
";
print "Description: $queryrow[2]
";
print "End point: $queryrow[3]
";
print "Handle: $queryrow[4]
";
print "
";
}
}
// ---------------------------------------------------
// FIRST RECORD OPTION SELECTED
// ---------------------------------------------------
//if ($selectedResourceOption == "<<")
//select first entry
function firstResource(&$ResID, &$ResName, &$ResDescription, &$ResHost, &$ResHandle)
{
//$rowquery = "SELECT * FROM resources ORDER BY id ASC";
$minIDQuery = "SELECT MIN(id) FROM resources;";
$minIDResult = mysql_query($minIDQuery) or die ("Invalid query");
$firstID = mysql_fetch_row($minIDResult);
$query = "SELECT * FROM resources WHERE id = $firstID[0]";
$result = mysql_query($query) or die ("Invalid query");
$queryrow = mysql_fetch_row($result);
$ResID = $queryrow[0];
$ResName = $queryrow[1];
$ResDescription = $queryrow[2];
$ResHost = $queryrow[3];
$ResHandle = $queryrow[4];
}
// ---------------------------------------------------
// SAVE OPTION SELECTED
// ---------------------------------------------------
//if ($selectedResourceOption == "Save")
//add new resource to database
//currently adds a new record, so if an old record is edited it is saved again as a new record.
//this is therefore a poor implementation, so must be improved as soon as possible
function saveResource(&$ResID, &$ResName, &$ResDescription, &$ResHost, &$ResHandle)
{
//does this record already exist?
//if it exists $fldResID will hold the current ID
if($ResID == "")
{
//insert new row into resource table
$query = "INSERT INTO resources(name, description,host, handle) VALUES ('$ResName', '$ResDescription', '$ResHost', '$ResHandle');";
$result = mysql_query($query) or die ("Invalid query");
echo "
New record: $resourceName added
";
} else {
//update current record
$query = "UPDATE resources SET name ='$ResName', description='$ResDescription', host='$ResHost', handle = '$ResHandle' WHERE id='$ResID';";
$result = mysql_query($query) or die ("Invalid query");
echo "
Update record: $resourceName updated
";
}
//get resource ID for new/updated record
$query = "SELECT * FROM resources WHERE name = '$ResName';";
$result = mysql_query($query) or die ("Invalid query");
$queryrow = mysql_fetch_row($result);
$ResID = $queryrow[0];
}
// ---------------------------------------------------
// NEW OPTION SELECTED
// ---------------------------------------------------
//if ($selectedResourceOption == "New")
//empty fields for new entry
function clearResourceFields(&$ResID, &$ResName, &$ResDescription, &$ResHost, &$ResHandle)
{
$ResID="";
$ResName = "";
$ResDescription = "";
$ResHost = "";
$ResHandle = "";
}
// ---------------------------------------------------
// DELETE OPTION SELECTED
// ---------------------------------------------------
//if ($selectedResourceOption == "Delete")
//Delete currently displayed entry
function deleteResource(&$ResID)
{
$query = "DELETE FROM resources WHERE id = '$ResID';";
$result = mysql_query($query) or die ("Invalid query");
echo "
Delete record: $ResID deleted
";
}
?>