<?php // add a skill and its associated attribute to the database class ajaxRequest { function addSkill() { require 'Mize_connect.php'; $mysqli = Mize_server(); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; exit; } $nameInput = (string) htmlspecialchars($_POST['skillName']); $attrInput = (string) htmlspecialchars($_POST['skillAttr']); $return = array(); $return['attr'] = $attrInput; $return['name'] = $nameInput; if (count($_POST) > 0) { $stmt = $mysqli->prepare("INSERT INTO mm_skills(name, attribute) \n\t\t\t\t\t\t\t\t\t\t\t\t VALUES (?, (SELECT id FROM mm_attributes WHERE name = ?))\n\t\t\t\t\t\t\t\t\t\t\t\t ON DUPLICATE KEY UPDATE attribute = (SELECT id FROM mm_attributes WHERE name = ?)"); $stmt->bind_param("sss", $nameInput, $attrInput, $attrInput); $stmt->execute(); $stmt->close(); } return json_encode($return); } } $ajaxRequest = new ajaxRequest(); echo $ajaxRequest->addSkill();