Hi,
I have a PHP script that I wrote several months ago which allows a user to
enter information into a MySQL database through a basic web form - it
worked very well. However, since then I had a system crash - luckily I
made a backup of the script days before the crash.
My problem is, that now the script generates errors which were not present
before. I've gone over it twice, even re-coded it just now, and still I
get the same errors.
Currently, I am using Win2k Pro, MySQL 3.23.33 and PHP4.0.4pl1 installed as
CGI.
Interestingly, when I try to run this script on my RH7.0 Linux box with
MySQL 3.22.32 and PHP3.0.18 it does not generate these errors. I have this
system setup with older versions of MySQL and PHP as those are the versions
that my hosting service uses.
Could someone please look over my code and tell me where I'm going wrong??
Thank you
-Tim
The errors I get are as follows:
Warning: Undefined variable: submit in index.php3 on line 17
Warning: Undefined variable: delete in index.php3 on line 37
Warning: Undefined variable: id in index.php3 on line 51
Warning: Undefined variable: id in
E:\WebPages\2001\AtikokanInfo\Web\www.atikokaninfo.com\htdocs\aedc\comcal\mcx\webmonkey.php3
on line 83
Here is the script which I am attempting to use:
<html>
<body>
<?php
$db = mysql_connect("localhost", "user", "passwd");
mysql_select_db("edoinfo",$db);
if ($submit) {
// here if no ID then adding else we're editing
if ($id) {
$sql = "UPDATE comcal001 SET
eventCategory='$eventCategory',eventName='$eventName',eventLocation='$eventLocation',eventCity='$eventCity',eventState='$eventState',eventCountry='$eventCountry',eventTime='$eventTime',eventAMPM='$eventAMPM',eventDuration='$eventDuration',eventMonth='$eventMonth',eventDay='$eventDay',eventDate='$eventDate',eventYear='$eventYear',eventC1Fname='$eventC1Fname',eventC1Lname='$eventC1Lname',eventC2Fname='$eventC2Fname',eventC2Lname='$eventC2Lname',eventACphone='$eventACphone',eventPhone='$eventPhone',eventACfax='$eventACfax',eventFax='$eventFax',eventACcell='$eventACcell',eventCell='$eventCell',eventEmail='$eventEmail',eventWeb='$eventWeb',eventDetails='$eventDetails',entryDate='$entryDate'
WHERE id=$id";
} else {
$sql = "INSERT INTO comcal001
(eventCategory,eventName,eventLocation,eventCity,eventState,eventCountry,eventTime,eventAMPM,eventDuration,eventMonth,eventDay,eventDate,eventYear,eventC1Fname,eventC1Lname,eventC2Fname,eventC2Lname,eventACphone,eventPhone,eventACfax,eventFax,eventACcell,eventCell,eventEmail,eventWeb,eventDetails,entryDate)
VALUES
('$eventCategory','$eventName','$eventLocation','$eventCity''$eventState','$eventCountry','$eventTime','$eventAMPM','$eventDuration','$eventMonth','$eventDay','$eventDate','$eventYear','$eventC1Fname','$eventC1Lname','$eventC2Fname','$eventC2Lname','$eventACphone','$eventPhone','$eventACfax','$eventFax','$eventACcell','$eventCell','$eventEmail','$eventWeb','$eventDetails','$entryDate')";
}
// run SQL against the DB
$result = mysql_query($sql);
echo "Record updated/edited!<p>";
} elseif ($delete) {
// delete a record
$sql = "DELETE FROM comcal001 WHERE id=$id";
$result = mysql_query($sql);
echo "$sql Record deleted!<p>";
} else {
// this part happens if we don't press submit
if (!$id) {
// print the list if there is not editing
$result = mysql_query("SELECT * FROM comcal001",$db);
while ($myrow = mysql_fetch_array($result)) {
printf("<a href=\"%s?id=%s\">%s %s</a> \n", $PHP_SELF, $myrow["id"],
$myrow["eventCategory"], $myrow["eventName"]);
printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a><br>",
$PHP_SELF, $myrow["id"]);
}
}
?>
<P>
<a href="<?php echo $PHP_SELF?>">ADD A RECORD</a>
<P>
<form method="post" action="<?php echo $PHP_SELF?>">
<?php
if ($id) {
// editing so select a record
$sql = "SELECT * FROM comcal001 WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$id = $myrow["id"];
$eventCategory = $myrow["eventCategory"];
$eventName = $myrow["eventName"];
$eventLocation = $myrow["eventLocation"];
$eventCity = $myrow["eventCity"];
$eventState = $myrow["eventState"];
$eventCountry = $myrow["eventCountry"];
$eventTime = $myrow["eventTime"];
$eventAMPM = $myrow["eventAMPM"];
$eventDuration = $myrow["eventDuration"];
$eventMonth = $myrow["eventMonth"];
$eventDay = $myrow["eventDay"];
$eventDate = $myrow["eventDate"];
$eventYear = $myrow["eventYear"];
$eventC1Fname = $myrow["eventC1Fname"];
$eventC1Lname = $myrow["eventC1Lname"];
$eventC2Fname = $myrow["eventC2Fname"];
$eventACphone = $myrow["eventACphone"];
$eventPhone = $myrow["eventPhone"];
$eventACfax = $myrow["eventACfax"];
$eventFax = $myrow["eventFax"];
$eventACcell = $myrow["eventACcell"];
$eventCell = $myrow["eventCell"];
$eventEmail = $myrow["eventEmail"];
$eventWeb = $myrow["eventWeb"];
$eventDetails = $myrow["eventDetails"];
$entryDate = $myrow["entryDate"];
// print the id for editing
?>
<input type=hidden name="id" value="<?php echo $id ?>">
<?php
}
?>
Category: <input type="Text" name="eventCategory" value="<?php echo
$eventCategory ?>"><br>
Event Name: <input type="Text" name="eventName" value="<?php echo
$eventName ?>"><br>
Location: <input type="Text" name="eventLocation" value="<?php echo
$eventLocation ?>"><br>
City: <input type="Text" name="eventCity" value="<?php echo $eventCity
?>"><br>
State: <input type="Text" name="eventState" value="<?php echo
$eventState ?>"><br>
Country: <input type="Text" name="eventCountry" value="<?php echo
$eventCountry ?>"><br>
Time: <input type="Text" name="eventTime" value="<?php echo $eventTime
?>"><br>
AM/PM: <input type="Text" name="eventAMPM" value="<?php echo $eventAMPM
?>"><br>
Duration: <input type="Text" name="eventDuration" value="<?php echo
$eventDuration ?>"><br>
Month: <input type="Text" name="eventMonth" value="<?php echo
$eventMonth ?>"><br>
Day: <input type="Text" name="eventDay" value="<?php echo $eventDay ?>"><br>
Date: <input type="Text" name="eventDate" value="<?php echo $eventDate
?>"><br>
Year: <input type="Text" name="eventYear" value="<?php echo $eventYear
?>"><br>
Contact 1 First Name: <input type="Text" name="eventC1Fname"
value="<?php echo $eventC1Fname ?>"><br>
Contact 1 Last Name: <input type="Text" name="eventC1Lname" value="<?php
echo $eventC1Lname ?>"><br>
Contact 2 First Name: <input type="Text" name="eventC2Fname"
value="<?php echo $eventC2Fname ?>"><br>
Contact 2 Last Name: <input type="Text" name="eventC2Lname" value="<?php
echo $eventC2Lname ?>"><br>
Phone: (<input type="Text" name="eventACphone" value="<?php echo
$eventACphone ?>">) <input type="Text" name="eventPhone" value="<?php echo
$eventPhone ?>"><br>
Fax: (<input type="Text" name="eventACfax" value="<?php echo $eventACfax
?>">) <input type="Text" name="eventFax" value="<?php echo $eventFax ?>"><br>
Cell: (<input type="Text" name="eventACcell" value="<?php echo
$eventACcell ?>">) <input type="Text" name="eventCell" value="<?php echo
$eventCell ?>"><br>
Email: <input type="Text" name="eventEmail" value="<?php echo
$eventEmail ?>"><br>
Web: <input type="Text" name="eventWeb" value="<?php echo $eventWeb ?>"><br>
Details: <input type="Text" name="eventDetails" value="<?php echo
$eventDetails ?>"><br>
Entry Date: <input type="Text" name="entryDate" value="<?php echo
$entryDate ?>"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
}
?>
</body>
</html>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
