Title: Plugin development – Database error (Fatal error: Call to a member function..)
Last modified: August 31, 2016

---

# Plugin development – Database error (Fatal error: Call to a member function..)

 *  [dsman](https://wordpress.org/support/users/dsman/)
 * (@dsman)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/plugin-development-database-error/)
 * Hello WordPress community,
    I’m currently developing Star Rating plugin and I
   get the following error: “ <b>Fatal error</b>: Call to a member function fetch_assoc()
   on a non-object in <b>C:\Users\User\Dropbox\XAMPP\htdocs\events\wp-content\plugins\
   review-plugin\inc\data-processing.php</b> on line <b>45</b>” when I try to save
   data in database.
 * I’m new in plugin development, please help me resolve this issue.
 * Thanks!
 * Here is my front-end code:
 *     ```
       $post_rating = "
       			 <fieldset id='demo1' class='rating'>
                               <input class='stars' type='radio' id='star5' name='rating' value='5' />
                               <label class = 'full' for='star5' title='Awesome - 5 stars'></label>
                               <input class='stars' type='radio' id='star4' name='rating' value='4' />
                               <label class = 'full' for='star4' title='Pretty good - 4 stars'></label>
                               <input class='stars' type='radio' id='star3' name='rating' value='3' />
                               <label class = 'full' for='star3' title='Meh - 3 stars'></label>
                               <input class='stars' type='radio' id='star2' name='rating' value='2' />
                               <label class = 'full' for='star2' title='Kinda bad - 2 stars'></label>
                               <input class='stars' type='radio' id='star1' name='rating' value='1' />
                               <label class = 'full' for='star1' title='Sucks big time - 1 star'></label>
   
                           </fieldset>
   
                         <script src='https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js'></script>
                           <script>
       					    $('.stars').click(function () {
   
       					        $.post('localhost/events/wp-content/plugins/review-plugin/inc/data-processing.php',{rate:$(this).val()},function(d){
       					        	console.log(d, 'here');
       					            if(d>0)
       					            {
       					                alert('You already rated');
       					            }else{
       					                alert('Thanks For Rating');
       					            }
       					        });
       					        $(this).attr('checked');
       					    });
                           </script>
   
       		";
       ```
   
 * (jQuery is here because I’m testing)
 * Saving in database code (data-proccesing.php) :
 *     ```
       <?php
       $ipaddress = md5($_SERVER['REMOTE_ADDR']); // here I am taking IP as UniqueID but you can have user_id from Database or SESSION
   
       $servername = "localhost"; // Server details
       $username = "root";
       $password = "";
       $dbname = "events";
   
       $conn = new mysqli($servername, $username, $password, $dbname);
       if ($conn->connect_error) {
           die("Unable to connect Server: " . $conn->connect_error);
       }
   
       if (isset($_POST['rate']) && !empty($_POST['rate'])) {
   
           $rate = $conn->real_escape_string($_POST['rate']);
       // check if user has already rated
           $sql = "SELECT <code>id</code> FROM <code>tbl_rating</code> WHERE <code>user_id</code>='" . $ipaddress . "'";
           $result = $conn->query($sql);
           $row = $result->fetch_assoc();
           if ($result->num_rows > 0) {
               echo $row['id'];
           } else {
   
               $sql = "INSERT INTO <code>tbl_rating</code> ( <code>rate</code>, <code>user_id</code>) VALUES ('" . $rate . "', '" . $ipaddress . "'); ";
               if (mysqli_query($conn, $sql)) {
                   echo "0";
               }
           }
       }
       $conn->close();
       ?>
       ```
   

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [dsman](https://wordpress.org/support/users/dsman/)
 * (@dsman)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/plugin-development-database-error/#post-7059285)
 * up
 *  Thread Starter [dsman](https://wordpress.org/support/users/dsman/)
 * (@dsman)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/plugin-development-database-error/#post-7059373)
 * up

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Plugin development – Database error (Fatal error: Call to a member function..)’
is closed to new replies.

## Tags

 * [call](https://wordpress.org/support/topic-tag/call/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [development](https://wordpress.org/support/topic-tag/development/)
 * [fatal](https://wordpress.org/support/topic-tag/fatal/)
 * [function](https://wordpress.org/support/topic-tag/function/)
 * [jquery](https://wordpress.org/support/topic-tag/jquery/)
 * [member](https://wordpress.org/support/topic-tag/member/)
 * [php](https://wordpress.org/support/topic-tag/php/)
 * [Saving](https://wordpress.org/support/topic-tag/saving/)

 * 2 replies
 * 1 participant
 * Last reply from: [dsman](https://wordpress.org/support/users/dsman/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/plugin-development-database-error/#post-7059373)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics