Posts

Showing posts from March 5, 2019

SQLSTATE[42000]: Syntax error or access violation: 1064 Error in setting Variable in bindparam

Image
0 I want to get data from DB and add string to theme and put them in another query . When I run code I've got this error : Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''goldhyipPID', 'goldhyipPayStatus', programName,'goldhyipLastPayout') VALUES ('1' at line 1 in C:wamp64wwwallmonitorstest.php on line 69 <?php set_time_limit(3600); require_once 'fetchdetails/func.php'; require_once 'config.php'; $stmt = $conn->prepare("SELECT * FROM `monitors`"); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $mo