php - Getting SQL error 1136 -
i getting sql error 1136. config file correct , contains $conn
variable connecting database.
<?php include './config.php'; $field = [ "test_id", "testcase_id", "circle_name", "performed_date", "assign_to", "assign_by", "status", "comment", "device_used", "testsuite_id", "simcard_no", "time", "review", "redirection_issue", "price_point_mismatch_issue", "subscription_on_first_concent", "landing_page_issue" ]; $testid = '12342004'; $value = 'tc_3ja_1'; $circle = 'gujarat'; $date_created = '16/01/21'; $assigned_to = 'chirag.parekh'; $assign_by = 'brijesh.mashruwala'; $current_status = 'pass'; $current_comment = ''; $action = ''; $device = 'xperia tipo'; $tsuite = 'ts_3ja_7'; $mobile = '8141088630'; $time = '11:12:54'; $review = 'created'; $issue1 = 'pass'; $issue2 = 'pass'; $issue3 = 'pass'; $issue4 = 'pass'; $val = compact( "testid", "value", "circle", "date_created", "assigned_to", "assign_by", "current_status", "current_comment", "action", "device", "tsuite", "mobile", "time", "review", "issue1", "issue2", "issue3", "issue4" ); $sqlreview = "insert tmtool.test_result_url (" . implode(",", $field) . ") values ('" . implode("','", $val) . "')"; if (mysqli_query($conn, $sqlreview)) { echo "succesful"; } else { echo "failure" . mysqli_errno($conn); } ?>
you have issue in query:
you have 17 columns
, inserting 18 values
in query.
Comments
Post a Comment