PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- Hint: use Ctrl+Enter for SQL autocomplete create table test( id int NOT NULL AUTO_INCREMENT, name varchar(255) UNIQUE, date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) );
Copy Clear
Copy Format Clear
<?php function saveData($connection, $name) { //global $connection; $query = "INSERT INTO test(name) VALUES( :name )"; $callToDb = $connection->prepare($query); $name = htmlspecialchars(strip_tags($name)); $callToDb->bindParam(":name", $name); try { $callToDb->execute(); printf("<h1> register: " . $name . " </h1>"); } catch (PDOException $e) { $error = $e->errorInfo; printf("<h1> SAVING RESULT " . $error[2] . "</h1>"); } } $name = "John"; $result = saveData($pdo, $name); $result = saveData($pdo, $name);
Show:  
Copy Clear