Php insert a form multiple times into a database according to date
I have been trying to figure out how to insert a form multiple times into a database.
PHP Code:
<?
require_once( "config2.php" );
session_start ();
$db_connection = mysql_connect ( $DBHost , $DBUser , $DBPass ) OR die ( mysql_error ());
$db_select = mysql_select_db ( $DBName ) or die ( mysql_error ());
$cookie_read = explode ( "|" , base64_decode ( $user ));
//define variables to hold cookie values.
$username = $cookie_read [ 1 ];
$_POST [ 'submit' ]))
$db_table = $TBL_PR . "events" ;
$_POST [ 'description' ] = substr ( $_POST [ 'description' ], 0 , 500 );
$_POST [ 'title' ] = substr ( $_POST [ 'title' ], 0 , 30 );
$_POST [ 'username' ] as $row => $name )
$username = mysql_real_escape_string ( $name );
$day = mysql_real_escape_string ( $_POST [ 'day' ][ $row ]);
$month = mysql_real_escape_string ( $_POST [ 'month' ][ $row ]);
$year = mysql_real_escape_string ( $_POST [ 'year' ][ $row ]);
$hour = mysql_real_escape_string ( $_POST [ 'hour' ][ $row ]);
$minute = mysql_real_escape_string ( $_POST [ 'minute' ][ $row ]);
$title = mysql_real_escape_string ( $_POST [ 'title' ][ $row ]);
$description = mysql_real_escape_string ( $_POST [ 'description' ][ $row ]);
mysql_query ( "INSERT INTO $db_table ( `username`, `event_id` , `event_day` , `event_month` , `event_year` , `event_time` , `event_title` , `event_desc` ) VALUES ('" . addslashes ( $username ). "', '', '" . addslashes ( $day ). "', '" . addslashes ( $month ). "', '" . addslashes ( $year ). "', '" . addslashes ( $hour . ":" . $minute ). "', '" . addslashes ( $title ). "', '" . addslashes ( $description ). "')" ) or die( mysql_error ());
$_POST [ 'month' ] = $_POST [ 'month' ] + 1 ;
?>
<? echo $_POST [ 'month' ]. '&year=' . $_POST [ 'year' ]; ?> ',1);">
<?
}
?>
<? IF( $_GET [ 'month' ] == "1" ){ echo "selected" ; } ?> >01</option>
<? IF( $_GET [ 'month' ] == "2" ){ echo "selected" ; } ?> >02</option>
<? IF( $_GET [ 'month' ] == "3" ){ echo "selected" ; } ?> >03</option>
<? IF( $_GET [ 'month' ] == "4" ){ echo "selected" ; } ?> >04</option>
<? IF( $_GET [ 'month' ] == "5" ){ echo "selected" ; } ?> >05</option>
<? IF( $_GET [ 'month' ] == "6" ){ echo "selected" ; } ?> >06</option>
<? IF( $_GET [ 'month' ] == "7" ){ echo "selected" ; } ?> >07</option>
<? IF( $_GET [ 'month' ] == "8" ){ echo "selected" ; } ?> >08</option>
<? IF( $_GET [ 'month' ] == "9" ){ echo "selected" ; } ?> >09</option>
<? IF( $_GET [ 'month' ] == "10" ){ echo "selected" ; } ?> >10</option>
<? IF( $_GET [ 'month' ] == "11" ){ echo "selected" ; } ?> >11</option>
<? IF( $_GET [ 'month' ] == "12" ){ echo "selected" ; } ?> >12</option>
<?
function getmicrotime (){
$usec , $sec ) = explode ( " " , microtime ());
$usec + (float) $sec );
$time_start = getmicrotime ();
$_GET [ 'year' ])){
$_GET [ 'year' ] = date ( "Y" );
$_GET [ 'month' ])){
$_GET [ 'month' ] = date ( "n" )+ 1 ;
$month = addslashes ( $_GET [ 'month' ] - 1 );
$year = addslashes ( $_GET [ 'year' ]);
$todays_date = date ( "j" );
$todays_month = date ( "n" );
$days_in_month = date ( "t" , mktime ( 0 , 0 , 0 , $_GET [ 'month' ], 0 , $_GET [ 'year' ]));
$first_day_of_month = date ( "w" , mktime ( 0 , 0 , 0 , $_GET [ 'month' ]- 1 , 1 , $_GET [ 'year' ]));
$first_day_of_month = $first_day_of_month + 1 ;
$count_boxes = 0 ;
$days_so_far = 0 ;
$_GET [ 'month' ] == 13 ){
$next_month = 2 ;
$next_year = $_GET [ 'year' ] + 1 ;
$next_month = $_GET [ 'month' ] + 1 ;
$next_year = $_GET [ 'year' ];
$_GET [ 'month' ] == 2 ){
$prev_month = 13 ;
$prev_year = $_GET [ 'year' ] - 1 ;
$prev_month = $_GET [ 'month' ] - 1 ;
$prev_year = $_GET [ 'year' ];
?>
<center>
<?
for ( $i = 1 ; $i <= $first_day_of_month - 1 ; $i ++) {
$days_so_far = $days_so_far + 1 ;
$count_boxes = $count_boxes + 1 ;
"<td width=\"45\" height=\"20\" class=\"beforedayboxes\" bgcolor=\" $table \"></td>\n" ;
$i = 1 ; $i <= $days_in_month ; $i ++) {
$days_so_far = $days_so_far + 1 ;
$count_boxes = $count_boxes + 1 ;
$_GET [ 'month' ] == $todays_month + 1 ){
$i == $todays_date ){
$class = "highlighteddayboxes" ;
$class = "dayboxes" ;
$i == 1 ){
$class = "highlighteddayboxes" ;
$class = "dayboxes" ;
"<td width=\"45\" height=\"20\" class=\" $class \">\n" ;
$link_month = $_GET [ 'month' ] - 1 ;
"<div align=\"right\"><span class=\"toprightnumber\">\n $i <input type=\"checkbox\" name=\"checkbox[]\" value=\" $i \"> </span></div>\n" ;
"</td>\n" ;
$count_boxes == 7 ) AND ( $days_so_far != (( $first_day_of_month - 1 ) + $days_in_month ))){
$count_boxes = 0 ;
"</TR><TR valign=\"top\">\n" ;
$extra_boxes = 7 - $count_boxes ;
$i = 1 ; $i <= $extra_boxes ; $i ++) {
"<td class=\"afterdayboxes\"></td>\n" ;
$time_end = getmicrotime ();
$time = round ( $time_end - $time_start , 3 );
?>
</tr>
<? IF( $_GET [ 'year' ] == "2008" ){ echo "selected" ; } ?> >2008</option>
<? IF( $_GET [ 'year' ] == "2009" ){ echo "selected" ; } ?> >2009</option>
<? IF( $_GET [ 'year' ] == "2010" ){ echo "selected" ; } ?> >2010</option>
<? IF( $_GET [ 'year' ] == "2011" ){ echo "selected" ; } ?> >2011</option>
<? IF( $_GET [ 'year' ] == "2012" ){ echo "selected" ; } ?> >2012</option>
<?
}
?>
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Reply With Quote
Bookmarks