Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*první sada dat*/
- $achname = $_POST['achname'];
- $achpoints = $_POST['achpoints'];
- $achdesc = $_POST['achdesc'];
- $creatorid = $_SESSION["uid"];
- /*parametry*/
- $query = $dbh->query('SELECT COUNT(*) FROM params');
- $query->execute();
- $result = $query->fetchColumn();
- $paramcount = $result;
- /*tohle tu bejt musí, jinak se to zacyklí! Nejde to tam nasolit rovnou, zkoušel jsem to, není mi úplně jasný proč, any hints?*/
- for ($i = 1; $i <= $paramcount; $i++) {
- if (isset($_POST[$i])) {
- $paramsstring = $paramsstring . $i . "=" . $_POST[$i] . ",";
- }
- }
- /*validation id, protože mysql neumí dva AI v jedný tabulce...*/
- $query = $dbh->prepare("SELECT MAX(vid) FROM validation");
- $query->execute();
- $result = $query->fetchAll();
- $nvid = (($result[0][0]) + 1);
- /*tak to tam vrazíme:*/
- try {
- $query = $dbh->prepare("INSERT INTO achievements (name, points, description, creatorid, paramids, validationid) VALUES (:name, :points, :description, :creatorid, :paramids, :validationid)");
- $query->bindParam(':name', $achname, PDO::PARAM_STR, 255);
- $query->bindParam(':points', $achpoints, PDO::PARAM_INT, 4);
- $query->bindParam(':creatorid', $creatorid, PDO::PARAM_INT, 7);
- $query->bindParam(':validationid', $nvid, PDO::PARAM_INT, 20);
- $query->bindParam(':description', $achdesc, PDO::PARAM_STR, 12000);
- $query->bindParam(':paramids', $paramsstring, PDO::PARAM_STR, 6000);
- $query->execute();
- }
- catch (PDOException $e) {
- echo $e->getMessage();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement