mricketts
-
Posts
3 -
Joined
-
Last visited
mricketts's Achievements
Newbie (1/5)
0
Reputation
-
I changed web hosting companies and now a php form that was working is no longer working. I haven't been able to figure out what the problem is. The form is a simple text input form that adds the text to a database. Every time the user inserts text with a comma, an error occurs. Below is the code for the form. Any help is much appreciated. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <?php require_once('inc/header.html'); ?> <?php require_once('../Connections/websitedatabase.php'); ?> <?php if (isset($_POST['note'])): $note = $_POST['note']; $name = $_POST['name']; $id = $_POST['id']; $sql = "UPDATE presidentnotes SET note='$note', name='$name' "; if (@mysql_query($sql)) { echo '<p>The note has been updated.</p>'; } else { echo '<p>Error updating note. Details: ' . mysql_error() . '</p>'; } ?> <?php else: $presidentnotes = @mysql_query( "SELECT note, name FROM presidentnotes "); if (!$presidentnotes) { exit('<p>Error fetching note details: ' . mysql_error() . '</p>'); } $presidentnotes = mysql_fetch_array($presidentnotes); $note = $presidentnotes['note']; $name = $presidentnotes['name']; $note = mysql_real_escape_string($note); $name = mysql_real_escape_string($name); ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <h1>President's Note on hompage - Edit5</h1> <label>Note:<br /> <textarea name="note" cols="100" rows="12"><?php echo $note; ?></textarea> </label><br /> <label>Name:<br /> <input name="name" type="text" value="<?php echo $name; ?>" size="40" /></label><br /> <input type="hidden" name="id" value="<?php echo $id; ?>" /> <input type="submit" value="SUBMIT" /></p> </form> <p> <?php endif; ?> <p> </p> </body> </html>
-
Thanks everyone. I got it working. I ended up creating a new table with a DATE filed and using the following code: $result = @mysql_query("SELECT id, date, event FROM eventscalendar WHERE MONTH(date) BETWEEN MONTH(CURDATE()) AND MONTH(CURDATE())+1");
-
I have a mysql database set up with 4 fields - id, month, day, event. The database will be filled with something like: month=Jan, day=4 and event=Meeting. All are text fields. The display will be Jan. 4: Meeting I can set up the PHP to display the database in a unordered list. The code for this is: <?php $result = @mysql_query("SELECT id, month, day, event FROM homecalendar"); if (!$result) { exit('<p>Error performing query: ' . mysql_error() . '</p>'); } while ($row = mysql_fetch_array($result)) { echo '<li>' . $row['month'] . $row['day'] .': ' . $row['event'] . '</li>' ; } ?> How can I limit the code to display items for only the current month and the next month?