i'm working on a website for a youthgroup in nashville and i want them to be able to do the updating themselves. i've pulled together a mishmash of scripts from tutorials etc - and put together something that works - sometimes. it will always read the info from the database - and it usually updates current records - but it rarely adds new records.
here's what i've got written in (obviously aside from the usr/psswd etc.)
<?php
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("database",$db);
if ($submit) {
if ($id) {
$sql = "UPDATE programs SET day='$day',time='$time',info='$info',program='$program',ministry='$ministry',location='$location' WHERE id=$id";
} else {
$sql = "INSERT INTO programs (day,time,info,program,ministry,location) VALUES ('$day','$time','$info','$program','$ministry','$location')";
}
$result = mysql_query($sql);
echo "Programs updated<p>";
} elseif ($delete) {
$sql = "DELETE FROM programs WHERE id=$id";
$result = mysql_query($sql);
echo "Program deleted<p>";
} else {
if (!$id) {
$result = mysql_query("SELECT FROM programs ORDER by program ASC",$db);
printf("<table><tr><td><font face=verdana size=2>Current Programs</font><td><font face=verdana size=2>Action</font></td></tr>");
while ($myrow = mysql_fetch_array($result)) {
printf("<tr><td><font face=verdana size=2><a href=\"%s?id=%s\">%s (%s)</a> </font>\n", $PHP_SELF, $myrow["id"], $myrow["program"], $myrow["ministry"]);
printf("<td><font face=verdana size=2><a href=\"%s?id=%s&delete=yes\">DELETE</a></font></tr>", $PHP_SELF, $myrow["id"]);
}
printf("</table>");
}
?>
<P>
<a href="<?php echo $PHP_SELF?>">ADD A RECORD</a>
<P>
<form method="post" action="<?php echo $PHP_SELF?>">
<?php
if ($id) {
$sql = "SELECT FROM programs WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$id = $myrow["id"];
$day = $myrow["day"];
$time = $myrow["time"];
$info = $myrow["info"];
$program = $myrow["program"];
$ministry = $myrow["ministry"];
$location = $myrow["location"];
?>
<input type=hidden name="id" value="<?php echo $id ?>">
<?php
}
?>
<table>
<tr>
<Td height="21" valign="top"><font size="2" face="verdana">Ministry:</font></td>
<td><input type="Text" name="ministry" value="<?php echo $ministry ?>">
<font face="verdana" size="1"><br>
Options: middle school, high school, college, all ages, parents</font></td>
</tr>
<tr>
<Td width="84"><font face="verdana" size="2" align="right">Week Day:
</font></td>
<td width="360"><input type="Text" name="day" value="<?php echo $day ?>"></td>
</tr>
<tr>
<td><font face="verdana" size="2" align="right">Time: </font></td>
<td><input type="text" name="time" value="<?php echo $time ?>"></td>
</tr>
<tr>
<td><font face="verdana" size="2" align="right">Program: </font></td>
<td><input type="text" name="program" value="<?php echo $program ?>"></td>
</tr>
<tr>
<td><font face="verdana" size="2" align="right">Location: </font></td>
<td><input type="text" name="location" value="<?php echo $location ?>"></td>
</tr>
<tr>
<td valign="top"><font face="verdana" size="2" align="right">Info:
</font></td>
<td><textarea name="info" cols="40" rows="10"><?php echo $info ?></textarea></td>
</tr>
<tr>
<td></td>
<td><input type="Submit" name="submit" value="Enter information"></td>
</tr>
</table>
</form>
<?php
}
?>
