Advertisement
davidfcarr

Spreadsheet data import for WordPress

Sep 9th, 2012
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <?php
  2.  
  3. /*
  4. Plugin Name: My Hack
  5. */
  6.  
  7. function past_spreadsheet() {
  8.  
  9. //get global database object
  10. global $wpdb;
  11.  
  12. if($_POST["sheet"])
  13. {
  14. $lines = explode("\n",stripslashes($_POST["sheet"]) );
  15. foreach($lines as $line)
  16. {
  17. $cells = explode("\t",$line);
  18. //sprintf like function for formatting sql
  19. $sql = $wpdb->prepare("INSERT INTO my_custom_table col1=%s, col2=%s, col3=%s", $cells[0], $cells[1], $cells[2]);
  20. $wpdb->query($sql);
  21. }
  22. }
  23. else
  24. {
  25. ?>
  26. Paste Spreadsheet</p>
  27. <p><form method="post" action="roster.php"><textarea name="sheet"></textarea>
  28. <input type="submit" value="Submit" />
  29. </form>
  30. </p>
  31. <?php
  32. }
  33.  
  34. } // end paste spreadsheet function
  35.  
  36. function parts_menu() {
  37. add_menu_page('Paste Spreadsheet', 'Paste Spreadsheet', 1, 'paste_spreadsheet', 'paste_spreadsheet', '', 3); //add toplevel menu page
  38. }
  39.  
  40. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement