AT78YsXQ

1<?php 
2    /*
3      Plugin Name: Dropdown menu referral
4      Plugin URI: http://osvaldolopez.us/example
5      Description: collect referral data
6      Version: 1.0
7      Author: Osvaldo Lopez Negrete
8      Author URI: http://osvaldolopez.us    
9      License: MIT
10      Text Domain: wp-referral
11    */
12function createTable() {
13    global $wpdb;
14    $sql = "CREATE TABLE `wp-referral` (
15                id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
16                referral VARCHAR(30),
17                user_Id INT(11) NOT NULL)";
18    $wpdb->query($sql);
19    
20}
21function insertData() {
22    global $wpdb;
23    $user_id = get_current_user_id();
24    $referralinput = $_POST['referral'];
25    $sql = "INSERT INTO `wp-referral` (`referral`, `user_Id`) VALUES ( '".$referralinput. "', '".$user_id."')";
26    $wpdb->query($sql);
27}
28function checkTable() {
29    
30   // global $wpdb;
31    //$sql = "CREATE TABLE IF NOT EXISTS `wp-referra`";
32//    $checktable = $wpdb->query($sql);
33  //  if($checktable == 0) {
34    //    createTable();
35     //   insertData();
36    //} else {
37      //  insertData();
38    //}
39}
40if (isset($_POST['submit_referral'])) {
41    insertData();
42}
43function dh_modify_read_more_link() {
44
45    return '<form method="post">
46                <h1>How did you hear about us</h1>
47                  <select name="referral">
48                    <option value="GoogleSearch">Google Search</option>
49                    <option value="SocialMedia">Social Media</option>
50                    <option value="Friendorfamily">Friend or family</option>
51                    <option value="Other">Other</option>
52                  </select>
53                  <br>
54                  <br>
55                  <input type="submit" name="submit_referral">
56            </form>';
57    
58
59}
60
61add_filter( 'the_content_more_link', 'dh_modify_read_more_link' );
62?>