Probably a simple error...
Posted on
16th Feb 2014 07:03 pm by
admin
I'm getting the error -- Parse error: syntax error, unexpected '{' in /home/content/c/s/t/csteffen242/html/staples/event.php on line 46
I checked it over and couldn't find anything wrong with an extra bracket, but I could easily be missing something simple
Code: <html>
<head>
<title>Show/Add Events</title>
</head>
<body>
<h1>Show/Add Events</h1>
<?php
$mysqli = mysqli_connect ---
//add new event
if ($_POST) {
$m = $_POST["m"];
$d = $_POST["d"];
$y = $_POST["y"];
$event_date = $y."-".$m."-".$d." ".$_POST["event_time_hh"].":
".$_POST["event_time_mm"].":00";
$insEvent_sql = "INSERT INTO calendar_events (event_title, event_shortdesc, event_start) VALUES ('".$_POST["event_title"]."', '".$_POST["event_shortdesc"]."', '$event_date')";
$insEvent_res = mysqli_query($mysqli, $insEvent_sql) or die(mysqli_error($mysqli));
} else {
$m = $_GET["m"];
$d = $_GET["d"];
$y = $_GET["y"];
}
//show events
$getEvent_sql = "SELECT event_title, event_shortdesc, date_format(event_start, '%1:%i %p') as fmt_date FROM calendar_events WHERE month(event_start) = '".$m."' AND dayofmonth(event_start) = '".$d."' AND year(event_start)= '".$y."' ORDER BY event_start";
$getEvent_res = mysqli_query($mysqli, $getEvent_sql) or die(mysqli_error($mysqli));
if (mysqli_num_rows($getEvent_res) > 0) {
$event_txt = "<ul>";
while ($ev = @mysqli_fetch_array($getEvent_res)) {
$event_title = stripslashes($ev["event_title"]);
$fmt_date = $ev["fmt_date"];
$event_txt .= "<li><strong>".$fmt_date."</strong>:
".$event_title."</br>".$event_shortdesc."</li>";
}
$event_txt .= "</ul>";
mysqli_free_result($getEvent_res);
} else {
$event_txt = "";
}
mysqli_close($mysqli);
if ($event_txt != "" {
echo "<p><strong>Today's Events:</strong></p>
$event_txt
<hr/>";
}
//show form
echo "
<form method="post" action="".$_SERVER["PHP_SELF"]."">
<p><strong>Would you like to add an event?</strong><br/>
Complete the form below and press the submit button to add an event</p>
<p><strong>Event Title:</strong><br/>
<input type="text" name="event_title" size="25" maxlength="25" />
<p><strong>Event Title:</strong><br/>
<input type="text" name="event_shortdesc" size="25" maxlength="255" />
<p><strong>Event Time (hh:mm):</strong><br/>
<select name="event_time_hh">";
for ($x=1; $x <= 24; $x++) {echo "<option value="$x">$x</option>";
}
echo "</select> :
<select name="event_time_mm">
<option value="00">00</option>
<option value="00">15</option>
<option value="00">30</option>
<option value="00">45</option>
</select>
<input type="hidden" name="m" value="".$m."">
<input type="hidden" name="d" value="".$d."">
<input type="hidden" name="y" value="".$y."">
<br/><br/>
<input type="submit" name="submit" value="Add Event">
</form>";
?>
</body>
</html>
No comments posted yet
Your Answer:
Login to answer
283
41
Other forums
Tracking Unique Clicks
Hi guys and gals,
Basically I have a database which tracks clicks on my outbound links, I do
LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...
$result = mysql_query(&q
How to store checkbox array in a session, and then be able to add to it?
I'm trying to store an array of checkbox values into a session array, sort of like a shopping cart,
Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que
Newb advice
Hi all,
I'm a flash front end designer and I've taken on a project that needs some back end p
modifying a property of an object from a different class
I have 2 classes:
- Math
- Distance
in my math class, I have this line:
$distance =
Posting to another Site?
I have software that people install.
When they install it, is there a way to make it post their d
Stats of viewers
Hello. I have a website in php and people can login. I want to make an admin control panel where u c
Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to
$variable = $variable
Hello
Sorry if this is a really simple question but I have run out of ideas. Is there a reall