Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function sql($query) {
- // SQL Connection details
- include "sql.php";
- // Initialize PDO connection
- $pdo = new PDO($sqldsn, $sqluser, $sqlpass, $sqlopt);
- // Prepare and execute statement
- $stm = $pdo->prepare("$query");
- $stm->execute();
- // Fetch results into array
- $result = $stm->fetchAll(PDO::FETCH_GROUP|PDO::FETCH_UNIQUE);
- return $result;
- }
- // Main
- $sqlhost = 'localhost';
- $sqldb = 'MyDB';
- $sqluser = 'mysqluser';
- $sqlpass = 'mypassword';
- $sqlport = "";
- // PDO Options
- $sqlchar = 'utf8';
- $sqldsn = "mysql:host=$sqlhost;dbname=$sqldb;charset=$sqlchar";
- $sqlopt = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => false,
- ];
- // Statement
- $sql = "INSERT INTO `MyTable` (`UserName`, `Email`, `ExpiryDate`, `Notes`) VALUES ('$username', '$email', '$expirydate', '$notes');";
- // Run query
- sql($sql);
- $notes = addslashes($notes);
Add Comment
Please, Sign In to add comment