Thread: SQL error on vote page.

Results 1 to 7 of 7
  1. #1 SQL error on vote page. 
    Registered Member
    Join Date
    Jan 2015
    Posts
    41
    Thanks given
    0
    Thanks received
    0
    Rep Power
    11
    fixed.
    Reply With Quote  
     

  2. #2  
    Respected Member


    Join Date
    Jan 2009
    Posts
    5,743
    Thanks given
    1,162
    Thanks received
    3,603
    Rep Power
    5000
    convert it to use one of the new mysql apis like pdo, mysqli

    Code:
    // connect to db
    $db = new PDO('mysql:host=localhost;dbname=' . MYSQL_HOST . ';charset=utf8', MYSQL_USERNAME, MYSQL_PASSWORD);
    
    // delete old records
    $query = $db->query('DELETE FROM votes WHERE time > UNIX_TIMESTAMP(NOW())');
    $query->execute();
    cba converting the rest
    Reply With Quote  
     

  3. #3  
    Registered Member
    Join Date
    Jan 2015
    Posts
    41
    Thanks given
    0
    Thanks received
    0
    Rep Power
    11
    Quote Originally Posted by Stuart View Post
    convert it to use one of the new mysql apis like pdo, mysqli

    Code:
    // connect to db
    $db = new PDO('mysql:host=localhost;dbname=' . MYSQL_HOST . ';charset=utf8', MYSQL_USERNAME, MYSQL_PASSWORD);
    
    // delete old records
    $query = $db->query('DELETE FROM votes WHERE time > UNIX_TIMESTAMP(NOW())');
    $query->execute();
    cba converting the rest
    I Dont even have the code you said for old tables i have these
    Code:
    $query = query("SELECT * FROM `votes` WHERE `playerName`='" . $username . "'");
    not this:
    Code:
    $query = $db->query('DELETE FROM votes WHERE time > UNIX_TIMESTAMP(NOW())');
    $query->execute();
    how can i replace?..
    Reply With Quote  
     

  4. #4  
    Registered Member
    Anthony`'s Avatar
    Join Date
    Sep 2008
    Age
    29
    Posts
    763
    Thanks given
    75
    Thanks received
    164
    Rep Power
    204
    Quote Originally Posted by Jas0n View Post
    how can i replace?..
    PHP: Overview - Manual
    Reply With Quote  
     

  5. #5  
    Registered Member
    Join Date
    Jan 2015
    Posts
    41
    Thanks given
    0
    Thanks received
    0
    Rep Power
    11
    edited my new errors after i fixed it..
    Reply With Quote  
     

  6. #6  
    Respected Member


    Join Date
    Jan 2009
    Posts
    5,743
    Thanks given
    1,162
    Thanks received
    3,603
    Rep Power
    5000
    Quote Originally Posted by Jas0n View Post
    edited my new errors after i fixed it..
    Code:
    function anti_inject($sql)
    {
        return mysqli::real_escape_string($sql);
    }
    Reply With Quote  
     

  7. #7  
    Registered Member
    Join Date
    Jan 2015
    Posts
    41
    Thanks given
    0
    Thanks received
    0
    Rep Power
    11
    Quote Originally Posted by Stuart View Post
    Code:
    function anti_inject($sql)
    {
        return mysqli::real_escape_string($sql);
    }
    error::
    Code:
    Parse error: syntax error, unexpected ',' in /home/u528026529/public_html/vote.php on line 55
    on this line
    Code:
      $sql = preg_replace("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/i"),"", $sql);
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. [Bug/Glitch] Captcha on vote page
    By hadesflames in forum Defects
    Replies: 3
    Last Post: 06-04-2014, 12:12 AM
  2. Replies: 4
    Last Post: 08-03-2013, 12:06 AM
  3. Need help wth voting getting a sql error.
    By Pk Insain in forum Help
    Replies: 6
    Last Post: 07-15-2013, 06:43 PM
  4. 667/718 Auto Vote SQL error
    By Nairobi in forum Help
    Replies: 2
    Last Post: 06-07-2013, 06:50 PM
  5. Replies: 9
    Last Post: 07-10-2011, 06:09 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •