50yVV4yq

1<?php
2$pdo = new PDO('mysql:dbname=floattest;host=127.0.0.1', 'root', '');
3
4$create = $pdo->prepare('CREATE TABLE IF NOT EXISTS tbl (val DECIMAL(9,2))');
5$create->execute();
6
7$del = $pdo->prepare('DELETE FROM tbl');
8$del->execute();
9
10$ins = $pdo->prepare('INSERT INTO tbl (val) VALUES (?)');
11$ins->bindValue(1, 0.5, PDO::PARAM_INT);
12$ins->execute();
13
14$sel = $pdo->prepare('SELECT * FROM tbl');
15$sel->execute();
16var_dump($sel->fetchColumn(0));