Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. function quote_install(){
  2. global $wpdb;
  3. global $quote_db_version;
  4. $table_name = $wpdb->prefix . 'quote';
  5.  
  6. // create sql your table
  7. $sql = "CREATE TABLE " . $table_name . " (
  8. ID int(11) NOT NULL AUTO_INCREMENT,
  9. time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  10. quote text NOT NULL,
  11. author text NOT NULL,
  12. qtag ENUM('G', 'W', 'Z', 'H', 'M') NOT NULL default 'G',
  13. PRIMARY KEY (ID)
  14. );";
  15.  
  16. require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
  17. dbDelta($sql); }
  18.  
  19. function read_single_Quote( $id=NULL ) {
  20. global $wpdb;
  21.  
  22. $table_name = $wpdb->prefix . 'quotes';
  23. // random select
  24. if($id ==NULL){
  25. $sql = $wpdb->prepare( "
  26. SELECT *
  27. FROM {$wpdb->prefix}'quotes'
  28. ORDER BY RAND()
  29. LIMIT 1
  30. ");
  31. } //get the row id = $id
  32. else {
  33. $sql = $wpdb->prepare( "
  34. SELECT *
  35. FROM {$wpdb->prefix}'quotes'
  36. WHERE ID = %d
  37. LIMIT 1
  38. ", $id );
  39. }
  40.  
  41. $result = $wpdb->get_results( $sql );
  42.  
  43. // databse error, return false
  44. if ( ! $result ) { return false; }
  45.  
  46. // return first result
  47. return $result[0];
  48.  
  49. $sql = $wpdb->prepare( "
  50. SELECT *
  51. FROM {$wpdb->prefix}quotes
  52. ORDER BY RAND()
  53. LIMIT 1
  54. ");
  55.  
  56. $sql = $wpdb->prepare( "
  57. SELECT *
  58. FROM {$wpdb->prefix}quotes
  59. WHERE ID = %d
  60. LIMIT 1
  61. ", $id );
  62.  
  63. $table_name = $wpdb->prefix . 'quotes';
  64.  
  65. $sql = $wpdb->prepare( "
  66. SELECT *
  67. FROM ".$table_name."
  68. ORDER BY RAND()
  69. LIMIT 1
  70. ");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement