Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try{
- $user = 'root';
- $pass = null;
- $pdo = new PDO('mysql:host=localhost; dbname=divebay', $user, $pass);
- $name = $_POST['name'];
- $desc = $_POST['description'];
- $cond = $_POST['condGroup'];
- $sprice = $_POST['sprice'];
- $iprice = $_POST['iprice'];
- $incprice = $_POST['incprice'];
- $duration = $_POST['duration'];
- $img = $_POST['img'];
- $owner = $_SESSION['username'];
- $valid = "set";
- $stmt2 = $pdo->prepare("SELECT * FROM auction WHERE ID = :id");
- $stmt2->bindParam(":id", $random, PDO::PARAM_INT);
- while(isset($valid)){
- $random = rand(100000,999999);
- $stmt2->execute();
- if(!$stmt2->fetch(PDO::FETCH_ASSOC)){
- unset($valid);
- }
- }
- $timestamp = time() + ($duration * 24 * 60 * 60);
- $stmt = $pdo->prepare("INSERT INTO auction(ID, name, owner, holder, sprice, iprice, incprice, etime, img, condition, description)
- VALUES (:id, :name, :owner, :holder, :sprice, :iprice, :incprice:, :etime, :img, :condition, :description");
- $stmt->bindParam(':id', $random, PDO::PARAM_INT);
- $stmt->bindParam(':name', $name, PDO::PARAM_STR);
- $stmt->bindParam(':owner', $owner, PDO::PARAM_STR);
- $stmt->bindParam(':holder', $owner, PDO::PARAM_STR);
- $stmt->bindParam(':iprice', $iprice, PDO::PARAM_STR);
- $stmt->bindParam(':sprice', $sprice, PDO::PARAM_STR);
- $stmt->bindParam(':incprice', $incprice, PDO::PARAM_STR);
- $stmt->bindParam(':etime', $timestamp, PDO::PARAM_INT);
- $stmt->bindParam(':img', $img, PDO::PARAM_STR);
- $stmt->bindParam(':condition', $condition, PDO::PARAM_STR);
- $stmt->bindParam(':description', $description, PDO::PARAM_STR);
- if($stmt->execute()){
- $worked ="yes";
- }
- }catch(PDOException $e){
- echo $e->getMessage();
- }
- $pdo = new PDO('mysql:host=localhost; dbname=divebay;charset=utf8', $user, $pass);
- $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
- $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $stmt = $pdo->prepare("INSERT INTO auction(ID, name, owner, holder, sprice, iprice, incprice, etime, img, condition, description)
- VALUES (:id, :name, :owner, :holder, :sprice, :iprice, :incprice:, :etime, :img, :condition, :description)");
- ^
- $stmt = $pdo->prepare("INSERT INTO auction(ID, name, owner, holder, sprice, iprice, incprice, etime, img, condition, description)
- VALUES (:id, :name, :owner, :holder, :sprice, :iprice, :incprice:, :etime, :img, :condition, :description");
- $stmt = $pdo->prepare("INSERT INTO auction(ID, name, owner, holder, sprice, iprice, incprice, etime, img, condition, description)
- VALUES (:id, :name, :owner, :holder, :sprice, :iprice, :incprice:, :etime, :img, :condition, :description)");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement