Me again, here's some of
The code:
table.php:
<?
$conn = mysql_connect("somehost", "username", "password") or die(mysql_error());
mysql_select_db("database_name", $conn) or die(mysql_error());
$sql = "CREATE TABLE `dealers` (
`dealer_name` VARCHAR( 100 ) NOT NULL ,
`dealer_phone` VARCHAR( 100 ) NOT NULL ,
`dealer_fax` VARCHAR( 100 ) NOT NULL ,
`email` VARCHAR( 100 ) NOT NULL ,
`website` VARCHAR( 100 ) NOT NULL ,
`address` VARCHAR( 100 ) NOT NULL ,
`operator1` VARCHAR( 20 ) NOT NULL ,
`operator2` VARCHAR( 20 ) NOT NULL ,
`operator3` VARCHAR( 20 ) NOT NULL ,
`operator4` VARCHAR( 20 ) NOT NULL ,
`description` VARCHAR( 200 ) NOT NULL ,
`dealer_image` VARCHAR( 100 ) NOT NULL ,
`county` VARCHAR( 100 ) NOT NULL
) ";
$sql_res = mysql_query($sql, $conn) or die(mysql_error());
?>
list.php
<?
function doDB()
{
global $conn;
$conn = mysql_connect("somehost", "username", "password") or die(mysql_error());
mysql_select_db("database_name", $conn) or die(mysql_error());
}
function getdeal()
{
global $sql_res;
$sql = "select dealer_name from dealers";
$sql_res = mysql_query($sql, $conn) or die(mysql_error());
}
doDB();
getdeal();
if (mysql_num_rows($sql_res) >= 1)
{
while($row = mysql_fetch_array($sql_res))
{
$dealer_name = stripslashes($row['dealer_name']);
$msg = "<a href=show.php?name=$dealer_name>$dealer_name</a><br>
<a href=edit.php?name=$dealer_name>EDIT?</a>";
}
}
else $msg = "No Dealers!";
?>
<html>
<head>
<title>Dealers List</title>
</head>
<body>
<center><h2>DEALERS LIST</h2><p>
<? echo $msg; ?>
</center>
</body>
</html>
show.php
<?
$name = $_GET[name];
function doDB()
{
global $conn;
$conn = mysql_connect("somehost", "username", "password") or die(mysql_error());
mysql_select_db("database_name", $conn) or die(mysql_error());
}
function getdeal()
{
global $sql_res;
$sql = "select * from dealers where dealer_name = '$name'";
$sql_res = mysql_query($sql, $conn) or die(mysql_error());
}
doDB();
getdeal();
if (mysql_num_rows($sql_res) == 1)
{
$row = mysql_fetch_array($sql_res);
$dealer_name = stripslashes($row['dealer_name']);
$dealer_phone = stripslashes($row['dealer_phone']);
$dealer_fax = stripslashes($row['dealer_fax']);
$email = stripslashes($row['email']);
$website = stripslashes($row['website']);
$address = stripslashes($row['address']);
$operator1 = stripslashes($row['operator1']);
$operator2 = stripslashes($row['operator2']);
$operator3 = stripslashes($row['operator3']);
$operator4 = stripslashes($row['operator4']);
$description = stripslashes($row['description']);
$dealer_image = stripslashes($row['dealer_image']);
$county = stripslashes($row['county']);
$msg = "<ol><li>Name: $dealer_name</li>
<li>Phone: $dealer_phone</li>
<li>Fax: $dealer_fax</li>
<li>Email: $email</li>
<li>Website:<a href=$website>$website</a></li>
<li>Address: $address</li>
<li>Operators: $operator1 $operator2 $operator3 $operator4</li>
<li>Description: $description</li>
<li>County: $county</li>
<li>Image: <img src=$dealer_image></li>
</ol>";
}
else $msg = "Invalid Dealer Name";
?>
<html>
<head>
<title>Showing Details</title>
</head>
<body>
<center><h2>SHOWING DETAILS FOR $dealer_name</h2><p>
<? echo $msg; ?>
</center>
</body>
</html>
add.php
<?
function doDB()
{
global $conn;
$conn = mysql_connect("somehost", "username", "password") or die(mysql_error());
mysql_select_db("database_name", $conn) or die(mysql_error());
}
doDB();
$op = $_POST[op];
if($op != "ds")
{
$msg = "<form method=post action=\"$_SERVER[PHP_SELF]\">
<p><b>Name:</b> <input type=text name=name><br>
<b>Phone: </b><input type=text name=phone><br>
<b>Fax: </b><input type=text name=fax><br>
<b>Email: </b><input type=text name=email><br>
<b>Website: </b><input type=text name=website><br>
<b>Address: </b><input type=text name=address><br>
<b>Operators: </b><select multiple name=\"operator[]\">
<option value=Vodafone>Vodafone</option>
<option value=O2>O2</option>
<option value=\"3 Ireland\">3 Irealand</option>
<option value=Meteor>Meteor</option>
</select><br>
<b>Description: </b><textarea name=description></textarea><br>
<b>Path to Image: </b><input type=text name=image><br>
<b>County: </b><select name=county>Have your options here!!</select><br>
<input type=hidden name=op value=ds>
<input type=submit value=Add>
</form>";
}
else if($op == "ds")
{
$name = $_POST[name];
$phone = $_POST[phone];
$fax = $_POST[fax];
$email = $_POST[email];
$website = $_POST[website];
$address = $_POST[address];
$operator = $_POST[operator];
$description = $_POST[description];
$image = $_POST[image];
$county = $_POST[county];
if ($name != NULL && $phone != NULL e.t.c.)
{
$sq = "insert into dealers values ("$name", "$phone", "$fax", "$email", "$website", "$address", "$operator[0]", "$operator[1]", "$operator[2]", "$operator[3]", "$description", "$image", "$county")";
$sq_res = mysql_query($sq, $conn) or die(mysql_error());
$msg = "New Dealer has been added in the database";
}
else {
header("Location: add.php");
exit;
}
}
?>
<html>
<head>
<title>ADD NEW DEALER</title>
</head>
<body>
<center><h2>ADD NEW DEALER</h2><p>
<? echo $msg; ?>
</center>
</body>
</html>
edit.php
<?
$name = $_POST[name];
function doDB()
{
global $conn;
$conn = mysql_connect("somehost", "username", "password") or die(mysql_error());
mysql_select_db("database_name", $conn) or die(mysql_error());
}
function getdeal()
{
global $sql_res;
$sql = "select * from dealers where dealer_name = '$name'";
$sql_res = mysql_query($sql, $conn) or die(mysql_error());
}
doDB();
getdeal();
if ($_POST[op] != "ds")
{
if (mysql_num_rows($sql_res) == 1)
{
$row = mysql_fetch_array($sql_res);
$dealer_name = stripslashes($row['dealer_name']);
$dealer_phone = stripslashes($row['dealer_phone']);
$dealer_fax = stripslashes($row['dealer_fax']);
$email = stripslashes($row['email']);
$website = stripslashes($row['website']);
$address = stripslashes($row['address']);
$operator1 = stripslashes($row['operator1']);
$operator2 = stripslashes($row['operator2']);
$operator3 = stripslashes($row['operator3']);
$operator4 = stripslashes($row['operator4']);
$description = stripslashes($row['description']);
$dealer_image = stripslashes($row['dealer_image']);
$county = stripslshes($row['county']);
$msg = "<form method=post action=\"$_SERVER[PHP_SELF]\">
<p><b>Name:</b> <input type=text name=name value=$dealer_name><br>
<b>Phone: </b><input type=text name=phone value=$dealer_phone><br>
<b>Fax: </b><input type=text name=fax value=$dealer_fax><br>
<b>Email: </b><input type=text name=email value=$email><br>
<b>Website: </b><input type=text name=website value=$website><br>
<b>Address: </b><input type=text name=address value=$address><br>
<b>Operators: </b> <input type=text readonly=true value=\"$operator1 $operator2 $operator3 $operator4\"><br>
<b>Choose other:</b><select multiple name=\"operator[]\">
<option value=Vodafone>Vodafone</option>
<option value=O2>O2</option>
<option value=\"3 Ireland\">3 Irealand</option>
<option value=Meteor>Meteor</option>
</select><br>
<b>Description: </b><textarea name=description value=$description>$description</textarea><br>
<b>Path to Image: </b><input type=text name=image value=$image><br>
<b>County: </b><input type=text name=county value=$county readonly=true><br>
<b>Choose Other: <select name=county>Have your options here!!</select> <br>
<input type=hidden name=op value=ds>
<input type=submit value=Add>
</form>";
}
else $msg = "Invalid Dealer Name";
}
else if ($_POST[op] == "ds")
{
$dealer_name = $_POST[name];
$dealer_phone = $_POST[phone];
$dealer_fax = $_POST[fax];
$email = $_POST[email];
$website = $_POST[website];
$address = $_POST[address];
$operator = $_POST[operator];
if ($operator == NULL)
{
$row = mysql_fetch_array($sql_res);
$operator1 = stripslashes($row['operator1']);
$operator2 = stripslashes($row['operator2']);
$operator3 = stripslashes($row['operator3']);
$operator4 = stripslashes($row['operator4']);
}
else {
$operator1 = $operator[0];
$operator2 = $operator[1];
$operator3 = $operator[2];
$operator4 = $operator[3];
}
$description = $_POST[description];
$dealer_image = $_POST[image];
$county = $_POST[county];
if ($county == NULL)
{
$row = mysql_fetch_array($sql_res);
$county = stripslashes($row['county']);
}
$query = "replace into dealers values("$dealer_name", "$dealer_phone", "$dealer_fax", "$email", "$website", "$address", "$operator1", "$operator2", "$operator3", "$operator4", "$description", "$image", "$county")";
$query_res = mysql_query($query, $conn) or die(mysql_error());
$msg = "Successfully Edited Dealer $dealer_name";
}
?>
<html>
<head>
<title>EDIT DEALER</title>
</head>
<body>
<center><h2>EDITING DEALER <? echo $dealer_name; ?></h2><p>
<? echo $msg; ?>
</center>
</body>
</html>
The rest of the code in the next POST!