Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function pdo_mysql($sql){
- $host = *;
- $user = *;
- $pass = *;
- $db = *;
- try {
- $PDO = new PDO( 'mysql:host=' . $host . ';dbname=' . $db, $user, $pass );
- }
- catch ( PDOException $e ) {
- echo 'MySQL error: ' . $e->getMessage(); exit;
- }
- $result = $PDO->query( $sql );
- if (is_array($result)){
- $row = $result->fetchAll( PDO::FETCH_ASSOC );
- }else{
- $row = $result;
- }
- return $row;
- }
- $sql = "...";
- $return = pdo_mysql($sql);
- foreach ($return as $row){
- // Execute some functions and show the results in a table (using datatables plugin)
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement