prefix . "aps_book";
//make sure there is a save name, if not create one from book name and rand, if no book name create one from word book_ and random.
$aps_savename_name = $_POST['aps_book_save_name'];
$aps_savenname_bookname = $_POST['aps_book_name'];
if( $aps_savename_name == '' && $aps_savenname_bookname !== '' ) { $aps_savename_check = $aps_savenname_bookname . '_' . rand(); }
elseif( $aps_savename_name == '' && $aps_savenname_bookname == '' ) { $aps_savename_check = 'book_' . rand(); }
else { $aps_savename_check = $aps_savename_name;}
$aps_convert_datez = $_POST['aps_book_pub_date'];
$aps_convert_datez = aps_convert_date($aps_convert_datez);
$aps_does_schema_exist = $wpdb->get_row("SELECT * FROM $tblname WHERE book_save_name = '$aps_savename_check'");
//var_dump($aps_does_schema_exist);
$aps_book_data = array (
//'book_id' => $_POST['aps_book_id'], // this inst needed
'book_name' => $_POST['aps_book_name'],
'book_url' => $_POST['aps_book_website'],
'book_desc' => $_POST['aps_book_description'],
'book_author' => $_POST['aps_book_author'],
'book_publisher' => $_POST['aps_book_publisher'],
'book_pub_date' => $aps_convert_datez,
//'book_pub_date' => $_POST['aps_book_pub_date'],
'book_edition' => $_POST['aps_book_edition'],
'book_isbn' => $_POST['aps_book_isbn'],
'book_format' => $_POST['apschema_book_schema_format'],
'book_genre' => $_POST['apschema_book_schema_genre'],
'book_review_by' => $_POST['aps_book_review_by'],
'book_save_name' => $aps_savename_check
);
//if the savename exists - update the row
if($aps_does_schema_exist !== NULL ) {
$wpdb->update(
$tblname,
$aps_book_data,
array(
'book_save_name' => $aps_savename_check
));
}
//if it doesnt exist add a new row.
elseif ($aps_does_schema_exist == NULL ) {
$wpdb->insert( $tblname,
$aps_book_data
);
}
echo aps_save_success();
} else { }
function aps_save_update_schema2222222($tblname, $schema_data, $schema_name) {
$aps_the_data = $_POST['schema_data'];
$aps_the_data = json_decode($aps_the_data, true);
$aps_data_array = array();
foreach ($aps_the_data as $itemz) {
$aps_data_array = json_decode($itemz, true);
}
$aps_the_table_name = $wpdb->prefix . $_POST['table_name'];
$aps_convert_datez = $_POST['aps_book_pub_date'];
$aps_convert_datez = aps_convert_date($aps_convert_datez);
$aps_does_schema_exist = $wpdb->get_row("SELECT * FROM $tblname WHERE book_save_name = '$aps_savename_check'");
//var_dump($aps_does_schema_exist);
$aps_book_data = array (
//'book_id' => $_POST['aps_book_id'], // this inst needed
'book_name' => $_POST['aps_book_name'],
'book_url' => $_POST['aps_book_website'],
'book_desc' => $_POST['aps_book_description'],
'book_author' => $_POST['aps_book_author'],
'book_publisher' => $_POST['aps_book_publisher'],
'book_pub_date' => $aps_convert_datez,
//'book_pub_date' => $_POST['aps_book_pub_date'],
'book_edition' => $_POST['aps_book_edition'],
'book_isbn' => $_POST['aps_book_isbn'],
'book_format' => $_POST['apschema_book_schema_format'],
'book_genre' => $_POST['apschema_book_schema_genre'],
'book_review_by' => $_POST['aps_book_review_by'],
'book_save_name' => $aps_savename_check
);
//if the savename exists - update the row
if($aps_does_schema_exist !== NULL ) {
$wpdb->update(
$tblname,
$aps_book_data,
array(
'book_save_name' => $aps_savename_check
));
}
//if it doesnt exist add a new row.
elseif ($aps_does_schema_exist == NULL ) {
$wpdb->insert( $tblname,
$aps_book_data
);
}
//echo aps_save_success();
else { }
} // end function aps_save_update_schema
?>
prefix . "aps_event";
//make sure there is a save name, if not create one from event name and rand, if no event name create one from word event_ and random.
$aps_savename_name = $_POST['aps_event_save_name'];
$aps_savenname_eventname = $_POST['aps_event_name'];
if( $aps_savename_name == '' && $aps_savenname_eventname !== '' ) { $aps_savename_check = $aps_savenname_eventname . '_' . rand(); }
elseif( $aps_savename_name == '' && $aps_savenname_eventname == '' ) { $aps_savename_check = 'event_' . rand(); }
else { $aps_savename_check = $aps_savename_name;}
$aps_does_schema_exist = $wpdb->get_row("SELECT * FROM $tblname WHERE event_save_name = '$aps_savename_check'");
//var_dump($aps_does_schema_exist);
//if the savename exists - update the row
if($aps_does_schema_exist !== NULL ) {
$wpdb->update(
$tblname,
array(
'event_id' => $_POST['aps_event_id'],
'event_type' => $_POST['aps_event_schema_event_type'],
'event_name' => $_POST['aps_event_name'],
'event_url' => $_POST['aps_event_website'],
'event_desc' => $_POST['aps_event_description'],
'event_start_date' => $_POST['aps_event_start_date'],
'event_end_date' => $_POST['aps_event_end_date'],
'event_start_time' => $_POST['aps_event_start_time'],
'event_end_time' => $_POST['aps_event_end_time'],
'event_duration' => $_POST['aps_event_duration'],
'event_address' => $_POST['aps_event_address'],
'event_pobox' => $_POST['aps_event_pobox'],
'event_city' => $_POST['aps_event_city'],
'event_region' => $_POST['aps_event_state_region'],
'event_postalcode' => $_POST['aps_event_postal_code'],
'event_country' => $_POST['aps_event_country'],
'event_email' => $_POST['aps_event_email'],
'event_phone' => $_POST['aps_event_telephone'],
'event_review_by' => $_POST['aps_event_review_by'],
'event_save_name' => $aps_savename_check ),
array(
'event_save_name' => $aps_savename_check
));
}
//if it doesnt exist add a new row.
elseif ($aps_does_schema_exist == NULL ) {
$wpdb->insert( $tblname, array(
'event_id' => $_POST['aps_event_id'],
'event_type' => $_POST['aps_event_schema_event_type'],
'event_name' => $_POST['aps_event_name'],
'event_url' => $_POST['aps_event_website'],
'event_desc' => $_POST['aps_event_description'],
'event_start_date' => $_POST['aps_event_start_date'],
'event_end_date' => $_POST['aps_event_end_date'],
'event_start_time' => $_POST['aps_event_start_time'],
'event_end_time' => $_POST['aps_event_end_time'],
'event_duration' => $_POST['aps_event_duration'],
'event_address' => $_POST['aps_event_address'],
'event_pobox' => $_POST['aps_event_pobox'],
'event_city' => $_POST['aps_event_city'],
'event_region' => $_POST['aps_event_state_region'],
'event_postalcode' => $_POST['aps_event_postal_code'],
'event_country' => $_POST['aps_event_country'],
'event_email' => $_POST['aps_event_email'],
'event_phone' => $_POST['aps_event_telephone'],
'event_review_by' => $_POST['aps_event_review_by'],
'event_save_name' => $aps_savename_check ));
}
echo aps_save_success();
} else { }
?>
prefix . "aps_movie";
//make sure there is a save name, if not create one from movie name and rand, if no movie name create one from word movie_ and random.
$aps_savename_name = $_POST['aps_movie_save_name'];
$aps_savename_moviename = $_POST['aps_movie_name'];
if( $aps_savename_name == '' && $aps_savename_moviename !== '' ) { $aps_savename_check = $aps_savename_moviename . '_' . rand(); }
elseif( $aps_savename_name == '' && $aps_savename_moviename == '' ) { $aps_savename_check = 'movie_' . rand(); }
else { $aps_savename_check = $aps_savename_name;}
$wpdb->insert( $tblname, array(
'movie_id' => $_POST['aps_movie_id'],
'movie_name' => $_POST['aps_movie_name'],
'movie_url' => $_POST['aps_movie_website'],
'movie_desc' => $_POST['aps_movie_description'],
'movie_director' => $_POST['aps_movie_director'],
'movie_producer' => $_POST['aps_movie_producer'],
'movie_actors' => $_POST['aps_movie_actors'],
'movie_review_by' => $_POST['aps_movie_review_by'],
'movie_save_name' => $aps_savename_check ));
echo aps_save_success();
} else { }
?>
 . ')
';
echo '