The follwoing code genertes the message
Sorry yu do nto have permisionto access exercise 6.8.php
How can I fix this?
include 'db.inc';
include 'clean.inc';
$DBName = "NewDatabase";
$TableName = "Feedback2";
//connect to DB server
$Link = mysql_connect($Host, $User, $Password)
OR die("Could not connect to database");
//select DB
mysql_select_db($DBName, $Link)
OR die(mysql_error());
$id = clean($id, 5);
//Has an id been provided?
//if so, retrieve all customer details for editing.
if (!empty($id))
{
$query = "SELECT * from $TableName where id=" . $id;
if ($result = @mysql_query($query, $Link))
{
$row = mysql_fetch_array($result);
//other processing
}
else
{
echo mysql_error();
}
}
//reset $Array since we areloading from the feedback2 table
$Array= array();
//Load all the form variables with newdatabase data
$Array["Company"] = $row["Company"];
$Array["Logo"] = $row["Logo"];
$Array["Strapline"] = $row["Strapline"];
$Array["Activity"] = $row["Activity"];
$Array["Contact"] = $row["Contact"];
$Array["Phone"] = $row["Phone"];
$Array["Mobile"] = $row["Mobile"];
$Array["Email"] = $row["Email"];
$Array["Add1"] = $row["Add1"];
$Array["Add2"] = $row["Add2"];
$Array["Add3"] = $row["Add3"];
$Array["Add4"] = $row["Add4"];
$Array["Postcode"] = $row["Postcode"];
$Array["Text"] = $row["Text"];
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<style type="text/css">
<!--
td {font-family: arial; font-size: 10pt; }
h1 {font-family: arial; font-size: 14pt; }
h3 {font-family: arial; font-size: 10pt; }
//-->
</style>
<title>Company details</title>
</head>
<body bgcolor="white">
<form method="post" action=example.6-8.php">
<!--example6.8 is from cookbook and uses $id to identify row to be updated>
<!-- its code is also in this directory. It is not called until you enter fields & submit-->
<h1> Company details</h1>
<h3>Please change any details below and submit: </h3>
<table>
<col span="1" align="right">
<tr>
<td><input type ="hidden" name="id" value="<?echo $ID;?>"></td>
</tr>
<tr>
<td><font>Company:</font></td>
<td><input type="text" name="Company"
value="<? echo $Array["Company"];?>" size=50></td>
</tr>
<tr>
<td><font>Logo:</font><</td>
<td><input type="text" name="Logo"
value="<? echo $Array["Logo"];?>" size=50></td>
</tr>
<tr>
<td><font>Strapline:</font></td>
<td><input type="text" name="Strapline"
value="<? echo $Array["Strapline"];?>" size=50></td>
</tr>
<tr>
<td><font>Activity:</font></td>
<td><input type="text" name="Activity"
value="<? echo $Array["Activity"];?>" size=50></td>
</tr>
<br><br>
<tr>
<td><font>Contact:</font></font></td>
<td><input type="text" name="Contact"
value="<? echo $Array["Contact"];?>" size=50></td>
</tr>
<tr>
<td><font>Phone:</font></font></td>
<td><input type="text" name="Phone"
value="<? echo $Array["Phone"];?>" size=50></td>
</tr>
<tr>
<td><font>Mobile:</font></font></td>
<td><input type="text" name="Mobile"
value="<? echo $Array["Mobile"];?>" size=50></td>
</tr>
<tr>
<td><font>Email:</font></font></td>
<td><input type="text" name="Email"
value="<? echo $Array["Email"];?>" size=50></td>
</tr>
<br>
<tr>
<td><font>Add1:</font></font></td>
<td><input type="text" name="Add1"
value="<? echo $Array["Add1"];?>" size=50></td>
</tr>
<tr>
<td><font>Add2:</font></font></td>
<td><input type="text" name="Add2"
value="<? echo $Array["Add2"];?>" size=50></td>
</tr>
<tr>
<td><font>Add3:</font></font></td>
<td><input type="text" name="Add3"
value="<? echo $Array["Add3"];?>" size=50></td>
</tr>
<tr>
<td><font>Add4:</font></font></td>
<td><input type="text" name="Add4"
value="<? echo $Array["Add4"];?>" size=50></td>
</tr>
<tr>
<td><font>Postcode:</font></font></td>
<td><input type="text" name="Postcode"
value="<? echo $Array["Postcode"];?>" size=50></td>
</tr>
<br>
<tr>
<td><font>Text:</font></font></td>
<td><input type="text" name="Text"
value="<? echo $Array["Text"];?>" size=50></td>
</tr>
<tr>
<td><input type="submit" value="Submit"></td>
</tr>
</table>
</form>
</body>
</html>
