Hi all!! Brand new to this place and so far the forum is best by far!!
Now to the good stuff:
I am currently working on a project that involves php and mysql. The part that I am now is the "admin" section. I am setting up so the user can add/delete/edit things to the database. Now I have the add part down its the next two that I have had some trouble with. Everywhere I search for has information on how to do everything to your database, behind the scenes, not on the user end. So here is the code that is for the "edit" page:
<?php
$dbh=mysql_connect ("localhost", "blah", "blah") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("snmwebde_rynodb");
if(isset($_GET['search']))
$search = $_GET['search'];
$query ="SELECT * FROM `spots`";
$result = mysql_query($query);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Database View</title>
</head>
<body>
<?php
while ($row=mysql_fetch_array($result, MYSQL_ASSOC)){
foreach($row as $key=>$value){
print "<b>$key:</b>
<table height= '5'> <tr><form name='form1' method='post' action='process.php'>
<input type='text' name='textfield' value='$value'> ";
}
print "<input type='submit' name='Submit' value='Submit'></tr></form></table><br>
<br/>";
}
?>
<p>
</p>
</body>
</html>Now basically what is happening here is that it is displaying all the records in editable form fields with a submit button after each complete record...simple right. Now is where I am stuck. When the user hit submit it goes to a page called "process.php" here is that page:
<?
$dbh=mysql_connect ("localhost", "blah", "blah") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("snmwebde_rynodb");
$category=$_POST{'category'};
$client=$_POST{'client'};
$keywords=$_POST{'keywords'};
$spot_name=$_POST{'spot_name'};
$thumbnail_name=$_POST{'thumbnail_name'};
$creation_date=$_POST{'creation_date'};
$series=$_POST{'series'};
$query = "insert into spots values
('$category','$client','$keywords','$spot_name','$thumbnail_name','$creation_date','$series')";
$result = mysql_query($query);
?>
Entry added!!<br>
To view database click <a href="viewdb.php">here</a>.Now I know I am wrong on this page for a few reasons. Its asking for all of those variables but I am not pulling any of those from the page before....also this is attempting to add a new record, not updating one that is already made. Any and all help will be greatly appreciated. Also on the "delete" part, any ideas would be great. Thanks guys