Re: I don't get it ... suddenly my script doesn't work ...

Check your error report settings. When you refer to something like $id as: if ($id)... PHP will throw a warning that $id isn't set. It's a nice debugging feature, but a pain in the arse otherwise. The problem is PHP now has a higher error level for some reason, so just nock it down to normal. -- Plutarck Should be working on something... ...but forgot what it was. "Tim Thorburn" <webadmin@athydro.com> wrote in message news:5.1.0.14.0.20010420222710.00ae9f40@pop.athydro.com... > 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\mc x\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='$eventL ocation',eventCity='$eventCity',eventState='$eventState',eventCountry='$even tCountry',eventTime='$eventTime',eventAMPM='$eventAMPM',eventDuration='$even tDuration',eventMonth='$eventMonth',eventDay='$eventDay',eventDate='$eventDa te',eventYear='$eventYear',eventC1Fname='$eventC1Fname',eventC1Lname='$event C1Lname',eventC2Fname='$eventC2Fname',eventC2Lname='$eventC2Lname',eventACph one='$eventACphone',eventPhone='$eventPhone',eventACfax='$eventACfax',eventF ax='$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,eve ntTime,eventAMPM,eventDuration,eventMonth,eventDay,eventDate,eventYear,event C1Fname,eventC1Lname,eventC2Fname,eventC2Lname,eventACphone,eventPhone,event ACfax,eventFax,eventACcell,eventCell,eventEmail,eventWeb,eventDetails,entryD ate) > VALUES > ('$eventCategory','$eventName','$eventLocation','$eventCity''$eventState','$ eventCountry','$eventTime','$eventAMPM','$eventDuration','$eventMonth','$eve ntDay','$eventDate','$eventYear','$eventC1Fname','$eventC1Lname','$eventC2Fn ame','$eventC2Lname','$eventACphone','$eventPhone','$eventACfax','$eventFax' ,'$eventACcell','$eventCell','$eventEmail','$eventWeb','$eventDetails','$ent ryDate')"; > > } > > // 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >