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 do I get the row number from from an sql table query
Hi all
I have a table that I query and it returns a number of rows.
mysql_num_rows($query)
The IE or FF detector
Hello Friends,
Problem of today ( we seek for php help ) as following ,
we know all th
using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto
Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.
Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h
Displaying Site Logo/Icon on a Title tag
really need some help out here. I want to insert a Logo/Icon just like the one close to the "PH
Mouseover to edit (Ajax)
hi friends, can anyone help with the code behind to get this application working, please in VB (new
php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat
Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
In the html page one text box
Menu restriction
How can I restrict the individual menu that would appear when a user logs in so that all users are c
