Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function getData($dataSQL,$params){
- $pdo_host = 'localhost';
- $pdo_user = 'root';
- $pdo_pass = '';
- $pdo_database = 'cs1a_pizza_db';
- //--------------------------------------------------------
- try {
- $pdo_dns = 'mysql:host='.$pdo_host.';dbname='.$pdo_database;
- $pdo_db = new PDO($pdo_dns, $pdo_user, $pdo_pass);
- $pdo_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- //------------------------------------------------------------------------------
- $pdo_sql = $pdo_db->prepare($dataSQL);
- $pdo_sql->execute($params);
- return $pdo_sql->fetchAll(PDO::FETCH_ASSOC);
- $pdo_db = null;
- echo "Connected successfully";
- }
- catch(PDOException $e)
- {
- echo "Connection failed: " . $e->getMessage();
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement