Advertisement
Guest User

Untitled

a guest
Apr 20th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.53 KB | None | 0 0
  1. $dbUser = 'dbUser';
  2. $dbHost = 'localhost';
  3. $dbName = 'dbName';
  4. $dbPassword = 'dbPassword';
  5. $dbCharset='utf-8';
  6. $dsn = sprintf("mysql:host=%s;dbname=%s;charset=%s",$dbHost,$dbName,$dbCharset);
  7. $pdo = new PDO($dsn,$dbUser,$dbPassword);
  8.  
  9. $sql = "INSERT INTO test (testField) VALUES('ั‚ะตัั‚')";
  10. $pdo->exec($sql);
  11.  
  12. $sql = "SELECT * FROM test";
  13. $statement = $pdo->prepare($sql);
  14. $statement->execute();
  15. $rows = $statement->fetchAll();
  16.  
  17.  
  18. header('Content-Type:text/html;charset=utf-8');
  19. echo '<pre>'.print_r($rows,true).'</pre>';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement