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
How could I do this?
Ive got a simple lottery game, and am using an sql database to keep track of the numbers bought. But
$variable = $variable
Hello
Sorry if this is a really simple question but I have run out of ideas. Is there a reall
for some reason mysql query not working, not inserting, please check it out
This code is not inserting anything into my db, don't know why, the $_SESSION variable does contain
how to insert value
I am having file bookissueadd.php..... in which i am having tag
<td height="21&q
Allegro crashes when running load_bitmap. Why?
I can not get Allegro to load any BMP images. Here is a section of test code. The picture is in the
PHP mail() rejected by SMTP
I'm currently working on a newsletter application which is installed on a windows 2003 server runnin
Open browser page depending on XML results
Hello,
I have some PHP code that sends webbased from data to an external url ( in the form of
how to easy edit text, with box? Help.
Hi.
I have a little problem. I'm doing a webpage for my aunt and I would like to make it as easy
type check while uploading
Hi Everyone,
How can I check the exact type of a file while uploading on my site?
Here
Request for tunning the below query
Hi,
Can any one help me on the below query while improving the performance,
