codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    PDO – Basic connection and fetch

    3rd October 2014

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
     
    <?php
     
    $name = 'codehaven';
    $username = 'root';
    $password = '';
     
    try {
        $conn = new PDO('mysql:host=localhost;dbname=ppc', $username, $password);
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $data = $conn->query('SELECT * FROM table1 WHERE myname = ' . $conn->quote($name));
        foreach($data as $row) {
            print_r($row);
        }
    } catch(PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
    }
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN