class Model {
public function getAllArticles(){
$dbh = new PDO($dsn, $user, $pass);
$query = "SELECT * FROM my_table";
return $dbh->query($query);
}
public function save($title, $article){
$dbh = new PDO($dsn, $user, $pass);
$query = "INSERT INTO my_table (title, article) VALUES ('$title', '$article')";
$dbh->query($query);
}
}
Y2xhc3MgTW9kZWwgewogIHB1YmxpYyBmdW5jdGlvbiBnZXRBbGxBcnRpY2xlcygpewogICAgJGRiaCA9IG5ldyBQRE8oJGRzbiwgJHVzZXIsICRwYXNzKTsKICAgICRxdWVyeSA9ICJTRUxFQ1QgKiBGUk9NIG15X3RhYmxlIjsKICAgIHJldHVybiAkZGJoLT5xdWVyeSgkcXVlcnkpOwogIH0KICBwdWJsaWMgZnVuY3Rpb24gc2F2ZSgkdGl0bGUsICRhcnRpY2xlKXsKICAgICRkYmggPSBuZXcgUERPKCRkc24sICR1c2VyLCAkcGFzcyk7CiAgICAkcXVlcnkgPSAiSU5TRVJUIElOVE8gbXlfdGFibGUgKHRpdGxlLCBhcnRpY2xlKSBWQUxVRVMgKCckdGl0bGUnLCAnJGFydGljbGUnKSI7CiAgICAkZGJoLT5xdWVyeSgkcXVlcnkpOwogIH0KfQ==
Standard input is empty
class Model {
public function getAllArticles(){
$dbh = new PDO($dsn, $user, $pass);
$query = "SELECT * FROM my_table";
return $dbh->query($query);
}
public function save($title, $article){
$dbh = new PDO($dsn, $user, $pass);
$query = "INSERT INTO my_table (title, article) VALUES ('$title', '$article')";
$dbh->query($query);
}
}
language:
PHP (php 7.3.5)
created:
11 years ago
Discover > Sphere Engine API
The brand new service which powers Ideone!
Discover > IDE Widget
Widget for compiling and running the source code in a web browser!
