Front end posting with extra tables MySQL
-
Hello,
So what im working on is a front end posting for a Facebook app. The problem I’m having is that i have to tie the facebook id and accesstoken to the post so i can retrive it later. I’ve managed to get the access_token and the user_id. The problem I’m having is that it seams like it doesn’t want to post it to my database.
This is what my code looks like.
<?php /* Template Name: Febuary Love */ if( 'POST' == $_SERVER['REQUEST_METHOD'] && !empty( $_POST['action'] ) && $_POST['action'] == "new_post") { // Do some minor form validation to make sure there is content if (isset ($_POST['title'])) { $title = $_POST['title']; } else { echo 'Please enter the Poem name'; } if (isset ($_POST['description'])) { $description = $_POST['description']; } else { echo 'Please enter some notes'; } $tags = $_POST['post_tags']; // ADD THE FORM INPUT TO $new_post ARRAY $new_post = array( 'post_title' => $title, 'post_content' => $description, 'post_category' => array($_POST['cat']), // Usable for custom taxonomies too 'tags_input' => array($tags), 'post_status' => 'draft', // Choose: publish, preview, future, draft, etc. 'post_type' => 'post', //'post',page' or use a custom post type if you want to 'post_author' => $user, 'access_token' => $access_token, ); //SAVE THE POST $pid = wp_insert_post($new_post); //SET OUR TAGS UP PROPERLY wp_set_post_tags($pid, $_POST['post_tags']); //REDIRECT TO THE NEW POST ON SAVE $link = get_permalink( $pid ); wp_redirect( $link ); } // END THE IF STATEMENT THAT STARTED THE WHOLE FORM //POST THE POST YO do_action('wp_insert_post', 'wp_insert_post'); get_header(); ?> <?php add_filter('fb_php_sdk_load','your_filter'); function your_filter($array) { $array[] = '2.1.2'; //exact version number you need return $array; } $facebook = new Facebook(array( 'appId' => '$app_id', 'secret' => '$app_secret', 'cookie' => true, )); $session = $facebook->getUser(); if (!empty($session)) { try{ $user = $facebook->getUser(); $user = $facebook->api('/me'); print_r($user); } catch (Exception $e){ } if (!empty($user)) { echo "hello"; } else die ("An error occured"); } else{ $loginUrl = $facebook->getLoginUrl(array( 'canvas' => 1, 'fbconnect' => 0, 'scope' => 'offline_access, publish_stream' )); echo "<a href='".$loginUrl."'>Click </a> to add the Copypanther Facebook application"; } ?> <?php $user = $facebook->getUser(); if($user){ $access_token = $facebook->getAccessToken(); print_r($access_token); } ?> <div id="container"> <div id="content" role="main"> <?php if ( have_posts() ) while ( have_posts() ) : the_post(); ?> <div id="post-<?php the_ID(); ?>" <?php post_class(); ?>> <?php if ( is_front_page() ) { ?> <h2 class="entry-title"><?php the_title(); ?></h2> <?php } else { ?> <h1 class="entry-title"><?php the_title(); ?></h1> <?php } ?> <div class="form-content"> <?php the_content(); ?> <!-- WINE RATING FORM --> <div class="wpcf7"> <form id="new_post" name="new_post" method="post" action="" class="wpcf7-form" enctype="multipart/form-data"> <!-- post name --> <fieldset name="name"> <label for="title">Love poem name:</label> <input type="text" id="title" value="" tabindex="5" name="title" /> </fieldset> <!-- post Category --> <fieldset class="category"> <label for="cat">Translate to:</label> <?php wp_dropdown_categories( 'tab_index=10&taxonomy=category&hide_empty=0' ); ?> </fieldset> <!-- post Content --> <fieldset class="content"> <label for="description">Love poem:</label> <textarea id="description" tabindex="15" name="description" cols="80" rows="10"></textarea> </fieldset> <!-- post tags --> <fieldset class="tags"> <label for="post_tags">Keywords (comma separated):</label> <input type="text" value="" tabindex="35" name="post_tags" id="post_tags" /> </fieldset> <fieldset class="submit"> <input type="submit" value="Send" tabindex="40" id="submit" name="submit" /> </fieldset> <input type="hidden" name="action" value="new_post" /> <?php wp_nonce_field( 'new-post' ); ?> </form> </div> <!-- END WPCF7 --> <?php wp_link_pages( array( 'before' => '<div class="page-link">' . __( 'Pages:', 'twentyten' ), 'after' => '</div>' ) ); ?> <?php edit_post_link( __( 'Edit', 'twentyten' ), '<span class="edit-link">', '</span>' ); ?> </div><!-- .entry-content --> </div><!-- #post-## --> <?php endwhile; // end of the loop. ?> </div><!-- #content --> </div><!-- #container --> <?php get_footer(); ?>
What i need to post is the $access_token and $user. They look like this:
$user:
Array ( [id] => xxxxxxx [name] => xxx xxxxx [first_name] => xxxxxx [last_name] => xxxxxx [link] => https://www.facebook.com/xxxxxxx%5Busername%5D => xxxxxxxx [hometown] => Array ( [id] => xxxxxxxxx [name] => xxxxxxxx, xxxxxx ) [location] => Array ( [id] => xxxxxxxxx [name] => xxxxxxxx, xxxxxxxx ) [bio] => Lost like always! [work] => Array ( [0] => Array ( [employer] => Array ( [id] => xxxxxx [name] => NGee ) [location] => Array ( [id] => xxxxxxxxxxx [name] => xxxxxxxx, xxxxxxxx ) [position] => Array ( [id] => xxxxxxxxx [name] => Owner, CEO ) [start_date] => 2010-01 ) ) [education] => Array ( [0] => Array ( [school] => Array ( [id] => 111487752200798 [name] => xxxxxxxxxxx) [year] => Array ( [id] => xxxxxxx [name] => xxxxxxx ) [type] => xxxxxxxxx ) [1] => Array ( [school] => Array ( [id] => 124099044279792 [name] => xxxxxxxx ) [year] => Array ( [id] => xxxxxxx [name] => 2010 ) [type] => College ) ) [gender] => male [timezone] => 1 [locale] => en_US [verified] => 1 [updated_time] => 2011-12-06T11:35:49+0000 ) hello
and the $access_token:
AAAEEh9vZCO3MBAHdRlbkZBCvMHbFy05oyc8E29LhEk5QBJWCavpz68IC4A7gZCGrR6mICXkn4SZA81ZACXaasXZtfeEtBePEg8b7iWZB1bquZCwZDZDThe thing is that as I understand it I need to save it in wp_post to tie it the the post.
So question is simple.
How to i post this information to DB / MySQL table wp_post?
Thanks for taking time to look at this.
Best Regards
GrundeLL
- The topic ‘Front end posting with extra tables MySQL’ is closed to new replies.