Warning: include(newIndogram/sma/localads.inc) [function.include]: failed to open stream: No such file or directory in /home/niranjan/public_html/indogram/index.html on line 67
Warning: include() [function.include]: Failed opening 'newIndogram/sma/localads.inc' for inclusion (include_path='.:/usr/lib/php') in /home/niranjan/public_html/indogram/index.html on line 67 Indogram - the global indian village in your neighborhood
<%@ page contentType="text/html; charset=iso-8859-1" language="java" %>
<%@ page import='java.util.*, java.sql.*, java.util.regex.*, java.text.SimpleDateFormat,javax.servlet.jsp.JspWriter' %>
<%@ include file='../basicevent.jsp' %>
<%!
Connection conn = null;
//int numRows = 0;
private void printTicketItem (JspWriter out, int eventID, String eventName, String dateString, String city, int eventType, int rowNum) throws Exception {
out.println ("\t");
out.println ("\t\t
");
}
%>
<%
// Connect to Database, verify password
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url, user, password);
PreparedStatement pstmt = conn.prepareStatement ("SELECT Distinct tblCalendar.ID,tblCalendar.EventName, tblCalendar.StartDate, tblCalendar.EventType FROM tblCalendar, ticket_categories WHERE tblCalendar.ID=ticket_categories.EventName and tblCalendar.StartDate>CURRENT_DATE and SiteID=? order by tblCalendar.StartDate");
String city="";
out.println ("
Want to sell tickets online to your events/movies? We make it easy. Click here
");
pstmt.setString (1, city = request.getParameter("city"));
ResultSet rs = pstmt.executeQuery();
int numRows = 0;
while (rs.next()) {
numRows++;
if (numRows == 1) {
// Print out table, etc.
out.println ("
");
out.println ("\t
Online Tickets
");
out.println ("\t
");
out.println ("\t\t
");
out.println ("Date");
out.println ("\t\t
");
out.println ("\t\t
");
out.println ("Event");
out.println ("\t\t
");
out.println ("\t\t
");
out.println ("Click To Buy");
out.println ("\t\t
");
out.println ("\t
");
}
int id = rs.getInt (1);
String eventName = rs.getString (2);
java.sql.Date eventDate = rs.getDate(3);
int eventType = rs.getInt(4);
java.text.DateFormat df = java.text.DateFormat.getDateInstance (java.text.DateFormat.MEDIUM);
String dateString = df.format (eventDate);
// Now, print out the stuff)
this.printTicketItem (out, id, eventName, dateString, city, eventType, numRows);
}
if (numRows>0) {
out.println ("
");
}
else
out.println ("
There are no tickets being sold online currently for this city.
